Sitemap

Sitemap

Teradata DBA Glossary of terms



Teradata RDBMS Terminology Definitions

Click on the relevant Teradata DBA term below to display the definition.

A

N

Access Module Process (AMP)

Node

Access Rights

Non-Unique Primary Index

Administration Workstation (AWS)

NUPI

Administrator

Non-unique Secondary Index

AMP

NUSI

ANSI

 

Array controller

O

AWS

ODBC

AWT - Amp Worker Task

Offline

 

 Online

B

Open Database Connectivity (ODBC)

Bandwidth

Optimizer

Basic Teradata Query (BTEQ)

Owner

BTEQ

 

Buffer

P

BYNET

Packdisk

byte

Parallel Database Extensions (PDE)

 

Parallel Processing

C

Parallelism

Cache

Parity

Call Level Interface (CLI)

Parsing Engine (PE)

Capacity Planning

 PDE

Channel

PDisks

channel connection

PE

CLI

Performance Tuning

Clique

Permanent Journal

Cluster

Policies and Standards

CPU

Primary Index

 

Primary Key

D

 Priority Scheduler

Data

Privilege

Data dictionary

Product Join

Data Control Language (DCL)

Profiles

Data Definition Language (DDL)

Program

Data Manipulation Language (DML)

Protocol

Data Integrity

 

Data Types

Q

Data Warehouse

Query

Data Warehousing

Query Optimisation

Database

 

Database Administrator

R

Database Administration

RAID

Database Management System (DBMS)

RAID 1

Database Schema

RAID 5

Datum

RAID S

DBA

RAM

DBC

Randam Access Memory

DBMS

RDBMS

DBQL

Recovery journal

Diagnostic

Remote Working

Disk

Relational Database

Disk Arrays

Resource Monitoring

Dispatcher

Resource Sampling Subsystem

Destination Selection Word (DSW)

Resource Usage (ResUsage)

DSS

Restart

Dual Site Security

Restore

Dump

ResUsage data

 

Roles

E

Row Hash

End user

Row-id

ETL

 

Explain

S

 

SCSI

F

Secondary Index

Fallback

Skewing

FastLoad

SMP

Field

SQL

Firmware

SQL Tuning

Foreign Key

Spool Space

 

Statistics

G

Stored Procedures

Gateway

System Bus

 

System Disks

H

 

Hash map

 T

Hash synonym

Table

Hashing

Tailgate and Bus and Tag Cables

Host

TASM

Host utility program

Teradata

HSCI

Teradata Certified Master

 

Teradata Database

I

Teradata DBA

I/O

Teradata Development

IBM Mainframe

Teradata Manager

Index

TPUMP

Information Warehouse

Traditional Data Warehousing

ITIL

Transient Journal

 

TWS - Tivoli Work Scheduler

J

 

Join

U

Join Index

User

Join Types

 

 

V

L

Vdisk

LAN

View

Local Area Network

Vnet

Lock

Vproc

Logical

X

Logical Unit Number (LUN)

XOR

 

 

M

 

Macros

 

Massive Parallel Processing System

 

Metadata

 

Micro Operating System Interface (MOSI)

 

Mirror

 

Module

 

MPP System

 

Multi-tasking

 

Multiload

 

Multi Value Compression

 

MVC 

 

 

 

 

  WORLD TIME

 

Please note that these pages are continually being updated. Please revisit the glossary if you do not find the keyword you are looking for.

Teradata DBA glossary of terms