Evolving materialized views in data warehouse

Chuan Zhang, Xin Yao, Jian Yang

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

33 Citations (Scopus)

Abstract

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.

Original languageEnglish
Title of host publicationProceedings of the 1999 Congress on Evolutionary Computation, CEC 1999
Place of PublicationPiscataway, NJ
PublisherInstitute of Electrical and Electronics Engineers (IEEE)
Pages823-829
Number of pages7
Volume2
ISBN (Print)0780355369
DOIs
Publication statusPublished - 1999
Externally publishedYes
Event1999 Congress on Evolutionary Computation, CEC 1999 - Washington, DC, United States
Duration: 6 Jul 19999 Jul 1999

Other

Other1999 Congress on Evolutionary Computation, CEC 1999
CountryUnited States
CityWashington, DC
Period6/07/999/07/99

Fingerprint

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

Cite this