摘要
在分析了相关的数据库应用系统迁移方法的基础上,提出了一个基于JDBC和XML的数据库迁移方法,系统阐述了数据库应用系统从一个数据库系统(DBMS)向另一个数据库系统迁移中数据结构和对象的迁移方案。采用了类JDBC思想,设计了从Oracle系统到MYSQL系统不同SQL之间的自动转换工具,并以一个具体的网关计费系统为例,实现了从Oracle到MYSQL的数据迁移,为同类系统的迁移提供了有益的参考。
After analyzing the relevant database application migration methods, a database migration method based on JDBC and XML is put forward, and systematically describes migration schemes of data structures and objects in the DBMS applications while the database application system migrates from one database system (DBMS) to another database system. An automatic conversion tool of SQL is expounded from Oracle systems to MYSQL system according the principle of JDBC. And data migration is achieved from Oracle to MYSQL for a specific gateway billing system as an example. Furthermore, it is of certain valuable reference to data migration of the similar corresponding systems.
出处
《计算机工程与设计》
CSCD
北大核心
2008年第20期5376-5378,5382,共4页
Computer Engineering and Design
基金
江苏省属高校产业化推进基金项目(JH07-032)