期刊文献+

数据仓库中物化视图的选取策略

Selection of Materialized View in Data Warehouse
下载PDF
导出
摘要 数据仓库中用存储大量的物化视图来加速OLAP的查询响应,物化视图的选取是数据仓库设计中的一个重要问题。论文提出了一个有效的物化视图选取算法,采用基于数据立方体层次搜索的方式选取视图。经分析与测试表明,该算法取得良好的效果和效率。 A data warehouse stores large amounts of materialized views to accelerate OLAP queries. The selection of materialized view is an important decision in designing data warehouse. The paper presents an efficient algorithm for materialized views selection based on searching view in the layer of data cube. The analysis and experimental study show that the algorithm has better solution and high efficiency.
出处 《计算技术与自动化》 2004年第3期43-46,共4页 Computing Technology and Automation
关键词 物化视图 数据仓库设计 数据立方体 算法 查询 搜索 OLAP 中用 策略 效率 data warehouse materialized view greedy algorithm
  • 相关文献

参考文献5

  • 1Venky Harinarayan, Anand Rajaraman, Jeffrey D. Ullman. Implementing Data Cubes Efficiently[A]. SIGMOD'96[C],Proc. ACM,1996:205-216.
  • 2Amit Shukla, Prasad M. Deshpande, Jeffrery F. Naughton. Materialized View Selection for Multidimensional Datasets[A]. VLDB'98[C], 1998: 488-499.
  • 3Thomas P. Nadeau, Toby J. Teorey. Achieving scalability in OLAP materialized view selection[A]. DOLAP'02[C], Proc.ACM,2002: 28-34.
  • 4严勇 袁晴晴 周皓峰 等.物化视图选择方法的研究.计算机科学,2003,30(10):251-254.
  • 5杨少军,范金存,李庆忠.数据仓库中物化视图的选择[J].计算机应用,2003,23(9):58-60. 被引量:11

二级参考文献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

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

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