12. Teradata Client tools

Teradata Client Software

The Teradata Database requires three distinct pieces of software: TPA,

PDE, and OS.

An operating system (OS), UNIX or Windows 2000, and a Teradata

software license are necessary for each node.

A Trusted Parallel Application (TPA) implements virtual processors and

runs on the OS with PDE. The Teradata Databse is classified as a TPA.

The components of the Teradata Database software include:

·

Channel Driver

·

Teradata Gateway

·

AMP

·

PE

Parallel Database Extensions (PDE) were added to the operating system

to support the parallel software environment.

On UNIX, a virtual processor (vproc) is a collection of software processes

running under the multi-tasking environment of the UNIX operating

system.

On Windows 2000, a vproc is a software process that runs under the

multi-tasking environment of the Windows 2000 operating system.

The client may be a mainframe system, such as IBM or Amdahl, which is

channel-attached to the Teradata Database, or it may be a PC or UNIX -

based system that is LAN-attached.

The client application submits an SQL request to the RDBMS, receives

the response, and submits the response to the user.