XML文档在关系数据库中的规范化存储

Normalized Storage of XML in Relational Databases

提出了一种存储方法 ,首先把 XML 文档映射为泛关系模式 ,再利用算法 Derive FDs推导出 XML 键所蕴含的泛关系模式上函数依赖集的规范覆盖 ,根据此规范覆盖 ,最后将泛关系模式保持函数依赖地分解为 3NF模式集 .得到了保持 XML 键约束的规范化存储模式 ,实现了 XML 文档在关系数据库中的规范化存储 .

This paper presents a storing method, first it maps XML documents into universal relational schema, then it derives canonical cover of functional dependencies over the universal relational schema implied by XML keys using algorithm DeriveFDs, finally it decomposes the universal relational schema into 3NF schemas according to the canonical cover. It gets normalized storage schemas, and the normalized storage of XML in relational databases is implemented. Experiment indicates the method is effective.