Free Downloads
Mastering Data Warehouse Aggregates: Solutions For Star Schema Performance

This is the first book to provide in-depth coverage of star schema aggregates used in dimensional modeling-from selection and design, to loading and usage, to specific tasks and deliverables for implementation projects Covers the principles of aggregate schema design and the pros and cons of various types of commercial solutions for navigating and building aggregates Discusses how to include aggregates in data warehouse development projects that focus on incremental development, iterative builds, and early data loads

Paperback: 384 pages

Publisher: Wiley; 1 edition (July 19, 2006)

Language: English

ISBN-10: 0471777099

ISBN-13: 978-0471777090

Product Dimensions: 7.4 x 0.8 x 9.3 inches

Shipping Weight: 1.2 pounds (View shipping rates and policies)

Average Customer Review: 4.8 out of 5 stars  See all reviews (8 customer reviews)

Best Sellers Rank: #1,120,786 in Books (See Top 100 in Books) #356 in Books > Computers & Technology > Databases & Big Data > Data Warehousing #1132 in Books > Textbooks > Computer Science > Database Storage & Design

Chris does a great job of laying out both the good and bad associated with using aggregates as a means to support Business Intelligence and Hierarchical-type queries within a Data Warehouse environment. As a disciple of Ralph Kimball's Chris kept true to the doctrine and helped the reader understand why he recommended the tacts he did throughout the manuscript. The material was easy to follow and his illustrations were clear representations of the material being presented. I especially liked that he added platform-specific hints and scenarios to tailor the material to the reader's environment. While I do not necessarily agree that building aggregate tables are the solution to many of the challenges in a Business Intelligence use of Data from a Data Warehouse, I do feel that Chris' book is a great place to start to learn the challenges and start down the path of solution to the problem. Add on material might include mention of other solutions that are not manual that also address the same challenge - such as the software package from HyperRoll.

I must confess that I was skeptic before reading the book, because I thought that it could not add very much to Kimball's books. However, I was wrong: this turned out to be a very useful book. Not only it contains the most detailed explanation of DW aggregates available, but it also contains a very good discussion of the loading process for various types of dimensions and facts, which forms the bulk of data warehouse "back room processing".One more final plus: the author completely adopts the Kimball approach to Data Warehousing, so this book fits very nicely with other books from Wiley's describing Kimball methodology.

This book answers the question of how can I make my data warehouse queries run faster. There is no magic to this, just pre-compute the data that you want to query and store that in your data warehouse. That is what is meant by 'aggregates' in this book. Of course that is easier said than done. The book covers issues like what to pre-compute and how to use the aggregate. It also has a nice introductory section on how to load a data warehouse with aggregates.

Aggregate tables can improve the performance of a data warehouse by hundreds or thousands of times.This book explains how to work with aggregates, and -- this was the most interesting part -- how to make it transparently, so the users don't have to know that they are querying aggregates.I strongly recommend this book!

Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance The Data Warehouse Mentor: Practical Data Warehouse and Business Intelligence Insights Data Architecture: A Primer for the Data Scientist: Big Data, Data Warehouse and Data Vault Big Data For Beginners: Understanding SMART Big Data, Data Mining & Data Analytics For improved Business Performance, Life Decisions & More! Building a Scalable Data Warehouse with Data Vault 2.0 Data Analytics: Practical Data Analysis and Statistical Guide to Transform and Evolve Any Business Leveraging the Power of Data Analytics, Data Science, ... (Hacking Freedom and Data Driven Book 2) The Data Warehouse Lifecycle Toolkit The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling Kimball's Data Warehouse Toolkit Classics: 3 Volume Set The Data Revolution: Big Data, Open Data, Data Infrastructures and Their Consequences Mastering Adoption Law and Policy (Mastering Series) (Carolina Academic Press Mastering) Star Trek: Voyages of Imagination: The Star Trek Fiction Companion: The "Star Trek" Fiction Companion Star Wars: Star Wars Character Description Guide (A New Hope) (Star Wars Character Encyclopedia Book 1) Star Wars Galaxy Tiles: A Star Wars Supplement (Star Wars Accessory) Star Wars Miniatures Ultimate Missions: Clone Strike: A Star Wars Miniatures Game Product (Star Wars Miniatures Product) Star Wars Jedi Academy: A Star Wars Miniatures Booster Expansion (Star Wars Miniatures Product) Cognitive Therapy for Personality Disorders: A Schema-Focused Approach (Practitioner's Resource Series)(3rd Edition) The Demand Control Schema: Interpreting as a Practice Profession Acceptance and Commitment Therapy for Couples: Using Mindfulness, Values, and Schema Awareness to Rebuild Relationships My Child Won't Sleep Through the Night: 5 No-Cry Solutions to Solve Your Child's Sleep Issues (Baby Sleep Solutions, Toddler Sleep Problems, Child Sleep Solutions, No-Cry Sleep Solution)