ETL技术在电网信息系统业务数据迁移中的应用

Application of ETL technology in business data migration of power grid information system

随着企业业务量的增加和业务的变化,旧的企业管理系统难以支撑企业日常的业务,需要对管理系统更新换代。旧系统中积累了大量珍贵的数据资源,这些数据对于新系统的良好运转是十分必要的。但是新旧系统的数据结构差异使得旧系统的数据不能直接应用于新系统,需要高质量的数据迁移。为了保证历史数据能够应用于新的管理系统,以海南营销管理系统旧系统数据迁移为背景,对数据迁移技术进行了探讨和设计,并将ETL技术成功应用于旧营销系统的数据迁移,并总结了在数据迁移项目中使用的管理方法。

With the increase of business volume and the change of the business,the old enterprise management system is difficult to support the daily business and needs to upgrade.The massive precious data resources are accumulated in the old system,which is necessary for the good working of the new system.But the differences of data structure of the old and new system make that the data of old system cannot be directly applied to the new system,so,the high quality data migration is necessary.In order that the historical data can be applied to the new management system,taking the data migration in Hainan marketing management system of the old system as the background,the technology of data migration is discussed and designed,at the same time,the ETL technology has been successfully applied to data migration of the old marketing system,and finally the management methods used in the data migration project is concluded.