Over View of Past Literature and Making Comparative Analysis Along with Our Strategy of Materialized View Selection

Sapna Choudhary, Roshna Mahajan

Abstract: This study is carried out with the aims of undertaking survey of the different approaches used by the researchers to select materialized view in optimal manner of data warehouse (DW). We have done comparative analysis of the available literature on the basis of relevant evaluation parameters viz. processing time, query frequency and spatial cost, area, storage etc. Our designed approach of materialized view selection is also given in this paper. This study may be helpful to the researchers, who are working in the domain of the data warehouse (DW) focusing on the materialized view selection.

Keywords: Data warehouse DW, materialized view, comparative analysis, processing time, query frequency and spatial cost, area, storage