| 银行管理信息系统服务器国产化过程中的ETL应用迁移 |
| |
| 引用本文： | 张春瑞,赵成坤,吴川,陈非.银行管理信息系统服务器国产化过程中的ETL应用迁移[J].计算机系统应用,2015,24(10):264-270. |
| |
| 作者姓名： | 张春瑞 赵成坤 吴川 陈非 |
| |
| 作者单位： | 中国建设银行新疆分行信息技术部, 乌鲁木齐 830000;中国建设银行新疆分行信息技术部, 乌鲁木齐 830000;中国建设银行新疆分行信息技术部, 乌鲁木齐 830000;中国建设银行新疆分行信息技术部, 乌鲁木齐 830000 |
| |
| 摘 要： | 本文对某国有大型银行省级分行将ETL应用系统由访问进口服务器迁移至国产高端容错计算机环境的过程进行了描述. 通过基于应用域的数据拆分和基于视图/物化视图、数据同步、同义词的数据同步, 基本完成了分行应用数据从进口服务器环境往国产高端容错计算机环境的迁移过程. 在这个过程中, 我们发现由于客观条件的限制, 数据同步前后数据的一致性结果比较存在一定难度, 对应用迁移正确性的确认造成不利影响. 在实际的迁移过程中, 通过相应的措施保证, 顺利完成了迁移过程.
|
| 关 键 词： | 服务器国产化 ETL 数据迁移 物化视图 国产高端容错计算机 |
| 收稿时间： | 2015/5/12 0:00:00 |
| 修稿时间： | 2015/8/10 0:00:00 |
Process of ETL Application Migration to Server Localization on Bank Information Management System |
| |
| ZHANG Chun-Rui,ZHAO Cheng-Kun,WU Chuan and CHEN Fei.Process of ETL Application Migration to Server Localization on Bank Information Management System[J].Computer Systems& Applications,2015,24(10):264-270. |
| |
| Authors: | ZHANG Chun-Rui ZHAO Cheng-Kun WU Chuan and CHEN Fei |
| |
| Affiliation: | Information Technology Department, Xinjiang Branch of China Construction Bank, Wulumuqi 830000, China;Information Technology Department, Xinjiang Branch of China Construction Bank, Wulumuqi 830000, China;Information Technology Department, Xinjiang Branch of China Construction Bank, Wulumuqi 830000, China;Information Technology Department, Xinjiang Branch of China Construction Bank, Wulumuqi 830000, China |
| |
| Abstract: | In this paper, we describe a migration process of ETL system to localized server environment in a large state-owned bank branch. Using technologies of data separation based on application domain and data synchronization based on views/materialized views, data, data synchronization, Synonym, we mainly accomplish the process of migrating branch-related data from imported server environment to localized server environment. In this process, the cause of data incorrectness during application migration is found, which arises from insufficiently support of commercial database system to temporal data. This problem makes it difficult to develop programs to check data synchronization result. In the actual process of migration, through the corresponding measures to ensure that we successfully completed the migration process. |
| |
| Keywords: | server localization ETL data migration materialized view domestic high-end fault-tolerant computer |
|
| 点击此处可从《计算机系统应用》浏览原始摘要信息 |
|
点击此处可从《计算机系统应用》下载全文 |
|
