Synonyms
Materialized view maintenance; View update
Definition
View maintenance typically refers to the updating of a materialized view (also known as a derived relation) to make it consistent with the base relations it is derived from. Such an update typically happens immediately, with the transaction that updates the base relations also updating the materialized views. However, such immediate updates impose significant overheads on update transactions that cannot be tolerated by many applications. Deferred view maintenance, on the other hand, allows the view to become inconsistent with its definition, and a refresh operation is required to establish consistency. Typically, under deferred maintenance, a view is incrementally updated only just before data is retrieved from it (i.e., on-demand, just before a query is performed on the view).
Historical Background
Early systems that supported views did so in their “pure form,” i.e., by storing just the view definition and using query...
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsRecommended Reading
Blakeley JA, Larson PÅ, Tompa FW. Efficiently Updating Materialized Views. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1986. p. 61–71.
Buneman P, Clemons EK. Efficient monitoring relational databases. ACM Trans Database Syst. 1979;4(3):368–82.
Chaudhuri S, Dayal U. An overview of data warehousing and OLAP technology. ACM SIGMOD Rec. 1997;26(1):65–74.
Colby LS, Griffin T, Libkin L, Mumick IS, Trickey H. Algorithms for deferred view maintenance. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1996. p. 469–80.
Gupta A, Mumick IS. Maintenance of materialized views: problems, techniques, and applications. IEEE Data Eng Bull. 1995;18(2):3–18.
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.
Hanson EN. A performance analysis of view materialization strategies. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1987. p. 440–53.
Labrinidis A, Roussopoulos N. A performance evaluation of online warehouse update algorithms. Technical report CS-TR-3954, Department of Computer Science, University of Marylan. 1998.
Quass D, Widom J. On-line warehouse view maintenance. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1997. p. 393–404.
Roussopoulos N, Kang H. Principles and techniques in the design of ADMS±. IEEE Comp. 1986;19(12):19–25.
Stonebraker M. Implementation of integrity constraints and views by query modification. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1975. p. 65–78.
Woodfill J, Stonebraker M. An implementation of hypothetical relations. In: Proceedings of the 9th International Conference on Very Data Bases; 1983. p. 157–66.
Zhuge Y, Garcia-Molina H, Hammer J, Widom J. View maintenance in a warehousing environment. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1995. p. 316–27.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Section Editor information
Rights and permissions
Copyright information
© 2018 Springer Science+Business Media, LLC, part of Springer Nature
About this entry
Cite this entry
Labrinidis, A., Sismanis, Y. (2018). View Maintenance. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_852
Download citation
DOI: https://doi.org/10.1007/978-1-4614-8265-9_852
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4614-8266-6
Online ISBN: 978-1-4614-8265-9
eBook Packages: Computer ScienceReference Module Computer Science and Engineering