Algorithm for selection of materialized views: based on a costs model

被引：13

作者：

Serna-Encinas, Maria Trinidad ^{[1
]}

Hoyo-Montao, Jose Antonio ^{[1
]}

机构：

[1] Inst Tecnol Hermosillo, Av Tecnol S-N Final,Col El Sahuaro, Hermosillo, Sonora, Mexico

来源：

ENC 2007: EIGHTH MEXICAN INTERNATIONAL CONFERENCE ON CURRENT TRENDS IN COMPUTER SCIENCE, PROCEEDINGS | 2007年

关键词：

D O I：

10.1109/ENC.2007.14

中图分类号：

TP18 [人工智能理论];

学科分类号：

081104 ; 0812 ; 0835 ; 1405 ;

摘要：

A data warehouse integrates businesses' information from both inner and outer data sources. The data set is use to assist the decision taking process, therefore, the multidimensional model design and the selection of materialized views represent a complex and thoughtful process. In this paper a new algorithm for the selection of optimum set of materialized views is proposed. The proposed algorithm establishes this set based on the utilization rate, calculation cost and the relationship update rate. The development of this work was made within a medical research project, allowing the testing and validation of the proposed algorithm under a real-life application.

引用

页码：18 / +

页数：2

共 50 条

[1] An Efficient MA-Based Materialized Views Selection Algorithm
Zhang, Qingzhou
Sun, Xia
Wang, Ziqiang
[J]. 2009 IITA INTERNATIONAL CONFERENCE ON CONTROL, AUTOMATION AND SYSTEMS ENGINEERING, PROCEEDINGS, 2009, : 315 - 318
[2] A View Recommendation Greedy Algorithm for Materialized Views Selection
Kumar, T. V. Vijay
Haider, Mohammad
Kumar, Santosh
[J]. INFORMATION INTELLIGENCE, SYSTEMS, TECHNOLOGY AND MANAGEMENT, 2011, 141 : 61 - 70
[3] 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
[J]. Jisuanji Gongcheng, 2006, 6 (79-81):
[4] The Model and Realization of Materialized Views Selection in Data Warehouse
Zhou, Lijuan
Wu, Minhua
Ge, Xuebin
[J]. FIFTH INTERNATIONAL CONFERENCE ON FUZZY SYSTEMS AND KNOWLEDGE DISCOVERY, VOL 5, PROCEEDINGS, 2008, : 406 - 411
[5] Selection of materialized views using stochastic ranking based Backtracking Search Optimization Algorithm
Gosain, Anjana
Sachdeva, Kavita
[J]. INTERNATIONAL JOURNAL OF SYSTEM ASSURANCE ENGINEERING AND MANAGEMENT, 2019, 10 (04) : 801 - 810
[6] Preprocessor of Materialized Views Selection
Zhang, Baili
Yang, Le
Zhou, Zhikai
Jiang, Hongjian
Liu, Ruizhao
Han, Jianxiong
[J]. 2018 FIRST INTERNATIONAL COGNITIVE CITIES CONFERENCE (IC3 2018), 2018, : 1 - 6
[7] Selection of materialized views using stochastic ranking based Backtracking Search Optimization Algorithm
Anjana Gosain
Kavita Sachdeva
[J]. International Journal of System Assurance Engineering and Management, 2019, 10 : 801 - 810
[8] Selection of materialized views:: A cost-based approach
Baril, X
Bellahsène, Z
[J]. ADVANCED INFORMATION SYSTEMS ENGINEERING, PROCEEDINGS, 2003, 2681 : 665 - 680
[9] Creation of Materialized Views Based on Neural Network Algorithm
Abbassi, Kamel
Ezzedine, Tahar
[J]. 2018 14TH INTERNATIONAL WIRELESS COMMUNICATIONS & MOBILE COMPUTING CONFERENCE (IWCMC), 2018, : 1542 - 1547
[10] Materialized Views Selection in Distributed Networks
Huang, Zhenhua
Zhao, Zhenqi
Cheng, Jiujun
[J]. JOURNAL OF INTERNET TECHNOLOGY, 2019, 20 (02): : 423 - 433

← 1 2 3 4 5 →