Chapter 1
The Teradata Architecture
“Fall seven times – Stand up eight!”
Table of Contents Chapter 1 – The Teradata Architecture
– All Teradata Tables are spread across All AMPs
– Each Table has a Column that is the Primary Index
– Each Table has a Column that is the Primary Index
– A Full Table Scan uses All-AMPs in Parallel
– Knowing the Primary Index of a Table is Vital
– Watch the Video on Teradata Architecture
Parallel Processing
The rows of a Teradata table are spread across the AMPs so each AMP can then process an equal amount of the rows when a USER queries the table.
The Teradata Architecture
The Parsing Engine (PE) takes the User's SQL and builds a Plan for each AMP to follow to retrieve the data. Parallel Processing is all about each AMP doing an equal amount of the work. If they start at the same time and end the same time they are performing true Parallel Processing. All communication is done over the BYNET.
All Teradata Tables are spread across All AMPs
Each table dreams of spreading their rows equally across the AMPs. Above are three tables with each table holding 9 rows (3-rows per AMP).
Each Table has a Column that is the Primary Index
Rows are spread across AMPs based only on the value of the Primary Index column.
Each Table has a Column that is the Primary Index
Use the Primary Index column in your SQL WHERE clause and only 1-AMP retrieves.
A Full Table Scan uses All-AMPs in Parallel
Each AMP read its 3-rows simultaneously (in Parallel)
A Full Table Scan has each AMP read each row it is responsible for from start to end.
Knowing the Primary Index of a Table is Vital
Find out the Primary Index of a Table and you can always query using the Fast Path.
Teradata Systems can Add AMPs for Linear Scalability
4-AMP Test System.
Order_Table has 16 rows.
8-AMP Production System – with the same 16 rows
If you double the size of your system (Double the AMPs) the system is twice as fast! system number one has only 4-AMPs, but system two has 8-AMPs and is twice as fast. When a customer buys more hardware they are adding AMPs to the system. Once the hardware is configured the AMPs will redistribute the data to include the new AMPs.
Watch the Video on Teradata Architecture
Tera-Tom Trivia
Tom Coffing was the first athlete to ever place at State in any sport at Lakota High School back in 1975. Tom went on to place 4th, 3rd, and 2nd in the state as a Lakota wrestler. Tom was later inducted into the first class of the Lakota Hall of Fame. Tom is pictured above at the ceremony.
Click on the link below or place it in your browser and watch the video on Teradata Architecture.