计算机应用 ›› 2005, Vol. 25 ›› Issue (08): 1849-1852.DOI: 10.3724/SP.J.1087.2005.01849

• 数据库与人工智能 • 上一篇    下一篇

一种基于XML映射规则的数据迁移方法设计和实现

胡晓鹏1,李晓航1,李岗2   

  1. 1.西南交通大学计算机与通信工程学院; 2.西南交通大学电气工程学院
  • 出版日期:2005-08-01 发布日期:2011-04-07

Design and implementation of XML mapping rule based data migration method

HU Xiao-peng1,LI Xiao-hang1,LI Gang2   

  1. 1.School of Computer Science and Communication Engineering,Southwest Jiaotong University,Chengdu Sichuan 610031,China; 2.School of Electrical Engineering,Southwest Jiaotong University,Chengdu Sichuan 610031,China
  • Online:2005-08-01 Published:2011-04-07

摘要: 数据迁移可以看作是实现从源数据库表到目的数据库表的映射。研究了数据迁移的形式化过程,详细讨论了该过程中存在的几类重要映射,提出了基于XML的通用映射规则表示方法。在此基础上,介绍了通过分析数据库表对象创建脚本自动生成XML形式映射规则框架的方法,并讨论了实际的数据迁移过程。

关键词: 数据迁移, 映射规则, 扩展置标语言, 数据定义语言

Abstract: Data migration is a mapping between source database and target database. The formal process of data migration was addressed and several principal mappings among the process were analyzed. An XML-based mapping rule representation method was fully discussed. Furthermore, an approach which can be used to retrieve XML mapping rule skeleton by parsing table object creation DDL script was intorduced. Finally, the method was applied in practice.

Key words: data migration, mapping rule, XML, data definition language

中图分类号: