Design and Implementation of Heterogeneous Database Archiving System Based on XML

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 heterogeneous database environment,this paper takes MSSQL Server 2005,MySQL5 and Oracle 10g as the objects of study,and uses 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.