The Community for Technology Leaders
Proceedings of 17th International Conference on Distributed Computing Systems (1997)
Baltimore, MD
May 27, 1997 to May 30, 1997
ISSN: 1063-6927
ISBN: 0-8186-7813-5
pp: 458
Jian Yang , Australian Defence Force Academy
Kamalakar Karlapalem , Clear Water Bay, Kowloon, Hong Kong
Qing Li , Hong Kong Polytechnic Univ.
ABSTRACT
Data warehouses are accessed by different queries with different frequencies. The portions of data accessed by a query can be treated as a view. When these views are related to each other and defined over overlapping portions of the base data, then it may be more efficient not to materialize all the views, but rather to materialize certain ``shared views'' from which the query results can be generated. In this paper, we address some issues related to determining this set of shared views to be materialized in order to achieve the best combination of good performance and low maintenance, and provide an algorithm for achieving this goal.
INDEX TERMS
Data warehousing, materialized view, Common expression, Multiple Query Optimization.
CITATION

Q. Li, J. Yang and K. Karlapalem, "A Framework for Designing Materialized Views in Data Warehousing Environment," Proceedings of 17th International Conference on Distributed Computing Systems(ICDCS), Baltimore, MD, 1997, pp. 458.
doi:10.1109/ICDCS.1997.603380
90 ms
(Ver 3.3 (11022016))