Abstract
In this paper we present a middleware for storing and retrieving XML documents in relational databases. To store XML documents in RDBMS, several mapping approaches can be used. We chose structure independent approach. This approach stores XML documents in fixed-schema tables and does not require a direct extension of SQL. So the middleware can be used with any RDBMS with minor changes in the interface. The middleware offers two alternative methods -namely XRel and Edge- for storing XML in the database. The Edge method is a straightforward method, while XRel utilizes path summary information for faster query processing. We present a comparative experimental study on the performance of insertion and retrieval of two types of XML documents along with a set of XPath queries executed though the XPath query processor which is a part of the middleware.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Bourret, R.P.: Middleware for Transfering Data Between XML Documents and Relational Databases (2001), http://www.rpbourret.com/xmldbms/index.htm
Bosak, J.: The Plays of Shakespeare (1999), http://www.ibiblio.org/bosak/
Bray, T., Paoli, J., Sperberg-McQueen, C.M., Maler, E.: Extensible Markup Language (XML) 1.0, 2nd edn. W3C Recommendation (2000), http://www.w3.org/lTR2OOOlRECxml-20001006l
Cheng, J., Xu, J.: IBM DB2 XML Extender-An End to End Solution for Storing and Retrieving XML Documents, IBM Corporation white paper (2000), http://www-306.ibm.com/software/data/db2/extenders/xmlext/xmllextbroch.pdf
Clark, J., DeRose, S.: XML Path Language (XPath) Version 1.0, W3C Recommendation (November 16, 1999), http://www.w3.org/TRl999/REC-xpatb-19991116
Dayen, I.: Storing XML in Relational Databases (2001), http://www.xml.com/pub/a/2001/06/20/databases.html
Deutsch, A., Fernandez, M., Suciu, D.: Storing Semistructured Data with STORED. In: Proc. of ACM SIGMOD, Philadelphia, PN (1999)
Drake, M.: Oracle XML DB White Paper (2004), http://otn.oracle.com/tech/xml/xmldb/Current/TWP.pdf
Florescu, D., Kossmann, D.: Storing and quering xml data using an RDBMS. IEEE Data Engineering Bulletin 22(3), 27–34 (1999)
Goldfarb, C.F., Prescod, P.: XML Handbook, 4th edn. Prentice Hall, Englewood Cliffs (2001)
Jiang, H., Lu, H.: Path Materialization Revisited: An Efficient Storage Model for XML Data. In: 2nd Australian Institute of Computer Ethics Conference, Canberra (2001)
Kentel, E.: A Performance Study on XPath Queries in Commercial Databases. Senior Project, Dept. of Computer Eng. Fatih University, Istanbul Turkey (2003)
Kurt, A., Atay, M.: An Experimental Study on Query Processing Efficiency of Native-XML and XML-Enabled Database Systems. In: Bhalla, S. (ed.) DNIS 2002. LNCS, vol. 2544, pp. 268–284. Springer, Heidelberg (2002)
Mercan, M.: An Implementation of an XPath Query Processor for XRel and Edge Methods, MS Thesis, Fatih University, Istanbul Turkey (2004)
OPENXML: Retrieving and Writing XML Data (2004), http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsql/ac_openxml_759d.asp
Schmit, A., Kersten, M.L., Windhouwer, M., Wass, F.: Efficient Relational Storage and Retrieval of XML documents. In: Suciu, D., Vossen, G. (eds.) WebDB 2000. LNCS, vol. 1997, pp. 47–52. Springer, Heidelberg (2001)
Shanmugasundaram, J., Tatarinov, I., Shekita, E., Kiernan, J., Viglas, E., Naughton, J.: A General Technique for Querying XML Documents using a Relational Database System. In: SIGMOD (2001)
Shanmugasundaram, J., Zhang, C., Tufte, K., He, G., DeWitt, D., Naughton, J.: Relational Databases for Querying XML Documents: Limitations and Opportunities. In: Proceeding of the 25th VLDB Conference, Edinburgh, Scotland (1999)
Su, A.Z.: An Implementation of Storage and Retrieval Methods for XML Documents in Relational RDBMSs, MS Thesis, Fatih University, Istanbul Turkey (2003)
Tatarinov, I., Iglas, S.: Storing and Quering Ordered XML Using a Relational Database System. In: ACM SIGMOD, Wisconsin, USA (2002)
Yao, B.B., Özsu, M.T., Keenleyside, J.: XBench – A Family of Benchmarks for XML DBMSs. In: Bressan, S., Chaudhri, A.B., Lee, M.L., Yu, J., Lacroix, Z. (eds.) CAiSE 2002 and VLDB 2002. LNCS, vol. 2590, pp. 162–164. Springer, Heidelberg (2002)
YoshiKawa, M., Amagasa, T.: XRel: A Path -based approach to storage and retrieval of XML documents using relational databases, ACM Trans. on Internet Technology (2001)
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
Şevkli, Z., Mercan, M., Kurt, A. (2004). A Middleware Approach to Storing and Querying XML Documents in Relational Databases. In: Yakhno, T. (eds) Advances in Information Systems. ADVIS 2004. Lecture Notes in Computer Science, vol 3261. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-30198-1_23
Download citation
DOI: https://doi.org/10.1007/978-3-540-30198-1_23
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-23478-4
Online ISBN: 978-3-540-30198-1
eBook Packages: Computer ScienceComputer Science (R0)