| Informix向Oracle迁移的关键技术研究 |
| |
| 引用本文： | 熊军军.Informix向Oracle迁移的关键技术研究[J].计算机工程,2012,38(14):52-55. |
| |
| 作者姓名： | 熊军军 |
| |
| 作者单位： | 中国人寿保险股份有限公司研发中心,北京,100022 |
| |
| 摘 要： | Informix公司被收购后存在原有数据库升级维护困难的问题，为提高数据库性能与稳定性及满足公司信息系统集中的需要，提出一种从Informix向Oracle数据库迁移的方法，其包括数据迁移和程序转换，采用Oracle数据库迁移工具包、存储过程和嵌入式结构化查询语言编程技术。项目试运行结果表明，基于该方法迁移的应用系统运行稳定、处理高效，能满足业务管理人员需求。
|
| 关 键 词： | 数据库迁移 甲骨文数据库 数据迁移 程序转换 存储过程 性能优化 |
| 收稿时间： | 2011-09-20 |
Key Technology Research of Migration from Informix to Oracle |
| |
| XIONG Jun-jun.Key Technology Research of Migration from Informix to Oracle[J].Computer Engineering,2012,38(14):52-55. |
| |
| Authors: | XIONG Jun-jun |
| |
| Affiliation: | XIONG Jun-jun(Research & Development Center,China Life Insurance Company Limited,Beijing 100022,China) |
| |
| Abstract: | 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 consists 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. |
| |
| Keywords: | database migration Oracle database data migration program transformation stored procedure performance optimization |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
| 点击此处可从《计算机工程》浏览原始摘要信息 |
|
点击此处可从《计算机工程》下载全文 |
