Design And Implementation Of A Basde On XML Heterogeneous Database Middleware

In the information process, not only different department but also different part inthe same department has established various information systems with heterogeneousdatabase systems in different period. These database systems include simple filedatabase, complex network database, and so on. Therefore, they are like separate islands,difficult to interconnect and gain access into each other’s database, and even moredifficult to share data resources. The problem of building redundant project andresources waste is increasingly serious.In order to solve the above mentioned problems, this paper provides a goodmethod through the technology of database middleware. Firstly, this paper brieflyintroduces XML technologies and theories of middleware, and compares some populartechnologies and models of heterogeneous database access. Then it introduces themapping method of relational database and XML in detail. After that, it presents thedesign and implementation of a “Based on XML Heterogeneous Database Middleware”(BoXMLDM).BoXMLDM takes XML as common data model, and use Eclipse and JAVA toaccomplish the target. BoXMLDM includes data dictionary, SQL parser and wrapperetc. It inputs with SQL and outputs with XML, and can allow users accessheterogeneous database and reuse query results freely.At present, BoXMLDM has been implemented in the intranet of our department,and has realized transparent access of heterogeneous data sources between ACCESSand SQL Server.