11. What is AMP ?

The Access Module Processor (AMP)

The

Access Module Processor (AMP) is the virtual processor (vproc) in

Teradata's shared-nothing architecture that is responsible for managing a

portion of the database. An AMP will control some portion of each table

on the system. AMPs do the physical work associated with generating an

answer set, including sorting, aggregating, formatting and converting. The

AMPs perform all database management functions in the system.

An AMP responds to Parser/Optimizer steps transmitted across the

BYNET by selecting data from or storing data to its disks. For some

requests, the AMPs may redistribute a copy of the data to other AMPs.

The

Database Manager subsystem resides on each AMP. This

subsystem will:

·

Lock databases and tables.

·

Create, modify, or delete definitions of tables.

·

Insert, delete, or modify rows within the tables.

·

Retrieve information from definitions and tables.

·

Return responses to the Dispatcher.

 The database manager subsystem provides a bridge between that

logical organization and the physical organization of the data on disks.

The Database Manager performs a space-management function that

controls the use and allocation of space.

Teradata performs all tasks in parallel, providing exceptional performance.

The greater the number of tasks processed in parallel, the better the

system performance. Many databases call themselves "parallel", but they

can only perform some tasks in parallel.