- Series: The Complete Reference
- Paperback: 510 pages
- Publisher: McGraw-Hill Education; 1 edition (July 28, 2010)
- Language: English
- ISBN-10: 0071744320
- ISBN-13: 978-0071744324
- Product Dimensions: 7.4 x 1 x 9.1 inches
- Shipping Weight: 2.3 pounds (View shipping rates and policies)
- Average Customer Review: 42 customer reviews
- Amazon Best Sellers Rank: #177,358 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Star Schema The Complete Reference 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
Frequently bought together
Customers who bought this item also bought
Customers who viewed this item also viewed
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.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
II. Multiple Stars
III. Dimension Design
IV. Fact Table Design
VI. Tools and Documentation
This is a very natural and logical progression through data modeling and ETL implications. You can read the book from beginning to end and/or use it as a reference when faced with a particular challenge. Star Schema covers a wide range of scenarios with examples that can be easily extrapolated to other industries or your particular data.
Even being in IT, IT books can be dry. However, Christopher’s writing style is that of a mentor. He walks you through each topic with examples. Often, I came up with a question only to be answered on the next page. This keeps the reader engaged and that makes for a deeper understanding of the material. Not every Customer Dimension or Sales Fact is modeled the same. After you know the concepts and the data, you can produce the best design.
From Conformed Dimensions to Recursive Hierarchies and Bridges, you will see your data and your data model in a new light. Every system needs a strong foundation. This book will help you develop a solid dimensional model that will support and grow as your business does.
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.
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.
Worth every penny, and more. Wish I had gotten it long time ago.
This is one of those books that I'll be keeping on my desk as a reference.
Most recent customer reviews
Data you provided in this book is real and useful information :)