In weniger als einer Minute können Sie mit dem Lesen von Star Schema The Complete Reference auf Ihrem Kindle beginnen. Sie haben noch keinen Kindle? Hier kaufen Oder fangen Sie mit einer unserer gratis Kindle Lese-Apps sofort an zu lesen.

An Ihren Kindle oder ein anderes Gerät senden


Kostenlos testen

Jetzt kostenlos reinlesen

An Ihren Kindle oder ein anderes Gerät senden

Jeder kann Kindle Bücher lesen  selbst ohne ein Kindle-Gerät  mit der KOSTENFREIEN Kindle App für Smartphones, Tablets und Computer.
Der Artikel ist in folgender Variante leider nicht verfügbar
Keine Abbildung vorhanden für
Keine Abbildung vorhanden


Star Schema The Complete Reference [Kindle Edition]

Christopher Adamson
5.0 von 5 Sternen  Alle Rezensionen anzeigen (1 Kundenrezension)

Kindle-Preis: EUR 31,49 Inkl. MwSt. und kostenloser drahtloser Lieferung über Amazon Whispernet

Weitere Ausgaben

Amazon-Preis Neu ab Gebraucht ab
Kindle Edition EUR 31,49  
Taschenbuch EUR 41,95  

Kunden, die diesen Artikel gekauft haben, kauften auch



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

Über den Autor und weitere Mitwirkende

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.


  • Format: Kindle Edition
  • Dateigröße: 5914 KB
  • Seitenzahl der Print-Ausgabe: 510 Seiten
  • Gleichzeitige Verwendung von Geräten: Bis zu 4 Geräte gleichzeitig, je nach vom Verlag festgelegter Grenze
  • Verlag: McGraw-Hill Osborne Media; Auflage: 1 (28. Juli 2010)
  • Verkauf durch: Amazon Media EU S.à r.l.
  • Sprache: Englisch
  • ASIN: B003Y8YWAE
  • Text-to-Speech (Vorlesemodus): Aktiviert
  • X-Ray:
  • Durchschnittliche Kundenbewertung: 5.0 von 5 Sternen  Alle Rezensionen anzeigen (1 Kundenrezension)
  • Amazon Bestseller-Rang: #196.026 Bezahlt in Kindle-Shop (Siehe Top 100 Bezahlt in Kindle-Shop)

  •  Ist der Verkauf dieses Produkts für Sie nicht akzeptabel?

Mehr über den Autor

Entdecken Sie Bücher, lesen Sie über Autoren und mehr


4 Sterne
3 Sterne
2 Sterne
1 Sterne
5.0 von 5 Sternen
5.0 von 5 Sternen
Die hilfreichsten Kundenrezensionen
2 von 2 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Breites Werk zum Thema 3. Januar 2013
Format:Taschenbuch|Verifizierter Kauf
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.
War diese Rezension für Sie hilfreich?
Die hilfreichsten Kundenrezensionen auf (beta) 4.6 von 5 Sternen  34 Rezensionen
16 von 16 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Excellent reference guide 27. September 2010
Von Steve Hoberman - Veröffentlicht auf
This is an excellent reference guide on dimensional modeling. The book is chock full of examples (very comprehensive examples), and it is written in a very clear to the point writing style. I found myself highlighting passages, and enjoyed reading the advanced techniques such as on multi-valued dimensions and the various ways of managing history. This book assumes you know the basics of data modeling. (If you need the basics, I would make a completely unbiased recommendation for my book, Data Modeling Made Simple).

What I also like about this book is that it is architecture-independent and Chris Adamson's techniques work for various data warehouse architectures and he explains how it fits in with the more common architectures of the Hub and Bus.

