Research Of Heterogeneous Database Integration Based On Eclipse Plug-in Technology

With the promotion of information development, enterprises have developed their own information management system based on their requirements. At the beginning, lacking of consistent planning and management, the systems they developed are relatively independent and information can not be shared between the systems. In a word, when several information systems are available inside the enterprise, the following problems may occur: (1) Different information storage and diverse locations lead to inconsistent management. (2) The systems of each department do not interact with each other, which leads to data inconsistency or data redundancy. (3) Large amount of data is idle and not made full use of, which cannot support the decision-making of leaders. (4) When the current system is upgraded, the new and old systems are not compatible. Therefore, data integration is an urgent issue that must be solved during information development.Data integration provides a standard access for users, to ignore the isomerism of data sources. There are three data integration solutions commonly used, including data warehouse,federal database and the mediator. The mediator is widely used due to its real time and expandability. The data integration mediator is used for second development by developers. The developers have to refer to the technical documents describing interface specifications while they are testing the accuracy of method and result. Generally, there are few visual tools to assist developers. Eclipse, as the one of the most widely used development platforms, has a large user group; besides, it has excellent plug-in system architecture. The paper studies and implements an eclipse plug-in tool which supports the query of the heterogeneous databases for developers. This tool effectively assists developers and improves development efficiency, with the database integration mediator as the core and eclipse plug-in as the user platform.This paper consists of several parts, which mainly:(1) Designs the mediator of data integration framework based on virtual view, and describes the main function of each module. Draws up the rules of virtual view,local view,meta data model which are all based on XML.(2) Mainly study the parse algorithm of SQL query and the combine mechanism of result set.(3) Studies the plug-in system architecture of eclipse, and implements the heterogeneous database integration tool based on eclipse plug-in.Now the tool could support the relational database, such as SQL Server 2000 and MySQL. The joint query for multiple databases is supported by defining the virtual view. Through switching the Eclipse view, the developers can validate the SQL query language and check the accuracy of result set rapidly. The work efficiency is improved.