期刊文献+

数据仓库中多数据源物化视图的一种有效更新算法 被引量:10

An Efficient Refreshment Algorithm for Materialized View in Data Warehouse with Multiple Sources
在线阅读 下载PDF
导出
摘要 数据仓库中存储着大量的汇总数据以支持查询和相关决策的制定 ,这些汇总数据常常是定义在若干数据源上的物化视图 当数据源发生变化时 ,物化视图也需要相应的更新 ,这必然给数据仓库带来庞大的开销 ,因而如何有效地对物化视图进行更新成为一个非常重要的问题 利用BinPartition算法可以使计算费用达到最低 。 Data warehouses store a large amount of summarized data in form of materialized views defined over some source relations to support querying and decision making When data sources change, these views need to be updated in time These impose a significant overhead on the warehouse, so it is a very important problem to incrementally maintain materialized views efficiently A BinPartition algorithm is proposed to construct an optimal delta propagation tree according to which the cost of view maintenance is minimal The correctness and time complexity of the algorithm are also given
出处 《计算机研究与发展》 EI CSCD 北大核心 2004年第5期874-879,共6页 Journal of Computer Research and Development
基金 国家自然科学基金项目 ( 69973 0 2 8) 国家"八六三"高技术研究发展计划基金项目 ( 2 0 0 2AA4113 10 )
关键词 数据仓库 物化视图 基本关系 划分 data warehouse materialized view base relation partition
  • 相关文献

参考文献9

  • 1J A Blakeley,P Larson,F W Tompa.Efficiently updating materialized views.In:Proc of ACM SIGMOD Conf.Washington,D C:ACM Press,1986.61~71
  • 2A Gupta,I S Mumick,V S Subrahmanian.Maintaining view incrementally.In:Proc of ACM SIGMOD Conf.Washington,D C:ACM Press,1993.157~166
  • 3Ki Yong Lee,Jin Hyun Son,Myoung Ho Kim.Efficient incremental view maintenance in data warehouse.In:Proc of CIKM'01.Atlanta,GA:ACM Press,2001.349~356
  • 4D Agrawal,A El Abbadi,A Singh et al.Efficient view maintenance at data warehouse.In:Proc of ACM SIGMOD RECORD.Tucson,AZ:ACM Press,1997.417~427
  • 5Y Zhuge,H Garcia-Molina,J L Wiener et al.View maintenance in a warehousing environment.In:Proc of ACM SIGMOD Conf.San Jose,CA:ACM Press,1993.316~327
  • 6J Hammer,H Garcia-Molina,J Widom et al.The Stanford data warehousing project.IEEE Bulletin of the Technical Committee on Data Engineering,1995,18(2):41~48
  • 7J D Ullman.Principles of Database and Knowledge-Base System.Maryland:Computer Science Press,1988
  • 8V W Christopher J.Data Structures and C Programs.Massachusetts:Addison-Wesley,1988
  • 9Transaction Processing Performance Council.Standard Benchmark D for Database System.1997.http://www.tpc.org

同被引文献86

引证文献10

二级引证文献6

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

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