|
|
|
| Research and realization of cross-platform information system data migration technology |
| Li Jing, Ma Chao, Huang Jingyu, Lu Yanyan |
| State Grid Hebei Information & Technology Company, Shijiazhuang 050000 |
|
|
|
|
Abstract The minicomputer equipment supported by the operation of the marketing analysis and auxiliary decision system of State Grid Hebei Corporation has been running for many years. In recent years, the IBM 9116-561 model device voltage regulator module has a family defect. There is a risk that the marketing data report cannot be reported normally due to the equipment failure, affecting the system. Safe and stable operation. Based on the above considerations, this article describes the key technologies involved in the migration of ETL and Sybase databases from existing minicomputer environments to PC server devices. The major technologies include: ① Informatica and workflow export and import; ② Sybase and ETL Extraction of tools; ③ Extraction of new environmental data. Through the technical research in the above aspects, it not only effectively solves the problems existing in the system operation process, lays the foundation for better follow-up operation and maintenance work, but also provides experience for the cross-platform migration of other systems, and has good reference value.
|
|
Received: 14 November 2018
Published: 29 September 2019
|
|
|
|
| Cite this article: |
|
Li Jing,Ma Chao,Huang Jingyu等. Research and realization of cross-platform information system data migration technology[J]. Electrical Engineering, 2019, 20(10): 70-74.
|
|
|
|
| URL: |
|
http://dqjs.cesmedia.cn/EN/Y2019/V20/I10/70
|
[1] 彭晓军. ETL技术在数据迁移中的应用及特殊数据的交换[D]. 西安: 西安电子科技大学, 2007.
[2] 宋鹏, 廉继红. ETL技术在复杂数据迁移项目中的应用[J]. 西安工程大学学报, 2008, 22(4): 493-497.
[3] 科普中国. 数据迁移(又称分级存储管理, hieraachical storage managerment, HSM)[EB/OL]. [201601]. http:// baike.baidu.com/item/数据迁移/10302464?tr=aladdin.
[4] 李晓峰, 宋君安. 数据迁移技术在多异构电力信息集成系统中的应用[J]. 江西电力, 2008, 32(6): 30-32.
[5] 李翀, 高玲玲, 陶鹏, 等. 用电信息采集系统跨平台数据迁移问题分析及处理[J]. 河北电力技术, 2016, 35(3): 11-13, 47.
[6] 李诗瑶. 浅谈Sybase数据库常见问题的原因及控制处理方法[J]. 计算机光盘软件与应用, 2014, 17(22): 117-118, 121.
[7] 郭乃网, 苏运, 瞿海妮, 等. 电力大数据安全体系架构研究与应用[J]. 电气技术, 2016, 17(11): 143-145.
[8] 肖民. 电力营销决策与辅助决策系统的设计与实现[D]. 成都: 电子科技大学, 2015.
[9] 吴国华. 数据库ETL在房产信息数据迁移整合中的应用[J]. 福建建设科技, 2016(4): 80-82.
[10] 陈俊. 企业信息化项目中的业务数据迁移研究[D]. 苏州: 苏州大学, 2014. |
|
|
|
2019, Vol. 20 
