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