loading...
Materialized Views in Data Warehousing Environments
Punta Arenas, Chile November 07-November 09
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/SCCC.2001.972626XXI International Conference of the C ...
 This Article 
 
PDF
HTML
 
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
Cristina Dutra de Aguiar Ciferri, Universidade Estadual de Maring?
Fernando da Fonseca de Souza, Universidade Federal de Pernambuco
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.
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, pp.0003, XXI International Conference of the Chilean Computer Science Society (SCCC'01), 2001
Usage of this product signifies your acceptance of the Terms of Use.