This is 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."
Star Schema The Complete Reference
et plus d'un million d'autres livres sont disponibles pour le Kindle d'Amazon. En savoir plus
| |||||||||||||||
Descriptions du produit
Détails sur le produit
Souhaitez-vous compléter ou améliorer les informations sur ce produit ? Ou faire modifier les images?
|
En savoir plus sur l'auteur
Découvrez des livres, informez-vous sur les écrivains, lisez des blogs d'auteurs et bien plus encore.
Dans ce livre
(En savoir plus)
Commentaires en ligne
Il n'y a pas encore de commentaires clients sur Amazon.fr
5 étoiles
4 étoiles
3 étoiles
2 étoiles
1 étoiles
Commentaires client les plus utiles sur Amazon.com (beta)
Amazon.com:
4.6 étoiles sur 5
23 commentaires
13 internautes sur 13 ont trouvé ce commentaire utile
5.0 étoiles sur 5
Excellent reference guide
27 septembre 2010
Par Steve Hoberman
- Publié sur Amazon.com
Format:Broché
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.
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.
7 internautes sur 7 ont trouvé ce commentaire utile
5.0 étoiles sur 5
Higly recommended
10 juin 2011
Par Andrea Vincenzi
- Publié sur Amazon.com
Format:Broché
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.
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.
4 internautes sur 4 ont trouvé ce commentaire utile
5.0 étoiles sur 5
A Definitive and Important Dimensional Design Guide - Beautifully Written
8 octobre 2010
Par Jim Stagnitto
- Publié sur Amazon.com
Format:Broché
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 ([...])
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 ([...])
›
Allez sur Amazon.com pour voir l'ensemble des 23 commentaires
4.6 étoiles sur 5
Ces commentaires ont-ils été utiles ?
Dites-le-nous
Listmania!
Rechercher des articles similaires par rubrique
Commentaires
Souhaitez-vous compléter ou améliorer les informations sur ce produit ? Ou faire modifier les images?
|
