Heterogeneous Databases, Data Sharing, Integration Middleware Technology Research

As enterprise applies scope enlarge, the information requirement of enterprise also increased fast, more and more application needs constantly visit heterogeneity data source. For enterprise, this application is the requirement from enterprise internal development; and is also the requirement for enterprise to adapt external environment. According to this requirement, in combination the "Digital manufacturing of aero industry project" in First Airplane Design and Research Institute, the heterogeneity database data share integration middleware platform were presented in this paper, which is based on Mediators pattern and using XML as exchange form, using XML Schema establish public model, using EJB technology implement. The mainly complete research contents are as follows:1) Design of integrated middleware architecture. Combination project, related to EJB, JSP, JDBC and XML etc., A Mediator middleware architecture, which using XML as exchange form, has been designed for heterogeneous database data share integration. It has offered service for the use of share data.2) Have put forward the conversion algorithm of relation schema to XML Schema. Based on the analysis of relation schema and XML Schema, It have completed reasonable effective relation schema to XML Schema pattern conversion algorithm.3) Have put forward inquiry distribution algorithm. Combination project reality, the inquiry distribution algorithm improved the authority control way of GAV method.4) Systematic safety design. From physical isolation data using limits of authority and application server aspects, it have carried out design and the analysis of middleware platform systematic safety.