O'Reilly logo

Teradata Database Administration – Teradata Internals by Tom Coffing, Todd Wilson

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 – AMP Worker Tasks

“Anything you can do needs to be done, so pick up the tool of your choice and get started.”

- Ben Linder

 

Teradata is a Message Passing System

All communication to and from AMPs are done via messages over the BYNET.

images

Every PE can communicate in a broadcast to all AMPs or to any AMP individually. AMPs can communicate to all other AMPs via a broadcast or to any other AMP individually.

Teradata has mastered communication with a message passing system between Virtual Processors (Vprocs) called AMPs and PEs. The Vprocs communicate through BYNET 0 or BYNET 1 or both with messages.

 

The Parsing Engine Parses the SQL and ...

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