ETL应用优化设计与实现研究

Study on the Optimization Design and Implementation of ETL Application

摘要: 分析和研究了传统ETL工作流程处理过程,采用JAVA技术,提出了ETL工作流程优化方案,对传统ETL性能问题提出了优化办法,并进行优化处理,很好地解决了数据集成处理过程数据融合、数据一致化和数据同步更新等重要问题,减轻了瓶颈制约,节约了处理时间开销.实际应用证明,优化后的ETL流程方案有效地减少了传统ETL工作流的时间花费,执行效率好,具有良好的实践应用价值.

Abstract: The processing procedure of the traditional ETL work flow is analyzed and studied.Based on JAVA,the optimized scheme of ETL work flow is presented,and it optimizes the traditional ETL performance,perfectly solves the problems about data fusion,data consistency and data synchronous update in the data integration processing procedure,and reduces bottleneck restriction and the processing time.The application proves that the optimized ETL flow scheme effectively reduces the time of the traditional ETL workflow with favorable application value.