A Maintenance Strategy of Materialized Views in Distributed Environment

Abstract:

Database provides users with various applications via materialized views. The trouble of the update of materialized views is that there are many changing data sources, and in turn, it is difficult to maintain the consistency of materialized views and data sources. This method, a algorithm to change the execution order of things to be updated in materialized views appropriately, is based on maintaining the consistency of materialized views and data sources in distributed environment using the time stamp method, which reduce the maintenance costs of materialized views theoretically.

• Periodical: Applied Mechanics and Materials (Volumes 182-183)
• Pages: 2123-2126
• DOI: https://doi.org/10.4028/www.scientific.net/AMM.182-183.2123
• Online since: June 2012
• Authors: Zhi Cheng Qu, Tao Lin Guo
• Keywords: Materialized Views, Rollback Compensation Costs, Update the List, Updated Complexity

References

[1] Y. s. Lu, X. Pen. Timestamp-Based Materialized View Maintenance with Multi-Version Control. Computer engineering &science. 2006, 28(7).

[2] L. Feng, The improvement of ECA-an Algorithm for Materialized View Consistency Maintenance. Journal of Changchun University of Technology (natural science edition). 2008, 29(4).

[3] M.Z. Xie, X.S. Wu, Research on Materialized View Maintenance Algorithm of Distributed Sources. Computer engineering & application, 2005(28).

[4] J.X. chen. The Consistency of View Maintenance and Drill-down in a Warehousing Environment. Computer engineering and applications. 2003, 39(26).

[5] J.C. Hang, K.H. Yang. Index based approach for heuristic query optimization in data warehouses. Computer Engineering and Applications, 2010, 46(3): 122-124.

[6] Jiao Yan, Z.Y. Wang. Distributed database technology. Beijin: National Defence Industry Press, (2000).

[7] J.Y. Chen, Q.X. Wang. Materialized View Maintenance and Drill- down at the warehouse span multiple sources. Journal of Chongqing University (natural science edition). 2005, 28(5).

[8] C.S. Chen, Y.Q. Sun, Analysis & Design of Parallel Object-Relational Database Based on BSP Model. Journal of shanghai jiaotong university. 1999, 33(9).

[9] J.C. Wen, Materialized view ECA Maintenance Algorithms and l Improvements in data warehouse. China science and technology information. 2008 (1).

[10] J.Y. Chen, The On-line Consistency of Materialized View Maintenance in a Warehousing Environment. Chongqing University . Doctoral thesis(2002).