Aster Data SQL and MapReduce
by Tom Coffing, John Nolan
Publisher: Coffing Publishing
Published: Feb, 2014
Contents
About Tom Coffing 7
About John Nolan 8
Chapter 1 – The Aster Data Architecture 9
Chapter 2 – Fact and Dimension Tables 24
Chapter 3 – How Aster Processes Data 37
Chapter 4 - Four Options for Aster Data Table Design 50
Chapter 5 - How Joins Work Inside the Aster Engine 62
Chapter 6 - Temporary and Analytic Tables 73
Chapter 7 – Aster Modeling Rules 81
Chapter 8 – Tera-Tom’s Top Tips 102
Chapter 9 - Indexes 111
Chapter 10 – Aster Windows Functions 122
Chapter 11 – SQL-MapReduce 159