Abstract
Data warehouses have become extremely important to support online analytical processing (OLAP) queries in databases. Since the data view that is obtained at a data warehouse is derived from multiple data sources that are continuously updated, keeping a data warehouse up-to-date becomes a crucial problem. An approach referred to as the incremental view maintenance is widely used. Unfortunately, a precise and formal definition of view maintenance (which can actually be seen as a distributed computation problem) does not exist. This paper develops a formal model for maintaining views at data warehouses in a distributed asynchronous system. We start by formulating the view maintenance problem in terms of abstract update and data integration operations and state the notions of correctness associated with data warehouse views. We then present a basic protocol and establish its proof of correctness. Finally, we present an efficient version of the proposed protocol by incorporating several optimizations. So, this paper is mainly concerned with basic principles of distributed computing and their use to solve database related problems.
This work was supported in part by an NSF/INRIA grant INT-009 5527.
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
Agrawal D., Alonso G., El Abbadi A. and Stanoi I., Exploiting Atomic Broadcast in Replicated Databases. Proc. of the International Conference on Parallelism (EUROPAR), pp. 496–503, August 1997.
Agrawal D., El Abbadi A., Singh A. and Yurek T., Efficient Data View Maintenance Warehouses. Proc. ACM SIGMOD, pp. 417–427, 1997.
Agrawal A., El Abbadi A., Mostéfaoui A., Raynal R. and Roy M., The Lord of the Rings: Efficient Maintenance of Views at Data Warehouses. IRISA Research Report #1441, IRISA, Rennes, France. Available at: http://www.irisa.fr/bibli/publi/pi/2002/1441/1441.html.
Agrawal D., El Abbadi A. and Steinke R.C., Epidemic Algorithms in Replicated Databases. Proc. ACM PODS, pp. 161–172, 1997.
Aguilera M.K., Chen W. and Toueg S., On Quiescent Reliable Communication. SIAM Journal of Computing, 26(6):2040–2073, 2000.
Colby L.S., Griffin T., Libkin L., Mumick I.S. and Trickey H., Algorithms for Deferred View Maintenance. Proc. ACM SIGMOD, acm Press, pp. 469–480, 1996.
Demers A. et al., Epidemic Algorithms for Replicated Database Maintenance. Proc. ACM PODC, acm Press, pp. 1–12, 1987.
Gupta A. and Mumick I.S., Maintenance of Materialized Views: Problems, Techniques and Applications. IEEE Bulletin of the Technical Committee on Data Engineering, 18(2):3–18, June 1995.
Gupta A., Mumick I.S. and Subramanian V.S., Maintaining Views Incrementally. Proc. ACM SIGMOD, pp. 157–166, 1993.
Hélary J.-M., Mostéfaoui A. and Raynal M., A General Scheme for Token and Tree-Based Distributed Mutual Exclusion Algorithms. IEEE Transactions on Parallel and Distributed Systems, 5(11):1185–1196, 1994.
Hull R. and Zhou G., A Framework for Supporting Data Integration Using the Materialized and Virtual Approaches. Proc. ACM SIGMOD, pp. 481–492, 1996.
Kemme B. and Alonso G., A New Approach to Developing and Implementing Eager Database Replication Protocols. ACM Transactions on Database Systems, 25(3):333–379, 2000.
Powell D. (Guest Editor). Special Issue on Group Communication. Communications of the ACM, 39(4):50–97, 1996.
Rundensteiner E.A., Koeller A. and Zhang X., Maintaining Data Warehouses over Changing Information Sources. Communications of the ACM, 43(6):57–62, 2000.
Stanoi I., Agrawal D. and El Abbadi A., Modeling and Maintaining Multi-View Data Warehouses. Proc. 18th. Int. Conference on Conceptual Modeling, Paris, France, pp. 161–175, 1999.
Wuu G. T. and Bernstein A. J., Efficient Solutions to the Replicated Log and Dictionary Problems. Proc. ACM PODC, pp. 233–242, 1984.
Zhuge Y., Garcia-Molina H., Hammer J. and Widom J., View Maintenance in a Warehousing Environment. Proc. ACM SIGMOD Int. Conf. on Management of Data, pp. 316–327, 1995.
Zhuge Y., Garcia-Molina H. and Wiener J.L., The Strobe Algorithms for Multi-Source Warehouse Consistency. Proc. Int. Conference on Parallel and Distributed Information Systems, 1996.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2002 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Agrawal, D., El Abbadi, A., Mostéfaoui, A., Raynal, M., Roy, M. (2002). The Lord of the Rings: Efficient Maintenance of Views at Data Warehouses. In: Malkhi, D. (eds) Distributed Computing. DISC 2002. Lecture Notes in Computer Science, vol 2508. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-36108-1_3
Download citation
DOI: https://doi.org/10.1007/3-540-36108-1_3
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-00073-0
Online ISBN: 978-3-540-36108-4
eBook Packages: Springer Book Archive