A Systematic Review on Materialized View Selection

被引：5
|
作者：
Gosain, Anjana [1 ]
Sachdeva, Kavita [1 ]
机构：
[1] Guru Gobind Singh Indraprastha Univ, Univ Sch Informat & Commun Technol, New Delhi 110078, India
来源：
PROCEEDINGS OF THE 5TH INTERNATIONAL CONFERENCE ON FRONTIERS IN INTELLIGENT COMPUTING: THEORY AND APPLICATIONS, FICTA 2016, VOL 1 | 2017年 / 515卷
关键词：
Data warehouse; Data warehouse evolution; View materialization; View selection; Business intelligence; Query optimization; Caching;
D O I：
10.1007/978-981-10-3153-3_66
中图分类号：
TP [自动化技术、计算机技术];
学科分类号：
0812 ;
摘要：
The purpose of materialized view selection is to minimize the cost of answering queries and fast query response time for timely access to information and decision support. Besides various research issues related to data warehouse evolution, materialized view selection is one of the most challenging ones. Various authors have given different methodologies, strategies and followed algorithms to solve this problem in an efficient manner. The main motivation behind this systematic review is to provide a path for future research scope in materialized view selection. Various techniques presented in the papers are identified, evaluated, and compared in terms of memory storage space, cost, and query processing time to find if any particular approach is superior to others. By means of a review of the available literature, the authors have drawn several conclusions about the status quo of materialized view selection and a future outlook is predicted on bridging the large gaps that were found in the existing methods.
引用
收藏
页码：663 / 671
页数：9
相关论文
共 50 条
  • [21] Research on Materialized View Selection Algorithm in Data Warehouse
    Zhou Lijuan
    Ge Xuebin
    Wang Linshuang
    Shi Qian
    2009 INTERNATIONAL FORUM ON COMPUTER SCIENCE-TECHNOLOGY AND APPLICATIONS, VOL 2, PROCEEDINGS, 2009, : 326 - 329
  • [22] Applying improved genetic algorithm to materialized view selection
    College of Computer and Communication Engineering, China University of Petroleum , Dongying 257061, China
    J. Comput. Inf. Syst., 2009, 2 (1003-1008):
  • [23] Anatomization of Miscellaneous Approaches for Selection and Maintenance of Materialized View
    Kurzadkar, Shailesh
    Bajpayee, Abhijeet
    PROCEEDINGS OF 2015 IEEE 9TH INTERNATIONAL CONFERENCE ON INTELLIGENT SYSTEMS AND CONTROL (ISCO), 2015,
  • [24] Architecture Based Materialized View Evolution: A Review
    Gosain, Anjana
    Sabharwal, Sangeeta
    Gupta, Rolly
    INTERNATIONAL CONFERENCE ON COMPUTER, COMMUNICATION AND CONVERGENCE (ICCC 2015), 2015, 48 : 256 - 262
  • [25] ASVMRT: Materialized View Selection Algorithm in Data Warehouse
    Yang, Jin-Hyuk
    Chung, In-Jeong
    JOURNAL OF INFORMATION PROCESSING SYSTEMS, 2006, 2 (02): : 67 - 75
  • [26] Materialized view selection under the maintenance time constraint
    Liang, WF
    Wang, H
    Orlowska, ME
    DATA & KNOWLEDGE ENGINEERING, 2001, 37 (02) : 203 - 216
  • [27] Model Based Materialized View Evolution: A Review
    Gosain, Anjana
    Sabharwal, Sangeeta
    Gupta, Rolly
    3RD INTERNATIONAL CONFERENCE ON RECENT TRENDS IN COMPUTING 2015 (ICRTC-2015), 2015, 57 : 1273 - 1280
  • [28] Materialized view selection based on query cost in data warehouse
    Zhou, LJ
    Liu, C
    Liu, D
    DATA MINING AND KNOWLEDGE DISCOVERY: THEORY, TOOLS, AND TECHNOLOGY VI, 2004, 5433 : 246 - 252
  • [29] SOFOS: Demonstrating the Challenges of Materialized View Selection on Knowledge Graphs
    Troullinou, Georgia
    Kondylakis, Haridimos
    Lissandrini, Matteo
    Mottin, Davide
    SIGMOD '21: PROCEEDINGS OF THE 2021 INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA, 2021, : 2789 - 2793
  • [30] Multi-objective materialized view selection using MOGA
    Prakash, Jay
    Vijay Kumar, T. V.
    INTERNATIONAL JOURNAL OF SYSTEM ASSURANCE ENGINEERING AND MANAGEMENT, 2020, 11 (SUPPL 2) : 220 - 231
12345