Academic Journals Database
Disseminating quality controlled scientific knowledge

A comparative study analysis of materialized view for selection cost

Author(s): T.Nalini | A.Kumaravel | K.Rangarajan

Journal: International Journal of Computer Science and Engineering Survey
ISSN 0976-3252

Volume: 3;
Issue: 1;
Start page: 13;
Date: 2012;
VIEW PDF   PDF DOWNLOAD PDF   Download PDF Original page

Keywords: materialization view | data warehousing | selection cost | I-mine item set index | FP growth

Materialized view selection is one of the most crucial techniques to design data warehouse in an optimal manner. Selecting views to materialize for the purpose of supporting the decision making efficiently is one of the most significant decisions in designing Data Warehouse. Selecting a set of derived views tomaterialize which minimizes the sum of total query response time & maintenance of the selected views is defined as view selection problem. Selecting a suitable set of views that minimizes the total cost associated with the materialized views is the key objective of data warehousing. In this paper we compare the various research works on several parameters for controlling the selection process and also we compare time , query frequency and spatial cost.
RPA Switzerland

Robotic Process Automation Switzerland


Tango Jona
Tangokurs Rapperswil-Jona