期刊文献+

立方体实体化的遗传算法设计与实现

Design and implementation of materialized cubes genetic algorithm
在线阅读 下载PDF
导出
摘要 多维立方体由基本立方体和基本立方体的聚集产生的立方体组成 .为了实时响应查询 ,查询优化非常重要 .多维立方体实体化是一种很好的解决方案 .在整个立方体集中实体化一个适当的子集 ,满足较好的空间和时间的平衡 ,并且满足对视图查询频率不同的要求 .为了实体化一个合适的立方体子集 ,通过介绍启发策略 ,提出了立方体实体化的启发式遗传算法 .该算法可以在用户要求的限定的存储空间约束条件下 ,较快的求出全局最优解 .经实验测试 。 Multidimensional data cubes are composed of base cube and the cubes aggregating on base cube. Since response time should be small, query optimization is critical. Materializing multidimensional cubes is a good solution. Partial materialization gives some good tradeoffs between the storage space and the average time to answer a query. In order to materialize an appropriate cube subset, a heuristic genetic algorithm was proposed. The algorithm can converge quickly and has the ability of optimizing globally in the condition of the given space. It can satisfy the requirement of different query frequency of view.
作者 孙惠琴 熊璋
出处 《北京航空航天大学学报》 EI CAS CSCD 北大核心 2004年第7期610-613,共4页 Journal of Beijing University of Aeronautics and Astronautics
关键词 数据 遗传算法 数据立方体 物化视图 联机分析处理 Data mining Design Encoding (symbols) Genetic algorithms Optimization
  • 相关文献

参考文献9

  • 1[1]Han Jiawei, Kamber M. Data mining[M]. Beijing: Higher Education Press, 2001
  • 2[2]Harinarayan V, Rajaraman A. Implementing data cubes efficiently [A]. In: Jagadish H V, Mumick I S. Proceedings of ACM SIGMOD International Conference on Management of Data [ C ]. New York: ACM Press, 1996.205 ~ 216
  • 3[3]Gray J, Bosworth A, Layman A, et al. Data cube: a relational aggregation operator generalizing group-by, cross-tab, and sub-totals [J]. Data Mining and Knowledge Discovery, 1997, 1(1): 29 ~ 53
  • 4[4]Neill F O, Graefe G . Multi-table joins through bitmapped join indices[A]. ACM SIGMOD Record[C]. 1995. 24(3) :8 ~ 11
  • 5[5]Gjyssens M, Lakshmanan L V S. A foundation for multi-dimensional databases[A]. Proceedings of the Twentythird International Conference on Very Large Databases[C]. Athens, 1997. 106 ~ 115
  • 6[6]Guting R H. An introduction to spatial database systems[J]. VLDB Journal, 1994,3(4) :357 ~ 399
  • 7[7]Agrawal R, Gupta A, Sarawagi S. Modeling multidimensional databases[A]. In: Gray A, Larson P. Proceedings of the 13th International Conference and Data Engineering [ C ]. Birmingham: IEEE Computer Society Press, 1997.232 ~ 243
  • 8[8]Lee M, Hammer J. Speeding up warehouse physical design using a randomized algorithm[A]. Proceedings of the International Workshop on Design and Management of Data Warehouses[ C ]. Heidelberg,Germany, 1999
  • 9[9]Zhang Chuan, Yao Xin, Yang Jian. An evolutionary approach to materialized views selection in a data warehouse environment [ J ].IEEE Transactions on Systems, Man and Cybernetics, 2001,31(3):282 ~ 294

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

内容加载中请稍等...
;
使用帮助 返回顶部