Glossary - Teradata Database

Database Introduction

Product
Teradata Database
Release Number
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-1091
lifecycle
previous
Product Category
Teradata® Database

1NF

First Normal Form

2NF

Second Normal Form

2PC

Two-Phase Commit

3NF

Third Normal Form

4NF

Fourth Normal Form

5NF

Fifth Normal Form

AMP

Access Module Processor

ANSI

American National Standards Institute

API

Application Programming Interface

ARC

Teradata Archive/Recovery Utility

ASCII

American Standard Code for Information Interchange

ASE

Account String Expansion

AWT

AMP Worker Task

BCNF

Boyce-Codd Normal Form

BTEQ

Basic Teradata Query

BYNET

Banyan Network (high-speed interconnect)

CAS

Channel-Attached System

CICS

Customer Information Control System

CLIv2

Call-Level Interface, Version 2

CNS

Console Subsystem

DB2

DATABASE 2

DBC

Database Computer

DBQAT

Database Query Analysis Tools

DBQL

Database Query Log

DBS

Database System or Database Software

DDE

Dynamic Data Exchange

DDL

Data Definition Language

DIP

Database Initialization Program

DML

Data Manipulation Language

DNS

Domain Name Source

DSS

Decision Support System

EBCDIC

Extended Binary Coded Decimal Interchange Code

FIPS

Federal Information Processing Standards

GDO

Globally Distributed Object

HI

Hash Index

IBM

International Business Machines Corporation

ID

Identification

IMS

Information Management System

I/O

Input/Output

ISV

Independent Software Vender

JBOD

Just a Bunch Of Disks

JDBC

Java Database Connectivity

JI

Join Index

LAN

Local Area Network

LUN

Logical Unit

MDS

Meta Data Services

MIPS

Millions of Instructions Per Second

MLPPI

Multilevel Partitioned Primary Index

MOSI

Micro Operating System Interface

MPP

Massively Parallel Processing

MTDP

Micro Teradata Director Program

NAS

Network-Attached System

NoPI Tables

Tables that are defined with no primary index (PI).

NPPI

Nonpartitioned Primary Index

NUPI

Nonunique Primary Index

NUSI

Nonunique Secondary Index

ODBC

Open Database Connectivity

OS/VS

Operating System/Virtual Storage

PDE

Parallel Database Extensions

PE

Parsing Engine

PI

Primary Index

PL/I

Programming Language 1

PJ/NF

Projection-Join Normal Form

PP2

Preprocessor2

PPI

Partitioned Primary Index

PUT

Parallel Upgrade Tool

QCD

Query Capture Database

QCF

Query Capture Facility

RAID

Redundant Array of Independent Disks

RCT

Resource Check Tools

RI

Referential Integrity

SIA

Shared Information Architecture

SMP

Symmetric Multiprocessing

SNMP

Simple Network Management Protocol

SR

Single Request

SSO

Single Sign On

TCP/IP

Transmission Control Protocol/Internet Protocol

TDGSS

Teradata Generic Security Services

TDP

Teradata Director Program

TDSP

Teradata Stored Procedures

TASM

Teradata Active System Management

TPA

Trusted Parallel Application

TS/API

Transparency Series/Application Program Interface

UPI

Unique Primary Index

USI

Unique Secondary Index

vproc

Virtual Processor

z/OS

IBM System z Operating System