15.10 - Glossary - Teradata Database

Teradata Database SQL Data Types and Literals

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1143-151K

ALC

Algorithmic Compression

AMP

Access Module Processor vproc

ANSI

American National Standards Institute

BLOB

Binary Large Object

BTEQ

Basic Teradata Query facility

BYNET

Banyan Network - High speed interconnect

CJK

Chinese, Japanese, and Korean

CLIv2

Call Level Interface Version 2

CLOB

Character Large Object

CPPI

Character Partitioned Primary Index. A partitioned primary index where the partitioning expression involves comparison of CHAR, VARCHAR, CHAR or VARCHAR CHARACTER SET GRAPHIC data types.

cs0, cs1, cs2, cs3

Four code sets (codeset 0, 1, 2, 3) used in EUC encoding

distinct type

a UDT that is based on a single predefined data type

E2I

External-to-Internal

EUC

Extended UNIX Code

FK

Foreign Key

HI

Hash Index

I2E

Internal-to-External

JI

Join Index

JIS

Japanese Industrial Standards

LOB

Large Object

LT/ST

Large Table/Small Table (join)

MVC

Multi-Value Compression

NUPI

Nonunique Primary Index

NUSI

Nonunique Secondary Index

OLAP

OnLine Analytical Processing

OLTP

OnLine Transaction Processing

PDE

Parallel Database Extensions

PE

Parsing Engine vproc

PK

Primary Key

predefined type

Teradata Database system type such as INTEGER and VARCHAR

RDBMS

Relational Database Management System

SDF

Specification for Data Formatting

structured type

A UDT that is a collection of one or more fields called attributes, each of which is defined as a predefined data type or other UDT (which allows nesting)

UCS-2

Universal Coded Character Set containing 2 bytes

UDF

User-Defined Function

UDM

User-Defined Method

UDT

User-Defined Type

UJI

Unique Join Index. A noncompressed, single-table join index where the definition includes a unique primary index (UPI), the ROWID keyword in the select list of the SELECT clause, and a WHERE clause that covers a query on the base table (the WHERE clause qualifies a superset of the row set qualified by the WHERE clause of a query on the base table).

UPI

Unique Primary Index

USI

Unique Secondary Index

vproc

Virtual Process