期刊文献+

物化视图合并的一种新算法 被引量:1

A New Algorithm for Merging Materialized Views
下载PDF
导出
摘要 用视图优化查询是提高数据库响应性能的重要手段,所以减少视图的搜索空间有非常重要的意义。该文提出了视图合并的一种新算法――匹配合并法,该算法大大地扩展了视图合并范围。为了更快地进行匹配合并,还提出了一种有效的索引结构――双分解树,通过分解视图集来达到快速合并视图的目的。实验表明,该合并算法改进了数据库的查询性能。 Materialized views can improve the database's performance, but numbers of materialized views will cost lots of spaces. So, it is necessary to decrease the number of the materialized views by merging. This paper gives a new algorithm named match merging. In order to accelerate the merging process, it introduces the two-partitioned tree, which is a kind of index. According to experiment, it is very useful.
作者 咸兵
出处 《计算机工程》 CAS CSCD 北大核心 2007年第12期90-92,共3页 Computer Engineering
关键词 物化视图 匹配合并 双分解树 Materialized views Match merging Two-partitioned tree
  • 相关文献

参考文献5

  • 1Goldstein J,Larson P.Optimizing Queries Using Materialized Views:a Practical,Scalable Solution[C]//Proceedings of SIGMOD.2001:331-342.
  • 2Agrawal S,Chaudhuri S,Narasayya V R.Automated Selection of Materialized Views and Indexes in SQL Databases[C]//Proceedings of the 26th International Conference on Very Large Databases,Cairo,Egypt.2000:496-505.
  • 3陈长清,冯玉才,袁磊.国产数据仓库管理系统DM_DW的设计[J].小型微型计算机系统,2002,23(5):596-599. 被引量:10
  • 4陈长清,程恳.一种实化视图的合并算法[J].计算机应用,2005,25(4):814-816. 被引量:1
  • 5Chaudhuri S,Narasayya V.An Efficient Cost-driven Index Selection Tool for Microsoft SQL Server[C]//Proc.of VLDB'97.1997.

二级参考文献12

  • 1吴永英,冯玉才,吴恒山,阳富民.分布式多媒体DBMS的研究与开发[J].计算机研究与发展,1997,34(1):28-32. 被引量:3
  • 2GOLDSTEIN J,LARSON P.Optimizing queries using materialized views:a practical,scalable solution[A].Proceedings of SIGMOD[C].2001.331-342.
  • 3AGRAWAL S,CHAUDHURI S,NARASAYYA VR.Automated Selection of Materialized Views and Indexes in SQL Databases[A].Proceedings of the 26th International Conference on Very Large Databases (VLDB00)[C].Cairo,Egypt,2000:496-505.
  • 4J.Hammer,H.Garcia-Molina,J.Widom,W.J.Labio,Y.Zhuge.The stanford data warehousing project[J].IEEE Data Engineering Bulletin,June 1995:1~4
  • 5Y.Zhuge,H.Garcia-Molina,J.Hammer,and J.Widom.View maintenance in a warehousing environment[C].In Proceedings of the ACM SIGMOD Conference,San Jose,California,May 1995:1~9
  • 6Y.Zhuge,H.Garcia-Molina,and J.L.Wiener.The strobe algorithms for multi-source warehouse consistency[C].Proceedings of the Conference on Parallel and Distributed Information Systems,Miami Beach,FL,December 1996:3~11
  • 7A.Gupta,V.Harinarayan and D.Quass.Aggregate-query processing in data warehousing environments[C].Proceedings of the 21st VLDB Conference,1995 332~336
  • 8D.Srivastava,S.Dar,H.V.Jagadish,Alon Y.Levy.Answering queries with aggregation using views[C].Proceedings of the 22nd VLDB Conference,1996 659~664
  • 9Labio WJ,Quass D,Adelberg B.Physical database design for data warehouse[C].In:ICDE,1997.194~198
  • 10S.Rosen,D.Shasha.A framework for automating physical database design[C].In Proceedings of International Conferrence on Very Large Data Bases,1991 401~11

共引文献9

同被引文献7

引证文献1

二级引证文献2

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

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