A Data Warehouse (DW) can be abstractly seen as a set of materialized views defined over relations that are stored in distributed
heterogeneous databases. The selection of views for materialization in a DW is thus an important decision problem. The objective
is the minimization of the combination of the query evaluation and view maintenance costs. In this paper we expand on our
previous work by proposing new heuristic algorithms for the DW design problem. These algorithms are described in terms of
a state space search problem, and are guaranteed to deliver an optimal solution by expanding only a small fraction of the
states produced by the (original) exhaustive algorithm.
Research supported by the European Commission under the ESPRIT Program LTR project “DWQ: Foundations of Data Warehouse Quality”