Title :
Tackling the challenges of materialized view design in data warehousing environment
Author :
Yang, Jian ; Karlapalem, Kamalakar ; Li, Qing
Author_Institution :
Dept. of Comput. Sci., New South Wales Univ., Canberra, NSW, Australia
Abstract :
The design of materialized views in a data warehousing environment is an important problem which has been largely overlooked in the past. If one regards data warehouse queries as integrated views over the base databases, then there is a need to select a set of views to be materialized so that the best combination of good performance and low maintenance cost can be achieved. The authors compare materialized view design (MVD) work with related problems such as common subexpressions and multiple query processing, discuss the unique requirements of MVD, and outline possible solutions of addressing some of the challenging issues of MVD
Keywords :
distributed databases; query processing; very large databases; common subexpressions; data warehouse queries; data warehousing environment; databases; high performance; integrated views; low maintenance cost; materialized view design; multiple query processing; Australia; Computer science; Costs; Data warehouses; Distributed databases; Educational institutions; Materials science and technology; Query processing; Warehousing; Water resources;
Conference_Titel :
Research Issues in Data Engineering, 1997. Proceedings. Seventh International Workshop on
Conference_Location :
Birmingham
Print_ISBN :
0-8186-7849-6
DOI :
10.1109/RIDE.1997.583695
