EXRT: towards a simple benchmark for XML readiness testing

  • Authors:

  • Michael J. Carey;Ling Ling;Matthias Nicola;Lin Shao

  • Affiliations:

  • Computer Science Department, University of California-Irvine, Irvine, CA;Computer Science Department, University of California-Irvine, Irvine, CA;IBM Silicon Valley Lab, San Jose, CA;Computer Science Department, University of California-Irvine, Irvine, CA

  • Venue:
  • TPCTC'10 Proceedings of the Second TPC technology conference on Performance evaluation, measurement and characterization of complex systems
  • Year:
  • 2010

Quantified Score

Hi-index 0.00

Visualization

Abstract

As we approach the ten-year anniversary of the first working draft of the XQuery language, one finds XML storage and query support in a number of commercial database systems. For many XML use cases, database vendors now recommend storing and indexing XML natively and using XQuery or SQL/XML to query and update XML directly. If the complexity of the XML data allows, shredding and reconstructing XML to/from relational tables is still an alternative as well, and might in fact outperform native XML processing. In this paper we report on an effort to evaluate these basic XML data management trade-offs for current commercial systems. We describe EXRT (Experimental XML Readiness Test), a simple micro-benchmark that methodically evaluates the impact of query characteristics on the comparison of shredded and native XML. We describe our experiences and preliminary results from EXRT'ing pressure on the XML data management facilities offered by two relational databases and one XML database system.