16.20 - Storing XML Data - 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)
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.