Access Module Process AMP in TD

AMPs

The Access Module Process (AMP) is the heart of the Teradata RDBMS.
The Access Module Process is a virtual processor (vproc) that provides a BYNET interface and performs many database and file management tasks.
AMPs control the management of the Teradata RDBMS and also provide control over the disk subsystem, with each AMP being assigned to a virtual disk.

Each AMP controls the following set of functions:
- BYNET (or Boardless BYNET) interface
- Database manager
- Locking

1. Joins
2. Sorting
3. Aggregation
4. Output data conversion
5. Disk space management
6. Accounting
7. Journaling

- File system and disk management

 

Each AMP is assigned a portion of the database to control. Each AMP also maintains its portion of the database tables stored on disks.

 

The AMP executes any SQL requests in three steps

1.        Lock the table.

2.        Execute the operation requested.

3.        End the transaction.