Encyclopedia of Database Systems

2018 Edition
| Editors: Ling Liu, M. Tamer Özsu

View Maintenance

  • Alexandros Labrinidis
  • Yannis Sismanis
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_852

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 to check access.

Recommended Reading

  1. 1.
    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.CrossRefGoogle Scholar
  2. 2.
    Buneman P, Clemons EK. Efficient monitoring relational databases. ACM Trans Database Syst. 1979;4(3):368–82.CrossRefGoogle Scholar
  3. 3.
    Chaudhuri S, Dayal U. An overview of data warehousing and OLAP technology. ACM SIGMOD Rec. 1997;26(1):65–74.CrossRefGoogle Scholar
  4. 4.
    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.Google Scholar
  5. 5.
    Gupta A, Mumick IS. Maintenance of materialized views: problems, techniques, and applications. IEEE Data Eng Bull. 1995;18(2):3–18.Google Scholar
  6. 6.
    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.Google Scholar
  7. 7.
    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.Google Scholar
  8. 8.
    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.Google Scholar
  9. 9.
    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.Google Scholar
  10. 10.
    Roussopoulos N, Kang H. Principles and techniques in the design of ADMS±. IEEE Comp. 1986;19(12):19–25.CrossRefGoogle Scholar
  11. 11.
    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.Google Scholar
  12. 12.
    Woodfill J, Stonebraker M. An implementation of hypothetical relations. In: Proceedings of the 9th International Conference on Very Data Bases; 1983. p. 157–66.Google Scholar
  13. 13.
    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.CrossRefGoogle Scholar

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2018

Authors and Affiliations

  1. 1.Department of Computer ScienceUniversity of PittsburghPittsburghUSA
  2. 2.IBM Almaden Research CenterAlmadenUSA

Section editors and affiliations

  • Yannis Kotidis
    • 1
  1. 1.Computer Science Dept.Athens Univ. of Economics and BusinessAthensGreece