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/Territory | Greece |
City | Athens |
Period | 26/08/97 → 29/08/97 |