Skip to main content
SpringerLink
Log in

View Maintenance

  • Living reference work entry
  • First Online:
Encyclopedia of Database Systems

  • 72 Accesses

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

Access this chapter

Log in via an institution

Institutional subscriptions

Recommended Reading

  1. Blakeley JA, Larson PÅ, Tompa FW. Efficiently Updating Materialized Views. In: Proceedings of ACM SIGMOD international conference on management of data. 1986. p. 61–71.

    Google Scholar 

  2. Buneman P, Clemons EK. Efficient monitoring relational databases. ACM Trans Database Syst. 1979;4(3):368–82.

    Article  Google Scholar 

  3. Chaudhuri S, Dayal U. An overview of data warehousing and OLAP technology. ACM SIGMOD Rec. 1997;26(1):65–74.

    Article  Google Scholar 

  4. Colby LS, Griffin T, Libkin L, Mumick IS, Trickey H. Algorithms for deferred view maintenance. In: Proceedings of ACM SIGMOD international conference on management of dat. 1996. p. 469–80.

    Google Scholar 

  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. Gupta A, Mumick IS, Subrahmanian VS. Maintaining views incrementally. In: Proceedings of ACM SIGMOD international conference on management of data. 1993. p. 157–66.

    Google Scholar 

  7. Hanson EN. A performance analysis of view materialization strategies. In: Proceedings of ACM SIGMOD international conference on management of data. 1987. p. 440–53.

    Google Scholar 

  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. Quass D, Widom J. On-line warehouse view maintenance. In: Proceedings of ACM SIGMOD international conference on management of data. 1997. p. 393–404.

    Google Scholar 

  10. Roussopoulos N, Kang H. Principles and techniques in the design of ADMS±. IEEE Comp. 1986;19(12):19–25.

    Article  Google Scholar 

  11. Stonebraker M. Implementation of integrity constraints and views by query modification. In: Proceedings of ACM SIGMOD international conference on management of data. 1975. p. 65–78.

    Google Scholar 

  12. Woodfill J, Stonebraker M. An implementation of hypothetical relations. In: Proceedings of 9th international conference on very data bases, 1983. p. 157–66.

    Google Scholar 

  13. Zhuge Y, Garcia-Molina H, Hammer J, Widom J. View maintenance in a warehousing environment. In: Proceedings of ACM SIGMOD international conference on management of data. 1995. p. 316–27.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Computer Science, University of Pittsburgh, Pittsburgh, PA, USA

    Alexandros Labrinidis

  2. IBM Almaden Research Center, Almaden, CA, USA

    Yannis Sismanis

Authors
  1. Alexandros Labrinidis
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Yannis Sismanis
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Alexandros Labrinidis .

Editor information

Editors and Affiliations

  1. Georgia Institute of Technology College of Computing, Atlanta, Georgia, USA

    Ling Liu

  2. University of Waterloo School of Computer Science, Waterloo, Ontario, Canada

    M. Tamer Özsu

Section Editor information

  1. Computer Science Dept., Athens Univ. of Economics and Business, 76, Patission Ave, 104 34, Athens, Greece

    Yannis Kotidis

Rights and permissions

Reprints and permissions

Copyright information

© 2016 Springer Science+Business Media LLC

About this entry

Cite this entry

Labrinidis, A., Sismanis, Y. (2016). View Maintenance. In: Liu, L., Özsu, M. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4899-7993-3_852-2

Download citation

  • DOI: https://doi.org/10.1007/978-1-4899-7993-3_852-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

Publish with us

Policies and ethics

Search

Navigation