本文已被:浏览 1063次 下载 2184次
Received:May 12, 2015 Revised:August 10, 2015
Received:May 12, 2015 Revised:August 10, 2015
中文摘要: 本文对某国有大型银行省级分行将ETL应用系统由访问进口服务器迁移至国产高端容错计算机环境的过程进行了描述. 通过基于应用域的数据拆分和基于视图/物化视图、数据同步、同义词的数据同步, 基本完成了分行应用数据从进口服务器环境往国产高端容错计算机环境的迁移过程. 在这个过程中, 我们发现由于客观条件的限制, 数据同步前后数据的一致性结果比较存在一定难度, 对应用迁移正确性的确认造成不利影响. 在实际的迁移过程中, 通过相应的措施保证, 顺利完成了迁移过程.
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
文章编号: 中图分类号: 文献标志码:
基金项目:
引用文本:
张春瑞,赵成坤,吴川,陈非.银行管理信息系统服务器国产化过程中的ETL应用迁移.计算机系统应用,2015,24(10):264-270
ZHANG Chun-Rui,ZHAO Cheng-Kun,WU Chuan,CHEN Fei.Process of ETL Application Migration to Server Localization on Bank Information Management System.COMPUTER SYSTEMS APPLICATIONS,2015,24(10):264-270
张春瑞,赵成坤,吴川,陈非.银行管理信息系统服务器国产化过程中的ETL应用迁移.计算机系统应用,2015,24(10):264-270
ZHANG Chun-Rui,ZHAO Cheng-Kun,WU Chuan,CHEN Fei.Process of ETL Application Migration to Server Localization on Bank Information Management System.COMPUTER SYSTEMS APPLICATIONS,2015,24(10):264-270