Abstract
Many applications deal with complex XML documents that need to be made persistent. We investigate the use of the object-relational modeling approach that combines both the strengths of object oriented concepts and relational DBMS technology provided by current DBMS vendors. As a prerequisite, we analyze the document definition and generate the equivalent object-relational database schema in SQL. We discuss the main issues when mapping XML documents to an object-relational target schema with the example of Oracle. The paper concludes with a summary of our experiences with the object-relational approach for XML document mangement.
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
R. Bourret: XML and Databases, 2000. http://www.rpbourret.com/xml/XMLAndDatabases.html
R. Bourret: Mapping DTDs to Database, 2001. http://www.rpbourret.com/xml/index.htm (on: http://www.xml.com).
M. Conrad: Speicherung von XML-Dokumenten mit bekanntem Schema in objektrelationalen Systemen am Beispiel Oracle, Diplomarbeit (German), HTWK Leipzig, 2001.
B. Chang, M. Scardina, S. Kiritzov: Oracle 9i XML Handbook. Maximize XML-enabled Oracle 9i, Oracle Press Osborne/Mc Graw Hill, 2001.
D. Florescu, D. Kossmann: Storing and Querying XML Data using an RDBMS, Data Engineering, Sept. 1999, Vol. 22, No. 3.
T. Kudrass: Management of XML Documents without Schema in Relational Database Systems, OOPSLA Workshop on Objects, 〈XML〉 and Databases, Tampa, Oct. 2001.
J. Melton, A. Simon: SQL: 1999-Understanding Relational Language Components. Morgan Kaufmann, 2001.
S. Muench: Building Oracle XML Applications, O’Reilly & Associates, 2000.
J. Shanmugasundaram et. al: Relational Databases for Querying XML Documents: Limitations and Opportunities, Proc. 25th VLDB conference, 1999.
M. Wutka: DTD Parser, 2001, http://www.wutka.com/dtdparser.html
Oracle Corp. XML Developers Kit, http://www.oracle.com/xml
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2002 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Kudrass, T., Conrad, M. (2002). Management of XML Documents in Object-Relational Databases. In: Chaudhri, A.B., Unland, R., Djeraba, C., Lindner, W. (eds) XML-Based Data Management and Multimedia Engineering — EDBT 2002 Workshops. EDBT 2002. Lecture Notes in Computer Science, vol 2490. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-36128-6_12
Download citation
DOI: https://doi.org/10.1007/3-540-36128-6_12
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-00130-0
Online ISBN: 978-3-540-36128-2
eBook Packages: Springer Book Archive