Research And Development Of Hibernate-Based Data Integration System

Rapid development of information technology provides us with plentiful useful data information, but some problems come along. All of these data are stored so dispersedly because of different developing time and departments that they became isolated information islands. This makes it difficult to access and they cannot be fully utilized. As a result, the data cannot effectively support decision-making. Data integration technology arises to solve these problems. Data integration is to physically or logically combine data of different sources, forms, or properties, and provide the user with a unified view of these data.This paper presents a new framework of data integration by applying O/R Mapping (Object Relational Mapping) to data integration technology. This framework, called Hibernate-Based Data Integration (HBDI) System, is based on the idea of object-oriented programming. The system is developed in the Java programming language, to solve the problem of naming semantic conflict (different names have the same meaning). This paper also compares several O/R Mapping technologies in Java area through a lot of performance tests. Testing result indicates that Hibernate offers significant advantages over other O/R Mapping technologies. With detailed requirement analysis, the framework is designed based on Hibernate. The framework has clear hierarchy and greatly reduces the coupling between application and SQL. It uses Middlegen and hbm2java respectively to create Hibernate mapping files and POJOs, so that the persistence layer can be created automatically. It calls the Ant commands by using batch files so that the system has good flexibility and reduces a lot of workload.Friendly GUI makes it convenient to add, edit, delete data source, edit field configuration file or PRI manager file, and query data from data sources.