Selecting Materialized Views based on Genetic Algorithm
Zhixiang Zhu, Dongjin Yu · Advanced Science and Technology Letters · 2014
As the data sets increase in data warehouse day by day, the cost used for OLAP operations becomes extremely high. One of the most effective ways to solve this problem is to build appropriate materialized views in the data warehouse. In order to select the appropriate views to be materialized with the possible minimized cost, we propose a novel approach to the materialized view selection problem based on a genetic algorithm. Experimental results show that the optimal solution for selecting materialized views can be obtained effectively using the approach presented.