REVIEW - The Data Warehouse Toolkit - The Complete Guide to Dimensional Modeling


Title:

The Data Warehouse Toolkit

The Complete Guide to Dimensional Modeling

Author:

Ralph Kimball, Margy Ross

ISBN:

Publisher:

John Wiley & Sons (2002)

Pages:

436pp

Reviewer:

David Ross

Reviewed:

February 2004

Rating:

★★★☆☆


an emphasis on addressing real business issues

My day job revolves around the building of Data Warehouses and Data Mining environments and I regularly recommend Ralph Kimball's numerous books on the topic to colleagues and clients. This particular book, an update of the 1996 edition, is no exception. This time around there is less emphasis on selling the concept of dimensional modelling (now the accepted way to build warehouses) and more on how to do it.

The books takes an interesting approach: after first discussing the basics of why and how create a dimensional model, it then uses cases studies from various industry sectors to explore the intricacies of the techniques and issues which arise during implementation. The temptation to focus on your own speciality should be avoided since each provides new insights. For instance, the handling of multiple time zones is covered in the section on transportation, while fact-less fact tables are covered in the education chapter. Throughout there is an emphasis on addressing real business issues, with numerous example schemas to support the text.

There are a few chapters relating to concept and benefits of data warehousing, how to implement a warehouse and future directions. While these provide useful context (the first chapter being an excellent introduction to the field), this is principally a book about dimensional modelling and as such I can strongly recommend it.


Book cover image courtesy of Open Library.





Your Privacy

By clicking "Accept Non-Essential Cookies" you agree ACCU can store non-essential cookies on your device and disclose information in accordance with our Privacy Policy and Cookie Policy.

Current Setting: Non-Essential Cookies REJECTED


By clicking "Include Third Party Content" you agree ACCU can forward your IP address to third-party sites (such as YouTube) to enhance the information presented on this site, and that third-party sites may store cookies on your device.

Current Setting: Third Party Content EXCLUDED



Settings can be changed at any time from the Cookie Policy page.