Thursday, September 25, 2014

Teradata Architecture

Architecture

Teradata relies on three architectural components.
TeradataWiki-Teradata Architecture
Teradata Architecture
Parsing Engine (PE)
The Parsing Engine (PE) is a component that interprets SQL requests, receives input records, and passes data. It sends the messages through the BYNET to the AMPs.
PE is made of following component .
1.Session Control: Major function of Session Control is Logon and Logoff
2.Parsing : The parser interprets sql statements and checks it for proper syntax and evaluate them symmetrically.
3. Optimizing :Developing the least expensive plan to return requested response set.
4. Dispatching : Pass the steps on to the AMP via BYNET.

BYNETs
The BYNET act as message-passing layer. It decides which AMP should receive a message.
Mechanism to communicate.
1. Broadcast 
2. Point to Point

Access Module Processor (AMP)
The AMP is a virtual processor (vproc) designed to managing a portion of the entire database.
It performs all database management functions such as sorting, aggregating, and formatting data.
The AMP receives data from the PE, formats rows, and distributes them to the disk storage units it controls. The AMP also retrieves the rows requested by the Parsing Engine.

Disks
Disks are disk drives associated with an AMP that store the data rows.

No comments:

Post a Comment