The Model and Realization of Materialized Views Selection in Data Warehouse

被引：0

作者：

Zhou, Lijuan ^{[1
]}

Wu, Minhua ^{[1
]}

Ge, Xuebin ^{[1
]}

机构：

[1] Capital Normal Univ, Beijing 100037, Peoples R China

来源：

FIFTH INTERNATIONAL CONFERENCE ON FUZZY SYSTEMS AND KNOWLEDGE DISCOVERY, VOL 5, PROCEEDINGS | 2008年

关键词：

D O I：

10.1109/FSKD.2008.390

中图分类号：

TP18 [人工智能理论];

学科分类号：

081104 ; 0812 ; 0835 ; 1405 ;

摘要：

The data warehouse is a repository of information collected from multiple, possibly heterogeneous, autonomous, distributed databases. The information stored at the data warehouse is in form of views referred to as materialized vies. One of the most important decisions in designing a data warehouse is selection of right views to be materialized So, we develop algorithms to select a set of views to materialize in data warehouse in order to minimize the total view maintenance cost under the constraint of a given query response time. We call it query cost view selection problem (QC_VSP). In this paper, First, we propose the cast model of QC_VSP Second; we design algorithms for QC_VSP. Third; we use experiments do demonstrate the porter of our approach.

引用

页码：406 / 411

页数：6

共 50 条

[21] Applying evolutionary algorithms to materialized view selection in a data warehouse
Horng, JT
Chang, YJ
Liu, BJ
SOFT COMPUTING, 2003, 7 (08) : 574 - 581
[22] Selection of views to materialize in a data warehouse
Gupta, H
Mumick, IS
IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2005, 17 (01) : 24 - 43
[23] Selection of views to materialize in a data warehouse
Gupta, H
DATABASE THEORY - ICDT'97, 1997, 1186 : 98 - 112
[24] Dealing with overlapped materialized views in the algorithms of dynamic selection for materialized views
Department of Computer Science and Engineering, Shanghai University, Shanghai 200072, China
Jisuanji Gongcheng, 2006, 6 (79-81):
[25] Materialized View Selection for a Data Warehouse Using Frequent Itemset Mining
Sohrabi, Mohammad Karim
Ghods, Vahid
JOURNAL OF COMPUTERS, 2016, 11 (02) : 140 - 148
[26] Algorithm for selection of materialized views: based on a costs model
Serna-Encinas, Maria Trinidad
Hoyo-Montao, Jose Antonio
ENC 2007: EIGHTH MEXICAN INTERNATIONAL CONFERENCE ON CURRENT TRENDS IN COMPUTER SCIENCE, PROCEEDINGS, 2007, : 18 - +
[27] Preprocessor of Materialized Views Selection
Zhang, Baili
Yang, Le
Zhou, Zhikai
Jiang, Hongjian
Liu, Ruizhao
Han, Jianxiong
2018 FIRST INTERNATIONAL COGNITIVE CITIES CONFERENCE (IC3 2018), 2018, : 1 - 6
[28] A Hybrid Metaheuristic Framework for Materialized View Selection in Data Warehouse Environments
Srinivasarao, Popuri
Satish, Aravapalli Rama
INTERNATIONAL JOURNAL OF COOPERATIVE INFORMATION SYSTEMS, 2023, 32 (04)
[29] A Hybrid Metaheuristic Framework for Materialized View Selection in Data Warehouse Environments
Srinivasarao, Popuri
Satish, Aravapalli Rama
INTERNATIONAL JOURNAL OF COOPERATIVE INFORMATION SYSTEMS, 2023,
[30] Dynamic selection of materialized views of multi-dimensional data
Inst. of Math., Acad. of Math. and Syst. Sci., Chinese Acad. of Sci., Beijing 100080, China
Ruan Jian Xue Bao/Journal of Software, 2002, 13 (06): : 1090 - 1096

← 1 2 3 4 5 →