O'Reilly logo

Teradata Physical Database Design by Tom Coffing, Leah Nolander

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3 - Teradata - The Cold Hard Facts

“Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you.”

-Carl Sandburg

Teradata Parallel Processing

images

Each AMP holds a portion of the rows for every table in the system.

Teradata was born to be parallel. When a user queries a system, they logon to a Parsing Engine for the entire session. The Parsing Engine checks the User's SQL syntax, their Access Rights for security purposes. Then, it comes up with a plan for the AMPs to retrieve the data. The Parsing Engine passes the plan to the AMPs over ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required