Shred XML documents using DB2 pureXML

Two methods for XML decomposition in DB2 for Linux, UNIX, and Windows

From the developerWorks archives

Salvador Ledezma and Bert Linden

Date archived: January 12, 2017 | First published: January 03, 2008

Since version 9.1, DB2 features significant new support for storing, managing, and searching XML data. One of these new features is annotated XML schema decomposition. Annotated XML schema decomposition allows you to decompose, or "shred", XML documents into relational tables. Another way to decompose XML documents is through the SQL or XML function: XMLTABLE. This article reviews the two methods of decomposing XML data including, how to use the XMLTABLE function for decomposition. It also compares annotated XML schema decomposition and XMLTABLE Decomposition and provides recommendations for the use of each.

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=280030
ArticleTitle=Shred XML documents using DB2 pureXML
publish-date=01032008