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 2 - How Teradata Tracks Objects

“I do skid row every night.”

- Sebastian Bach

 

Teradata Assigns each Object a Unique Numeric ID

Your SQL uses database names, table names and column names, but each of these is actually given a numeric ID and it is that Numeric ID that the Parsing Engine (PE) and the Access Module Processors (AMPs) use to track the objects.

Each Database, User, Profile and Role is assigned a globally unique numeric ID.

Each Table, View, Macro, Trigger, Stored Procedure, User-defined Function, Join Index, and Hash Index is assigned their own globally unique numeric ID.

Each Column is assigned a numeric ID that is unique within its Table ID.

Each Index is assigned a numeric ID unique within its Table ID.

The Data Dictionary ...

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