The Data Model Resource Book, Volume 2: A Library of Universal Data Models by Industry Types

by Len Silverston

Datenmodelle für Kernfunktionen, die in nahezu allen Geschäftsbereichen eine Rolle spielen: Dieses zweibändige, überarbeitete Handbuch in der 2. Auflage zeigt Datenbankprogrammierern, wie sie zwei Drittel der üblichen Entwicklungszeit sparen können! Im Mittelpunkt dieses 2. Bandes steht die Erstellung von Datenmodellen für verschiedenste Anwendungsgebiete - von der Finanzdienstleistung über das Versicherungswesen bis zu Bildungsangeboten. Dabei wird...

• Format: Paperback
• Language: English
• ISBN: 0471353485
• ISBN13: 9780471353485
• Release Date: March 2001
• Publisher: Wiley
• Length: 576 Pages
• Weight: 2.25 lbs.
• Dimensions: 1.3" x 7.4" x 9.1"

Customer Reviews

Is it worth buying a book for only one chapter?

Yes, it is. Because the other chapters have all sorts of useful content as well. This book covers Manufacturing, Telecommunications, Health Care, Insurance, Financial Services, Professional Services, Travel, and e-Commerce. Most companies, even if they aren't in those sectors, use the services of companies that are (or may do a little bit of them - offer insurance on their products, for example), and if you need to include these areas in your model, in more detail than was covered in volume 1 (the core Universal Data Model book), then this is the place to start. If you are in one of these areas, then the specific chapter has a lot of useful stuff (I have worked in Travel, Telecommunications and Professional Services), but it is well worth checking out the other models for ideas that can be re-used in your area.

Excellent, best practice industry data models!

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!

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 learningI 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.

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!

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.