The Data Model Resource Book: A Library of Universal Data... and over one million other books are available for Amazon Kindle. Learn more

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

24 customer reviews
ISBN-13: 978-0471353485
ISBN-10: 0471353485
Why is ISBN important?
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Sell yours for a Gift Card
We'll buy it for $14.78
Learn More
Trade in now
Have one to sell? Sell on Amazon
Buy used
Buy new
Rent from Amazon Price New from Used from
"Please retry"
Paperback, March 7, 2001
"Please retry"
$43.59 $37.66
Multimedia CD, Import
"Please retry"
More Buying Choices
36 New from $43.59 14 Used from $37.66
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

InterDesign Brand Store Awareness Rent Textbooks
$56.97 FREE Shipping. Only 1 left in stock (more on the way). Ships from and sold by Gift-wrap available.

Frequently Bought Together

The Data Model Resource Book, Vol. 2: A Library of Data Models for Specific Industries + The Data Model Resource Book, Vol. 1: A Library of Universal Data Models for All Enterprises + The Data Model Resource Book, Vol. 3: Universal Patterns for Data Modeling (Volume 3)
Price for all three: $175.80

Buy the selected items together

Editorial Reviews


"I thought the models in the books were well thought out and adequately explained." (Computer Shopper, February 2002)


"In addition to being an excellent resource for data modelers, this book will help managers, business analysts and architects gain a high level understanding of various industries and integration challenges facing IT professionals. Len's concepts, insights and models provide a valuable contribution to data architecture."--Regina Pieper Enterprise Architect, Sun Microsystems

"Len Silverston has produced an enormously useful two-volume compendium of generic (but not too generic) data models for an extensive set of typical enterprise subject areas, and for various industries that any data modeler will likely encounter at some point in his or her career. The material is clearly written, well organized, and goes below the obvious to some of the more perverse and difficult information requirements in an enterprise. This is an invaluable resource for doing one's homework before diving into any modeling session; if you can't find it here, there is certainly a very similar template that you can use for just about any situation with which you might be faced."-- William G. Smith President, William G. Smith & Associates

"In today's fast-paced e-oriented world, it is no longer acceptable to bury business constraints in hard-to-change data structures. Data architects must comprehend complex requirements and recast them into data architecture with vision for unforeseen futures. Len?s models provide an outstanding starting point for novice and advanced data architects for delivering flexible data models. These models position an organization for the business rule age. Their proper implementation and customization allows the organization to externalize and manage business policies and rules so that the business can proactively change itself. In this way, the data architecture, based on Len's models and procedures for customizing them, becomes by design the foundation for business change."--Barbara von Halle Founder, Knowledge Partners, Inc. Co-author of Handbook of Relational Database Design

"These books are long overdue and a must for any company implementing universal data models. They contain practical insights and templates for implementing universal data models and can help all enterprises regardless of their level of experience. Most books address the needs for data models but give little in the way of practical advice. These books fill in that void and should be utilized by all enterprises."--Ron Powell Publisher, DM Review

"I was first introduced to The Data Model Resource Book three years ago when I was hired by a firm that wanted an enterprise data model. This company did not believe the dictum that "all companies are basically the same;" they felt they were somehow unique. After a little analysis with Len Silverston's help, we found that we were actually quite a bit the same: we had customers, accounts, employees, benefits, and all the things you'd find in any corporation. All we had to do was adapt the product component of Len's book and we were ready to move ahead with a great framework for all of our data. A CD-ROM that accompanies the book provided scripts to build the model in Oracle very quickly. We then began mapping all of our detailed data types to the enterprise model and, voila, we could find a place for all of those various spellings and misspellings of Account Number.

Volume 2 of this revised edition provided even more exciting features: models of industry-specific data. I began to see interesting patterns that permeated this volume. For example, a reservation is a reservation, whether you're an airline, a restaurant, or a hotel. (We even have something similar in the oil industry--the allocation.)

Another concept from the book that has changed my thinking and vocabulary is the word "party." I recently managed a project in which an employee could also function as a customer and as an on-line computer user. The team was in disagreement regarding a name for this entity; but after checking The Data Model Resource Book, we realized that here we had a party playing three roles.

Whether your job is to jump-start a data warehouse project or borrow ideas for any subject area in your next operational database, I highly recommend The Data Model Resource Books, Revised Edition, Volumes 1 and 2 as your bible for design."--Ted Kowalski Data Architect, Equilon Enterprises LLC Author of Opening Doors: A Facilitator's Handbook


Shop the New Digital Design Bookstore
Check out the Digital Design Bookstore, a new hub for photographers, art directors, illustrators, web developers, and other creative individuals to find highly rated and highly relevant career resources. Shop books on web development and graphic design, or check out blog posts by authors and thought-leaders in the design industry. Shop now

Product Details

  • Paperback: 576 pages
  • Publisher: Wiley; Revised Edition, Volume 2 edition (March 7, 2001)
  • Language: English
  • ISBN-10: 0471353485
  • ISBN-13: 978-0471353485
  • Product Dimensions: 7.4 x 1.2 x 9.2 inches
  • Shipping Weight: 2 pounds (View shipping rates and policies)
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (24 customer reviews)
  • Amazon Best Sellers Rank: #513,820 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

44 of 48 people found the following review helpful By David on August 1, 2002
Format: Paperback
What a [scheme]. I thought I was purchasing some templates - generic data models oriented for specific industries. This book is a teaser for the author's electronic products, which contain the real templates. This book has just enough information to lead you to believe the electronic product is plausable, but not enough to really use the data models discussed(without the expensive downloads). I expected a bunch of entities with the PK and FK attributes ready for customizing with my company specific attributes... NOT.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
35 of 38 people found the following review helpful By Ivan Vandermerwe on February 24, 2003
Format: Paperback
First the content: Contains everything that is not taught in graduate school (been there), and everything that a data modeller needs know about data modelling.
Next the format: Consumerism at its worse! An incomplete template here, missing template there-a tease to lay out $400 for a complete set of templates (on top of the $100 plus for both volumes already laid out).
The conclusion: invest in volume 1 and familiarize yourself with the valuable concepts layed out there-save your money and TIME with volume 2.
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
9 of 9 people found the following review helpful By Dagna Gaythorpe on February 14, 2005
Format: Paperback
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
10 of 11 people found the following review helpful By A Customer on March 30, 2004
Format: Paperback
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!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
5 of 5 people found the following review helpful By Chandra Srinimugam on February 25, 2004
Format: Paperback
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.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
The Data Model Resource Book, Vol. 2: A Library of Data Models for Specific Industries
This item: The Data Model Resource Book, Vol. 2: A Library of Data Models for Specific Industries
Price: $56.97
Ships from and sold by

Want to discover more products? Check out this page to see more: data modeling