I also very much appreciated the "Further Reading" sections at the end of each chapter.
11 von 11 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Higly recommended 10. Juni 2011
Von Andrea Vincenzi - Veröffentlicht auf
You won't find a more detailed book on dimensional modeling even if you look really hard!
Professional modelers who have already read Kimball's books (like the essential "The Data Warehouse Toolkit") will appreciate the fact that Chris Adamson takes the concepts expressed in those books a step further and goes into considerable more detail, which happens to be very useful, particularly with more advanced techniques.
In fact, even the most complex design situations, which used to require a lot of thinking and experience to be implemented correctly, become clear and can be mastered by anyone who has read this book, because they are explained with lots of examples and from different perspectives.
Also, the organization of the book around technical topics (Dimension design, Fact table design, Performance...) makes it easier to use it as a reference as compared to the Kimball's book, which is organized around examples taken from various different industries.
In conclusion, this is the kind of book that leaves no gaps between theory and practice, I highly recommend it.
6 von 6 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen A Definitive and Important Dimensional Design Guide - Beautifully Written 8. Oktober 2010
Von Jim Stagnitto - Veröffentlicht auf
I always been a great fan of Chris Adamson's writing - and "Star Schema - the Complete Reference" further reinforces this admiration.

The text is a model of clarity, and the book's ideas are organized and presented in a way that rewards the reader with well-chosen examples of escalating dimensional elegance and power as progressively more advance concepts are introduced. Chris deftly and wisely avoids investing too much ink in philosophical discussions of data warehousing architectures, by (correctly) pointing out that dimensional models are universally embraced by all thought-leaders for the "last mile" presentation of information to users. So we best model them correctly - regardless of the upstream plumbing that feeds them.

All of the great dimensional design techniques that we've come to expect from Chris are presented here with added depth and context- including truly great materials on modeling each of the fact table types, and brilliant design approaches for hierarchies and aggregates. But I also appreciate the fact that "Star Schema" bravely addresses really tough dimensional design challenges (multi-valued dimensions, factless facts, derived schemas, and many others) that too often confound and frustrate mere mortal (us) practitioners in the field.

Chris has managed to produce a truly practical dimensional data warehouse design book that is at once irrefutably comprehensive, empowering, and yet eminently readable - a very tough balance to strike. Many thanks and congratulations to him - this is a wonderful and important contribution to the field.

Jim Stagnitto
Llumino, Inc. ([...]), Caserta Concepts ([...])
6 von 6 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Great for both Star and Snowflake Schemas 12. März 2013
Von Jaewoo Kim - Veröffentlicht auf
Format:Taschenbuch|Verifizierter Kauf
This book really deserves its 5 stars. It is, by far, the best book on data warehousing I have ever read.

Not only is the content very precise and comprehensive, but it is also very well written.

Data Warehousing concepts are notoriously difficult to explain. That's why so many well-meaning DW books comes short. If you can only read one book on DW design, then make it this one.

Contrary to the title, the book covers Snowflake Schema quite adeptly, and the author is careful to list all the pros and cons of going from Star to Snowflake. That leap from star to snowflake should always be taken with considerable thought.

The book is light both on data analytics and ETL. This book is almost all about Star and Snowflake schemas.

1)The best book on data warehousing design I have ever read.
2)Comprehensive AND in-depth coverage of both Star and Snowflake schemas.
3)Very well written.

1)Doesn't cover much outside of data warehousing. It has light coverage of data analytics and ETL.
5 von 5 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Absolutely Wonderful. 24. März 2011
Von Amazon Customer - Veröffentlicht auf
Format:Taschenbuch|Verifizierter Kauf
I have been working designing and developing OLTP databases for 20 years. I am new to Data warehouses and picked up this book based on reviews and I don't have any regrets. I have completed 4 out of 18 chapters ~ 85 pages. I love the way Chris analyses each topic from different angles and explains the pros and cons of each approach. I am fully satisfied with this purchase and would say that this is a great book to clear the concepts of database design for warehouses, which, is very different from OLTP designs.

This book does not show how to use a tool. It is purely design concepts. If you are looking for a book that shows how to use a tool, you are looking at the wrong stuff.
Waren diese Rezensionen hilfreich?   Wir wollen von Ihnen hören.
Kundenrezensionen suchen
Nur in den Rezensionen zu diesem Produkt suchen

Kunden diskutieren

Das Forum zu diesem Produkt
Diskussion Antworten Jüngster Beitrag
Noch keine Diskussionen

Fragen stellen, Meinungen austauschen, Einblicke gewinnen
Neue Diskussion starten
Erster Beitrag:
Eingabe des Log-ins

Kundendiskussionen durchsuchen
Alle Amazon-Diskussionen durchsuchen

Ähnliche Artikel finden