Teradata Physical Database Design

  • 1h 36m
  • Leah Nolander, Tom Coffing
  • Coffing Data Warehousing
  • 2013

The design of the data warehouse is the most important aspect, so this book is a fantastic guide on exactly how to do just that. This book brilliantly touches on the important things a designer needs to do to build a world-class data warehouse. They will clearly understand the environment and all options to enhance the performance based on the design. This will teach you great detail in a high-level manor that really focuses clearly so you won’t get bogged down with too much minutia. It will allow you to understand the important issues so you can make clear decisions.

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.

Leah Nolander grew up in Phoenix, AZ. In college, she studied Psychology with an emphasis on Pre-Med, and graduated at the top of her class, Magna Cum Laude, from Creighton University in Omaha, NE. She is currently attending Indiana University in their Doctorate program for Optometry.

At Coffing Data Warehousing, Leah has co-authored seven books and has been responsible for Nexus quality assurance. She is responsible for testing Nexus on all platforms including Teradata, Oracle, DB2, Netezza, Greenplum, Vertica, ParAccel, SQL Server, Redshift, Kognitio, and Hadoop.

In this Book

  • Physical Database Design in Layman's Terms
  • Three Options for Teradata Table Design
  • Teradata - The Cold Hard Facts
  • How Joins Work Under the Covers
  • Secondary Indexes – An Alternate Path to the Data
  • Physical Design
  • Denormalization
  • Things to Consider
  • Deep Dive Overhead for each Row
  • Compression
  • Top SQL Commands Cheat Sheet
SHOW MORE
FREE ACCESS