The Study On Heterogeneous Database Exchange Based On XML

Data exchange could achieve data-sharing by eliminating conflict between heterogeneous databases and redundantly storing data in each database. At present, the method for data exchange based on XML is in common use. However, it is inflexible because it relies on customizing a XML schema in advance. This paper designs a dual-XML-schema solution of database exchanging to solve the problem.According to the solution given in this paper, the source and target convert each relation schema to XML schema respectively with XML Schema Language. The heterogeneity between source and target would be eliminated by XML schema mapping with mapping rules. Since the mapping rules is created dynamically, this solution can adapt itself to the change occurred in source or target by updating mapping rules.In this paper, dual-XML-schema solution of database exchange is applied to meet the data sharing requirement of basal hydrographic information database. This paper also gave detailed design and implementation of the pivotal process in data exchange system, including schema conversion, schema registering, schema mapping, data exchange and so on. Finally this paper used a representative example to validate the feasibility of dual-XML-schema solution.The solution designed in this paper is rooted in a thoughtway of dual-Schema data exchange which put forward in a literature written by Gao Jianqiang. Due to all the modules are relatively isolated and easy to extend, the solution could be used in kinds of science domain to solve data-sharing between heterogeneous databases.