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 条
  • [21] Selecting materialized views in a data warehouse
    Zhou, LJ
    Liu, C
    Liu, DX
    [J]. STORAGE AND RETRIEVAL FOR MEDIA DATABASES 2003, 2003, 5021 : 456 - 461
  • [22] Simulated annealing for materialized view selection in data warehousing environment
    Derakhshan, Roozbeh
    Dehne, Frank
    Korn, Othmar
    Stantic, Bela
    [J]. PROCEEDINGS OF THE IASTED INTERNATIONAL CONFERENCE ON DATABASES AND APPLICATIONS, 2006, : 89 - +
  • [23] Research on materialized view selection
    Lin, Zi-Yu
    Yang, Dong-Qing
    Wang, Teng-Jiao
    Song, Guo-Jie
    [J]. Ruan Jian Xue Bao/Journal of Software, 2009, 20 (02): : 193 - 213
  • [24] View selection for designing the global data warehouse
    Theodoratos, D
    Ligoudistianos, S
    Sellis, T
    [J]. DATA & KNOWLEDGE ENGINEERING, 2001, 39 (03) : 219 - 240
  • [25] Materialized view selection for multi-cube data models
    Shukla, A
    Deshpande, PM
    Naughton, JF
    [J]. ADVANCES IN DATABASE TECHNOLOGY-DEBT 2000, PROCEEDINGS, 2000, 1777 : 269 - 284
  • [26] Parallel generation of base relation snapshots for materialized view maintenance in data warehouse environment
    Saeki, S
    Bhalla, S
    Hasegawa, M
    [J]. 2002 INTERNATIONAL CONFERENCE ON PARALLEL PROCESSING, PROCEEDINGS OF THE WORKSHOPS, 2002, : 383 - 390
  • [27] Materialized View Selection for Aggregate View Recommendation
    Ehsan, Humaira
    Sharaf, Mohamed A.
    [J]. DATABASES THEORY AND APPLICATIONS (ADC 2019), 2019, 11393 : 104 - 118
  • [28] Clustering-based materialized view selection in data warehouses
    Aouiche, Kamel
    Jouve, Pierre-Emmanuel
    Darmont, Jerome
    [J]. ADVANCES IN DATABASES AND INFORMATION SYSTEMS, PROCEEDINGS, 2006, 4152 : 81 - 95
  • [29] Data mining-based materialized view and index selection in data warehouses
    Kamel Aouiche
    Jérôme Darmont
    [J]. Journal of Intelligent Information Systems, 2009, 33 : 65 - 93
  • [30] Algorithms for Selecting Materialized Views in a Data Warehouse
    Yousri, Noha A. R.
    Ahmed, Khalil M.
    El-Makky, Nagwa M.
    [J]. 3RD ACS/IEEE INTERNATIONAL CONFERENCE ON COMPUTER SYSTEMS AND APPLICATIONS, 2005, 2005,
12345