Heterogeneous Data Exchange Design And Realization Based On XML

With the rapid development of internet and information technology in recent years, the data amount is increasing explosively which result in the wide application of database technology. However, that various differences in choosing database processing system lead to the variety of data sources forms a huge heterogeneous database circumstances, so, how to co-share those heterogeneous databases is becoming a challenge to all of us.XML technology, which shows her powerful influence in data exchanging upon her birth, is becoming not only a data format standard irreverent to platform or supplier , but also overcomes those deficiencies of those traditional EDI data exchange technology ,such as inflexibility, high cost, poor interactivity.The following paper explores data exchange of heterogeneous databases, giving a much more detailed solution on achieving heterogeneous according to XML, and also accomplishes a vivid example on heterogeneous database.This essay set up a model on the basis of XML technology, using XML text as a carrier for data exchange, designing a changing regulation dictionary of XML text format as human machine interaction. It solves the problems as error inserting; structure conflicting and meaning conflicting that come up in the exchanging process through an advanced defined exchanging rule to administrate the exchanging process. Besides this, this essay also founds the mapping regulation for three pairs, which are database structures with XML SCHEMA, data of database with XML text, the data type of the database. Third, this essay brings up a mapping regulation which is"a table to a XML SCHEMA and a XML text", simplifies the structure of XML SCHEMA, and effectively buffers the analysis ability in case of too enormous XML text. Fourth, this paper addresses a solving program on big target data exchanging problems and security issues in transforming process. Fifth, making full use of J2EE standard circumstance, JDOM API outlet and JDBC drive to accomplish the move of heterogeneous database, realizing the goal of heterogeneous database exchanging.This subject comes from the"Spring Plan", a funds program of Education Department, has achieved great progress through years of practical data test.