A performance comparison of DB2 9 pureXML and CLOB or shredded XML storage

From the developerWorks archives

Matthias Nicola and Vitor Rodrigues

Date archived: January 13, 2017 | First published: December 07, 2006

Like other databases, the DB2® V8 XML Extender offers two storage and access models for XML: XML documents can be stored intact as unparsed text in CLOB columns, or they can be mapped and shredded to a set of relational tables. Both options have known performance limitations. The new pureXML™ technology in DB2® 9 seeks to overcome these limitations by storing and querying XML in its inherent hierarchical format. This article describes a series of measurements to characterize the cases in which pureXML does or doesn't provide a performance benefit, and to quantify the performance difference to CLOB or shredded storage.

This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management, XML
ArticleID=182334
ArticleTitle=A performance comparison of DB2 9 pureXML and CLOB or shredded XML storage
publish-date=12072006