Teradata Database Administration: Teradata Internals
- 1h 43m
- Todd Wilson, Tom Coffing
- Coffing Data Warehousing
- 2013
This DBA book takes the reader deep inside the guts of Teradata, down to the row level, block level, and cylinder level. Readers have an opportunity to understand Teradata at a level that 1% of the world understands Teradata. This book will bring you into the top 1% of knowledge of Teradata.
About the Authors
Tom Coffing, better known as Tera-Tom, is the founder of Coffing Data Warehousing where he has been CEO for the past 20 years. Tom has written over 50 books on all aspects of Teradata, Netezza, Kognitio, Redshift, ParAccel, Vertica, SQL Server, and Greenplum. Tom has taught over 1,000 Teradata classes in places such as India, Africa, Europe, China, Malaysia, and throughout North America.
Tom is also the owner and designer of the Nexus Query Chameleon, the most sophisticated enterprise query tool in the industry. The Nexus works on all platforms, including Hadoop, converts table structures between all systems, and allows companies to load their ERwin logical model inside Nexus. The Nexus guides users like a GPS system. Users point and click on any table or view from any system, and they are guided to what joins to what. As users choose the columns they want on their report, the SQL is built automatically.
In High School, Tom was the first athlete from his school to ever place at state. He was selected by his school to represent them at Buckeye Boys State, and Tom was inducted into the first class of the Lakota High School Hall of Fame.
At the University of Arizona and University of Nevada Las Vegas, Tom was a two-time All-American wrestler, Sophomore Athlete of the year, and a two-time winner of the 1980 Olympic wrestling trials. Tom graduated with a Bachelor's degree in Speech Communications.
After college, Tom became a state and national champion speech winner for Toastmasters and won two orchid awards as an actor. Tom is the proud father of three wonderful children and has been married for the past 32 years.
Todd Wilson is the Chief Technology Officer of Coffing Data Warehousing. As CTO, Todd has overseen the development of Coffing's premiere data analytics tool, The Nexus Query Chameleon. Under Todd's leadership, the Nexus has expanded to support data sources from all spectrums of data warehousing such as Kognitio (in-memory analytics), HP Vertica (columnar data), Hadoop (including such "Big Data" companies such as Cloudera and Hortonworks), cloud service data sources (Amazon's Redshift), as well as, traditional data sources such as Oracle, Teradata, SQL Server, Greenplum and DB2.
An experienced, .NET developer, Todd has developed data replication tools, data movement tools, data visualization tools, database management tools, DDL conversion tools and is currently overseeing the development of the Nexus Logical Model Loader. As a technical consultant, he has worked with several Fortune 500 companies in fields such as telecommunication, PC manufacturing and health care. Todd is a Teradata Certified Master and a graduate of Pepperdine University.
In this Book
-
The Cold, Hard Teradata Facts
-
How Teradata Tracks Objects
-
AMP Worker Tasks
-
Deep Dive Overhead for Each Row
-
Compression
-
Data Stored in the Row
-
How Data Rows are Stored in Blocks
-
Disk Cylinders and the Master Index
-
Teradata Virtual Storage (TVS)
-
Teradata Writes and Blocks
-
Access Logging
-
DBQL Query Logging
-
ResUsage
-
Top SQL Commands Cheat Sheet