Have one to sell?

Sell on Amazon

Flip to back Flip to front

Listen Playing... Paused You're listening to a sample of the Audible audio edition.
Learn more

See all 3 images

Follow the Author

Name: Star Schema The Complete Reference: Adamson, Christopher: 9780071744324: Books - Amazon.ca
Rating: 4.7 (192 reviews)

Christopher Adamson

Star Schema The Complete Reference Paperback – Illustrated, July 28 2010

by Christopher Adamson (Author)

4.7 192 ratings

See all formats and editions

Amazon Price

New from

Used from

Kindle Edition

"Please retry"

$37.05

—

Paperback, Illustrated

"Please retry"

—

$50.82

$56.42

Kindle Edition
$37.05 Read with Our Free App
Paperback
from $50.82

14 Used from $56.42 18 New from $50.82 1 Collectible from $130.21

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

The definitive guide to dimensional design for your data warehouse

Learn the best practices of dimensional design. Star Schema: The Complete Reference offers in-depth coverage of design principles and their underlying rationales. Organized around design concepts and illustrated with detailed examples, this is a step-by-step guidebook for beginners and a comprehensive resource for experts.

This all-inclusive volume begins with dimensional design fundamentals and shows how they fit into diverse data warehouse architectures, including those of W.H. Inmon and Ralph Kimball. The book progresses through a series of advanced techniques that help you address real-world complexity, maximize performance, and adapt to the requirements of BI and ETL software products. You are furnished with design tasks and deliverables that can be incorporated into any project, regardless of architecture or methodology.

Master the fundamentals of star schema design and slow change processing
Identify situations that call for multiple stars or cubes
Ensure compatibility across subject areas as your data warehouse grows
Accommodate repeating attributes, recursive hierarchies, and poor data quality
Support conflicting requirements for historic data
Handle variation within a business process and correlation of disparate activities
Boost performance using derived schemas and aggregates
Learn when it's appropriate to adjust designs for BI and ETL tools

ISBN-10

9780071744324
ISBN-13

978-0071744324
Edition

1st
Publisher

McGraw Hill
Publication date

July 28 2010
Language

English
Dimensions

18.8 x 2.46 x 23.11 cm
Print length

510 pages
See all details

Highest ratedin this set of productsThis item:
Christopher Adamson
192
Paperback
33 offers from $50.82
Lowest pricein this set of products
Lawrence Corr
183
Paperback
$51.95
Bestsellingin this set of products
Margy Ross
614
Paperback
$68.87

Product description

From the Publisher

Christopher Adamson is the founder of Oakton Software LLC and a faculty member at The Data Warehousing Institute. He works with customers in all industries to establish data warehousing strategies, define and prioritize projects, and design solutions. Chris has taught dimensional design to thousands of students worldwide, and has written numerous books and articles.

About the Author

Christopher Adamson is the founder of Oakton Software LLC and a faculty member at The Data Warehousing Institute. He works with customers in all industries to establish data warehousing strategies, define and prioritize projects, and design solutions. Chris has taught dimensional design to thousands of students worldwide, and has written numerous books and articles.

Product details

ASIN ‏ : ‎ 0071744320
Publisher ‏ : ‎ McGraw Hill; 1st edition (July 28 2010)
Language ‏ : ‎ English
Paperback ‏ : ‎ 510 pages
ISBN-10 ‏ : ‎ 9780071744324
ISBN-13 ‏ : ‎ 978-0071744324
Item weight ‏ : ‎ 821 g
Dimensions ‏ : ‎ 18.8 x 2.46 x 23.11 cm

Best Sellers Rank: #328,968 in Books (See Top 100 in Books)
- #46 in Database Design Databases
- #73 in Data Warehousing
- #141 in Data Mining

Customer Reviews:
4.7 192 ratings

About the author

Follow authors to get new release updates, plus improved recommendations.

Christopher Adamson

Brief content visible, double tap to read full content.

Full content visible, double tap to read brief content.

Chris Adamson has taught dimensional modeling to thousands of students world-wide. He is faculty member at The Data Warehousing Institute (TDWI), teaches at conference events and provides onsite education.

Through his company Oakton Software LLC, Chris works with customers to develop data warehousing strategies, identify and prioritize projects, design solutions, and manage implementations. His customers have included Fortune 500 companies, government entities and software tool vendors.

Chris's latest book is Star Schema: The Complete Reference (McGraw-Hill 2010). He is author of Mastering Data Warehouse Aggregates, and co-author of Data Warehouse Design Solutions, both published by Wiley.

Chris also contributes to many TDWI publications, and blogs about data warehousing at StarSchemaCentral.com.

Customer reviews

4.7 out of 5

192 global ratings

5 star		81%
4 star		13%
3 star		3%
2 star		2%
1 star		1%

How are ratings calculated?

Top reviews from Canada

There was a problem filtering reviews right now. Please try again later.

Sheldon Irving

I compared this good to the other star schema books or data warehousing.

Reviewed in Canada 🇨🇦 on May 7, 2020

Verified Purchase

I compared this good to the other star schema books or data warehousing. This is the best of the best

