银行管理信息系统服务器国产化过程中的ETL应用迁移  

Process of ETL Application Migration to Server Localization on Bank Information Management System

作　　者：张春瑞[1] 赵成坤[1] 吴川[1] 陈非[1] 

机构地区：[1]中国建设银行新疆分行信息技术部,乌鲁木齐830000

出　　处：《计算机系统应用》2015年第10期264-270,共7页Computer Systems & Applications

摘　　要：本文对某国有大型银行省级分行将ETL应用系统由访问进口服务器迁移至国产高端容错计算机环境的过程进行了描述.通过基于应用域的数据拆分和基于视图/物化视图、数据同步、同义词的数据同步,基本完成了分行应用数据从进口服务器环境往国产高端容错计算机环境的迁移过程.在这个过程中,我们发现由于客观条件的限制,数据同步前后数据的一致性结果比较存在一定难度,对应用迁移正确性的确认造成不利影响.在实际的迁移过程中,通过相应的措施保证,顺利完成了迁移过程.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.

关 键 词：服务器国产化 ETL 数据迁移 物化视图 国产高端容错计算机 

分 类 号：TP368.5[自动化与计算机技术—计算机系统结构]