Evolving materialized views in data warehouse

Chuan ZHANG, Xin YAO, Jian YANG

Research output: Book Chapters | Papers in Conference ProceedingsConference paper (refereed)Researchpeer-review

34 Citations (Scopus)


A data warehouse contains multiple views accessed by queries. One of the most important decisions in designing a data warehouse is the selection of materialized views for the purpose of efficiently implementing decision making. The search space for the selection of materialized views is exponentially large, therefore, heuristics have been used to search a small fraction of the space to get a near optimal solution. In this paper, we explore the use of a genetic algorithm for the selection of materialized views based on multiple global processing plans for many queries. Our experimental studies indicate that the genetic algorithm delivers better solutions than some heuristics. © 1999 IEEE.
Original languageEnglish
Title of host publicationProceedings of the 1999 Congress on Evolutionary Computation, CEC 1999
PublisherIEEE Computer Society
Number of pages7
Publication statusPublished - 20 Jan 2003
Externally publishedYes


Dive into the research topics of 'Evolving materialized views in data warehouse'. Together they form a unique fingerprint.

Cite this