Customer Reviews


2 Reviews
5 star:
 (2)
4 star:    (0)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
Share your thoughts with other customers
Create your own review
 
 
Most Helpful First | Newest First

2 of 2 people found the following review helpful
5.0 out of 5 stars The title says it all, 29 Aug 2012
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.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


5.0 out of 5 stars great reference, 27 Feb 2014
Verified Purchase(What is this?)
This review is from: Star Schema The Complete Reference (Kindle Edition)
I work in the BI and Analytics area, this is a great overall reference for first timers and experienced professionals
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


Most Helpful First | Newest First

This product

Star Schema The Complete Reference
Star Schema The Complete Reference by Christopher Adamson
19.55
Add to wishlist See buying options
Only search this product's reviews