Data Integration Based On Agent

Data integration is the foundation of constructing Data Warehouse and Decision Support System. In the medical and financial field, because of different hospital and bank using different software system, so there are a large number of heterogeneous data. Heterogeneous data integration needs to resolve the problem of object recognition, data conversion, and data store and so on. This paper tries to study integration Agent that has the capability of data mapping and defining, in order to solve the problem of"information islands", thus effectively achieve the aim of inter-industry data sharing.Comparing and analyzing the method of data integration such as using specialized data integrating tools and data integration tools that are provided by the data warehouse solution providers for data integration, according to the problem that the existing data integration method can not work well with the user-level data dictionary database, introduce the data integration strategy of based on data mapping and Agent. In the process of data integration, establishing a integration project for database using user-level data dictionary according to the needs of users, heterogeneous data can be converted to the same configuration data through data mapping, coordinate various Agents through the communication between the Agents, so as to effectively realize the task of data collect, convert and store.In the system, Inter-Agent uses the model of client and server; establish secure communication links, a server Agent corresponds to a client Agent. The client Agent works based on integration project that describes data mapping, according to the definition of integration project, extracts data from heterogeneous systems, converts the extracted data in accordance with the pre-designed rules, unifies the heterogeneous data in format, stores in the form of standard XML documents, and transfers the XML documents to server, server Agent extract data from XML documents, store into server database after object recognition.Design and implement the data integration system based on Agent, verify and achieve through acquiring the data from the database of Dongfeng health system.