ACCU Home page ACCU Conference Page
Search Contact us ACCU at Flickr ACCU at GitHib ACCU at Facebook ACCU at Linked-in ACCU at Twitter Skip Navigation

Search in Book Reviews

The ACCU passes on review copies of computer books to its members for them to review. The result is a large, high quality collection of book reviews by programmers, for programmers. Currently there are 1949 reviews in the database and more every month.
Search is a simple string search in either book title or book author. The full text search is a search of the text of the review.
    View all alphabetically
Mastering Data Warehouse Design
Claudia Imhoff et al.
Rick Stones
Appeared in:
This book tries to be a comprehensive guide to data warehousing from fundamental relational concepts (Chapter 2) upwards. It also aims, according to the back cover, to provide advice on two conflicting approaches, the more traditional Inmon relational approach, and Kimball's dimensional data mart approach.

The book gets off to a rather slow start, with a somewhat unfocused chapters on basic relational concepts, business models and discovering keys, which I thought strange. If the reader needed this basic introduction, they probably are not ready to try building a data warehouse, never mind worrying about which philosophical approach was best.

Things then improve as the book settles down into the more practical steps of getting the model correct, and deciding what data needs including. It then moves into more data warehouse type areas, looking at managing hierarchies, the calendar, and transactions, all key areas for data warehousing. Most of these chapters concentrate on relational techniques. There are some sections I personally found odd - for example some explanations of when to use bit map indexes - which seemed out of place in a book that felt it needed to start by defining normal forms and then only the first three.

By the end of the book I did not really feel the authors had addressed "head-on the challenging questions raised by Kimball" as promised on the back cover. I also found it not a particularly easy read; it never really managed to make me want to pick up the book to explore further, though to be fair I've read much worse. The book seemed strongest in the chapters when it concentrated on relational based techniques for smaller data warehouses, which are being built by people who need a refresher at the beginning of the book on normal forms. Overall a worthwhile book for beginners to data warehousing who need to build smaller relational data warehouses, but unfortunately never really justifies its "mastering" title.