The XML Data type, introduced in Teradata 14.10, provides the following new capabilities:
•A new XML data type that allows you to store XML content in a compact binary form that preserves the information set of the XML document, including the hierarchy information and type information derived from XML validation
•Functions and methods on the XML type that support common XML operations like parsing, validation, transformation (XSLT) and Query (XPath and XQuery)
•Supports the XQuery query language for querying and transforming XML content
•Supports the following SQL/XML functions and stored procedures:
|
•XMLDOCUMENT
•XMLELEMENT
•XMLFOREST
•XMLCONCAT
•XMLCOMMENT
•XMLPI
•XMLTEXT
•XMLAGG
|
•XMLPARSE
•XMLVALIDATE
•XMLQUERY
•XMLSERIALIZE
•XMLTABLE
•AS_SHRED_BATCH
•XMLPUBLISH
•XMLPUBLISH_STREAM
|
Benefits
•Removes the requirement to map between hierarchical and relational models prior to storing the XML contents. Previously, this was required when using the XML shredding and publishing functionality in Teradata XML Services.
•Provides the ability to preserve document identity. In contrast, the shredding facility that Teradata XML Services supports only extracts the values out of the XML document without retaining the document identity.
•Provides a compact method for storing XML content where the internal representation is 5~10 times smaller than the original text representation.
•Provides standard query language support for querying XML using XQuery 1.0 and XPath 2.0.
•Provides a more efficient method for parsing, transforming and querying XML content.
•Integrates the functionality in the Teradata XML Services offering into Teradata Database using syntax that conforms to the ANSI SQL/XML specification.
Considerations
•The XML type accommodates values up to 2GB in size. However, operations like XSLT and XQuery, which load documents into memory, are only supported on documents that are smaller in size, where the processing operation does not require more memory than specified by the XML_MemoryLimit DBS Control field. This field caps the amount of memory available for XML operations so that these operations do not strain memory resources. A pseudo-streaming version of XQuery is allowed on large documents via the XMLEXTRACT method on the XML type.
•XML path indexes are not supported.
•XML schemas and XSLT stylesheets are not managed by Teradata Database.
Schema and Stylesheet Consolidation Utility
The Schema and Stylesheet consolidation utility is available for download as a zip file on this page. There is one significant change in this utility compared to the user documentation. The user documentation speaks of two executables ConsolidateSchema.exe and ConsolidateStylesheet.exe. In this version of the utility the two have been combined into a single executable csldgen.exe. The Readme.txt file included in the zip file gives more details regarding the need for schema and stylesheet consolidation and how to perform such consolidation. This utility is only relevant if your schemas and stylesheets use imports and includes.
Download Teradata Vantage Express, a free, fully-functional Teradata Vantage database, that can be up
and running on your
system in minutes. Please download and read the user guide for installation instructions.
Note that in order to run this VM, you'll need to install VMware Workstation Player, VMware Fusion,
VMware Server, VirtualBox, or
UTM on your system. For more details, see our getting started guides.
For feedback, discussion, and community support, please visit the Cloud Computing forum.