XML Shredding and Publishing - Teradata Vantage

This section describes the XML shredding and publishing process and the stored procedures that provide this functionality:

• XML publishing stored procedures allow you to publish the results of an SQL query in XML format:
  • XMLPUBLISH_STREAM
  • XMLPUBLISH
• XML shredding stored procedures load XML documents into relational tables:
  • The AS_SHRED_BATCH stored procedure provides streamed shredding functionality with the mapping provided as an annotated schema.
  • The XSLT_SHRED and XSLT_SHRED_BATCH stored procedures provide shredding functionality with the mapping provided as an XSLT stylesheet. XSLT_SHRED is used for single XML document shredding and XSLT_SHRED_BATCH is used to shred multiple XML documents. In comparison to streamed shredding, the XSLT-based shredding procedures load the document being shredded into memory. While this requires more memory, it makes shredding more flexible.

The schema based shredding examples in this section reference tables, files, and data defined in:

• Examples in this Document
• XML Type Usage Examples