Average Reviews:
(More customer reviews)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 ([...])
Click Here to see more reviews about: Star Schema The Complete Reference
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
Get 38% OFF
Click here for more information about Star Schema The Complete Reference
No comments:
Post a Comment