The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies. Plus, you'll receive expert data warehouse training and the advice of the industry's most experienced data warehouse consulting professionals. You can submit Teradata Database Enhancement Requests here.

Expand All Subscribe to Teradata Developer Exchange - Database content The Latest
C/C++ Coded User-Defined Function Scenario
User-Defined Functions

This feature was introduced in Teradata Database V2R5.1.

R14.10 Temporal Feature Deep Dive

When Teradata released its new temporal capabilities in 2010, it caused us all to start to thinking differently about the element of time in the Data Warehouse by providing powerful tools for managing and navigating temporal & bitemporal data structures. With the release of Teradata R14.10, we will be challenged still further.

Period Data Type and Derived Period Column Scenario

Overview: Period Data Types and Derived Period Columns

 

Teradata Database supports storage and manipulations that involve durations, spans of time defined by a beginning and ending bounds:

ARRAY Data Type Scenario

SQL ARRAY/VARRAY Data Type

This feature was introduced in Teradata Database 14.00.

Description

ARRAY is a type of user-defined data type (UDT) that can represent up to five dimensions, each with a user-defined maximum number of individual elements. All of the elements of an ARRAY must be of the same data type.

Unity Source Link Scenario

Overview of Unity Source Link

Unity Source Link (USL) allows reads and joins from an external or foreign database to Teradata Database without requiring data replication in the Teradata data warehouse. USL can be used to:
  • create heterogeneous joins for reporting
  • insert or select from a foreign database into Teradata Database
  • migrate data to Teradata Database
Row-level security

Row-Level Security

This feature was introduced in Teradata Database 14.00.

Description

Teradata row-level security (RLS) allows you to restrict data access on a row-by-row basis in accordance with your site security policies. Row-level security policies can be used in addition to the standard GRANT privileges to provide a finer level of access control to table data.

Teradata Database 14.10 Overview

Learn all about TD 14.10!

Extracting table and column statistics

Statistics provides valuable information to the optimizer to make decisions on generating optimal explain plan.  The information about the statistics can be obtained by using the “Help Statistics” command however the displayed data cannot be used to join with other tables.  The article provides a java stored procedure and DDL which extracts the output of "Help Statistics" at Table and Column level and capture the data into tables. 

The captured data in the tables helps with:

New Teradata Express 14.10 Versions Available

Teradata is announcing new Teradata Express 14.10 images. These new images are at patch level 14.10.00.02 which represents the current shipping version of Teradata 14.10. This gives you access to the recently released Teradata 14.10 database for your test and development needs.

Important

These images represent a departure from the from the TD 14.0 and TD 13.10 releases.

Teradata Express 14.10 for VMware Player User Guide

Teradata Express for VMware Player (TDE-V) is a free, fully operational Teradata Virtual Machine with up to one terabyte of storage. Imagine being able to install a fully operational Teradata database on your PC and be running queries in five minutes, easy as 1-2-3.

Pages