| 基于遗传算法的物化视图优化方法 |
| |
| 引用本文： | 王宜贵. 基于遗传算法的物化视图优化方法[J]. 计算机与现代化, 2011, 0(8): 23-25. DOI: 10.3969/j.issn.1006-2475.2011.08.007 |
| |
| 作者姓名： | 王宜贵 |
| |
| 作者单位： | 山东电子职业技术学院,山东济南,250014 |
| |
| 摘 要： | 物化视图是提高数据仓库执行效率的有力方法,但是物化视图的保存会占用存储空间。本文把查询需要扫描的物化视图或事实表的空间大小作为查询时间开销,以查询的时间开销和物化视图的存储开销作为衡量标准建立代价估算模型,设计基于遗传算法的物化视图优化算法。目的是使系统在物化视图方面的存储开销和查询时间开销的和最小。试验结果表明算法可行。
|
| 关 键 词： | 数据仓库 物化视图 遗传算法 |
Optimization Method of Materialized View Based on Genetic Algorithm |
| |
| WANG Yi-gui. Optimization Method of Materialized View Based on Genetic Algorithm[J]. Computer and Modernization, 2011, 0(8): 23-25. DOI: 10.3969/j.issn.1006-2475.2011.08.007 |
| |
| Authors: | WANG Yi-gui |
| |
| Affiliation: | WANG Yi-gui(Shandong College of Electronic Technology,Jinan 250014,China) |
| |
| Abstract: | The materialized view is an important means of increasing the execution efficiency of a data warehouse,but the storage of materialized view costs space.This paper takes the materialized view which has to be scanned during the query or the space size of fact tables as the query time cost,the time cost of query and the storage cost of materialized view as measurement standard to build the cost estimation model and design the optimization algorithm of materialized view based on genetic algorithm,in order to mi... |
| |
| Keywords: | data warehouse materialized view genetic algorithm |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
