Wiley.com
Print this page Share

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

ISBN: 978-0-471-35348-5
576 pages
March 2001
The Data Model Resource Book, Volume 2: A Library of Universal Data Models by Industry Types, Revised Edition (0471353485) cover image

Description

A quick and reliable way to build proven databases for core business functions
Industry experts raved about The Data Model Resource Book when it was first published in March 1997 because it provided a simple, cost-effective way to design databases for core business functions. Len Silverston has now revised and updated the hugely successful First Edition, while adding a companion volume to take care of more specific requirements of different businesses. Each volume is accompanied by a CD-ROM, which is sold separately. Each CD-ROM provides powerful design templates discussed in the books in a ready-to-use electronic format, allowing companies and individuals to develop the databases they need at a fraction of the cost and a third of the time it would take to build them from scratch.
With each business function boasting its own directory, this CD-ROM provides a variety of data models for specific implementations in such areas as financial services, insurance, retail, healthcare, universities, and telecom.
See More

Table of Contents

Foreword.

Acknowledgments.

About the Author.

Introduction.

Manufacturing.

Telecommunications.

Health Care.

Insurance.

Financial Services.

Professional Services.

Travel.

E-Commerce Models.

Using the Industry Models in the Real World.

Appendix A: Entities and Attributes for Manufacturing Models.

Appendix B: Entities and Attributes for Telecommunications Models.

Appendix C: Entities and Attributes for Health Care Models.

Appendix D: Entities and Attributes for Insurance Models.

Appendix E: Entities and Attributes for Financial Services Models.

Appendix F: Entities and Attributes for Professional Services Models.

Appendix G: Entities and Attributes for Travel Models.

Appendix H: Entities and Attributes for E-Commerce Models.

Appendix I: List of Entities and Their Associated Figures.

How to Use the Volume 2 Industry Electronic Products.

Index.
See More

Author Information

LEN SILVERSTON (lsilverston@univdata.com) is founder and owner of Universal Data Models, LLC (www.universaldatamodels.com), a Colorado-based firm providing consulting and training for helping enterprises customize and implement "universal data models" and develop holistic, integrated systems. Mr. Silverston has over 20 years' experience in delivering data integration, database and data warehouse solutions to organizations.
See More

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

See More

Errata

Do you think you've discovered an error in this book? Please check the list of errata below to see if we've already addressed the error. If not, please submit the error via our Errata Form. We will attempt to verify your error; if you're right, we will post a correction below.

ChapterPageDetailsDatePrint Run
2.10 Error in relationship from PARTY to DEPLOYMENT
There should be a 1:M relationship from PARTY to DEPLOYMENT. The relationship from INVENTORY ITEM to PARTY does not account for PARTY.
139 Error in Figure 4.2
The figure shows PARTY FACILITY entity. It should be named FACILITY ROLE.
217 5.11: Word POLICY missing
CASUALTY INSURANCE should be CASUALTY INSURANCE POLICY.
265 FUNCTION should be FUNTIONAL
In the last sentence the text is, "In this instance, the FUNCTION SETTING"
It should be: "In this instance, the FUNCTIONAL SETTING"
Appendix H Error with value ID
In LOGIN ACCOUNT HISTORY, in the rows for both CURRENT USER ID and USER ID, 3rd column (last column) value should be "short varchar" instead of ID.
Appendix H Error with value ID
In USER LOGIN in the row that shows CURRENT USER ID, 3rd column (last column) value should be "short varchar" instead of ID.
List of entities and their associated figures
Remove the references to v1:2.11, v2:4.2 for PARTY FACILITY. Keep the reference to v2:3.3 for PARTY FACILITY.
CD CD Error for 2.10
Missing relationship from DEPLOYMENT to FACILITY. Need to add a relationship showing that a DEPLOYMENT is located at a FACILITY and that a FACILITY may be the location for a FACILITY.
CD CD Error for 5.1
Insurance model: Missing subtype relationship of EMPLOYEE to PERSON ROLE. Add keys of party id and role type id to EMPLOYEE table.
CD CD Error for 5.1
Insurance model: Missing subtype relationship of INSURANCE AGENT to PERSON ROLE. Added keys of party id and role type id to INSURANCE AGENT.
CD CD Error for 5.1
Insurance model: Missing subtype relationship of INSURANCE SUPPORT STAFF (with its subtypes of CLAIMS ADJUSTOR and OTHER STAFF) to PERSON ROLE. Added keys of party id and role type id to INSURANCE SUPPORT STAFF as well as to CLAIMS ADJUSTOR and OTHER STAFF.
CD CD Error for 5.1
Insurance model: Missing PARENT ORGANIZATION. Added table PARENT ORGANIZATION with keys of party id and role type id.
CD CD Error for 5.11
Insurance model: INDIVIDUAL HEALTH CARE PROVIDER is not shown as a PARTY ROLE. INDIVIDUAL HEALTH CARE PROVIDER should be a subtype of PERSON ROLE and include its keys of party id and role type id.
CD CD Error for 5.16
Insurance model: Relationship from SETTLEMENT ROLE TYPE to PARTY should be from SETTLEMENT ROLE to PARTY. Relationship from SETTLEMENT ROLE TYPE to PARTY should be from SETTLEMENT ROLE to PARTY and thus there should be a "role type id" attribute in SETTLEMENT ROLE.
CD CD Error for 5.16
Insurance model: SETTLEMENT ROLE TYPE doesn’t have the subtype relationship to ROLE TYPE. SETTLEMENT ROLE TYPE should be a subtype of ROLE TYPE and thus should have a "role type id" attribute.
CD CD Error for 6.2
Financial services model: Relationship of "PARTY OBJECTIVE to OBJECTIVE TYPE" is non-identifying. Relationship of "PARTY OBJECTIVE to OBJECTIVE TYPE" should be identifying.
See More

Notes

Visit these related products by Len Silverston
For more information about this and the author's other data model products, visit this site.
See More

Buy Both and Save 25%!

+

The Data Model Resource Book, Volume 2: A Library of Universal Data Models by Industry Types, Revised Edition (US $75.00)

-and- Professional Microsoft SQL Server 2012 Administration (US $49.99)

Total List Price: US $124.99
Discounted Price: US $93.74 (Save: US $31.25)

Buy Both
Cannot be combined with any other offers. Learn more.
Back to Top