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

Deepika Kirti, Jaspreeti Singh
2014 International Journal of Computer Applications  
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
more » ... ce 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.
doi:10.5120/16803-6521 fatcat:uzol5cawl5ambpov6zlsys3t7q