Improve Query Performance Using Effective Materialized View Selection and Maintenance: A Survey
Data Warehouse (DW) can be defined as a set of data cubes defined over the source relation. To avoid complex query evaluation based on master table, to increase the speed of queries posted to a data warehouse, the authors can use some snapshot results from the query processing stored in the data warehouse called materialized views. Appropriate materialized views selection is one of the better and crucial decisions in designing a data warehouse for high efficiency as well as it is the basic requirement of successful business application. Materialized views are found extremely useful for quick query processing. In this paper, first they are focusing on various techniques that are implemented in past, recent for the selection of materialized view.