Research And Implementation On Data Integration Tool Of Support Information System

Due to historical reasons, the existing information management system of equipment department, the architecture of the system is different, the software and hardware environment of the system is different, how these application system data integration, realize the sharing of data, become an urgent problem to be solved.In this paper, we take the equipment department data using demand as the starting point, in-depth investigations and studies on enterprise information system data and daily work, data integration technology in domestic and international are analyzed and compared. On this basis, the research has designed a set of equipment data integrated management tool, can carry on the management to the heterogeneous data source integration, query can achieve data, effectively solves the problem of data cannot be shared.In this paper, the design tool in data integration management, adopt three layer model and the B/S environment as the overall system architecture, data exchange with XML as the intermediate format, using XML Schema as a public model for data integration, using Xquery as a common language for data query. In the process of developing the system, taking eclipse3.2.0 as the platform, using Java as development language, also use a variety of development tools and third party software package, to ensure the efficiency of system development and advanced.In this paper, the data integration management tool is divided into four modules according to the function, respectively, as the data source management, data model, data integration query processing, system maintenance management and so on, can meet the need of data integration management personnel and equipment business personnel to use need, including data integration management, the use of the tool management of heterogeneous data sources, generating data integration mode, set up a global query view, assign user role permission; equipment business personnel use the tool to apply for the registration of the data source, the extraction of shared data query.In this paper, the use of equipment support simulation data, each module of the data integrated management tool functions were tested to verify, from the actual application effect and the test results, the advanced system design thought, realization method is scientific and reasonable, the application of the system to make the equipment of heterogeneous data source management work more scientific, efficient, directly, make the data inquiry to become more transparent, fast and accurate, to enhance the comprehensive utilization efficiency of equipment data and equipment work scientific decision level.In this paper, the design and implementation of system functions at the same time, also to the technical problems of the system are studied, the future work to improve and perfect the system from the following two aspects.(1) to optimize the data integrated management tools for application layer data interface, seamless docking with the assistant decision-making for high level application software, the realization of the equipment business data automatic extraction and import.(2) to enhance the data schema integration function optimization study, the conflict in the solving schema mapping process, realize the automatic pattern matching, to minimize the use of manual intervention way.