Skip to main content
Journal cover image

Materialized views

Publication ,  Journal Article
Chirkova, R; Yang, J
Published in: Foundations and Trends in Databases
December 1, 2011

Materialized views are queries whose results are stored and maintained in order to facilitate access to data in their underlying base tables. In the SQL setting, they are now considered a mature technology implemented by most commercial database systems and tightly integrated into query optimization. They have also helped lay the foundation for important topics such as information integration and data warehousing. This monograph provides an introduction and reference to materialized views. We cover three fundamental problems: (1) maintaining materialized views efficiently when the base tables change, (2) using materialized views effectively to improve performance and availability, and (3) selecting which views to materialize. We also point out their connections to a few other areas in database research, illustrate the benefit of cross-pollination of ideas with these areas, and identify several directions for research on materialized views. © 2012 R. Chirkova and J. Yang.

Duke Scholars

Altmetric Attention Stats
Dimensions Citation Stats

Published In

Foundations and Trends in Databases

DOI

EISSN

1931-7891

ISSN

1931-7883

Publication Date

December 1, 2011

Volume

4

Issue

4

Start / End Page

295 / 405
 

Citation

APA
Chicago
ICMJE
MLA
NLM
Chirkova, R., & Yang, J. (2011). Materialized views. Foundations and Trends in Databases, 4(4), 295–405. https://doi.org/10.1561/1900000020
Chirkova, R., and J. Yang. “Materialized views.” Foundations and Trends in Databases 4, no. 4 (December 1, 2011): 295–405. https://doi.org/10.1561/1900000020.
Chirkova R, Yang J. Materialized views. Foundations and Trends in Databases. 2011 Dec 1;4(4):295–405.
Chirkova, R., and J. Yang. “Materialized views.” Foundations and Trends in Databases, vol. 4, no. 4, Dec. 2011, pp. 295–405. Scopus, doi:10.1561/1900000020.
Chirkova R, Yang J. Materialized views. Foundations and Trends in Databases. 2011 Dec 1;4(4):295–405.
Journal cover image

Published In

Foundations and Trends in Databases

DOI

EISSN

1931-7891

ISSN

1931-7883

Publication Date

December 1, 2011

Volume

4

Issue

4

Start / End Page

295 / 405