Research And Application Of Heterogeneous Database Integration Based On OpenJMS And XML

With the further development of dadabase,sharing and exchanging data safely and smoothly between heterogeneous database, which can't be carried on is bottlelink of government/large enterprise. Especially in E-government filed,for there are systems of different period, there are many heterogeneous data resources called "lone island of information",which reduces the cooperation efficiency between different departments, data sharing,exchanging and consistency are difficult to implement. Besides these, some new requirement, such as cooperation,data mining,providing uniform access entrance are difficult to implement, So heterogeneous database integration is an important subject for researching database application technology.In order to store and extract data, the unified definition of data form is needed, while studying on information transmission between heterogeneous database, XML is an extensible markup language, it can describe itself, which makes it more fit for data exchange. bivariate table structure of RDB can be mapped to XML document via constructing a unifed DTD document. After that, it can be intergrated to centeral database via data transforming of XML data.In behave of decreasing system charge and reducing programming workload on server while heterogeneous database's intergration, it selects message middleware OpenJMS to realize message transmission between system database and central database. OpenJMS supports synchronous and asynchronous transmission of information, supports local transation and message selection, supports such protocol as RMI, HTTP and TCP/IP, which ensures reliable message transmission,transation and message filter.This paper researchs on the methods of heterogeneous database integration based on Hubei traffic plan of science and technology project "Hubei ganghang E-government system", proposes an integrated model of heterogeneous database based on OpenJMS and XML, the thesis focus on data exchange, trigger used for data extraction is further investigated,which ensures data's synchronous update;message middleware OpenJMS used for message send and receive is deeply resrarched,which can provide efficient transmission and ensure reliability;database mapping is further studyed,It uses XML document as unified standard to communicate,maps RDB to XML document by DTD document, after that, it intergrates XML data to central database,which ensures smoothly data exchange between systematic database and central database. In the end,it verifies the model and applys the model system to Hubei GangHang E-government System to get the anticipated purpose.