Materialization of fragmented views in multidimensional databases

Matteo Golfarelli, Vittorio Maniezzo, Stefano Rizzi
2004 Data & Knowledge Engineering  
The most effective technique to enhance performances of multidimensional databases consists in materializing redundant aggregates called views. In the classical approach to materialization, each view includes all and only the measures of the cube it aggregates. In this paper we investigate the benefits of materializing views in vertical fragments, aimed at minimizing the workload response time. We formalize the fragmentation problem as a 0-1 integer linear programming problem, which is then
more » ... ed by means of a standard integer programming solver to determine the optimal fragmentation for a given workload. Finally, we demonstrate the usefulness of fragmentation by presenting a large set of experimental results based on the TPC-H benchmark.
doi:10.1016/j.datak.2003.11.001 fatcat:7fjokqe2xvfvvanspt3gz44use