A Comparative Study of Materialised View Selection in Data Warehouse Environment

A data warehouse (DW) contains many views accessed by different queries. Amongst the most important decisions in designing a DW is the selection of views to materialize for efficiently supporting the process of decision making. Materialized views are advantageous because they provide faster access to data and enhance the query performance. The major factors involved in materialization of views include query processing cost and view maintenance cost. Materialized views are kept up to date by using various techniques viz. view selection, view synchronization, view maintenance and view adaptation. Selection of the materialized views is, however, one of the most vital tasks in data warehousing environment in order to provide optimal efficiency by reducing query response time and query processing as well. In this paper, we present various approaches of view selection in data warehousing environment that have been proposed in the past. We have provided a comprehensive study on research works of many authors on certain important parameters and presented a comparative analysis in tabular format.