Title :
Anatomization of miscellaneous approaches for selection and maintenance of Materialized view
Author :
Shailesh Kurzadkar;Abhijeet Bajpayee
Author_Institution :
Department of Computer Science and Engineering, Nagpur Institute of Technology, India
Abstract :
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.
Keywords :
"Maintenance engineering","Data warehouses","Time factors","Computer science","Clustering algorithms","Conferences","Query processing"
Conference_Titel :
Intelligent Systems and Control (ISCO), 2015 IEEE 9th International Conference on
DOI :
10.1109/ISCO.2015.7282236