Fifth International Conference on Computer and Information Technology (CIT'05) Storing Normalized XML Documents in Normalized Relations Shanghai, China September 21-September 23 ISBN: 0-7695-2432-X
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/CIT.2005.175
This paper studies the XML storage in relations. Unlike traditional techniques, it considers the semantics expressed by functional dependencies. We propose an algorithm for mapping DTD to relational schema, which preserves not only the content and structure but also the semantics of original XML documents. To tackle the problem of constraints expression, we introduce a way to de?ne functional dependencies and normalization for DTD. In a normalized DTD, every constraints expressed by functional dependencies can be concluded to keys. So we use the key de?nitions for XML as the foundation for relation generation, and maintain the keys in relations. After investigating the relationship between functional dependencies in XML documents with the corresponding ones in relations, we further prove that, if the original DTD is normalized, the generated relations will be in BCNF. So our method keeps the good properties of normalized DTD, and can fully leverage the relational technology.
Citation:
Zijing Tan, JianJun Xu, Wei Wang, Baile Shi, "Storing Normalized XML Documents in Normalized Relations," cit, pp.123-129, Fifth International Conference on Computer and Information Technology (CIT'05), 2005 Usage of this product signifies your acceptance of the Terms of Use. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||