作者投稿和查稿 主编审稿 专家审稿 编委审稿 远程编辑

›› 2005, Vol. 31 ›› Issue (17): 89-91.

• 论文 • 上一篇    下一篇

受限多维物化视图选择算法

林颖,沈洁,谢翠华,杨耘   

  1. 扬州大学信息工程学院计算机科学与工程系,扬州大学信息工程学院计算机科学与工程系,扬州大学信息工程学院计算机科学与工程系,武汉大学遥感信息工程学院 扬州 225009
  • 发布日期:2005-09-15

Algorithm of Multidimensional Materialized View Selection Under Cost Constraints

LIN Ying1,SHEN Jie1,XIE Cuihua1,YANG Yun2   

  1. (1.Department of Computer Science,Yangzhou University,Yangzhou 225009;2.School of Remote Sensing Information Engineering,Wuhan University,Wuhan 430079)
  • Published:2005-09-15

摘要: 受限物化视图的选择是当前数据仓库研究的最重要的问题之一。提出利用最小祖先树筛选视图,并结合改进的试探式策略进行物化视图选择的算法。该算法能有效地解决物化视图的两类问题。理论分析与实验结果表明在数据维度大、维层次复杂的情况下,与以往算法相比,该算法有着更优执行的效率。

关键词: 数据仓库, 物化视图, 遗传算法, 启发式算法

Abstract: Materialized view selection under cost constraint is one of the most important issues in data warehouse development. This paper firstly presents a materialized view selection algorithm, which selects views to materialize based on the minimal ancestor tree and implements with an improved heuristic strategy. This algorithm can effectively solve the two kinds of problems on selecting views to materialize. Both theory and experiment results show that the algorithm is more efficient than the previous algorithm under high dimension situations.

中图分类号: