Storing XML Data - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantageā„¢ XML Data Type

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1140-162K
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.