基于XML的异构数据库归档系统的设计与实现  

Design and Implementation of Heterogeneous Database Archiving System Based on XML

作　　者：李育岭[1] 万晓冬[1] 

机构地区：[1]南京航空航天大学自动化学院,江苏南京210016

出　　处：《计算机与现代化》2013年第1期95-97,101,共4页Computer and Modernization

摘　　要：数据库归档技术能够有效解决企业数据骤增带来的管理和维护上的难题,而各数据库系统自带的归档机制在异构数据库环境中却存在较大局限性。针对异构数据库环境,本文以MSSQL Server 2005、MySQL5、Oracle 10g为研究对象,采用XML来设计数据库归档系统,通过转换模块消除3种数据库平台中数据格式和管理上的差异,使数据库的历史数据在存储设备和数据库运行系统中实现双向映射。The technology of database archiving can effectively solve the problems in data management and maintenance, which caused by the surge of enterprise data. Archiving mechanism taken by the database system itself has serious limitations. For het- erogeneous database environment, this paper takes MSSQL Server 2005, MySQL5 and Oracle 10g as the objects of study, and u- ses XML to design the database archiving system. The system removes the differences in data format and management for the three database platforms by conversion module so that the data can map bidirectionally between storage device and database system.

关 键 词：归档系统 异构数据库 XML映射 C S结构 

分 类 号：TP393[自动化与计算机技术—计算机应用技术]