Abstract
We propose a method to generate XML documents from relational databases by using nested relational algebra. Starting with a specification of the structure of the XML document, and a description of the database schema, we give an algorithm to build automatically a nested algebra query that will generate a nested view from the relational database; this view is isomorphic to the desired XML document, that can easily be generated from it. We discuss limitations of (and extensions to) the framework.
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: From Relations to Semistructured Data and XML. Morgan Kaufman, San Francisco (1999)
Deutsch, A., Fernandez, M., Suciu, D.: Storing Semistructured Data with STORED. In: Proceedings of the ACM SIGMOD Conference (1999)
Fernandez, M., Morishima, A., Suciu, D., Tan, W.: Publishing Relational Data in XML: the SilkRoute Approach. IEEE Data Engineering Bulletin 24(2) (2001)
da Silva, A.S., Filha, I.E., Laender, A.H.F., Embley, D.W.: Representing and Querying Semistructured Web Data Using Nested Tables with Structural Variants. In: Spaccapietra, S., March, S.T., Kambayashi, Y. (eds.) ER 2002. LNCS, vol. 2503, p. 135. Springer, Heidelberg (2002)
Mani, M., Lee, D., Muntz, R.R.: Semantic Data Modeling Using XML Schemas. In: Kunii, H.S., Jajodia, S., Sølvberg, A. (eds.) ER 2001. LNCS, vol. 2224, p. 149. Springer, Heidelberg (2001)
Lee, D., Chu, W.: CPI: Constraint-Preserving Inlining Algorithm for Mapping XML DTD to Relational Schema. Data and Knowledge Engineering journal 39 (2001)
Lee, D., Chu, W.: Constraints-Preserving Transformation from XML Document Type Definition to Relational Schema. In: Laender, A.H.F., Liddle, S.W., Storey, V.C. (eds.) ER 2000. LNCS, vol. 1920, pp. 323–338. Springer, Heidelberg (2000)
Lee, D., Mani, M., Chiu, F., Chu, W.: Nesting-Based Relational-to-XML Translation. In: Int’l. Workshop on Web and Databases, WebDB (2001)
Shanmugasundaram, J., Kiernan, J., Shekita, E.J., Fan, C., Funderburk, J.: Querying XML Views of Relational Data. In: Proceedings of VLDB 2001
Vittori, C., Dorneles, C., Heuser, C.: Creating XML Documents from Relational Data Sources. In: Proceedings of EC-Web (2001)
Vossen, G.: Data Models, Database Language and Database Management Systems. Addison-Wesley, Reading (1991)
Extensible Markup Language (XML) 1.0. In: Bray, T., Paoli, J., Sperberg- McQueen, C.M. (eds.) W3C Recommendation, 2nd edn., http://www.w3.org/TR/REC-xml-20001006
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2003 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Badia, A. (2003). Automatic Generation of XML from Relations: The Nested Relation Approach. In: Jeusfeld, M.A., Pastor, Ó. (eds) Conceptual Modeling for Novel Application Domains. ER 2003. Lecture Notes in Computer Science, vol 2814. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-39597-3_33
Download citation
DOI: https://doi.org/10.1007/978-3-540-39597-3_33
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-20257-8
Online ISBN: 978-3-540-39597-3
eBook Packages: Springer Book Archive