The Data Model Resource Book, Vol. 2: A Library of Data Models for Specific Industries

The books offers an optional electronic download of the SQL for each industry for $400 but this is not at all necessary to benefit from the templates offered in the book because the book provides detailed data model constructs showing everything necessary to implement the models including primary and foreign key structures, attributes, relationship and attribute optionality, cardinalities of relationships, full explanations of the rationale behind each model, and even data examples for most of the models and attributes. We licensed the electronic download also and it saved us some time instead of having to manually enter the models from the book, however, the book without the electronic downloads is complete in and of itself, and it is amazing that one can buy an extensive library of industry data models for the cost of this book!


Invaluable   March 16, 2003
5 out of 5 found this review helpful

The comprehensive industry data models and data warehouse designs in this book have been invaluable to our organization. These models are extremely well thought out and complete with Primary Keys, Foreign Keys and rational behind the data modeling choices. This book helped us deliver much higher quality solutions and saved us a tremendous amount of time. This book is worth many times its cost and we highly recommend it to any data modeler. We believe its an essential part of any data modelers toolkit.


What a time saver and valuable resource!   February 25, 2004
Chandra Srinimugam (Woodinville, WA)
5 out of 5 found this review helpful

My copy of both volume 1 and volume 2 have been referenced so many times that they are tattered and worn, but such a valuable resource on all my projects. Whenever I contemplate a design, I first look at this book and, more often than not, I get ideas and best practices on ways to model the construct. I have successfully re-used designs from both volume 1 and 2 and have applied models from both of these books towards the modeling of many industries including distribution, manufacturing, telecommunications, health care, financial services and professional services.

I have found that the models provided are very relevant, re-usable, and of very high quality. They also provide all the details necessary to create physical database designs. They include entities, keys (primary and foreign), relationships (named), attributes, and the appendices include a complete listing and cross referencing of the entities and attributes, which entities are used in which diagrams (in volume 2), and domains that specify the data type and suggested lengths for each attribute. The book provides clear explanations as to why the models are modeled a certain way as well as includes data examples showing the specific instances of data that could be stored in these models.

The data models offered are at what I would consider a mid level of abstraction. Therefore, they offer a good level of flexibility without being overly abstract. The author will use very useful abstractions such as a "party", "product", "agreement" and "work effort" (with many specific subtypes of these entities as they apply to the various industries) but he does not go overboard by including overly generic concepts like "item" "activity", or "thing" entities. What I really like is that the author will often show multiple ways of modeling the same construct and show the pros and cons of the different ways to model a construct. Sometimes specific data modeling constructs are shown and sometimes more abstract entity models are shown.

Both the volume 1 common models and volume 2 industry models have not only saved me time by being able to re-use the constructs, but they have offered some perspectives that did not occur to me and have literally been a life saver to me on many a project. I could not ask for a better reference on data modeling templates and re-usable data modeling examples!


Also buy Volume 2!   March 9, 2004
Herman Koester (Belleville, IL USA)
3 out of 3 found this review helpful

This is an excellent companion to Volume 1 and well worth the cost for not only the book, but also the industry specific CDs. There is a separate CD for each industry specific data model, however it wouldn't take long for a person to buy just the book and end up spending more in man-hours trying to create the data model from the book, which isn't a very good use of your time. Buy the CD also.

My organization found this book a tremendous help on one of our projects. The time saved on just one project will more than pay for the book and CD.

This is not a how-to for data modeling, however I believe it should be purchased along with your how-to book if you are interested in learning

I know there are other universal data models available. However the others I've seen are either very simple, don't have a CD, and don't have near the content as these models, or they are unbelievably expensive.