16.20 - Storing XML Data - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ XML Data Type

Teradata Database
Teradata Vantage NewSQL Engine
March 2019
Programming Reference
Teradata Database provides these methods for storing XML data:
  • Store XML data in tables containing columns defined with the XML data type
  • Use XML shredding to extract values from XML documents and use the values to update tables in the database

This table compares the two methods for storing XML data.

XML Type XML Shredding
  • No requirement to map between hierarchical and relational models prior to storing the XML contents.
  • Preserves the information set of the XML document, including the hierarchy information and type information derived from XML validation.
  • Stores XML content in a compact binary form.
  • Requires you to map the XML document structure to the target tables prior to storing the XML contents.
  • Does not preserve the document identity.
  • Provides better query performance for large XML documents.