The book deals extensively with one of the most critical elements in data warehouse design: the problem of how to handle time in the model. He examines many different roles that time plays in the model, including its role in the construction of dimensions.

The crux of his analytical efforts come with the introdution of his “Dot Modeling” method. This method provides a simple, but highly useful, conceptual framework for generating the logical model of the data warehouse. It also gives explicit support for handling most of the time-related issues. A major added benefit is that the basic Dot Modeling constructs are far simpler yet more complete than standard Entity/Relationship modeling diagrams, which makes it a joy to use with end users, who are able to construct complete and easy to comprehend data models without being required to learn any arcane Parent/Child terminologies or be dragged down into a discussion of the pros and cons of a Snowflaked model.

The rest of the book covers many other essentials of data warehouse construction, including physical implementation issues, an excellent discusion on the business justification for the project and its importance for success, and project management suggestions.

Enjoy this great book!

[The rest]