Advertisement

Redundancy Free Mappings from Relations to XML

  • Millist W. Vincent
  • Jixue Liu
  • Chengfei Liu
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 3129)

Abstract

Given the fact that relational and object-relational databases are the most widely used technology for storing data and that XML is the standard format used in electronic data interchange, the process of converting relational data to XML documents is one that occurs frequently. The problem that we address in this paper is an important one related to this process. If we convert a relation to an XML document, under what circumstances is the XML document redundancy free? In some allied work we formally defined functional dependencies in XML (XFDs) and, based on this definition, formally defined redundancy in an XML document. We then introduced a normal form for an XML document (XNF) and showed that it is a necessary and sufficient condition for the elimination of redundancy. In this paper we address the problem of determining what class of mappings map a relation in BCNF to an XML document in XNF. The class of mappings we consider is very general and allows arbitrary nesting of the original flat relation. Our main result establishes a necessary and sufficient condition on the DTD induced by the mapping for it to be in XNF.

Keywords

Normal Form Relation Scheme Electronic Data Interchange Nest Relation Multivalued Dependency 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    Abiteboul, S., Buneman, P., Suciu, D.: Data on the Web. Morgan Kaufmann, San Francisco (2000)Google Scholar
  2. 2.
    Arenas, M., Libkin, L.: A normal form for XML documents. In: Proc. ACM PODS Conference, pp. 85–96 (2002)Google Scholar
  3. 3.
    Atzeni, P., DeAntonellis, V.: Foundations of databases. Benjamin Cummings (1993)Google Scholar
  4. 4.
    Bray, T., Paoli, J., Sperberg-McQueen, C.M.: Extensible markup language (XML) 1.0. Technical report (1998), http://www.w3.org/Tr/1998/REC-XML-19980819
  5. 5.
    Buneman, P., Davidson, S., Fan, W., Hara, C.: Reasoning about keys for XML. In: International Workshop on Database Programming Languages (2001)Google Scholar
  6. 6.
    Codd, E.F.: Recent investigations in relational database systems. In: IFIP Conference, pp. 1017–1021 (1974)Google Scholar
  7. 7.
    Levene, M., Vincent, M.W.: Justification for inclusion dependency normal form. IEEE Transactions on Knowledge and Data Engineering 12, 281–291 (2000)CrossRefGoogle Scholar
  8. 8.
    Mok, W.Y., Ng, Y.K., Embley, D.: A normal form for precisely characterizing redundancy in nested relations. ACM Transactions on Database Systems 21(1), 77–106 (1996)CrossRefGoogle Scholar
  9. 9.
    Thomas, S.J., Fischer, P.C.: Nested relational structures. In: Kanellakis, P. (ed.) The theory of databases, pp. 269–307. JAI Press (1986)Google Scholar
  10. 10.
    Vincent, M.W.: A new redundancy free normal form for relational database design. In: Thalheim, B., Libkin, L. (eds.) Database Semantics, pp. 247–264. Springer, Heidelberg (1998)CrossRefGoogle Scholar
  11. 11.
    Vincent, M.W.: Semantic foundations of 4NF in relational database design. Acta Informatica 36, 1–41 (1999)CrossRefMathSciNetGoogle Scholar
  12. 12.
    Vincent, M.W., Liu, J.: Functional dependencies for XML. In: Fifth Asian Pacific Web Conference (2003)Google Scholar
  13. 13.
    Vincent, M.W., Liu, J.: Multivalued dependencies and a 4NF for XML. In: Eder, J., Missikoff, M. (eds.) CAiSE 2003. LNCS, vol. 2681, pp. 14–29. Springer, Heidelberg (2003)CrossRefGoogle Scholar
  14. 14.
    Vincent, M.W., Liu, J.: Multivalued dependencies in XML. In: James, A., Younas, M., Lings, B. (eds.) BNCOD 2003. LNCS, vol. 2712, pp. 4–18. Springer, Heidelberg (2003)CrossRefGoogle Scholar
  15. 15.
    Vincent, M.W., Liu, J., Liu, C.: The implication problem for unary functional dependencies in XML. In submitted for publication (2003)Google Scholar
  16. 16.
    Vincent, M.W., Liu, J., Liu, C.: Multivalued dependencies and a redundancy free 4NF for XML. In: Bellahsène, Z., Chaudhri, A.B., Rahm, E., Rys, M., Unland, R. (eds.) XSym 2003. LNCS, vol. 2824, pp. 254–266. Springer, Heidelberg (2003)CrossRefGoogle Scholar
  17. 17.
    Vincent, M.W., Liu, J., Liu, C.: Strong functional dependencies and a redundancy free normal form for XML. In: 7th World Multi-Conference on Systemics, Cybernetics and Informatics (2003)Google Scholar
  18. 18.
    Vincent, M.W., Liu, J., Liu, C.: Strong functional dependencies and their applicatiopn to normal forms in XML. Accepted for publication, ACM Transactions on Database Systems (February 2004)Google Scholar
  19. 19.
    Widom, J.: Data management for XML – research directions. IEEE data Engineering Bulletin 22(3), 44–52 (1999)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2004

Authors and Affiliations

  • Millist W. Vincent
    • 1
  • Jixue Liu
    • 1
  • Chengfei Liu
    • 1
  1. 1.School of Computer and Information ScienceUniversity of South Australia 

Personalised recommendations