Welcome to the InfoSci Platform
Reference Hub3
Materialized Views in Multidimensional Databases

Materialized Views in Multidimensional Databases

Stefano Paraboschi, Giuseppe Sindoni, Elena Baralis, Ernst Teniente
Copyright: © 2003 |Pages: 30
ISBN13: 9781591400530|ISBN10: 1591400538|EISBN13: 9781591400868
DOI: 10.4018/978-1-59140-053-0.ch008
Cite Chapter Cite Chapter

MLA

Paraboschi, Stefano, et al. "Materialized Views in Multidimensional Databases." Multidimensional Databases: Problems and Solutions, edited by Maurizio Rafanelli, IGI Global, 2003, pp. 222-251. https://doi.org/10.4018/978-1-59140-053-0.ch008

APA

Paraboschi, S., Sindoni, G., Baralis, E., & Teniente, E. (2003). Materialized Views in Multidimensional Databases. In M. Rafanelli (Ed.), Multidimensional Databases: Problems and Solutions (pp. 222-251). IGI Global. https://doi.org/10.4018/978-1-59140-053-0.ch008

Chicago

Paraboschi, Stefano, et al. "Materialized Views in Multidimensional Databases." In Multidimensional Databases: Problems and Solutions, edited by Maurizio Rafanelli, 222-251. Hershey, PA: IGI Global, 2003. https://doi.org/10.4018/978-1-59140-053-0.ch008

Export Reference

Mendeley
Favorite

Abstract

This chapter presents materialized views in the context of multidimensional databases (MDDBs). A materialized view is a view whose content is explicitly stored in the database. The advantage of materializing views is that it is not necessary to recompute the query every time the view is accessed. The shortcoming is that it has to be kept consistent with the updates on the base tables. However, efficient incremental maintenance techniques have been proposed. MDDBs are an ideal environment for materialized views because frequency of updates is low, MDDB data models permit easy adoption of incremental maintenance, and queries can be modeled in such a way to allow an easy definition of the view selection problem, i.e., the problem of selecting which query to materialize in an MDDB. Hence, we present the problems of choosing and maintaining materialised views with the corresponding solutions.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.