Design And Implementation Of A XML-based Data Transformation Tool Between Heterogeneous Databases

With the development of database technology and high frequency of information exchange between industries, demands of data sharing between different types of databases become increasingly prominent. Traditional transformation tools for transforming data between heterogeneous databases have not adequately address the complex types of heterogeneous databases to exchange information, so using the new XML technology, The paper designs and implements a data transformation tool between heterogeneous databases based on standard XML data format.XML has the features of platform independency,easy extendibility,good interactivity, Semantic description of the data, data transmission capacity and It is the ideal cross-media of heterogeneous data source.The paper designs a data transformation tool model based on XML and gives the design and presentation of structure of XML data file and XML structure file in it.It achieves to transform data in two-way that the transfer way and the merger way.And it gives settlement to conflicts in naming ,structure,data type and meaning. On the basis of actual needs,The paper takes into account the complex conditions of one-to-many and many-to-one between tables in source database and purpose database. At the same time, It gives the idea of sub-data and put it into practice because of data transformation of large amounts of data needing high software and hardware environmental.In the implementation of the data transformation tool,the paper chooses Microsoft Visual Studio.NET platform and Visual C# programming language.It implements classes of database operation based on ADO.NET technology and designs human user interface.This paper implements the function of the data transformation tool and puts it into effect in data exchange system of Liaoning credit project.The subject carries out on Liaoning credit project,The data transformation tool completes the actual data test and achieves good results.