bookshelf bookshelf bookshelf bookshelf

Books on Data Warehouse and Data Mining

The Data Warehouse Toolkit: The Complete Guild to Dimensional Modeling (Second Edition)
Ralph Kimball and Margy Ross
Wiley, 2004
If you only want to own a single book on data warehousing, this book should be it.  It is written by Ralph Kimball who is really the person behind dimensional modeling.  In my opinion, dimensional modeling is really the only cost-effective approach for any organization that wants to build reusable components that can be used to build data marts.  The book is an excellent overview for project managers, business analysis or data architects that are new to data warehouse development.  The first several chapters are essential to building a shared vocabulary in a data warehouse team.

The Data Warehouse Lifecycle Toolkit: The Complete Guild to Dimensional Modeling (Second Edition)
Ralph Kimball, Laura Reeves, Margy Ross and Warren Thornthwaite
Wiley, 2004

This book is a more advanced version of the Data Warehouse Toolkit but is targeted at project managers of data warehouse projects.  In includes a much more detailed analysis of the steps in building a data warehouse and goes into extensive detail about the roles and responsibilities in the entire lifecycle of a data warehouse project.  The book also includes a CD that has spreadsheets for use in data warehouse task management.

Common Warehouse Metamodel: An Introduction to the standard for Data Warehouse Integration
John Poole, Dan Chang, Douglas Tolbert, and David Mellor
OMG Press, Wiley Publishing Inc, 2002

The CWM standard is very large a complex standard and there is very little information about how it is actually used in practice.  But it is nonetheless a core technology that you need to understand if you are going to keep your metadata from being trapped by a single vendors solution. This is a non-technical book targeted and business analyst's and project managers that are familiar with metadata issues.

Common Warehouse Metamodel: Developer's Guide
John Poole, Dan Chang, Douglas Tolbert, and David Mellor
OMG Press, Wiley Publishing Inc, 2003

This is the technical companion to the Introductory CWM book but targeted at programmers rather than business analyst's and project managers.  It has a much more detailed discussion of CWM internals and also give sample programs in Java.  This book is really targeted at Java programmers.