Storing XML Data | XML Data Type | Teradata Vantage - Storing XML Data - Teradata Vantage - Analytics Database

XML Data Type
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
tkc1628112506748.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dgs1472251600184
lifecycle
latest
Product Category
Teradata Vantage™
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.