Materialized View Selection in the Data Warehouse

被引：0
|
作者：
Zhou Lijuan [1 ]
Geng Haijun [1 ]
Xu Mingsheng [1 ]
机构：
[1] Capital Normal Univ, Informat Engn Coll, Beijing 100037, Peoples R China
来源：
APPLIED MECHANICS AND MECHANICAL ENGINEERING, PTS 1-3 | 2010年 / 29-32卷
关键词：
materialized view selection; multidimensional lattice; HRU algorithm; PGA algorithm;
D O I：
10.4028/www.scientific.net/AMM.29-32.1133
中图分类号：
TH [机械、仪表工业];
学科分类号：
0802 ;
摘要：
A data warehouse stores materialized views of data from one or more sources, with the purpose of efficiently implementing decision-support or OLAP queries. Materialized view selection is one of the crucial decisions in designing a data warehouse for optimal efficiency. The goal is to select an appropriate set of views that minimizes sum of the query response time and the cost of maintaining the selected views; given a limited amount of resource, e.g., materialization time, storage space, etc. In this article, we present an improved PGA algorithm to accomplish the view selection problem; the experiments show that our proposed algorithm shows it's superior.
引用
收藏
页码：1133 / 1138
页数：6
相关论文
共 50 条
  • [1] Materialized view selection in a data warehouse
    Feng, Y
    Du, XY
    Wang, S
    [J]. WEB-AGE INFORMATION MANAGEMENT, PROCEEDINGS, 2000, 1846 : 323 - 328
  • [2] 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
  • [3] 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
  • [4] 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
  • [5] 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
  • [6] 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
  • [7] Applying evolutionary algorithms to materialized view selection in a data warehouse
    Horng, JT
    Chang, YJ
    Liu, BJ
    [J]. SOFT COMPUTING, 2003, 7 (08) : 574 - 581
  • [8] Materialized View Selection for a Data Warehouse Using Frequent Itemset Mining
    Sohrabi, Mohammad Karim
    Ghods, Vahid
    [J]. JOURNAL OF COMPUTERS, 2016, 11 (02) : 140 - 148
  • [9] 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)
  • [10] 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,
12345