Research and Optimization of Materialized Views Selection Algorithm Based on the Data Warehouse

Jian Bing Xiahou; Qian Qian Wei; Xiao Na Deng; Xiao Wei Liu

doi:10.4028/www.scientific.net/AMR.926-930.3165

Paper Titles

Primary Functions on a Curve and its Applications
p.3149

QSPR Model for Predicting Retention Time Basis on Gene Expression Programming
p.3153

Real-Time Intrusion Detection Based on System Call and ARTIS Model
p.3157

Real-Time Video Matting Algorithm Based on Chroma Key
p.3161

Research and Optimization of Materialized Views Selection Algorithm Based on the Data Warehouse
p.3165

Research of Digital Image Watermarking Robustness Algorithm Based on DCT
p.3171

Research of Particle Swarm Optimization Algorithm and its Applications in Optimization Theory
p.3175

Research of Single Cavity Exhaust Muffler Based on AML and CFD Method
p.3179

Research on an Improved Random Weight GA Based on Heap Sort
p.3183

HomeAdvanced Materials ResearchAdvanced Materials Research Vols. 926-930Research and Optimization of Materialized Views...

Research and Optimization of Materialized Views Selection Algorithm Based on the Data Warehouse

Abstract:

Materialized view is an effective mothed for improving the efficiency of queries in data warehouse system,and materialized views selection problem is one of the most important decisions in designing a data warehouse.This paper begins with a brief introduction to materialized view and study of the existing materialized viewalgorithm.Then in order toselect an appropriate set of views that minimizes total query response timeand the cost of maintaining the selected views under a limitedstorage space, a hybrid algorithm combined with the advantages of ant colony algorithm and immune genetic algorithm is proposed.Inaddition,analyze the shortcomings of this algorithm and propose some improvement ideas, which optimize the efficiency of algorithm to some extent.