基于XML的异构数据库信息共享研究

【作者】 吴志平；

【导师】 谭同德；

【作者基本信息】 郑州大学 ， 计算机应用技术， 2003， 硕士

【摘要】 数据库系统已经成为现代人们进行信息管理最常用的手段。作为计算机科学技术中发展最快，应用最广泛的重要分支之一，数据库已成为计算机信息系统和计算机应用系统的重要技术基础和支柱。随着数据库技术的发展，异构数据库系统(Heterogeneous DataBase System)的研究已经逐渐成为该领域研究的一个热点。 目前大多数城市的信息化建设中，都面临着政府职能部门之间的信息资源共享问题，随着信息化程度的不断提高，部门与部门之间的信息资源共享需求愈来愈突出，逐渐成为政府提高实际工作效率的一个瓶颈。 本论文从实际项目的应用出发，分析了在实际项目中实现政务网络系统异构数据库之间信息共享的局限性：项目投资过高、查询信息不能与实际数据保持实时一致、重复投资与开发等。根据当前网络数据库技术的发展趋势，本文提出了基于XML的、B／S三层架构的政务网络系统异构数据库之间信息资源共享的实施方案。介绍了该方案的整体设计以及几个关键问题的解决方法，包括： ● 根据各异构数据库共享信息动态生成信息资源目录(IRD)； ● Web方式的中间层数据库设计和管理； ● 根据共享信息的表及字段动态生成异构数据库SQL查询语句实现局部数据查询； ● 根据数据库结构特征和XML数据模型特点，设计表结构字段名称与XML文档标签之间的对应关系，实现关系数据库数据向标准XML文档的转化。 通过B／S三层架构实现政务网络异构数据库之间信息共享，有投资低，易管理，效率高等特点，易于在城市信息化建设中推广普及。更多还原

【Abstract】 At present, database system have became the most used method in the information management . As the fast developing and most comprehensive in computer science technology, database have already became the important technology and support in computer information system and computer application system. With the database system’s developing, Heterogeneous DataBase System researching is becoming the hotspot.Now, in many cities’ information construction, there is a information resources sharing problem among the government functional departments. In company with the improving of information, the problem of information-sharing among the functional departments is becoming a bottleneck on the advancing of government work efficiency.Depend on the practical item application, this paper analyses the limitation in the government network system heterogeneous databases’ information-sharing. Such as investment too high, searching information can’t keep consistent with the real data, overlapping investment and overlapping developing, ect. Based on current trend of network database technology, this paper bring up an executive-plan: "Basing on XML, B/’S three-ply structure government network system heterogeneous databases information-sharing", and introduces the plan’s integrated design as well as several sixty-four-dollar questions’ solutions. Those questions include as well: dynamic creating IRD(Information Resource Directory) based on sharing information of heterogeneous databases, web layer database’s design and manage, dynamic creating SQL query statement to realize heterogeneous database’s local data querying, the translation from query result to XML document.Through the medium of B/S three-ply structure, the method of realize government network system heterogeneous databases information-sharing, has got several merits such as :low-investment, manageableness, high-efficiency etc. And, it is too apt to generalize at city information construction.更多还原