Teradata Architecture diagram
Here the basic and most important component is PE (Parsing Engine) and PE can support up to 120 sessions.
1) Session Control : It checks authorization of users before processing any SQL query.
2) Parser : It checks syntax of the SQL query and access rights to the user to access various database objects referred in the SQL query.
3) Optimizer : Determines the most effective way by creating a plan or execution steps to follow in order to perform actions on database objects as per SQL query submitted by user and scans the SQL query to determine where to place locks.
4) Dispatcher : It controls the sequence in which steps are executed and It passes the execution steps to AMP by using BYNET. Dispatcher also plays an important role by combining all the responses received and send it to user.
The Next component is BYNET. It is used for communication between PE's and AMP's (Access Module Processor). There are two BYNET's available in any TERADATA environment: BYNET-0 & BYNET-1. Two BYNET's allows for continuous sending and receiving messages between PE's and AMP's.
AMP's can be considered as the worker in TERADATA Architecture. All the calculations and actual execution takes place in AMP only.Each AMP has it's own dedicated VDISK (Virtual DISK) to which it queries and process the steps planned by Optimizer. AMP's work only on their own VDISK and do not have access to other AMP's VDISK. Once the AMP perform the steps, it send back response to PE via BYNET where all the responses from various AMP's is collected and sent back to user.
1) Session Control : It checks authorization of users before processing any SQL query.
2) Parser : It checks syntax of the SQL query and access rights to the user to access various database objects referred in the SQL query.
3) Optimizer : Determines the most effective way by creating a plan or execution steps to follow in order to perform actions on database objects as per SQL query submitted by user and scans the SQL query to determine where to place locks.
4) Dispatcher : It controls the sequence in which steps are executed and It passes the execution steps to AMP by using BYNET. Dispatcher also plays an important role by combining all the responses received and send it to user.
The Next component is BYNET. It is used for communication between PE's and AMP's (Access Module Processor). There are two BYNET's available in any TERADATA environment: BYNET-0 & BYNET-1. Two BYNET's allows for continuous sending and receiving messages between PE's and AMP's.
AMP's can be considered as the worker in TERADATA Architecture. All the calculations and actual execution takes place in AMP only.Each AMP has it's own dedicated VDISK (Virtual DISK) to which it queries and process the steps planned by Optimizer. AMP's work only on their own VDISK and do not have access to other AMP's VDISK. Once the AMP perform the steps, it send back response to PE via BYNET where all the responses from various AMP's is collected and sent back to user.
No comments:
Post a Comment