异构数据库的数据共享集成中间件技术研究

【作者】 刘桂斌；

【导师】 胡飞；

【作者基本信息】 西北工业大学 ， 计算机应用技术， 2005， 硕士

【摘要】 随着企业应用范围的不断扩大,企业对信息的需求也日益增大,越来越多的企业应用需要访问到多种异构数据源。对于企业应用来说,这既是企业内部发展的需要,也是企业适应外部环境的需要。针对这一需求,结合中航第一飞机设计研究院“飞机制造业数字化工程”项目,本文提出了以XML为数据交换格式,使用XML Schema建立公共模型,利用EJB技术作为中间件实现平台,实现了Mediator模式异构数据库数据共享中间件平台。主要完成的研究内容如下: 1)异构数据库数据共享集成中间件体系结构的设计。结合项目本身运用EJB、JSP、JDBC、XML等相关技术,提出并设计了以XML为数据交换格式的Mediator模式异构数据库数据共享中间件平台,为共享数据的使用提供服务。 2)提出了关系模式到XML Schema的转换算法。通过对数据库关系模式和XML Schema分析,完成了合理有效的关系模式到XML Schema模式转换算法。 3)提出了查询分配算法。结合项目实际,对基于GAV方法的查询分配算法在权限控制方面进行了改进。 4)进行了系统安全性设计。从物理隔离、数据使用权限和应用服务器三个方面进行了中间件平台系统安全性的分析和设计。更多还原

【Abstract】 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.更多还原