Volume 9 Issue 4 - February 2018

  • 1. Fsvmrt: materialized view selection algorithm in data warehouse using ‘r’

    Authors : Dr. B. Ashadevi, V. Sindhuja

    Pages : 184-191

    DOI : http://dx.doi.org/10.21172/1.94.28

    Keywords : Keywords:Data Warehouse, Data Warehousing, Views, Materialization, View Selection, Clustering

    Abstract :

    Abstract - A data warehouse processes a given set of queries by utilizing the multiple materialized views. One of the critical decisions involved in the process of designing a data warehouse for optimal efficiency, is the materialized views selection. Due to space and maintenance cost constraint, the materialization of all views is unfeasible. The total cost associated with the materialized views to be minimized by selecting a suitable set of views in data warehousing . In this paper, we present a framework for selection of views to materialize based on the K- means clustering method using ‘R’ to overcome the problem resulting from conventional view selection algorithms. In the presented algorithm, Framework for Selection of Views to Materialize using Reduced Table (FSVMRT), we first generate reduced tables in the data warehouse using K – means clustering by R tool, and then we consider the combination of reduced tables as materialized views instead of a combination of the original base relations. This algorithm optimizes storage space and query processing cost of the views. Thus, an efficient data warehousing system is the outcome.

    Citing this Journal Article :

    Dr. B. Ashadevi, V. Sindhuja, "Fsvmrt: materialized view selection algorithm in data warehouse using ‘r’", Volume 9 Issue 4 - February 2018, 184-191