Tackling the challenges of materialized view design in data warehousing environment

Jian Yang, Kamalakar Karlapalem, Qing Li

Research output: Unpublished conference presentation (presented paper, abstract, poster)Conference presentation (not published in journal/proceeding/book)Academic researchpeer-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
Pages32-41
Number of pages10
Publication statusPublished - 1 Jan 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

Conference

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

ASJC Scopus subject areas

  • Hardware and Architecture
  • Software
  • Engineering (miscellaneous)

Cite this