Teradata Tuning

1 Module 1 Lesson Intermediate

About this course

The purest abstraction of a database is a file stored in a computer disk. Then, a (relational) database management system is a piece of software that allows one to read portions of the file using the SQL language. This over-simplification serves as a starting point of how (relational) databases and DBMS are built.

The Teradata Corporation defines Teradata Database (renamed to Vantage) as “ an information repository supported by tools and utilities that make it a complete and active relational database management system.” The Teradata Database follows a parallel processing architecture.

Course Structure

1 Lesson

The Approach of Teradata

In this module, we visit all the building blocks we will need to explore performance tuning in the next chapters. These are the topics of parallel database architectures; the shared-nothing architecture of Teradata; hardware and software components of Teradata, including cabinets, cliques, clusters, nodes, hot-standby nodes, Parallel Database Extensions, Parsing Engine (PE), BYNET, Access Module Processor (AMP), VProc, and Database File System; database objects; storing physical rows in an AMP VDisk, including the Teradata parallel hash algorithm, AMP hash maps, row hashes, physical rows, data blocks, VDisk logical sectors and cylinders, and the Master and Cylinder Index; logical row- and columnar orientation; and DBMS services, including the fallback AMP hash maps, Teradata Intelligent Memory, transactions, permanent and transient journals, WAL protocol, locks and deadlock handling, sessions, and workload management.