Storing XML Data | XML Data Type | Teradata Vantage - 17.10 - Storing XML Data - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - XML Data Type

Advanced SQL Engine
Teradata Database
Release Number
July 2021
Last Update
Content Type
Programming Reference
Publication ID
English (United States)
Last Update
Vantage provides the following 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.