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

Author: Len Silverston
List Price: $60.00
Our Price: Click to see the latest and low price
ISBN: 0471353485
Publisher: John Wiley & Sons (07 March, 2001)
Sales Rank: 32,840
Average Customer Rating: 4.54 out of 5

Customer Reviews

Rating: 5 out of 5
What a time saver and valuable resource!
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!


Rating: 5 out of 5
Also buy Volume 2!
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.


Rating: 5 out of 5
Invaluable
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.

Similar Products

Data Model Patterns: Conventions of Thought
Patterns of Enterprise Application Architecture


Book Index