Abstract
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 language | English |
|---|---|
| Pages (from-to) | 451-460 |
| Number of pages | 10 |
| Journal | Informatica (Ljubljana) |
| Volume | 27 |
| Issue number | 4 |
| Publication status | Published - Dec 2003 |
| Externally published | Yes |
Keywords
- Data warehousing
- Dynamic view selection
- Materialized views