Framework for designing materialized views in data warehousing environment

Jian Yang*, Kamalakar Karlapalem, Qing Li

*Corresponding author for this work

Research output: Chapter in Book/Report/Conference proceedingConference proceeding contributionpeer-review

34 Citations (Scopus)

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.

Original languageEnglish
Title of host publicationProceedings - International Conference on Distributed Computing Systems
Place of PublicationLos Alamitos, CA
PublisherInstitute of Electrical and Electronics Engineers (IEEE)
Pages458-465
Number of pages8
ISBN (Print)0818678143 , 0818678135
Publication statusPublished - 1997
Externally publishedYes
EventProceedings of the 1997 17th International Conference on Distributed Computing Systems - Baltimore, MD, USA
Duration: 27 May 199730 May 1997

Other

OtherProceedings of the 1997 17th International Conference on Distributed Computing Systems
CityBaltimore, MD, USA
Period27/05/9730/05/97

Fingerprint

Dive into the research topics of 'Framework for designing materialized views in data warehousing environment'. Together they form a unique fingerprint.

Cite this