Informix向Oracle迁移的关键技术研究  

Key Technology Research of Migration from Informix to Oracle

作　　者：熊军军[1] 

机构地区：[1]中国人寿保险股份有限公司研发中心,北京100022

出　　处：《计算机工程》2012年第14期52-55,共4页Computer Engineering

摘　　要：Informix公司被收购后存在原有数据库升级维护困难的问题,为提高数据库性能与稳定性及满足公司信息系统集中的需要,提出一种从Informix向Oracle数据库迁移的方法,其包括数据迁移和程序转换,采用Oracle数据库迁移工具包、存储过程和嵌入式结构化查询语言编程技术。项目试运行结果表明,基于该方法迁移的应用系统运行稳定、处理高效,能满足业务管理人员需求。Based on the consideration that the current used Informix database software can not be maintained due to an enterprise merge, this paper proposes a method to migrate database from Informix to Oracle, which benefits improving the stability and performance of the database and expands the applications. This resolution consist： of data and programs transformations and uses Oracle Migration Workbench（OMW）, procedure and embedded SQL programming language technologies. Experimental results show that the migrated systems operate stably and efficiently to meet the need of business managers.

关 键 词：数据库迁移 甲骨文数据库 数据迁移 程序转换 存储过程 性能优化 

分 类 号：TP311.56[自动化与计算机技术—计算机软件与理论]