期刊文献+

多数据源数据仓库实体化视图维护与下查 被引量:3

Materialized View Maintenance and Drill-down at the warehouse span multiple sources
在线阅读 下载PDF
导出
摘要 研究了多源单视图下数据仓库实体化视图联机维护与下查一致性问题,并提出普适性强一致收敛维护算法M Glide。算法引入动作列表来控制数据仓库收到的信息顺序,采用版本控制、补偿思想和应答机制来协调源数据库与数据仓库间的数据更新,从而保证了数据仓库视图维护与下查的一致性,并通过一个示例说明了该算法在实际中的具体运用。 The consistency of view maintenance and drill-down at the warehouse span multiple sources is studied. So the wide strongly consistent algorithm M-Glide is introduced, which imposes an action list to record the updating sequel sets, and uses version control and compensating mechanisms, along with acknowledgementmechanisms, to synchronize the data refreshments between data sources and data warehouse. The authors illustrate the application of the algorithm by a typical example.
出处 《重庆大学学报(自然科学版)》 EI CAS CSCD 北大核心 2005年第5期80-85,共6页 Journal of Chongqing University
基金 国家教育部博士生基金资助项目(98061117)
关键词 算法M-Glide 数据仓库 实体化视图 补偿技术 OLAP查询 algorithm M-Glide data warehouse materialized views compensate techniques OLAP query
  • 相关文献

参考文献7

二级参考文献18

  • 1.[EB/OL].http://www-db.Stanford.edu/warehousing/warehouse.html.,.
  • 2T Griffin,L Libkin.Incremental maintenance of views with duplicates [C].In:Proceedings of ACM SIGMOD International Conference on Management of Data,San Jose,CA,1995-05:323-339.
  • 3J A Blakeley,P-A Larson,F W Tompa.Efficiently updating material- ized views[C].In:Proceedings of the ACM SIGMOD International Con- ference on Management of data,Washington,D C,1986-06:61-71.
  • 4A Gupta,I Mumick,V Subrahmanian.Maintaining views incrementally [C].In:Proceedings of the 1993 ACM SIGMOD International Confer- ence on Management of Data,Washington, D C, 1993-05 : 157-166.
  • 5J V Harrison,S W Dietrich.Maintenance of materialized views in a deductive database:An update propagation approach[C].In:Proceedings of the 1992 JICLSP Workshop on Deductive Databases, 1992:56-65.
  • 6Y Zhuge,H Garcia-Molina,J Hammer et al.View maintenance in a warehousing environment[C].In:Proceedings of ACM SIGMOD Confer- ence,San Jose,CA, 1995:316~327.
  • 7Y Zhuge,J L Wiener,H Garcia-Molina.Multiple View Consistency for Data Warehousing[C].In:Proceedings of the International Confer- ence on Data Engineering,Binghamton,UK, 1997-04.
  • 8Y Zhuge,H Garcia-Molina,J L Wiener.The Strobe Algorithms for Multi-Source Warehouse Consistency[C].In:Proceedings of the Conference on Parallel and Distributed Information Systems,Miami Beach, FL, 1996-12.
  • 9Y Zhuge,H Garcia-Molina,J L Wiener.Consistency Algorithms for Multi-Source Warehouse View Maintenance[J].Journal of Distributed and Paralled Databases, 1998 ;6( 1 ) :7-40.
  • 10H Garcia-Molina,W J Labio,J L Wiener et al.Distributed and Par- allel Computing Issues in Data Warehousing[C].In:Proceedings of ACM Principles of Distributed Computing Conference, 1999.

共引文献15

同被引文献32

  • 1谢民主,伍祥生.分布式数据源的实视图维护算法研究[J].计算机工程与应用,2005,41(28):170-173. 被引量:1
  • 2VenKatesh Ganti, Johannes Gehrke, Raghu Ramakrishnan. Deichumon: Mining and Monitoring Evoling Data[J]. IEEE Transaction on Knowledge and Data Engineering,2001,13(1) : 50-63
  • 3Zhuge Yue,Garciar Molina Hector, Wieners JanetL. Consistency Algorithms for Multisource Warehouse View Maintenance[J]. Distributed and Parallel Databases, 1998,6(1) : 7-40
  • 4[美]Hector Garciar Molina,Jeffrey D,Ullman Jen-nifer Widom.数据库系统实现(英文版)[M].北京:机械工业出版社,2001.
  • 5Divyakant Agrawal, Amr EI Abbadi, et al; Efficient View Maintenance at Datawarehouses[M]. ACM SIGMOD Conf: Management of Data, 1997.
  • 6GUPTA A, MUMICK I S. Maintenance of materialized views : problems, techniques, and applications [ J ]. IEEE Data Eng Bull, 1995, 18(2) : 3-19.
  • 7ZHUGE Y, GARCIA-MOLINA H, HAMMER J, ct al. View maintenance in a warehousing environment [ C ] // Proceedings of SIGMOD. New York: ACM, 1995: 316- 327.
  • 8CHEN R, MENG W. Precise detection and proper handling of view maintenance anomalies in a multidatabase environment [C]// Proceedings of the Second IFCIS International Conference on Cooperative Information Systems. Washington, D. C. : IEEE Computer Society, 1997: 110-119.
  • 9ZHUGE Y, GARCIA-MOLINA The strobe algorithms for H, HAMMER J, et al. multi-source warehouse consistency[C] //Proceedings of the Fourth International Conference on Parallel and Distributed Information Systems. Washington, D. C. : IEEE Computer Society, 1996: 146-157.
  • 10AGRAWAL D, ABBADI A E, SINGH A, et al. Efficient view maintenance at data warehouses [ C ]//Proceedings of SIGMOD. New York: ACM, 1997:417-427.

引证文献3

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

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