基于语义的XML模式到关系模式的转换

作者：用户投稿发布时间： 09/12/18

　　基于语义的XML模式到关系模式的转换

　　Translating from XML Schema to Relation Schema on Semantic Constraint

　　【摘要】可扩展标记语言XML技术自出现以来,在许多领域内得到广泛的支持并有着广阔的应用前景。XML的核心作用体现于数据的交换与共享。利用XML的样式语言来实现数据间的转换和显示,可以满足用户的多种需求。由于XML的诸多优势并没有表现在存储上,如何更为有效地存储和管理XML数据已成为一个研究热点。本文基于XML文档中的映射规则,从保持语义约束的角度考虑,展开对XML模式规范化存储的研究,包括:对XML文档用映射语言进行描述;基于映射规则对应的表树探讨一种生成键的方法;基于XML键和函数依赖之间的关系讨论简化键和简化函数依赖的定义,以及键向简化函数依赖的转换等;讨论XML模式到关系模式的转换,给出一种基于XML键的转换算法,把泛关系模式保持函数依赖且无损连接地分解为3NF模式集,使得到的关系模式合理化。本文的主要研究成果如下:(1)参考已有的XML映射规则定义,给出XML文档的泛关系定义和相应的映射规则。(2)提出基于XML文档的有效生成键的智能拓展算法:事先给出标识键文件,该文件存放可预知的能唯一标识其他数据的键字符串,在算法运行过程中能动态更新,然后基于映射规则对应的表树,得到完备的XML键集,并给出算法分析和证明。(3)提出一种新的XML模式到关系模式的转换方法,该方法不需要给定文档类型定义(Document Type Description,DTD),先将XML键集转换为简化函数依赖集,减少属性结点的冗余,然后保持函数依赖的把泛关系分解为关系范式,使得到的关系模式中的关系表及其属性合理化。从理论和实验的角度,验证算法的有效性。

　　【Abstract】 Extensible markup language XML technology has been widely supported in many domains and has had bright prospect of broad application since its appearance.The key role of XML lies in the data exchange and sharing.Using the XML style language to realize the data translation and manifestation can satisfy various kinds of users' demands.Since many of XML' s advantages could not be found in memory,how to store and manage the XML data effectively has become a hot research subject.Based on the XML document' s mapping rules,this paper did research into normalized storage of XML schema from the perspective of keeping semantic constraints.It includes: description of the XML document in mapping rules;discussion of a new method of generating XML key based on table tree from mapping rules;discussion of the definition of both simplified keys and simplified functional dependencies and of the translation from keys to simplified functional dependencies based on the connection between XML keys and functional dependencies;discussion of the translation from XML schema to relation schema and presentation of a new translation algorithm based on XML key.This algorithm can keep functional dependency and lossless connection to divide the universal relation into 3rd normal form schema set,and it can make the derived relation schema reasonable.The contributions of this paper are as follows:(1)Referencing to the definition of XML mapping rules,we present the definition of the universal relation and the correlative mapping rules on XML document.(2)A algorithm for intelligent extending to efficiently deriving XML keys based on XML document is proposed.Firstly we present Label Key file able to store a lot of key character strings which can foreseeably and exclusively mark the other data,and it is dynamically updated in the algorithm running. Then the algorithm derives the key set from the table tree of mapping rules,and present the analysis and proof of this algorithm.(3)A new normalized translation method is proposed for translating XML schema to relational schema,without the DTD (Document Type Description).Firstly XML key set is translated into simplified functional dependencies,which can reduce the redundancy of attribute nodes.Divide the universal relation into relational normal form while keeping functional dependency,and ensure the relational table and its attributes of the derived relational schema reasonable.The method has been proved to be valid from the view of theory and experiment.

　　【关键词】 XML; 关系数据库; 转换方法; XML键; 函数依赖

　　【Key words】 XML; Relational database; Translation method; XML key; Functional dependenc

　　基于语义的XML模式到关系模式的转换

　　中文摘要 3-4

　　英文摘要 4-5

　　1.绪论 8-16

　　1.1 问题的提出 8-9

　　1.2 研究目的和意义 9-10

　　1.3 国内外研究现状 10-13

　　1.4 主要工作和成果 13-14

　　1.5 本文的结构 14-16

　　2.XML语言 16-26