O'Reilly logo

Teradata Architecture for IT and Developers by Tom Coffing, John Nolan

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 5 – Inside the AMPs Disk

“My father taught me to work; he did not teach me to love it.”

- Abraham Lincoln

Rows are Stored in Data Blocks which are stored in Cylinders

images

Above, you see many rows of the same table stored in a data block. You can have many data blocks stored in a cylinder and an AMP owns thousands of cylinders.

An AMP's rows are stored inside a Data Block in a Cylinder

images

This is a real data block that contains the overhead in front of each row. This data block among other data blocks will reside inside a cylinder. The rows ...

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