Approaches for Selecting Views to Materialize Based on Multi-Maintenance Strategy

A data warehouse stores materialized views,with the purpose of efficiently implementing OLAP queries or decision-support.Hence,selecting views to materialize is one of the most important decisions in designing a data ware- house.In this paper,we present a framework for analyzing the issues ,which goal is to select an appropriate set of views so that the sum cost of processing queries and maintaining the materialized views is minimized.Based on the proposed benefit model,we proposed two approaches.The target of first approach is to solve the problem considering both multi- query optimization and the maintenance process optimization.In this approach,we present three algorithms:IRMVS, IMVS and RMVS.The second approach uses a simple search strategy that can cut down the time complexity to a line- ar.The comparative experiment indicates that these algorithms are efficient and feasible.