基于SQL-92和JDBC的SpaceOS数据库数据迁移的实现
|
摘要
针对Space操作系统的Postgre SQL数据库能对异构关系数据库进行数据迁移的需求,在SQL-92和JDBC基础上,介绍异构数据迁移时元数据和记录数据处理的主要流程,并设计了以表示层、元数据层、业务逻辑层和数据访问层为结构的数据迁移模块。详细分析了SQL声明前数据类型映射和代理主键值映射这两个关键步骤的算法实现。数据迁移模块在JDK1.6环境下实现。通过对异构数据库与Postgre SQL间进行数据迁移实验,验证了迁移模块是合理而有效的,具有良好的通用性和兼容性。
Aiming at the demand that the Postgre SQL databases data of Space operating system is able to migrate the data of heterogeneous relational databases,based on SQL-92 and JDBC,we introduce the main processes of dealing with metadata and recorded data when the heterogeneous data is in migration,and design a data migration module,which is structured with presentation layer,metadata layer,business logic layer and data access layer. We also analyse in detail the algorithm implementation in regard to two key steps of data type mapping and surrogate primary key values mapping before SQL statement. The data migration module is implemented with JDK1. 6. The data migration tests between Postgre SQL and heterogeneous database show that the migration module is reasonable and effective. Meanwhile,it has good versatility and compatibility.
Aiming at the demand that the Postgre SQL databases data of Space operating system is able to migrate the data of heterogeneous relational databases,based on SQL-92 and JDBC,we introduce the main processes of dealing with metadata and recorded data when the heterogeneous data is in migration,and design a data migration module,which is structured with presentation layer,metadata layer,business logic layer and data access layer. We also analyse in detail the algorithm implementation in regard to two key steps of data type mapping and surrogate primary key values mapping before SQL statement. The data migration module is implemented with JDK1. 6. The data migration tests between Postgre SQL and heterogeneous database show that the migration module is reasonable and effective. Meanwhile,it has good versatility and compatibility.
引文
[1]Space操作系统项目组.Space操作系统白皮书[M].北京金杰科技创新研究所,2005.
[2]彭智勇,彭煜玮.PostgreS QL数据库内核分析[M].北京:机械工业出版社,2012.
[3]Search BI.企业数据管理优先度调查报告[R].Tech Targe,2012.
[4]Gavin Powell.Beginning Database Design[M].Wiley Publishing,Inc,2008.
[5]余秋明.异构数据库间数据迁移研究[D].南昌:南昌大学,2009.
[6]Y Daniel Liang.Java语言程序设计基础篇[M].北京:机械工业出版社,2011.
[7]贝尔.深入理解MyS QL[M].北京:人民邮电出版社,2010.
[8]萨默维尔.软件工程[M].北京:机械工业出版社,2011.
[9]熊华平,李莉娇,陈付平,等.大型异构数据库数据迁移系统的研究与应用[J].计算机应用与软件,2012,29(7):178-181.
[10]左萧冰.具有数据整合机制的Space数据库的研究与实现[D].北京:首都师范大学,2012.
[2]彭智勇,彭煜玮.PostgreS QL数据库内核分析[M].北京:机械工业出版社,2012.
[3]Search BI.企业数据管理优先度调查报告[R].Tech Targe,2012.
[4]Gavin Powell.Beginning Database Design[M].Wiley Publishing,Inc,2008.
[5]余秋明.异构数据库间数据迁移研究[D].南昌:南昌大学,2009.
[6]Y Daniel Liang.Java语言程序设计基础篇[M].北京:机械工业出版社,2011.
[7]贝尔.深入理解MyS QL[M].北京:人民邮电出版社,2010.
[8]萨默维尔.软件工程[M].北京:机械工业出版社,2011.
[9]熊华平,李莉娇,陈付平,等.大型异构数据库数据迁移系统的研究与应用[J].计算机应用与软件,2012,29(7):178-181.
[10]左萧冰.具有数据整合机制的Space数据库的研究与实现[D].北京:首都师范大学,2012.