Study of Various Methodologies for Selection of Materialized View

Priti Badar
2016 An International Journal of Engineering & Technology   unpublished
Fast reply time and correctness are significant factors in the success of any database. In huge databases mostly in distributed database, query reply time plays a vital role as timely access to information and it is the essential condition of successful business application. A data warehouse utilizes multiple materialized views to proficiently process a given set of queries. The main objective of data warehousing is to choose an appropriate set of views that minimizes the total cost associated
more » ... al cost associated with the materialized views. The materialization of all views is not achievable because of the space constraint and maintenance cost constraint. Materialized views selection is one of the vital decisions in designing a data warehouse for optimal efficiency. Choosing a suitable set of views that minimizes the total cost related with the materialized views is the main aim of data warehousing. This paper discusses various methodologies for choosing views to materialize so as to get the best grouping of good query reply, low query processing cost and low view maintenance cost in a given storage space constraints. These methodologies take into account all the cost metrics related with the materialized views selection. They pick the most cost effective views to materialize and thus optimize the maintenance, storage and query processing cost, thereby resulting in a proficient data warehousing system.