XML Shredding Based on a Schema

Teradata Vantageā„¢ XML Data Type

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1140-162K

XML shredding is the process of extracting values from XML documents and using them to update tables in the database. This is done based on a user-defined mapping specification that maps the XML structure to the target tables.

For example, you can perform these typical tasks to shred XML documents:

  1. Load the XML document to be shredded into an XML column of a staging table.
  2. Define an SQL query that returns a result set with 2 columns:
    • An ID column
    • The XML column that contains the XML document to be shredded
  3. Create an annotated schema that maps the XML document structure to the target tables.
  4. Store the mapping so that it can be easily referenced, for example, in a schema repository table.
  5. Call the AS_SHRED_BATCH stored procedure with the following arguments:
    • The SQL query you defined in step 2
    • The annotated schema you saved in step 4