Dynamic Materialized View Selection in Data Warehouse Environment

Chuan Zhang*, Jian Yang, Kamalakar Karlapalem

*Corresponding author for this work

Research output: Contribution to journalArticlepeer-review

6 Citations (Scopus)


Materialized view selection is one of the important areas in data warehouse design. Due to the dynamic nature of data warehouse, materialized views should evolve in response to the application requirement change, which is studied as a dynamic materialized view selection problem. One aspect of dynamic materialized view selection that differs from static materialized view selection is that the existing materialized views should be taken into consideration when selecting new materialized views. In this paper, a frame-work is presented to illustrate the design methodology for dynamic materialized view selection. A new cost - the materialized view reorganization cost is introduced and incorporated when selecting new views to materialize. Based on our cost model, a set of algorithms for dynamic materialized view selection are developed and some experimental results are provided.

Original languageEnglish
Pages (from-to)451-460
Number of pages10
JournalInformatica (Ljubljana)
Issue number4
Publication statusPublished - Dec 2003
Externally publishedYes


  • Data warehousing
  • Dynamic view selection
  • Materialized views


Dive into the research topics of 'Dynamic Materialized View Selection in Data Warehouse Environment'. Together they form a unique fingerprint.

Cite this