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
Tax calculation will be finalised at checkout
Purchases are for personal use only
Recommended Reading
Bellahsene Z. View adaptation in the fragment-based approach. IEEE Trans Knowl Data Eng. 2004;16(11):1441–55.
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.
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.
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.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Section Editor information
Rights and permissions
Copyright information
© 2018 Springer Science+Business Media, LLC, part of Springer Nature
About this entry
Cite this entry
Ross, K.A. (2018). View Adaptation. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_855
Download citation
DOI: https://doi.org/10.1007/978-1-4614-8265-9_855
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4614-8266-6
Online ISBN: 978-1-4614-8265-9
eBook Packages: Computer ScienceReference Module Computer Science and Engineering