Foundations and Trends® in Databases > Vol 4 > Issue 4

Materialized Views

Rada Chirkova, North Carolina State University, Department of Computer Science, USA, chirkova@csc.ncsu.edu Jun Yang, Duke University, Department of Computer Science, USA, junyang@cs.duke.edu
 
Suggested Citation
Rada Chirkova and Jun Yang (2012), "Materialized Views", Foundations and TrendsĀ® in Databases: Vol. 4: No. 4, pp 295-405. http://dx.doi.org/10.1561/1900000020

Published: 14 Dec 2012
© 2012 R. Chirkova and J. Yang
 
Subjects
Query Processing and Optimization,  Data Warehousing,  Data Integration and Exchange,  Database Design and Tuning
 

Free Preview:

Article Help

Share

Download article
In this article:
1. Introduction
2. Maintaining Materialized Views
3. Using Materialized Views
4. Selecting Views to Materialize
5. Connections to Other Problems
6. Conclusion and Future Directions
References

Abstract

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.

DOI:10.1561/1900000020
ISBN: 978-1-60198-622-1
116 pp. $80.00
Buy book
 
ISBN: 978-1-60198-623-8
116 pp. $110.00
Buy E-book
Table of contents:
1. Introduction
2. Maintaining Materialized Views
3. Using Materialized Views
4. Selecting Views to Materialize
5. Connections to Other Problems
6. Conclusion and Future Directions
References

Materialized Views

Materialized views are a natural embodiment of the ideas of precomputation and caching in databases. Instead of computing a query from scratch, a system can use results that have already been computed, stored, and kept in sync with database updates. The ability of materialized views to speed up queries benefits most database applications, ranging from traditional querying and reporting to web database caching, online analytical processing, and data mining. By reducing dependency on the availability of base data, materialized views have also laid much of the foundation for information integration and data warehousing systems. The database tradition of declarative querying distinguishes materialized views from generic applications of precomputation and caching in other contexts, and makes materialized views especially interesting, powerful, and challenging at the same time. Study of materialized views has generated a rich research literature and mature commercial implementations, aimed at providing efficient, effective, automated, and general solutions to the selection, use, and maintenance of materialized views.

This monograph provides an accessible introduction and reference to materialized views, explains its core ideas, highlights its recent developments, and points out its sometimes subtle connections to other research topics in databases.

 
DBS-020