Abstract
Selecting views to materialize is one of the most important decisions in designing a data warehouse. In this paper, we present a frame work for analyzing the issues in selecting views to materialize so as to achieve the best combination of good query performance and low view maintenance. We first develop a heuristic algorithm which can provide a feasible solution based on individual optimal query plans. We also map the materialized view design problem as 0-1 integer programming problem, whose solution can guarantee an optimal solution.
| Original language | English |
|---|---|
| Title of host publication | Proceedings of the 23rd International Conference on Very Large Databases, VLDB 1997 |
| Editors | Matthias Jarke |
| Place of Publication | San Fransisco, CA |
| Publisher | Morgan Kaufmann |
| Pages | 136-145 |
| Number of pages | 10 |
| ISBN (Electronic) | 1558604707, 9781558604704 |
| Publication status | Published - 1997 |
| Externally published | Yes |
| Event | 23rd International Conference on Very Large Databases, VLDB 1997 - Athens, Greece Duration: 26 Aug 1997 → 29 Aug 1997 |
Other
| Other | 23rd International Conference on Very Large Databases, VLDB 1997 |
|---|---|
| Country | Greece |
| City | Athens |
| Period | 26/08/97 → 29/08/97 |