Skip to main content
SpringerLink
Log in

View Adaptation

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

  • 30 Accesses

Synonyms

Materialized view redefinition

Definition

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

Access this chapter

Log in via an institution

Institutional subscriptions

Recommended Reading

  1. Bellahsene Z. View adaptation in the fragment-based approach. IEEE Trans Knowl Data Eng. 2004;16(11):1441–55.

    Article  Google Scholar 

  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.

    Article  MATH  Google Scholar 

  3. Gupta A, Mumick IS, Ross KA. Adapting materialized views after redefinitions. In: Proceedings of the SIGMOD Conference on Management of Data. San Jose; 1995. p. 211–22.

    Google Scholar 

  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 

Download references

Author information

Authors and Affiliations

  1. Columbia University, New York, NY, USA

    Kenneth A. Ross

Authors
  1. Kenneth A. Ross
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Kenneth A. Ross .

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. Department of Informatics, Athens University of Economics and Business, 76, Patission Ave, 104 34, Athens, Greece

    Yannis Kotidis

Rights and permissions

Reprints and permissions

Copyright information

© 2017 Springer Science+Business Media LLC

About this entry

Cite this entry

Ross, K.A. (2017). View Adaptation. In: Liu, L., Özsu, M. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4899-7993-3_855-2

Download citation

  • DOI: https://doi.org/10.1007/978-1-4899-7993-3_855-2

  • Received:

  • Accepted:

  • Published:

  • Publisher Name: Springer, New York, NY

  • Print ISBN: 978-1-4899-7993-3

  • 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