Title
Materialized Views In Data Warehousing Environments
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.
Year
DOI
Venue
2001
10.1109/SCCC.2001.972626
SCCC 2001: XXI INTERNATIONAL CONFERENCE OF THE CHILEAN COMPUTER SCIENCE SOCIETY, PROCEEDINGS
Keywords
Field
DocType
data warehouses,scalability,olap,materialized views,data warehousing,performance,warehousing,databases,distributed databases,information analysis
Data warehouse,Data mining,Computer science,Incremental maintenance,View maintenance,Distributed database,Online analytical processing,Materialized view,Database,Scalability
Conference
Citations 
PageRank 
References 
2
0.41
16
Authors
2
Name
Order
Citations
PageRank
Cristina Dutra De Aguiar Ciferri116627.92
Fernando da Fonseca de Souza2367.89