Materialized Views in Multidimensional Databases
Stefano Paraboschi (Universita di Bergamo, Italy), Giuseppe Sindoni (National Institute of Statistics, Italy), Elena Baralis (Politecnico di Torino, Italy) and Ernst Teniente (Universitat Politecnica de Catalunya, Spain)
Copyright: © 2003
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.