基于关系数据库的XML数据管理计算机技术专业论文.docxVIP

I II Abstract Due to adaptable structure and flexibility in defining the tags, XML has recently emerged as the leading medium for data storage and data transfer over the World Wide Web. Many organizations had adopted XML as the principal facet in their online business applications. On the other hand, relational database is still widely used as the back-end database in most organizations. Thereby, how to effectively map XML documents to relational database becomes a hot topic for current researchers. This paper proposes an effective mapping scheme to bridge XML and relational database based on the model-mapping method. Our approach has only three pre-defined tables to store the structural information of leaf node, paths of leaf nodes and inner nodes within the tree structure respectively, which save the storage size. On the other hand, the combination of path indexing and numbering label supports the representation of ancestor-descendant and sibling relationship between nodes. The relational schema is used for an efficient processing of queries in particular queries involving structural conditions. The chain and unchained path expression can be converted to the corresponding SQL statement while avoiding redundant joins. And the mechanism also puts forward an algorithm of conversion for handling the traversal query in the part of XML document.Finally, An experiment based on an middleware prototype is implemented for verifying the mapping and converting algorithm with the collection XML document of different size and complexity. The test data indicated that our strategy and algorithm is robust in terms of database storage, data loading and query time of complex queries. Key words: Model mapping , XML, Node label, XPath, Relational Database PAGE PAGE IV 目录 第一章 绪论1 1.1 研究背景1 1.2 选题意义2 1.3 研究现状2 1.4 本文组织框架3 1.5 作者的主要研究内容4 第二章 本文理论基础6 2.1 半结构化数据介绍6 2.1.1 半结构化数据的特点与应用6 2.1.2 半结构化数据模型理论基础7 2.2 XML 语法与结构 8 2.2.1 文档结构，语法定义9 2.2.2 文档类型定义10 2.3 XML 查询语言 10 2.3.1 路径表达式