Greenplum: Architecture and SQL

  • 2h 22m
  • Leona Coffing, Tom Coffing
  • Coffing Data Warehousing
  • 2015

Greenplum is the first open source data warehouse. Purchased and improved by EMC, sold to Dell, makes Greenplum one of the most powerful and widely-used systems in the world. This incredible MPP data warehouse is designed for on-premises systems and the cloud. This book details the architecture of the Greenplum Data Warehouse and the SQL commands available. This book is perfect for anyone who designs, administers or queries Greenplum. The book educates readers on how to create tables and indexes, how the data is distributed, and how the system processes the data. Plus, it is followed up with over 700 pages of SQL examples and explanations. The Authors Tera-Tom Coffing, who has written over 75 successful books on Data Warehousing and Leona Coffing, Chief Financial Officer (CFO) of Coffing Data Warehousing bring a combined 40 years of experience of data warehouse knowledge to create this must have book.

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.

Leona Coffing is the Co-founder and Chief Financial Officer of Coffing Data Warehousing. She has co-authored several books on data warehousing and has produced more than 75 CoffingDW books. Leona has always been a driving force in the success and growth of Coffing Data Warehousing. She has successfully been able to keep Coffing Data Warehousing as an independent company without utilizing venture capital.

Leona is also responsible for managing all of CoffingDW Nexus programmers and has managed and mentored over 30 Coffing Data Warehousing employees. She has also been responsible for part of the design of Nexus. She is credited with the idea of implementing Microsoft products inside Nexus.

In this Book

  • Introduction to the Greenplum Architecture
  • Greenplum Table Structures
  • Hashing and Data Distribution
  • The Technical Details
  • Physical Database Design
  • Denormalization
  • Nexus
  • The Basics of SQL
  • The WHERE Clause
  • Distinct vs. Group by
  • Aggregation
  • Join Functions
  • Date Functions
  • Conversions and Formatting
  • Sub-Query Functions
  • OLAP Functions
  • Temporary Tables
  • Character Strings
  • Interrogating the Data
  • Set Operators Functions
  • View Functions
  • Table Create and Data Types
  • Data Manipulation Language (DML)
  • Greenplum Explain
  • Statistical Aggregate Functions


Rating 4.5 of 364 users Rating 4.5 of 364 users (364)
Rating 4.6 of 23 users Rating 4.6 of 23 users (23)