Extensibility covers the mechanisms by which you, as the user or developer, can extend the functionality of the Teradata Database, for example with the use of User Defined Functions, or UDFs.

Expand All Subscribe to Teradata Developer Exchange - Extensibility content The Latest
Supporting SHA-2 hashing using a JAVA Table Operator



This article provides an example of implementing a java table operator. The specific use case is support for the SHA-2 family of hash encodings, for more details on SHA-2 see https://en.wikipedia.org/wiki/SHA-2

Background on why a JAVA table operator was chosen as the implementation mechanism for SHA-2.

R Solutions Across the Unified Data Architecture

The adoption of R is exploding within the analytic community and so have the number of R solutions, ranging from open source R on Hadoop to parallel functions on Aster and Teradata. 

Teradata 14.10 XML Data Type
The XML Data type, introduced in Teradata 14.10, provides the following new capabilities:
Implementing a multiple input stream Teradata 15.0 Table Operator for K-means clustering


This article is a follow on to article [1] which discussed implementing K-means using a Teradata release 14.10 table operator. The main contribution of this article is to discuss how to use the new Teradata 15.0 multiple input stream feature and a short discussion on a gcc compiler performance optimization.

A Quick Tour of the XML Type

XML is a markup language, used to format data in a wide variety of applications. It is commonly used as a message format for application integration (e.g. XML messages exchanged between applications, with those applications implementing an XML based API). Somewhat less commonly, it is used as a document format, to tag information in a platform independent manner. Starting in Teradata Database version 14.10, XML is supported as a native SQL data type.

Teradata Query Grid and Machine Learning in Hadoop

This article describes how to use Teradata query grid to execute a Mahout machine learning algorithm on a Hadoop cluster based on data sourced from the Teradata Integrated Data Warehouse. Specifically the Mahout K-means cluster analysis algorithm is demonstrated.  K-means is a computationally expensive algorithm that under certain conditions is advantageous to execute on the Hadoop cluster. Query Grid is an enabling technology for the Teradata Unified Data Architecture (UDA).

XML Query

Querying XML

Teradata XML Services

Teradata XML Services provide assistance in database transformation of XML structures to and from relational structures. This is primarily an enterprise fit feature. XML in this context is regarded as a data format that is used to describe incoming or outgoing warehouse data. A key concept for this feature is that we are not transforming to store XML but rather to maintain a relational data model or to integrate relational data into an enterprise XML message structure! The relational data model is bested suited for enterprise analytics. XML structures are best suited for enterprise integration.

Running Unsupported Queries from a Stored Procedure

Stored Procedures

SQL Stored Procedures were added to Teradata around 2003 with the release of Teradata V2R5.1. Since then the capabilities of SQL Stored Procedure s has been expanded. However, there are still some queries that cannot be run directly from within a Stored Procedure.


In database multiple variable linear regression using the CM_Solve Table Operator

In a prior article [1] we described how to use the Teradata 14.10 CalcMatrix operator and R to perform a multiple variable linear regression analysis. This article extends that concept with a comprehensive in database solution by introducing a new in database table operator named “CM_Solve”. This approach has value in cases when you want to solve a large number of independent systems of equations or you simply do NOT want to use the R client for solving the system of equations based on the SSCP matrix.