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

在对军械装备保障数据仓库体系结构进行研究的基础上,针对ETL任务的调度优化问题进行研究。通过对ETL调度过程的数学化描述,采用一种改进的粒子群算法,实现了对调度过程的优化。通过改进惯性向量,形成更具寻优特性的改进粒子群算法,并应用在以最小执行时间为目标函数的ETL任务调度中。实践证明,采用此种改进算法,在调度优化中取得良好应用效果,相对传统方式执行效率有了较大提升。

Research on Ordnance Equipment Support Data Warehouse ETL Process Optimizing

The structure of ordnance equipment support data warehouse 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 PSO in ETL task scheduling. The use of IPSO improves the performance of ETL process in ordnance equipment support data warehouse.