Anatomization of miscellaneous approaches for selection and maintenance of Materialized view

Data Warehouse is a repository of large amount of data collected from multiple data sources. It is mainly used for processing of queries and detailed analysis of data that is useful for decision makers. Hence to make this data available in less amount of time is essential. Here comes the concept of Materialize view. Materialized view stores result of queries which improve query performance. It is not possible to materialize all the views since to materialize a view, requires cost for maintenance and also storage space. Hence proper materialized views selection is one of the important decisions in designing a data warehouse to get best possible results. So it is required to select materialized view which minimizes response time of query and cost of maintenance. In this paper, detailed analysis of miscellaneous methods of materialized view selection and maintenance is done.