Encyclopedia of Database Systems

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

Self-Maintenance of Views

  • Himanshu Gupta
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_839

Definition

A data warehouse is a collection of materialized views derived from base relations that may not reside at the warehouse. It is important to keep the views up to date in response to changes to the base relations. Self-maintenance of views involves maintaining the views, using information that is strictly local to the warehouse: the view definitions and the view contents. Such self-maintenance of views (whenever possible) is more efficient than incremental maintenance or recomputation of views.

Key Points

In a data warehouse, views are computed and stored in the database to allow efficient querying and analysis of the data. These views stored at the data warehouse are known as materialized viewsand are defined in terms of the base relations residing in data sources that may or may not be local to the warehouse. To keep the views consistent with the base data, any change reported by the data sources must be reflected in the views. In response to the changes at the base...

This is a preview of subscription content, log in to check access.

Recommended Reading

  1. 1.
    Gupta A, Blakeley JA. Using partial information to update materialized views. Inf Syst. 1995;20(9):641–62.CrossRefGoogle Scholar
  2. 2.
    Gupta A, Mumick IS. Maintenance of materialized views: problems, techniques, and applications. IEEE Data Eng Bull. 1995;18(2):3–18.Google Scholar
  3. 3.
    Huyn N. Efficient view self-maintenance. In: Proceedings of the Workshop on Materialized Views; 1996.Google Scholar
  4. 4.
    Huyn N. Multiple-view self-maintenance in data warehousing environments. In: Proceedings of the 23rd International Conference on Very Large Data Bases; 1997.Google Scholar
  5. 5.
    Tompa FW, Blakeley JA. Maintaining materialized views without accessing base data. Inf Syst. 1988;13(4):393–406.zbMATHCrossRefGoogle Scholar

Copyright information

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

Authors and Affiliations

  1. 1.Stony Brook UniversityStony BrookUSA

Section editors and affiliations

  • Yannis Kotidis
    • 1
  1. 1.Department of InformaticsAthens Universitu of Economics and BusinessAthensGreece