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

摘要

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