KEMBAR78
Teradata Architecture | PDF | Computer Data Storage | Sql
Scribd
Upload
107 views3 pages

Teradata Architecture

The Teradata architecture is based on massively parallel processing. It uses parsing engines to prepare query execution plans and send them to Access Module Processors (AMPs) via the BYNET messaging layer. AMPs store and retrieve data from disks in parallel and return results to the parsing engine. Nodes contain operating systems, CPUs, memory, and disks and work together across this architecture to process queries and retrieve data for clients in a distributed manner.

Uploaded by

anjani kammella
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
107 views3 pages

Teradata Architecture

The Teradata architecture is based on massively parallel processing. It uses parsing engines to prepare query execution plans and send them to Access Module Processors (AMPs) via the BYNET messaging layer. AMPs store and retrieve data from disks in parallel and return results to the parsing engine. Nodes contain operating systems, CPUs, memory, and disks and work together across this architecture to process queries and retrieve data for clients in a distributed manner.

Uploaded by

anjani kammella
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

TERADATA ARCHITECHTURE

-----------------------------------------------------------------------------------------------

Teradata architecture is based on Massively Parallel Processing (MPP) architecture. The major
components of Teradata are Parsing Engine, BYNET and Access Module Processors (AMPs).
The following diagram shows the high level architecture of a Teradata Node.

Components of Teradata
The key components of Teradata are as follows −
 Node − It is the basic unit in Teradata System. Each individual server in a Teradata
system is referred as a Node. A node consists of its own operating system, CPU,
memory, own copy of Teradata RDBMS software and disk space. A cabinet consists of
one or more Nodes.
 Parsing Engine − Parsing Engine is responsible for receiving queries from the client and
preparing an efficient execution plan. The responsibilities of parsing engine are −
o Receive the SQL query from the client
o Parse the SQL query check for syntax errors
o Check if the user has required privilege against the objects used in the SQL query
o Check if the objects used in the SQL actually exists
o Prepare the execution plan to execute the SQL query and pass it to BYNET
o Receives the results from the AMPs and send to the client
 Message Passing Layer − Message Passing Layer called as BYNET, is the networking
layer in Teradata system. It allows the communication between PE and AMP and also
between the nodes. It receives the execution plan from Parsing Engine and sends to
AMP. Similarly, it receives the results from the AMPs and sends to Parsing Engine.
 Access Module Processor (AMP) − AMPs, called as Virtual Processors (vprocs) are the
one that actually stores and retrieves the data. AMPs receive the data and execution plan
from Parsing Engine, performs any data type conversion, aggregation, filter, sorting and
stores the data in the disks associated with them. Records from the tables are evenly
distributed among the AMPs in the system. Each AMP is associated with a set of disks
on which data is stored. Only that AMP can read/write data from the disks.

Storage Architecture
When the client runs queries to insert records, Parsing engine sends the records to BYNET.
BYNET retrieves the records and sends the row to the target AMP. AMP stores these records on
its disks. Following diagram shows the storage architecture of Teradata.

Retrieval Architecture
When the client runs queries to retrieve records, the Parsing engine sends a request to BYNET.
BYNET sends the retrieval request to appropriate AMPs. Then AMPs search their disks in
parallel and identify the required records and sends to BYNET. BYNET then sends the records
to Parsing Engine which in turn will send to the client. Following is the retrieval architecture of
Teradata.

You might also like