军械装备保障数据仓库中的ETL过程优化研究

Research on Ordnance Equipment Support Data Warehouse ETL Process Optimizing

摘要:

针对军械装备保障数据仓库中复杂的ETL过程,提出采用改进的粒子群算法进行ETL任务调度的优化策略;通过改进惯性向量,使其具备动态调整能力,形成更具寻优特性的动态w粒子群算法(DWPSO)；在对数据仓库ETL调度过程进行数学化描述的基础上,将改进算法应用在以最小执行时间为目标函数任务调度中,并通过仿真实验证明了该算法的有效性。

Abstract:

The structure of data warehouse ETL Process is studied in this paper. An improved method is put forward to optimize scheduling process for lifting efficiency of ETL process. By improving inertia vector, the performance of PSO gets promoted. Experiments proved that the improved PSO is much better than traditional algorithm. The use of DWPSO improves the performance of ETL process in ordnance equipment support data warehouse.