easy to follow along. good diagrams. this is better then the other books the one from the bill inum? is harder toi understand. the person that wrote this book was a student of that guy. this person did a better job to explain + you do not need to cross reference pages as all explanations are given linearly. the other book jumped all over the place and it was harder to follow. I took the Data warehouse workshop at BCIT and loved this book. Its actually worth a read when dealing sql database. People taking a data quality course should also get this book as it teaches you how to organize your data and make it useful for business.

One person found this helpful

Helpful

Gary Singh

Explains Kimball Terminology/Concepts in an easy to understand language

Reviewed in Canada 🇨🇦 on May 7, 2014

Verified Purchase

Awesome book. Dr. Kimball's dimensional modeling book rewritten in an easier language with focus on the concepts rather than industry solutions. Sometimes the content seems a little superfluous but the author has tried to explain from different perspectivrs and Overall it is a great book.

2 people found this helpful

Helpful

M. Humphrey

Excellent introduction and reference for dimensional design

Reviewed in Canada 🇨🇦 on June 13, 2015

Verified Purchase

Excellent introduction and reference for dimensional design. Puts star schema and dimensional design in a business context. I would recommend reading this before digging into the Kimball (The Data Warehouse Toolkit).

One person found this helpful

Helpful

Ted Siller

its the book.... it showed up ...

Reviewed in Canada 🇨🇦 on November 10, 2016

Verified Purchase

its the book ....it showed up rather quickly I thought...(the topic is rather boring) ....but otherwise

Reviewed in Canada 🇨🇦 on November 21, 2014

Verified Purchase

This book is a must-have.

Helpful

Top reviews from other countries

Translate all reviews to English

Mr. Jonathan Levin

Very Powerful

Reviewed in the United Kingdom 🇬🇧 on December 7, 2014

Verified Purchase

This is an excellent excellent book. A real gem that will literally solve almost all your datawarehousing / BI projects biggest problems.
Getting the right data model and knowing about different modelling methodologies to reference and quote in meetings is far far more powerful than people realise.

2 people found this helpful

Mr. Glen A. Pyper

a must have for the library

Reviewed in the United Kingdom 🇬🇧 on February 11, 2015

Verified Purchase

A must have

Pallanen

Nice book, arrived in time and in perfect condition

Reviewed in the United Kingdom 🇬🇧 on January 14, 2019

Verified Purchase

Helped me a lot in college!

Sakhr Nammari

great reference

Reviewed in the United Kingdom 🇬🇧 on February 27, 2014

Verified Purchase

I work in the BI and Analytics area, this is a great overall reference for first timers and experienced professionals

LZR

Excelente y muy especializada guía sobre diseño dimensional

Reviewed in Spain 🇪🇸 on January 6, 2013

Verified Purchase

El acierto de esta guía sobre diseño dimensional es precisamente su especialización en este aspecto fundamental de la construcción de data warehouses / data marts.
Es concisa, clara y precisa en sus explicaciones, orientada a la práctica (pero sin detenerse en particularidades de un SGBD o herramienta BI), progresiva en su exposición de técnicas de modelado (arranca desde los fundamentos y finaliza analizando cuestiones de rendimiento), muy bien organizada (fundamentos, estrellas, dimensiones, hechos, rendimiento y herramientas) y fácil de reutilizar como manual de referencia.
Reseñar su cualidad para distanciarse de polémicas sobre arquitecturas (Inmon vs. Kimball), destacando por encima de sus diferencias sus coincidencias en la importancia que ambas conceden al modelado dimensional, que es el tema y objetivo del libro. No obstante, el tratamiento de diferentes tipos de arquitectura resultará probablemente escueto y superficial en exceso.
De similar defecto adolece la última parte del libro sobre herramientas y documentación (100 páginas aprox.).
Para terminar, este libro decepcionará a quienes busquen un texto más completo sobre data warehouse (tipo las "biblias" clásicas de Kimball), lo cual es un objetivo fuera del propósito, alcance y extensión del mismo.

2 people found this helpful

Translate review to English

See all reviews

Amazon Music Stream millions of songs	Amazon Advertising Find, attract and engage customers	Amazon Business Everything for your business	Amazon Drive Cloud storage from Amazon	Amazon Web Services Scalable Cloud Computing Services

Book Depository Books With Free Delivery Worldwide	Goodreads Book reviews & recommendations	IMDb Movies, TV & Celebrities	Amazon Photos Unlimited Photo Storage Free With Prime	Shopbop Designer Fashion Brands

Warehouse Deals Open-Box Discounts	Whole Foods Market We Believe in Real Food	Amazon Renewed Like-new products you can trust	Blink Smart Security for Every Home

Follow the Author

Star Schema The Complete Reference Paperback – Illustrated, July 28 2010

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

The definitive guide to dimensional design for your data warehouse

What do customers buy after viewing this item?

Product description

From the Publisher

About the Author

Product details

About the author

Christopher Adamson

Customer reviews

Top reviews from Canada

There was a problem filtering reviews right now. Please try again later.

Top reviews from other countries