Amazon Resale
EUR 34.93 with 24 percent savings
RRP: EUR 46.12
EUR 13.14 delivery Friday, 1 May. Details
Or fastest delivery Tuesday, 28 April. Details
In stock
EUR EUR 34.93 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
EUR EUR 34.93
Subtotal
Initial payment breakdown
Delivery cost, delivery date and order total (including tax) shown at checkout.
Shipper / Seller
Amazon
Amazon
Shipper / Seller
Amazon
Returns
Returnable within 30 days of receipt
Returnable within 30 days of receipt
Item can be returned in its original condition for a full refund within 30 days of receipt
Read full return policy
Gift options
Available at checkout
Available at checkout This item is a gift. Change
At checkout, you can add a custom message, a gift receipt for easy returns and have the item gift-wrapped
Payment
Secure transaction
Your transaction is secure
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
Added to

Sorry, there was a problem.

There was an error retrieving your Wish Lists. Please try again.

Sorry, there was a problem.

List unavailable.
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet or computer – no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

  • Star Schema The Complete Reference

Follow the author

Follow to get new release updates, special offers (including promotional offers), and improved recommendations.
Christopher Adamson
Follow
Something went wrong. Please try your request again later.

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

by Christopher ADAMSON (Author)
4.7 out of 5 stars (241)
{"desktop_buybox_group_1":[{"displayPrice":"EUR 34.93","priceAmount":34.93,"currencySymbol":"EUR","integerValue":"34","decimalSeparator":".","fractionalValue":"93","symbolPosition":"left","hasSpace":true,"showFractionalPartIfEmpty":true,"offerListingId":"Bc3MCRubXuT7dtTHaX%2FH8XWV18hv%2BWiqchd9qhwzBLONhqEHLvzbTNx4LyzKlPfcLHrbYQWZyQvZWwoj8kc5NIjJzeqnNVcliWBdjEahw7oRPW8%2F2s5UeQEhO%2BgGgiJh","locale":"en-GB","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}]}

Purchase options and add-ons

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
Read more
Previous slide of product details
  1. ISBN-10
    9780071744324
  2. ISBN-13
    978-0071744324
  3. Edition
    Illustrated
  4. Publisher
    McGraw Hill
  5. Publication date
    7 July 2010
  6. Language
    English
  7. Dimensions
    18.75 x 2.95 x 23.16 cm
  8. Print length
    512 pages
Next slide of product details

Frequently bought together

This item: Star Schema The Complete Reference
EUR34.93
In stock
Sent from and sold by Amazon.
+
The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition
EUR50.31
In stock
Sent from and sold by Amazon.
+
Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema
EUR23.04
In stock
Sent from and sold by Amazon.
Total price: $00
To see our price, add these items to your basket.
Details
Added to Basket
Choose items to buy together.

Product description

Review

Select Guide Rating

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
  • Publication date ‏ : ‎ 7 July 2010
  • Edition ‏ : ‎ Illustrated
  • Language ‏ : ‎ English
  • Print length ‏ : ‎ 512 pages
  • ISBN-10 ‏ : ‎ 9780071744324
  • ISBN-13 ‏ : ‎ 978-0071744324
  • Item weight ‏ : ‎ 1.05 kg
  • Dimensions ‏ : ‎ 18.75 x 2.95 x 23.16 cm
  • Best Sellers Rank: 106,267 in Books (See Top 100 in Books)
  • Customer reviews:
    4.7 out of 5 stars (241)

About the author

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

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 stars
241 global ratings

Top reviews from United Kingdom

  • GP
    5.0 out of 5 stars The best
    Reviewed in the United Kingdom on 17 April 2025
    Format: PaperbackVerified Purchase
    Best Star Schema book I’ve ever read.
    Helpful
     Report
  • Stevew
    5.0 out of 5 stars Great book on star scema
    Reviewed in the United Kingdom on 28 August 2023
    Format: PaperbackVerified Purchase
    Excellent book on star schema and it's use in data warehouse etc. Needs to be read slowly to get the most from it, very well written but you need to understand what is being said before pushing on. I wanted to understand star schema models for excel power pivot and power bi to make it easier to avoid crafting complex dax measures.
    3 people found this helpful
    Helpful
     Report
  • Mr. Jonathan Levin
    5.0 out of 5 stars Very Powerful
    Reviewed in the United Kingdom on 7 December 2014
    Format: PaperbackVerified 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.
    4 people found this helpful
    Helpful
     Report
  • Pallanen
    5.0 out of 5 stars Nice book, arrived in time and in perfect condition
    Reviewed in the United Kingdom on 14 January 2019
    Format: PaperbackVerified Purchase
    Helped me a lot in college!
    Helpful
     Report
  • Sakhr Nammari
    5.0 out of 5 stars great reference
    Reviewed in the United Kingdom on 27 February 2014
    Format: Kindle EditionVerified Purchase
    I work in the BI and Analytics area, this is a great overall reference for first timers and experienced professionals
    2 people found this helpful
    Helpful
     Report
  • Mr. Glen A. Pyper
    5.0 out of 5 stars a must have for the library
    Reviewed in the United Kingdom on 11 February 2015
    Format: PaperbackVerified Purchase
    A must have
    Helpful
     Report
  • Mark Wilcock
    5.0 out of 5 stars The title says it all
    Reviewed in the United Kingdom on 29 August 2012
    Format: Paperback
    The title says it all - this is a comprehensive guide and reference on start schemas. It is a useful book for those of us design BI systems - the correct design of a star schema is the bedrock of a data warehouse or cube.

    It sets the scene very well for example explaining the difference between operational and analytic systems. It has the clearest comparison I've ever read of the two rival architectures, the Inmon `Corporate Information Factory' and the Kimball `Dimensional Data Warehouse'.

    It describes the basic anatomy of a star schema and defines and explains all the key terms clearly (e.g. junk dimensions, surrogate keys). It then expands to more complex designs; several fact tables, slowly changing dimensions, bridge tables. It discusses the pros and cons of various design options such as the use of an outrigger tables and snowflake schemas.

    It covers advanced topics including using designs using bridge tables for navigating hierarchies which I found very useful. There is a good section on factless fact tables.

    I have designed several BI systems and their underlying star schemas and this was a useful book to me. I would agree with the book's title that it is a complete reference.
    11 people found this helpful
    Helpful
     Report

Top reviews from other countries

Translate all reviews to English
  • Toretto
    5.0 out of 5 stars Buon libro
    Reviewed in Italy on 12 August 2021
    Format: PaperbackVerified Purchase
    Buon libro sul datawarehousing, libro tecnico per gente del mestiere
    Report
  • Der mächtige Thor
    5.0 out of 5 stars Breites Werk zum Thema
    Reviewed in Germany on 3 January 2013
    Format: PaperbackVerified Purchase
    Hier schreibt ein alter Guru in voller Breite zum Thema Star Schema. Das ist Beratungsknowhow, welches man eigentlich normalerweise nicht für kleines Geld geschenkt bekommt. Wer sich mit dem Thema beschäftigt ist mit diesem Buch sehr gut beraten.
    Report
  • phi
    5.0 out of 5 stars contenu
    Reviewed in France on 26 May 2019
    Format: Kindle EditionVerified Purchase
    Tres bien
    Report
  • LZR
    5.0 out of 5 stars Excelente y muy especializada guía sobre diseño dimensional
    Reviewed in Spain on 6 January 2013
    Format: PaperbackVerified 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.
    Report
  • Amazon Customer
    5.0 out of 5 stars Very good
    Reviewed in Japan on 2 January 2019
    Format: PaperbackVerified Purchase
    Ok
    Report
See more reviews