WEB Services-Based Key Technology Research Of Data Integration

With the rapid development of Internet, information technology and the database technology, companies and enterprises have established their own IT information integration systems,which has accumulated a large amount of heterogeneous data. How to deal with these data efficiently and conveniently has become the issue of the process of enterprise information. Therefore, the research of the heterogeneous data integration system has become a hot button in the industry and academia.This paper realizes the integration of the heterogeneous relational database, from the root of the problem caused by heterogeneous data,making good use of the popular and useful web service and the middleware technology and applied it to projects,achieving good effects for actual integration of newly-added system databases.First, the paper introduces the background of heterogeneous data integration,research status and the current problems faced by heterogeneous integration;Secondly, the study and the analysis of the current advantages and disadvantages of data integration methods, combined with the actual situation and needs, using Mediator / Wrapper architecture for heterogeneous data integration system design and development.Using distributed technology to design and develop the Mediator,this loose way of reducing the operational structure of the system's dependence on Mediator and the Mediator system depends on the Wrapper, in an effort to improve the overall system scalability and stability.The wrapper which differs from the traditional Wrapper, Each wrapper is independent of each deployed on different physical nodes, by invoking the web service to establish communications with the Mediator, in an effort to achieve interaction.The query processing is the key of the data integration system, mainly related to the design and transformation of the query language, query decomposition and query optimization and so for.According to SQL language and XQuery language. Combined with the actual situation in a distributed system, It designed Minisql as an intermediate query language, which is compact,flexible and powerful, can fit a variety of data sources and thus do cross-language processing, a good solution to the problem of schema mapping and language parsing.Finally, the integrated system applies to digital library data platform, which verifies the correctness and feasibility of the integrat1system.