Applying evolutionary algorithms to materialized view selection in a data warehouse

J. T. Horng, Y. J. Chang, B. J. Liu

Research output: Contribution to journalArticlepeer-review

31 Scopus citations


Effective analysis of genome sequences and associated functional data requires access to many different kinds of biological information. A data warehouse [14,16] plays an important role for storage and analysis for genome sequence and functional data. A data warehouse stores lots of materialized views to provide an efficient decision-support or OLAP queries. The view-selection problem addresses to select a fittest set of materialized views from a variety of MVPPs 0 forms a challenge in data warehouse research. In this paper, we present genetic algorithm to choose materialized views. We also use experiments to demonstrate the power of our approach.

Original languageEnglish
Pages (from-to)574-581
Number of pages8
JournalSoft Computing
Issue number8
StatePublished - Jul 2003


  • Data warehouses
  • Genetic algorithms
  • Genomes
  • Materialized views


Dive into the research topics of 'Applying evolutionary algorithms to materialized view selection in a data warehouse'. Together they form a unique fingerprint.

Cite this