Share Email Print

Proceedings Paper

Selecting materialized views in a data warehouse
Author(s): Lijuan Zhou; Chi Liu; Daxin Liu
Format Member Price Non-Member Price
PDF $17.00 $21.00

Paper Abstract

A Data Warehouse contains lots of materialized views over the data provided by the distributed heterogeneous databases for the purpose of efficiently implementing decision-support or OLAP queries. It is important to select the right view to materialize that answer a given set of queries. In this paper, we have addressed and designed algorithm to select a set of views to materialize in order to answer the most queries under the constraint of a given space. The algorithm presented in this paper aim at making out a minimum set of views, by which we can directly respond to as many as possible user’s query requests. We use experiments to demonstrate our approach. The results show that our algorithm works better. We implemented our algorithms and a performance study of the algorithm shows that the proposed algorithm gives a less complexity and higher speeds and feasible expandability.

Paper Details

Date Published: 10 January 2003
PDF: 6 pages
Proc. SPIE 5021, Storage and Retrieval for Media Databases 2003, (10 January 2003); doi: 10.1117/12.476247
Show Author Affiliations
Lijuan Zhou, Harbin Univ. of Science and Technology (China)
Harbin Engineering Univ. (China)
Chi Liu, Harbin Univ. of Science and Technology (China)
Daxin Liu, Harbin Engineering Univ. (China)

Published in SPIE Proceedings Vol. 5021:
Storage and Retrieval for Media Databases 2003
Minerva M. Yeung; Rainer W. Lienhart; Chung-Sheng Li, Editor(s)

© SPIE. Terms of Use
Back to Top
Sign in to read the full article
Create a free SPIE account to get access to
premium articles and original research
Forgot your username?