| Abstract |
|
In this paper we discuss the use of materialized views in the construction and maintenance of data warehousing environments. Although materializing views represents the most effective technique to improve OLAP (on-line analytical processing) query performance, it introduces particular challenges into these environments: (i) identification of which views to materialize, considering the trade-off among performance, scalability and view maintenance restrictions; and (ii) incremental maintenance of these views. In addition to analyzing and comparing some current proposals aimed at solving these two challenges, in this paper we also identify restrictions in the surveyed proposals to a Web distributed data warehousing environment, in which the warehouse data are fragmented, replicated and allocated through several sites. Some suggestions are made to overcome such restrictions.
|
 Additional Information
|
Index Terms- Data Warehousing, Materialized Views, Maintenance of Materialized Views, Selection of Views to Materialize, Data Warehouse Distribution
Citation:
Cristina Dutra de Aguiar Ciferri, Fernando da Fonseca de Souza,
"Materialized Views in Data Warehousing Environments,"
sccc,
p. 0003,
XXI International Conference of the Chilean Computer Science Society (SCCC'01),
2001
|
