基于关系数据库的XML分解存储方案

Decomposing and Storing XML Based on Relational Databases

本文给出了一个基于关系数据库的XML分解存储方案。首先,通过对XML语法的分析,定义了XML树,XML树是一棵结构规则的树所有的节点都具有相同的格式。通过XML树可以把结构不规则的XML文档映射成结构规则的XML树。其次,通过定义关系XSR,将XML树存储到关系数据库中去。该方案可以保证数据的完整性。在分解存储时,一个XML文档只需映射到一个关系表,而其它分解方案一般需要映射到多个关系表。该方案是一个通用方案,可以处理任意的XML文档。

This paper gives a scheme for decomposing and storing XML in relational databases. First, through the analysis of XML syntax, we define the XML tree： all of its nodes have the same format. The XML tree helps to map an irregular XML document to a regular XML tree. Second, we define the relation XSR to store an XML tree to RDB. Data integrity is guaranteed, and in the mapping process, an XML document will be mapped to just one table other than multiple ones. This scheme is a common scheme. It can be used to process any XML document.