15.00 - Glossary - Teradata Database

Teradata Database SQL Fundamentals

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1141-015K

2PC

Two-Phase Commit

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

cs0, cs1, cs2, cs3

Four code sets (codeset 0, 1, 2, and 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

external routine

UDF, UDM, or external stored procedure that is written using C,
C++, or Java

external stored procedure

a stored procedure that is written using C, C++, or Java

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)

NoPI tables

Tables that are defined with no primary index (PI)

NPPI

Nonpartitioned Primary Index

NUPI

Nonunique Primary Index

NUSI

Nonunique Secondary Index

OLAP

Online Analytical Processing

OLTP

Online Transaction Processing

PDE

Parallel Database Extensions

PE

Parsing Engine vproc

PI

Primary Index

PK

Primary Key

PPI

Partitioned Primary Index

predefined type

Teradata Database system type such as INTEGER and VARCHAR

QCD

Query Capture Database

RDBMS

Relational Database Management System

SDF

Specification for Data Formatting

stored procedure

a stored procedure that is written using SQL statements

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

UPI

Unique Primary Index

USI

Unique Secondary Index

vproc

Virtual Process