Research On The Critical Technology Of Heterogeneous Data Sources Integration Based On XML

With the fierce competition of the global economy, modern enterprises should response quickly to the market requirements, making a correct decision based on the analysis of volumes of integrated data. Due to the diversity of the database, OS and the uniform of the data between enterprises, which result in a great deal of heterogeneous data resources? Obviously isolated information can not meet the requirements for modern enterprise's production. Therefore, it is imperative to exchange these heterogeneous data and sharing data with each other. Some systems have been designed to resolve this problem. By now, existing systems on the data exchange bare some shortage:1) Most of existing systems have not yet considered the problem of getting through the limitation of firewall defended by enterprises. Instead, it connected directly to the database by opening the firewall's port. There is a safety problem with the above system by nature.2) Distribution component technology (CORBAR and DCOM) provides the ability for interaction among multi-system. Some data exchange systems emerged based on the RPC technology. For the difference on the programming language between the two architectures, it is impossible to invoke each other. 3) Focusing on the particular database to develop software to exchange data resource. It is difficult to maintain the system if the back-end DBMS changed. 4) With more and more new formats of data appear. The traditional EDI system can not satisfy the requirements of exchanging the data in terms of structure format.This thesis focused on the shortages of the existing system for data exchange, based on the Application Basic Project (No.20027366) named "Research on Intelligent and Secure Data Backup Technology-WebDX data exchange" and sponsored by Chongqing STC. Focusing on the requirements proposed by enterprises to exchange heterogeneous data resources independent of platform, DBMS and based on B/S model should be met. A new solution was put forward which uses mapping document as template to exchange data with critical technology such as XML as the medium, Web Service based on the soap proxy for transport the message, with CMP entity beans to wrapper the database table with object oriented. The problems resolved are listed as fellows:(1) Presented a new mapping template XML file for transform the data, that enabled the data retrieved and transformed from source end meet the local databaseschema. It is convenient to parse the returned document.(2) In order to create a clean layered architecture that returns the data in the form of Element to the user. Creating JavaBean to interface with Session Bean and finishing the business logic of transforming data. Take this JavaBean as the implement for the Web service provider and generate Web Service, enabled the system to be independent of platform realistically. Penetrating the firewall unblocked.(3) Using EJB2.0 standard CMP Entity Beans to construct a structure to wrap a database table as an object enabled the implement for the business logic to be independent of back-end DBMS, reduced the complexity for developing the system. At the same time improves the performance and safety of the system;(4) The system (WebDX) of exchanging heterogeneous data resources based on the multi-tiers B/S model layered EJB tiers component pattern was realized.