A Comparative Study of Materialised View Selection in Data Warehouse Environment

2013 5th International Conference on Computational Intelligence and Communication Networks Pub Date : 2013-09-27 DOI:10.1109/CICN.2013.100

Alka, A. Gosain

{"title":"A Comparative Study of Materialised View Selection in Data Warehouse Environment","authors":"Alka, A. Gosain","doi":"10.1109/CICN.2013.100","DOIUrl":null,"url":null,"abstract":"A data warehouse (DW) contains many views accessed by different queries. Amongst the most important decisions in designing a DW is the selection of views to materialize for efficiently supporting the process of decision making. Materialized views are advantageous because they provide faster access to data and enhance the query performance. The major factors involved in materialization of views include query processing cost and view maintenance cost. Materialized views are kept up to date by using various techniques viz. view selection, view synchronization, view maintenance and view adaptation. Selection of the materialized views is, however, one of the most vital tasks in data warehousing environment in order to provide optimal efficiency by reducing query response time and query processing as well. In this paper, we present various approaches of view selection in data warehousing environment that have been proposed in the past. We have provided a comprehensive study on research works of many authors on certain important parameters and presented a comparative analysis in tabular format.","PeriodicalId":415274,"journal":{"name":"2013 5th International Conference on Computational Intelligence and Communication Networks","volume":"53 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2013-09-27","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"3","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"2013 5th International Conference on Computational Intelligence and Communication Networks","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/CICN.2013.100","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 3

Abstract

A data warehouse (DW) contains many views accessed by different queries. Amongst the most important decisions in designing a DW is the selection of views to materialize for efficiently supporting the process of decision making. Materialized views are advantageous because they provide faster access to data and enhance the query performance. The major factors involved in materialization of views include query processing cost and view maintenance cost. Materialized views are kept up to date by using various techniques viz. view selection, view synchronization, view maintenance and view adaptation. Selection of the materialized views is, however, one of the most vital tasks in data warehousing environment in order to provide optimal efficiency by reducing query response time and query processing as well. In this paper, we present various approaches of view selection in data warehousing environment that have been proposed in the past. We have provided a comprehensive study on research works of many authors on certain important parameters and presented a comparative analysis in tabular format.

查看原文本刊更多论文

数据仓库环境下物化视图选择的比较研究

数据仓库(DW)包含由不同查询访问的许多视图。设计DW中最重要的决策之一是选择要实现的视图，以有效地支持决策制定过程。物化视图是有利的，因为它们提供了更快的数据访问并增强了查询性能。视图物化所涉及的主要因素包括查询处理成本和视图维护成本。物化视图通过使用视图选择、视图同步、视图维护和视图自适应等技术来保持更新。然而，选择物化视图是数据仓库环境中最重要的任务之一，以便通过减少查询响应时间和查询处理来提供最佳效率。在本文中，我们介绍了过去提出的数据仓库环境中视图选择的各种方法。我们对许多作者在某些重要参数上的研究成果进行了综合研究，并以表格形式进行了比较分析。

本文章由计算机程序翻译，如有差异，请以英文原文为准。

求助全文

约1分钟内获得全文求助全文

来源期刊

2013 5th International Conference on Computational Intelligence and Communication Networks

自引率

0.00%

发文量