Star Schema The Complete Reference and over one million other books are available for Amazon Kindle. Learn more
Try the eTextbook free for 7 days on your Fire, iOS, Android, PC, or Mac.

Condition: Used: Like New
Comment: SHIPS DIRECTLY FROM AMAZON. Book is sharp with only minor wear. Has a publisher's remainder mark.
Access codes and supplements are not guaranteed with used items.
Qty:1
  • List Price: $62.00
  • Save: $22.31 (36%)
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Star Schema The Complete ... has been added to your Cart
Sell yours for a Gift Card
We'll buy it for $7.46
Learn More
Trade in now
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Star Schema The Complete Reference Paperback – July 7, 2010

ISBN-13: 978-0071744324 ISBN-10: 0071744320 Edition: 1st

Buy New
Price: $39.69
30 New from $29.49 21 Used from $21.39
Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$39.69
$29.49 $21.39
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Get Up to 80% Back When You Sell Us Your Books
$39.69 FREE Shipping. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

Star Schema The Complete Reference + Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema + The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling
Price for all three: $120.18

Buy the selected items together
NO_CONTENT_IN_FEATURE

Shop the New Digital Design Bookstore
Check out the Digital Design Bookstore, a new hub for photographers, art directors, illustrators, web developers, and other creative individuals to find highly rated and highly relevant career resources. Shop books on web development and graphic design, or check out blog posts by authors and thought-leaders in the design industry. Shop now

Product Details

  • Series: The Complete Reference
  • Paperback: 510 pages
  • Publisher: McGraw-Hill Osborne Media; 1 edition (July 7, 2010)
  • Language: English
  • ISBN-10: 0071744320
  • ISBN-13: 978-0071744324
  • Product Dimensions: 7.4 x 1.1 x 9.1 inches
  • Shipping Weight: 1.4 pounds (View shipping rates and policies)
  • Average Customer Review: 4.6 out of 5 stars  See all reviews (34 customer reviews)
  • Amazon Best Sellers Rank: #77,633 in Books (See Top 100 in Books)

Editorial Reviews

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.

Customer Reviews

Chris provides examples that connect the theory to real world design challenges.
Patrick Simpers
The book is chock full of examples (very comprehensive examples), and it is written in a very clear to the point writing style.
Steve Hoberman
The book expertly traverses fundamentals of star schemas through sophisticated concepts like degenerate dimensions.
Doug Laney

Most Helpful Customer Reviews

17 of 17 people found the following review helpful By Steve Hoberman on September 27, 2010
Format: Paperback
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
11 of 11 people found the following review helpful By Andrea Vincenzi on June 10, 2011
Format: Paperback
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
7 of 7 people found the following review helpful By Jaewoo Kim VINE VOICE on March 11, 2013
Format: Paperback Verified Purchase
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.

Pros:
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.

Cons:
1)Doesn't cover much outside of data warehousing. It has light coverage of data analytics and ETL.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
7 of 7 people found the following review helpful By Amazon Customer on March 23, 2011
Format: Paperback Verified Purchase
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
6 of 6 people found the following review helpful By Jim Stagnitto on October 7, 2010
Format: Paperback
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 ([...])
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews


More About the Author

Chris Adamson has taught dimensional modeling to thousands of students world-wide. He is faculty member at The Data Warehousing Institute (TDWI), teaches at conference events and provides onsite education.

Through his company Oakton Software LLC, Chris works with customers to develop data warehousing strategies, identify and prioritize projects, design solutions, and manage implementations. His customers have included Fortune 500 companies, government entities and software tool vendors.

Chris's latest book is Star Schema: The Complete Reference (McGraw-Hill 2010). He is author of Mastering Data Warehouse Aggregates, and co-author of Data Warehouse Design Solutions, both published by Wiley.

Chris also contributes to many TDWI publications, and blogs about data warehousing at StarSchemaCentral.com.


Want to discover more products? Check out this page to see more: who is tax exempt

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
Star Schema The Complete Reference
This item: Star Schema The Complete Reference
Price: $39.69
Ships from and sold by Amazon.com