摘要: 基于历史数据,what-if分析方法可对假设情景进行分析,为决策者提供预测信息,但在分析过程中存在数据方体的重新计算问题。针对该问题,提出一种使用Max函数的数据方体增量计算方法,减少增量计算过程中对事实表的访问时间。实验结果表明,该方法可将增量计算的性能提高约15%。
关键词:
what-if分析,
数据方体,
delta表,
增量计算
Abstract: Based on the historical data, what-if analysis can analyze the hypothetical scenarios and provide useful information for the decision-maker. Aiming at the problem of re-computation of data cubes in what-if analysis, this paper presents an algorithm of incremental computation of data cube for Max function to reduce the access time of fact table. Experimental results show that the performance of incremental computation can be improved about 15%.
Key words:
what-if analysis,
data cube,
delta table,
incremental computation
中图分类号:
肖艳芹;李 俊;黄 炜. What-if分析中的Max数据方体增量计算[J]. 计算机工程, 2010, 36(9): 29-31.
XIAO Yan-qin; LI Jun; HUANG Wei. Incremental Computation of Max Data Cube in What-if Analysis[J]. Computer Engineering, 2010, 36(9): 29-31.