基于SQL-92和JDBC的SpaceOS数据库数据迁移的实现  

THE IMPLEMENTATION OF DATA MIGRATION ON SPACEOS DATABASE BASED ON SQL-92 AND JDBC

作　　者：宁泰安 刘金刚[1,2] 

机构地区：[1]首都师范大学计算机科学联合研究院,北京100048 [2]中国科学院计算技术研究所,北京100080

出　　处：《计算机应用与软件》2014年第12期64-67,190,共5页Computer Applications and Software

摘　　要：针对Space操作系统的Postgre SQL数据库能对异构关系数据库进行数据迁移的需求,在SQL-92和JDBC基础上,介绍异构数据迁移时元数据和记录数据处理的主要流程,并设计了以表示层、元数据层、业务逻辑层和数据访问层为结构的数据迁移模块。详细分析了SQL声明前数据类型映射和代理主键值映射这两个关键步骤的算法实现。数据迁移模块在JDK1.6环境下实现。通过对异构数据库与Postgre SQL间进行数据迁移实验,验证了迁移模块是合理而有效的,具有良好的通用性和兼容性。Aiming at the demand that the PostgreSQL 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 PostgreSQL and heterogeneous database show that the migration module is reasonable and effective.Meanwhile, it has good versatility and compatibility.

关 键 词：SpaceOS PostgreSQL异构数据库 数据迁移SQL-92 JDBC 

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