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] 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,
  • [22] 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
  • [23] 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):
  • [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] Materialized view selection under the maintenance time constraint
    Liang, WF
    Wang, H
    Orlowska, ME
    DATA & KNOWLEDGE ENGINEERING, 2001, 37 (02) : 203 - 216
  • [26] ASVMRT: Materialized View Selection Algorithm in Data Warehouse
    Yang, Jin-Hyuk
    Chung, In-Jeong
    JOURNAL OF INFORMATION PROCESSING SYSTEMS, 2006, 2 (02): : 67 - 75
  • [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] 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
  • [30] Simulated annealing for materialized view selection in data warehousing environment
    Derakhshan, Roozbeh
    Dehne, Frank
    Korn, Othmar
    Stantic, Bela
    PROCEEDINGS OF THE IASTED INTERNATIONAL CONFERENCE ON DATABASES AND APPLICATIONS, 2006, : 89 - +
12345