Actian Matrix (Formely ParAccel) - Architecture and SQL

by Tom Coffing, Ed Bernier

Overview

One of the most exciting new technologies is Columnar and one of the premier pioneers of this technology is Actian’s Matrix database. This book details the architecture of the Matrix system and shows all SQL commands with real-world examples that work. This book educates readers on how to create tables and indexes, how the data is distributed, how columnar works, and how the system processes 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 a Matrix system. The Authors, Tera-Tom Coffing and Ed Bernier, bring experience and expertise together. Tom Coffing has written over 70 books on all technologies and is considered one of the best technical authors in the world. Ed Bernier is a past employee of Actian and Netezza, and has inside knowledge because of his system engineering background on a wide variety of systems.

Product Details

ISBN-13:	9781940540313
Publisher:	Coffing Publishing
Publication date:	10/25/2015
Series:	Tera-Tom Genius Series , #17
Sold by:	Barnes & Noble
Format:	eBook
Pages:	697
File size:	10 MB

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] Bernier has over 20 years’ experience working with databases, data warehousing and analytics. Most recently Ed spent 8 years at Netezza, inventor of the data warehouse appliance. Ed was a Netezza Systems Engineer and he was teamed up with a sales person to provide pre and post-sales support in the New England, Upstate NY and Eastern Canada Sales Territory. The Netezza appliance was one of the most exciting products Ed had ever sold at that point in his career. Ed was a pivotal part of IT history as Netezza continued to pioneer the computer industry with the first true data warehouse appliance. Ed then spent two years as a Sr. Systems Engineer at ParAccel, which was eventually purchased by Actian. ParAccel was founded by one of the original co-founders of Netezza, Barry Zane. Ed once again played a key part in IT history as ParAccel became one of the first MPP columnar databases to run on aAW14 cluster of commodity x86 nodes. Amazon’s Redshift database is based on the ParAccel Columnar PADB database. Ed currently works at WebAction, which has pioneered a real-time analytics platform that allows clients to run SQL and analytics against streaming data. His responsibilities include Proof of Concepts (POC's), presentations, whiteboard sessions, product training, software installations and upgrades, sales meetings, RFI and RFP responses, proposals and general sales and customer support activities. His academic credentials include: BS, Computer Science, Math at the University of Hartford ; AAS, Electronics at the University of Hartford Ed is an evangelist of next generation analytical solutions for structured, semi-structured and unstructured data sources. Having spent over 25 years working with databases, data warehousing, business intelligence and analytical appliance technology and solutions he understands the power of analytics to gain insight from the captured data. Ed believes that the answers for many of the struggles of society will come through data analysis. Analyzing clinical, claim, and behavioral data should provide greater insights into health. Analyzing data generated by web browsing, twitter, phone traffic and law enforcement databases will improve public safety and reduce crime and terrorism. Analyzing business data and combining this with external sources will provide companies ever greater insight into their customers, suppliers and internal processes giving them the tools they need to compete and improve efficiencies. Promoting next generation analytical solutions is certainly an exciting and worthwhile pursuit especially as new sources of data generated by sensors becomes more readily available.