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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Abiteboul, S., Buneman, P., Suciu, D.: Data on the Web. Morgan Kaufmann, San Francisco (2000)
Arenas, M., Libkin, L.: A normal form for XML documents. In: Proc. ACM PODS Conference, pp. 85–96 (2002)
Atzeni, P., DeAntonellis, V.: Foundations of databases. Benjamin Cummings (1993)
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
Buneman, P., Davidson, S., Fan, W., Hara, C.: Reasoning about keys for XML. In: International Workshop on Database Programming Languages (2001)
Codd, E.F.: Recent investigations in relational database systems. In: IFIP Conference, pp. 1017–1021 (1974)
Levene, M., Vincent, M.W.: Justification for inclusion dependency normal form. IEEE Transactions on Knowledge and Data Engineering 12, 281–291 (2000)
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)
Thomas, S.J., Fischer, P.C.: Nested relational structures. In: Kanellakis, P. (ed.) The theory of databases, pp. 269–307. JAI Press (1986)
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)
Vincent, M.W.: Semantic foundations of 4NF in relational database design. Acta Informatica 36, 1–41 (1999)
Vincent, M.W., Liu, J.: Functional dependencies for XML. In: Fifth Asian Pacific Web Conference (2003)
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)
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)
Vincent, M.W., Liu, J., Liu, C.: The implication problem for unary functional dependencies in XML. In submitted for publication (2003)
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)
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)
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)
Widom, J.: Data management for XML – research directions. IEEE data Engineering Bulletin 22(3), 44–52 (1999)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2004 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Vincent, M.W., Liu, J., Liu, C. (2004). Redundancy Free Mappings from Relations to XML. In: Li, Q., Wang, G., Feng, L. (eds) Advances in Web-Age Information Management. WAIM 2004. Lecture Notes in Computer Science, vol 3129. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-27772-9_35
Download citation
DOI: https://doi.org/10.1007/978-3-540-27772-9_35
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-22418-1
Online ISBN: 978-3-540-27772-9
eBook Packages: Springer Book Archive