Encyclopedia of Database Systems

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

View Adaptation

  • Kenneth A. RossEmail author
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_855


Materialized view redefinition


Small changes to the definition of a materialized view are often needed in database systems. View adaptation is the process of keeping a materialized view up-to-date when the definition of the view is changed. View adaptation aims to leverage the previously materialized view to generate the new view, since the cost of rebuilding the materialized view from scratch may be expensive.

Key Points

View adaptation is related to the question of answering queries using views. The new view can be thought of as a query, with the old view available to help compute it. However, view adaptation also admits in-place changes that are not possible using a query-answering approach. For example, if a redefined view contains most but not all of the records from the original view, then view adaptation could be achieved by deleting the records that no longer qualify.

A variety of adaptation techniques are presented in [2, 3], allowing changes to the...

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

Recommended Reading

  1. 1.
    Bellahsene Z. View adaptation in the fragment-based approach. IEEE Trans Knowl Data Eng. 2004;16(11):1441–55.CrossRefGoogle Scholar
  2. 2.
    Gupta A, Mumick IS, Rao J, Ross KA. Adapting materialized views after redefinitions: techniques and a performance study. Inf Syst. 2001;26(5):323–62.zbMATHCrossRefGoogle Scholar
  3. 3.
    Gupta A, Mumick IS, Ross KA. Adapting materialized views after redefinitions. In: Proceedings of the SIGMOD Conference on Management of Data; 1995. p. 211–22.zbMATHCrossRefGoogle Scholar
  4. 4.
    Mohania MK, Dong G. Algorithms for adapting materialized views in data warehouses. In: Proceedings of the International Symposium on Cooperative Database Systems for Advanced Applications; 1996. p. 309–16.Google Scholar

Copyright information

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

Authors and Affiliations

  1. 1.Columbia UniversityNew YorkUSA

Section editors and affiliations

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