database management systems

This book provides an extremely comprehensive and useful set of industry data models. They have been a tremendous value to us by allowing us to reference best-practice designs on our projects as well as being able to save a great deal of time by not having to re-invent the wheel for standard data modeling structures. The models are extremely well thought out and offer insight into both effective ways of modeling as well as pitfalls to be careful of. The author shows extensive knowledge and expertise in the various industries that are provided. We have used many of the models from the health care, insurance, professional services and e-commerce models to give us a kick-start on data modeling projects as well as to double check our designs and make sure we didn't overlook anything important and we did end up modifying and improving many of our data models based upon ideas from this book.

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!

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.

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!