XML文档及其函数依赖到关系的映射

有许多文章提出了根据DTD将XML映射成关系的方法,但都没有考虑XML的语义,而语义信息对数据存储模式设计、查询优化、更新异常检查等来说是十分重要的,如果在DTD上指定了XML的函数依赖,在映射到关系数据库中就需要将其考虑进去.基于Hybrid Inlining方法并考虑XML函数依赖,提出了一种既能保持XML文档的内容和结构信息,又能保持函数依赖信息的映射方法.通过这种方法可以减少存储冗余,同时证明了映射后的关系都满足第三范式.

Mapping XML Documents to Relations in the Presence of Functional Dependencies

Many methods for mapping XML to relations have been proposed without considering the semantics of XML data before. But the semantics is very important to design schemas for storage, optimize queries, and check update anomalies, etc. In the presence of XML FDs which are specified over DTDs, this paper presents a method based on the hybrid inlining to map XML to relations for storage. The constraints which are represented by FDs, as well as the content and the structure, are preserved at the same time. Much storage redundancy can be reduced through using this method. Furthermore, this paper proves that those relations mapped from XML are all in Third Normal Form (3NF).