Skip to main content

An Experimental Study on Query Processing Efficiency of Native-XML and XML-enabled Database Systems

  • Conference paper
  • First Online:

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 2544))

Abstract

With XML becoming a standard for representing semi-structured documents on the web and a standard for data exchange between different systems, some database companies are adding XML support to their existing database systems, while some other companies coming out with pure or native database systems for XML. In this paper, we present an experimental study on the query processing efficiency of a native-XML database system and an XMLenabled database system on a selected set of queries including operations from text-processing, DML and relation algebra. The experiments are conducted on two well-known commercial database systems using the web interfaces based on HTTP. The cost metrics we used are CPU time, the numbers of physical and logical reads. The queries were run on identical machines for 3 different sizes of documents with and without indexing. A subset of experimental results is presented and overall results are discussed. Generally speaking the XML-enabled system performed better.

This is a preview of subscription content, log in via an institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. W3 Consortium Extensible Markup Language (XML) http://www.w3.org/TR/REC-xml, W3C Recommendation 6 October 2000

  2. A.R. Schmidt, et al., The XML Benchmark Project. INS-R0103, Amsterdam, Netherlands, April 30, 2001.

    Google Scholar 

  3. M. Fernandez, J. Simeon, P. Wadler. XML Query Languages: Experiences and Exemplars, Summer 1999

    Google Scholar 

  4. P. A. Boncz and M. L. Kersten. MIL primitives for Querying a Fragmented World. The VLDB Journal, 8(2):101–119, 1999.

    Article  Google Scholar 

  5. A.R. Schmidt, et all., Efficient Relational Storage and Retrieval of XML Documents. In International Workshop on the Web and Databases (In conjuction with ACM SIGMOD), pages 47–52, Dallas, TX, USA, 2000.

    Google Scholar 

  6. T. Shimura, M. Yoshikawa, and S. Uemura. Storage and Retrieval of XML Documents Using Object-Relational Databases. In Database and Expert Systems Applications, pages 206–217. Springer, 1999.

    Google Scholar 

  7. D. Chamberlin, D. Florescu, J. Robbie, J. S,meon, and M. Stefanescu. Xquery: A Query Language for XML, Feb 2001, http://www.w3.org/TR/xquery.

  8. T. Böhme, E. Rahm. Xmach-1:A Benchmark for XML Data Management.

    Google Scholar 

  9. P. Cotton, D. Fallside, A. Malhotra. Position Paper on XML Query. W3C Query Languages Workshop, December 1998.

    Google Scholar 

  10. Software AG. Tamino Documentation. 2001. http://www.softwareag.com/tamino/

  11. B. Wait, Oracle Corporation. About Oracle XML Products. November 1999 http://otn.oracle.com/tech/xml/info/htdocs/otnwp/about_oracle_xml_products.htm

  12. B. Wait, Oracle Corporation. Customizing Data Presentation. November 1999 http://otn.oracle.com/tech/xml/info/htdocs/otnwp/xml_custom_presentation.htm

  13. Mustafa Atay, Query Processing Efficiency in Native-XML and XML-enabled Databases, Aug 2001 Fatih University, Istanbul, Turkey, MS Thesis.

    Google Scholar 

  14. S. Bressan, G. Dobbie, Z. Lacroix, M. L. Lee, Y. Guang Li, U. Nambiar, B. Wadhwa: XOO7: Applying OO7 Benchmark to XML Query Processing Tools, Proceedings of the 10th ACM CIKM, Atlanta, Georgia, November 2001.

    Google Scholar 

  15. P. Bohannon, J. Freire, P. Roy, J. Simeon: From XML,Schema to Relations: A Cost-based Approach to XML Storage. ICDE 2002

    Google Scholar 

  16. J. Shanmugasundaram, K. Tufte, C. Zhang, G. He,, J. DeWitt, J. F. Naughton: Relational Databases for Querying XML, Documents: Limitations and Opportunities. VLDB 1999: 302–314

    Google Scholar 

  17. D. Florescu, D. Kossmann: Storing and Querying XML Data using an RDMBS. IEEE Data Engineering Bulletin 22(3): 27–34 (1999)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2002 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Kurt, A., Atay, M. (2002). An Experimental Study on Query Processing Efficiency of Native-XML and XML-enabled Database Systems. In: Bhalla, S. (eds) Databases in Networked Information Systems. DNIS 2002. Lecture Notes in Computer Science, vol 2544. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-36233-9_21

Download citation

  • DOI: https://doi.org/10.1007/3-540-36233-9_21

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-00264-2

  • Online ISBN: 978-3-540-36233-3

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics