Lecture Notes in Computer Science, 2002, Volume 2419/2002, 313-350, DOI: 10.1007/3-540-45703-8_23

What Difference Heuristics Make: Maintenance-Cost View-Selection Revisited

Chi-Hon Choi, Jeffrey Xu Yu and Gang Gou

View Related Documents

Abstract

The maintenance-cost view-selection problem is one of the important issues in data warehouse design. It is to select a set of materialized views under a maintenance cost constraint (such as maintenance time), in order to minimize the total query processing cost for a given set of queries. The problem has recently received significant attention. Several greedy/heuristic algorithms were proposed. However, the quality of the greedy/heuristic algorithms has not been well analyzed. In this paper, in a multidimensional data warehouse environment, we reexamine the greedy/heuristic algorithms in various settings, and provide users with insights on the quality of these heuristic algorithms.

Fulltext Preview

Image of the first page of the fulltext document