期刊文献+

基于遗传算法的受限物化视图 被引量:2

Selection of Materialized ViewsUnder Cost Constraints Based on Genetic Algorithm
原文传递
导出
摘要 受限物化视图的选择是当前数据仓库研究的最重要的问题之一,且其是个NP问题。本文通过对视图与查询关系的研究,提出了一种选择物化视图的两阶段算法框架,首先利用候选视图选择算法缩小视图选择的范围,而后利用遗传算法解决受限物化视图的选择问题。 Materialized view selection under cost constraint is one of the most important issues in data warehouse development,and it is a NP.By deeply researched the relationship of views and queries,a tow-phases algorithm is designed to resolve the problem.Firstly,candidate views selection algorithm is used to reduce the selection range.Based on that,we has successfully resolve the problem of materialized views selection with Genetic algorithm.
出处 《网络安全技术与应用》 2007年第6期61-62,73,共3页 Network Security Technology & Application
关键词 物化视图 候选视图 遗传算法 materialized view candidate views genetic algorithm
  • 相关文献

参考文献1

二级参考文献9

  • 1Molina HG 杨冬青 唐世渭 徐其钧 等译.数据库系统实现[M].北京:机械工业出版社,Prentice Hall,2001..
  • 2InmonWH 王志海 等译.数据仓库[M].北京:机械工业出版社,2002..
  • 3Han J, Kambr M. Data Mining - Concepts and Techniques[M].Morgan Kaufmann Publishers; Higher Education Press, 2001.
  • 4Harinarayan V, Rajaraman A, Ullman JD. Implementing Data Cubes Efficiently[A]. Proc ACM SIGMOD'96[C], 1996.205 -216.
  • 5Yang J, Karlapalem K, Li Q. A Framework for Designing Materialized Views in Data Warehousing Environment[R]. Technical Report from Hong Kong University of Science and Technology, 1996.
  • 6Cheung DW, Zhou B, Kao B. Requirement-Based Data Cube Schema Design[A]. ACM CIIGM'99[C], 1999.
  • 7Mistry H, Roy P, Sudarshan S, et al. Materialized View Selection and Maintenance Using Multi-Query Optimization[A]. ACM SIGMOD[C], 2001.
  • 8Ross KA, Sirvastava D, Sudarshan S. Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time[A]. ACM SIGMOD'96[C]. 1996. 447 - 458.
  • 9InmonWH 王志海 等译.数据仓库[M].北京:机械工业出版社,2002..

共引文献10

同被引文献15

  • 1刘乃丽,李玉忱,王石,王素青.存储空间约束下物化视图的选择[J].计算机应用,2004,24(8):76-78. 被引量:4
  • 2林颖,沈洁,谢翠华,杨耘.受限多维物化视图选择算法[J].计算机工程,2005,31(17):79-81. 被引量:3
  • 3崔晓军,薛永生,张东站,黄宗毅.基于多维护策略的物化视图选择方法[J].计算机科学,2006,33(2):114-117. 被引量:3
  • 4张柏礼,朱文.关于实视图维护问题的研究[J].现代电子技术,2007,30(1):71-73. 被引量:1
  • 5Gupta H,Mumick I S. Selection of views to materialize un- der a maintenance cost constraint [ C ]//Proceedings of the 7th International Conference on Database Theory. Springer, 1999:453-470.
  • 6Harinarayan V, Rajaraman A, Ullman J. Implementing data cubes efficiently[ C]//Proceedings of the 1996 ACM SIG- MOD International Conference on Management of Data. 1996:205-216.
  • 7Chan Goretti K Y, Li Qing, Feng Ling. Design and selection of materialized views in a data warehousing environment: A case study[ C]//Proceedings of the 2nd ACM International Workshop on Data Warehousing and OLAP. 1999:42-47.
  • 8Gupta H, Harinarayan V, Rajaraman A, et al. Index selec- tion for OLAP [ C ]//Proceedings of the 13th International Conference on Data Engineering. IEEE Computer Society Press, 1997:208-219.
  • 9Nadeau Thomas P, Teorey Toby J. Achieving scalability in OLAP materialized view selection [ C ]//Proceedings of the 5th ACM International Workshop on Data Warehousing and OLAP. 2002:28-34.
  • 10严勇 袁晴晴 周皓峰 等.物化视图选择方法的研究[c]第二十届全国数据库学术会议论文集[J].计算机科学,2003,:251-254.

引证文献2

二级引证文献2

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

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