Tackling the challenges of materialized view design 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

5 Citations (Scopus)

Abstract

How to design materialized views in a data warehousing environment is an important problem which has been largely overlooked in the past. If we regard data warehouse queries as integrated views over the base databases, then there exists a need of selecting a set of views to be materialized so that the best combination of good performance and low maintenance cost can be achieved. In this paper, we compare materialized view design (MVD) work with such related problems 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.

Original languageEnglish
Title of host publicationProceedings of the IEEE International Workshop on Research Issues in Data Engineering
EditorsPeter Scheuermann
Place of PublicationLos Alamitos, CA
PublisherInstitute of Electrical and Electronics Engineers (IEEE)
Pages32-41
Number of pages10
ISBN (Print)0818678496
Publication statusPublished - 1997
Externally publishedYes
EventProceedings of the 1997 7th International Workshop on Research Issues in Data Engineering, RIDE'97 - Birmingham, UK
Duration: 7 Apr 19978 Apr 1997

Other

OtherProceedings of the 1997 7th International Workshop on Research Issues in Data Engineering, RIDE'97
CityBirmingham, UK
Period7/04/978/04/97

Fingerprint

Dive into the research topics of 'Tackling the challenges of materialized view design in data warehousing environment'. Together they form a unique fingerprint.

Cite this