A Hybrid Metaheuristic Framework for Materialized View Selection in Data Warehouse Environments

被引:0
|
作者
Srinivasarao, Popuri [1 ]
Satish, Aravapalli Rama [1 ]
机构
[1] AP Univ, Sch Comp Sci & Engn, VIT, Amaravati, India
关键词
Multiple view processing plan; materialized view selection; genetic algorithm; Aquila optimizer; view maintenance cost; query processing cost; response time;
D O I
暂无
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
The huge response time taken by the analytical queries is one of the most challenging problems in a data warehouse. The main reason for this high response time is the enormous amount of data being queried and the complex nature of the queries. This problem can be addressed with Materialized View Selection (MVS), where the optimal views with low response time are selected. To this end, the possible views for the analytical queries are randomly defined in the search space. Since most of the existing solutions are formulated based on semi-optimal solutions, this work introduces a hybrid metaheuristic-based framework to address the issue reliably. The major gaps in the existing research works are the resource wastage issue and the space constraint issue. These gaps are aimed to be addressed by the proposed hybrid framework. The proposed work integrates a Genetic Algorithm (GA) with Aquila Optimizer (AO) to search for the most optimal views from the search space. The presented solution follows highly efficient exploratory and exploitation behaviors to optimize the considered problem. Based on an iterative procedure, the most optimal views are selected by the hybrid framework, and these views are evaluated for minimum cost and time. Finally, performance evaluations are carried out to signify the practicality of the proposed approach.
引用
收藏
页数:34
相关论文
共 50 条
  • [1] A Hybrid Metaheuristic Framework for Materialized View Selection in Data Warehouse Environments
    Srinivasarao, Popuri
    Satish, Aravapalli Rama
    [J]. INTERNATIONAL JOURNAL OF COOPERATIVE INFORMATION SYSTEMS, 2023, 32 (04)
  • [2] Materialized View Selection in the Data Warehouse
    Zhou Lijuan
    Geng Haijun
    Xu Mingsheng
    [J]. APPLIED MECHANICS AND MECHANICAL ENGINEERING, PTS 1-3, 2010, 29-32 : 1133 - 1138
  • [3] Materialized view selection in a data warehouse
    Feng, Y
    Du, XY
    Wang, S
    [J]. WEB-AGE INFORMATION MANAGEMENT, PROCEEDINGS, 2000, 1846 : 323 - 328
  • [4] Research on Materialized View Selection in the Data Warehouse
    Zhou Li-juan
    Geng Hai-jun
    Xu Ming-sheng
    [J]. RECENT TRENDS IN MATERIALS AND MECHANICAL ENGINEERING MATERIALS, MECHATRONICS AND AUTOMATION, PTS 1-3, 2011, 55-57 : 361 - 366
  • [5] A novel coral reefs optimization algorithm for materialized view selection in data warehouse environments
    Hossein Azgomi
    Mohammad Karim Sohrabi
    [J]. Applied Intelligence, 2019, 49 : 3965 - 3989
  • [6] Research on Materialized View Selection Algorithm in Data Warehouse
    Zhou Lijuan
    Ge Xuebin
    Wang Linshuang
    Shi Qian
    [J]. 2009 INTERNATIONAL FORUM ON COMPUTER SCIENCE-TECHNOLOGY AND APPLICATIONS, VOL 2, PROCEEDINGS, 2009, : 326 - 329
  • [7] A novel coral reefs optimization algorithm for materialized view selection in data warehouse environments
    Azgomi, Hossein
    Sohrabi, Mohammad Karim
    [J]. APPLIED INTELLIGENCE, 2019, 49 (11) : 3965 - 3989
  • [8] ASVMRT: Materialized View Selection Algorithm in Data Warehouse
    Yang, Jin-Hyuk
    Chung, In-Jeong
    [J]. JOURNAL OF INFORMATION PROCESSING SYSTEMS, 2006, 2 (02): : 67 - 75
  • [9] Analysis and Comparison on Selection Algorithms of Materialized View in Data Warehouse
    Lin, Qiao
    [J]. 2011 INTERNATIONAL CONFERENCE ON FUTURE COMPUTERS IN EDUCATION (ICFCE 2011), VOL II, 2011, : 132 - 136
  • [10] Materialized view selection based on query cost in data warehouse
    Zhou, LJ
    Liu, C
    Liu, D
    [J]. DATA MINING AND KNOWLEDGE DISCOVERY: THEORY, TOOLS, AND TECHNOLOGY VI, 2004, 5433 : 246 - 252