The Data Model Resource Book: A Library of Logical Data and Data Warehouse Designs (Paperback)

~ (Author), (Author), (Author) "On many of our data modeling consulting engagements, our clients ask us the same question: Where can we find a book showing a standard way..." (more)
Key Phrases: data warehouse data model, shipment line item, party contact mechanism, John Smith, Main Street, Joe Schmidt (more...)

Editorial Reviews

Product Description

Proven data models that save companies' time and money developing data architectures, databases and data warehouses.

The Data Model Resource Book provides a common set of data models for specific functions common to most businesses, such as sales, marketing, order processing, contracts, shipments, invoicing, work efforts, budgeting, and accounting. Readers can apply more than one data model to their own company to meet specific data needs.

A CD-ROM ,sold separately, contains the SQL for all of the data models contained in the book in Oracle, Sybase, Informix, Microsoft SQL Server and ANSI compatable formats.

From the Publisher

Proven data models that save companies' time and money developing databases and data warehouses. The Data Model Resource Book provides a common set of data models for specific functions common to most businesses, such as sales, marketing, order processing, budgeting, and accounting. Readers can apply more than one data model to their own company to meet specific data needs. A CD-ROM, sold separately, contains all of the data models contained in the book in electronic form.

See all Editorial Reviews

Product Details

• Paperback: 355 pages
• Publisher: John Wiley & Sons (March 1997)
• Language: English
• ISBN-10: 0471153648
• ISBN-13: 978-0471153641
• Product Dimensions: 9.1 x 7.4 x 0.8 inches
• Shipping Weight: 1.4 pounds
• Average Customer Review: 3.8 out of 5 stars  See all reviews (16 customer reviews)
• Amazon.com Sales Rank: #1,111,811 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

18 of 18 people found the following review helpful:

5.0 out of 5 stars My Bible For The Most Flexible Way To Solve Problems, May 11, 2000

By	Jeffrey Schenk (Smyrna, Tennessee) - See all my reviews (REAL NAME)

I purchased this book several years ago, and while I have other good
references on modeling, and other books with the Inmon name on them, I must
say this is the book that is highlighted, annotated, and worn.

The sample relationships set forth in this text are so exhaustively thought
out that I seldom find a real-world circumstance that the model won't
handle.

Perhaps my favorite thing about this text is that the authors reason aloud
about their motives for creating things in a particular fashion... so
whether you agree or not, at least you understand the what and why behind
the decision... very helpful when you're considering an alternate solution.
This book doesn't spell out relationships... it thinks them out.

If you're someone who needs to understand the reasoning beneath the doing,
someone who needs to be able to articulate your modeling decisions... then
here's your book.
€ÿ

13 of 13 people found the following review helpful:

5.0 out of 5 stars Excellent resource of data models and physical designs, March 3, 1999

By	Van Scott "cardmore" (USA) - See all my reviews

The Resource Book is one of the more useful books I have seen on data architecture. It is just what it says: an (excellent) resource library for seven logical data models, one warehouse design, and two data mart designs. These data models and designs can be used as templates or starting points for your own modeling, an introduction to subject areas you might not be familiar with, validating your existing models, and a help to building a corporate data model. The logical models tend to be very complete. You probably won't need all their features, but they provide a good reference.

The book provides a good notation for showing the relationship among high-level models, mid-level models, and data warehouse and data mart designs. Instance tables (sample data) help bring the models to life. The book also provides a good methodology for transforming logical data models to data warehouse designs. The book is an extremely useful resource.

12 of 12 people found the following review helpful:

3.0 out of 5 stars A Good Resource for Initiating a Modeling Effort, October 16, 1997

By A Customer

Have you ever had difficulty overcoming the inertia of "getting started" when preparing for a requirements gathering session? How often do you encounter subject matter experts who are not quite sure just what it is that they "need" from an information standpoint? I have found "The Data Model Resource Book" to be of significant assistance in preparing for Logical Modeling Sessions. In an effort to develop "Straw Man" models, in particular, this book has proven to be an excellent resource. In some cases, the basic concepts identified in the book, if not the structures of the models themselves, survive the analysis effort. The definitions and the structures provide stimuli to the thinking of the project team, resulting in a more thorough analysis of the subject area under consideration. I agree that Kimball's book "The Data Warehouse Toolkit" is probably the best resource going for data warehouse design and implementation with today's technology. It is true that this book is not the "Silver Bullet" for slaying the data modeling werewolf. Nonetheless, for a wide variety of applications, (particularly Operational Applications) "The Data Model Resource Book" has been of much assistance.