HP Vertica - Architecture and SQL

by Tom Coffing, Leslie Nolander

Overview

One of the most exciting new database inventions is Columnar technology. HP has built one of the best columnar databases in the world. HP Vertica is designed for both on-premises and cloud technology. This book details the architecture of the HP Vertica database and the SQL commands available. The book educates readers on how to create tables and indexes, how the data is distributed, and how the system process the data. Plus, it is followed up with over 500 pages of SQL examples and explanations. This book is a must have for anyone designing, implementing or querying the HP Vertica system. The Authors Tera-Tom Coffing, who has written over 75 successful books on Data Warehousing and Leslie Nolander, Chief Operations Officer (COO) of Coffing Data Warehousing bring a combined 40 years of experience of data warehouse knowledge to create this must have book.

Product Details

ISBN-13:	9781940540344
Publisher:	Coffing Publishing
Publication date:	12/01/2015
Series:	Tera-Tom Genius Series , #20
Sold by:	Barnes & Noble
Format:	eBook
Pages:	757
File size:	42 MB
Note:	This product may take a few minutes to download.

About the Author

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. You can contact Tom at 513 300-0341 or at [e-mail].
Leslie Nolander has been the Chief Operating Officer (COO) at CoffingDW for the past ten years. She is responsible for running the business and has done a brilliant job of orchestrating the procedures and standards at CoffingDW. Leslie has personally negotiated hundreds of contracts both internationally and domestically and has overseen every financial transaction. Leslie is the author of multiple books and a key asset in the design and implementation of the Nexus Query Chameleon. Leslie has a Bachelor's Degree from the University of Arizona in Child Development and Family Relations and completed a fifth year Teacher Certification Program. Leslie was a teacher the first ten years of her career before joining the team at CoffingDW. Leslie resides in Phoenix, Arizona with her husband Jason and they have two daughters.