计算机工程与应用 ›› 2012, Vol. 48 ›› Issue (25): 154-158.

• 数据库、信号与信息处理 • 上一篇    下一篇

数据立方体实体化的多目标遗传算法

陈  佳,李  敏   

  1. 武汉纺织大学 数学与计算机学院,武汉 430073
  • 出版日期:2012-09-01 发布日期:2012-08-30

Multiobjective genetic algorithms for materialized view selection in OLAP data warehouses

CHEN Jia, LI Min   

  1. School of Mathematics and Computer Science, Wuhan Textile University, Wuhan 430073, China
  • Online:2012-09-01 Published:2012-08-30

摘要: 多维数据实视图选择问题是一个NP完全问题。提出一种基于约束的多目标优化遗传算法,将查询代价和维护代价分开考虑,更有效地解决复杂的实视图选择问题。实验结果表明,该算法具有更好的性能,特别是在获得的Pareto前沿的分布性上。

关键词: 多目标优化, 遗传算法, 数据仓库, 视图选择

Abstract: The data cube selection problem is known to be an NP-hard problem. This paper presents an evolutionary algorithm in which query cost and maintenance cost are considered separately for constrained optimization and  more effectively addresses the complex view-selection problem. The experimental results show that the multi-objective optimization algorithm has better performance, especially in the distribution of the obtained Pareto front.

Key words: multiobjective optimization, genetic algorithms, data warehouse, view selection