Abstract
Data warehouse is a repository of information collected from multiple, possibly heterogeneous, autonomous and distributed databases. The information stored in the warehouse is in the form of Materialized views. In data warehouses materialized views are used to pre-compute and store aggregated data such as sums and averages. Materialized views are the derived relation, which are stored as the relation in the database, when some update occurs in the parent relation all its child relations also gets updated by viewing to maintain the consistency and convergence [3] of the database. In this paper we present a new method of incremental view maintenance with the inclusion of some existing approaches [2][3]. We utilized the concept of version store [2] for older versions of tables that have been updated at the source.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Gupta, A., Mumick, I.S. (eds.): Materialized Views: Techniques, Implementations and Applications. MIT Press, Cambridge (1999)
Zhou, J., Larson, P., Elmongui, H.G.: Lazy Maintenance of Materialized Views. In: Proceedings of the 33rd International conference on Very large data bases, Vienna, Austria (2007)
Zhuge, Y., Garcia-Molina, H., Hammer, J., Widom, J.: View Maintenance in a Warehousing Environment. In: Proceeding of SIGMOD Conference (1999)
Breibart, Y., Gracia-Molina, H., Silberschatz, A.: Overview of multi database transaction management. VLDB Journal 1(2), 181–239 (1992)
Agrawal, D., Abbadi, A., El, S.A., Yurek, T.: Efficient View Maintenance at Data Warehouses. In: The Proceedings of the ACM SIGMOD International Conference on Management of Data, Tucson, Arizona, USA (1997)
Gupta, A., Mumick, I.S.: Maintenance of Materialized Views: Problems, Techniques, and Applications. IEEE Bulletin of the Technical Committee on Data Engineering 18(2), 3–18 (1995)
Gupta, A., Mumick, I.S., Subrahmanian, V.: Maintaining views incrementally. In: Proceedings of the 1993 ACM SIGMOD International Conference on Management of Data, Washington, D.C, May 1993, pp. 157–166 (1993)
Yeung, G.C.H., Gruver, W.A.: Multiagent Immediate Incremental View Maintenance for Data Warehouses. IEEE Transaction on Systems, Man, and Cybernetics – Part A: Systems and Human 35(2) (March 2005)
He, H., et al.: Asymmetric Batch Incremental View Maintenance. In: The Proceedings of the 21st International Conference on Data Engineering ICDE (2005). IEEE, Los Alamitos (2005)
Labio, W.J., Yang, J., Cui, Y., Garcia-Molina, H., Widom, J.: Performance issues in incremental warehouse maintenance. In: Proc. 2000 Intl. Conf. Very Large Data Bases, Cairo, Egypt (September 2000)
Mohania, M., Samtani, S., Roddick, J., Kambayashi, Y.: Advances and Research Directions in Data-Warehousing Technology. Published in Australasian Journal of Information Systems 7(1) (1999)
Qin, B., Wang, S., Du, X.: Effective Maintenance of Materialized Views in Peer Data Management Systems. In: Proceeding of the First International Conference on Semantics, Knowledge, and Grid (SKG 2005). IEEE, Los Alamitos (2006); 0-7695-2534-2/05 ©
Blakeley, J.A., Larson, P.-A., Tompa, B.W.: Efficiently Updating Materialized Views. ACM, New York (1986); 0-89791-191-1/86/0500/0061
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2009 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Almazyad, A.S., Siddiqui, M.K., Ahmad, Y., Khan, Z.I. (2009). An Incremental View Maintenance Approach Using Version Store in Warehousing Environment. In: Ślęzak, D., Kim, Th., Zhang, Y., Ma, J., Chung, Ki. (eds) Database Theory and Application. DTA 2009. Communications in Computer and Information Science, vol 64. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-10583-8_2
Download citation
DOI: https://doi.org/10.1007/978-3-642-10583-8_2
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-10582-1
Online ISBN: 978-3-642-10583-8
eBook Packages: Computer ScienceComputer Science (R0)