Assortment of Materialized View: A Comparative Survey in Data Warehouse Environment

Abstract

Data warehouse is a repository of large amount of data collected from multiple heterogeneous and distributed data sources. Data warehouse stores lots of data in the form of views, referred as materialized views which provide a base for decision support or OLAP queries. Materialized views store the result of queries which improves the query performance. One of the most important aspect in data warehousing is the selection of materialized views which minimizes the query response time and maintenance cost, given a limited storage space. In this paper, analysis of various approaches of view selection in data warehousing environment is done that have been proposed in the recent past and also provided a comprehensive study of these approaches based on various parameters such as issues addressed, query language supported, comparison to benchmark etc.

Cite this paper

@inproceedings{Kirti2014AssortmentOM, title={Assortment of Materialized View: A Comparative Survey in Data Warehouse Environment}, author={Deepika Kirti and Jaspreeti Singh and Chuan Zhang and Xinsheng Yao and Jian Yang and Guisheng Yin and Xiang Yu and Liandong Lin and Kamel Aouiche and Pierre-Emmanuel Jouve and J{\'e}r{\^o}me Darmont and Satyanarayana R. Valluri and Soujanya Vadapalli and Kamalakar Karlapalem and Hongjun Lu and quot and In-Jeong Chung}, year={2014} }