16.20 - XML Shredding Based on a Schema - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ XML Data Type

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1140-162K
Language
English (United States)

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