Tackling the challenges of materialized view design in data warehousing environment

The design of materialized views in a data warehousing environment is an important problem which has been largely overlooked in the past. If one regards data warehouse queries as integrated views over the base databases, then there is a need to select a set of views to be materialized so that the best combination of good performance and low maintenance cost can be achieved. The authors compare materialized view design (MVD) work with related problems such as common subexpressions and multiple query processing, discuss the unique requirements of MVD, and outline possible solutions of addressing some of the challenging issues of MVD.