Research And Implement Of XML-based Data Transformation For Heterogenous Database

With the maturity of database technology, Database Management System has become the most important tool of data management. Today, enterprises, institutions and government agencies have built numerous Database Management Systems in different data formats and system platforms. However, that various differences in choosing Database Management System lead to the variety of data sources forms a huge heterogeneous database circumstances. How to co-share those heterogeneous databases is becoming a challenge to all of us.With the features of platform independent, easy extendibility, good interactivity and strong semantics, XML becomes the factual standard of data exchange. This paper gives a much more detailed solution on data conversion between heterogeneous databases, and also accomplishes a data conversion system between heterogeneous databases.In order to accomplish the system, this paper studies the mapping technique between the relational model and XML model, and proposes a method about how to describe the table structure, data types, integrity constraints and other informations of relational model. This paper uses base64 encoding to solve the binary large object data conversion in heterogeneous databases. For the security issues of data conversion between heterogeneous databases, this paper studies the XML encryption technique and designes a security conversion model of heterogeneous databases.This paper also describes the detail design and analysis on all parts of the system and accomplishes the system in .NET platform finally. And it applies to the credit project in Liaoning Province, through the actual data validation, this system has achieved good results.