Definition
Database systems often define views in order to provide conceptual subsets of the data to different users. Each view may be very complex and require joining information from multiple base relations, or other views. A view can simply be used as a query modification mechanism, where user queries referring to a particular view are appropriately modified based on the definition of the view. However, in applications where fast response times to user queries are essential, views are often materialized by storing their tuples inside the database. This is extremely useful when recomputing the view from the base relations is very expensive. When changes occur to their base relations, materialized views need to be updated, with a process known as view maintenance, in order to provide fresh data to the user.
Historical Background
The use of relational views has long been proposed in relational database systems. The notion of materialized views, or snapshots, was first proposed in [1]....
This is a preview of subscription content, log in via an institution to check access.
Recommended Reading
Adiba B, Lindsay B. Database snapshots. In: Proceedings of the 6th international conference on very data bases, 1980. p. 86–91.
Colby L, Kawaguchi A, Lieuwen D, Mumick IS, Ross KA. Supporting multiple view maintenance policies. In: Proceedings of the ACM SIGMOD conference on management of data, 1997. p. 405–16.
Deligiannakis A, Kotidis Y, Roussopoulos N. Processing approximate aggregate queries in wireless sensor networks. Inf Syst. 2006;31(8):770–92.
Gupta A, Mumick IS. Maintenance of materialized views: problems, techniques, and applications. IEEE Data Eng Bull. 18(2):3–19. Special Issue on Materialized Views and Data Warehousing, June 1995.
Gupta A, Mumick IS, Rao J, Ross KA. Adapting materialized views after redefinitions: techniques and a performance study. Inf Syst. 16(5):323–62. Special Issue on Data Warehousing, July 2001.
Gupta A., Mumick IS, Subrahmanian VS. Maintaining views incrementally. In: Proceedings of the ACM SIGMOD international conference on management of data, 1993. p. 157–66.
Jagadish HV, Mumick IS, Silberschatz A. View maintenance issues in the chronicle data model. In: Proceedings of the 14th ACM SIGACT-SIGMOD-SIGART symposium on principles of database systems, 1995. p. 113–24.
Kotidis Y, Roussopoulos N. DynaMat: a dynamic view management system for data warehouses. In: Proceedings of the ACM SIGMOD international conference on management of data, 1999. p. 371–82.
Labrinidis A, Roussopoulos N. WebView materialization. In: Proceedings of the ACM SIGMOD international conference on management of data, 2000. p. 367–78.
Labrinidis A, Roussopoulos N. Balancing performance and data freshness in web database servers. In: Proceedings 29th international conference on very large data bases, 2003. p. 393–404.
Roussopoulos N. The incremental access method of view cache: concept, algorithms, and cost analysis. ACM Trans Database Syst. 1991;16(3):535–63.
Roussopoulos N, Kang H. Principles and techniques in the design of ADMS±. IEEE Comput. 1986;19(2):19–25.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Section Editor information
Rights and permissions
Copyright information
© 2016 Springer Science+Business Media LLC
About this entry
Cite this entry
Deligiannakis, A. (2016). View Maintenance Aspects. In: Liu, L., Özsu, M. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4899-7993-3_838-2
Download citation
DOI: https://doi.org/10.1007/978-1-4899-7993-3_838-2
Received:
Accepted:
Published:
Publisher Name: Springer, New York, NY
Online ISBN: 978-1-4899-7993-3
eBook Packages: Springer Reference Computer SciencesReference Module Computer Science and Engineering