Our Blog Excerpts Savings Contact


Dorset House Publishing
High-Quality Books on Software Engineering and Management.  Since 1984.
dorsethouse.com > titles


iDH Sign-Up

Get Our e-News
Delivered by FeedBurner

Data Model Patterns:
Conventions of Thought

by David C. Hay

*Now in softcover, at a lower price*

ISBN: 978-0-932633-74-3  
©1996  288 pages   softcover  
$36.95 (plus shipping)

Subject(s): Data Modeling

*For UPS Ground within U.S. only.
For more info., or for Int.'l or rush orders, click here.

Rate this

Gain Insight Into Business Structure
Using and Re-Using These Data Model Patterns

About the Book

Learning the basics of a modeling technique is not the same as learning how to use and apply it. To develop a data model of an organization is to gain insights into its nature that do not come easily. Indeed, analysts are often expected to understand subtleties of an organization's structure that may have evaded people who have worked there for years.

Here's help for those analysts who have learned the basics of data modeling (or "entity/relationship modeling") but who need to obtain the insights required to prepare a good model of a real business.

Structures common to many types of business are analyzed in areas such as accounting, material requirements planning, process manufacturing, contracts, laboratories, and documents.


In each chapter, high-level data models are drawn from the following business areas:

  • The Enterprise and Its World
  • The Things of the Enterprise
  • Procedures and Activities
  • Contracts
  • Accounting
  • The Laboratory
  • Material Requirements Planning
  • Process Manufacturing
  • Documents
  • Lower-Level Conventions

This Title Is Now Also Available As an eBook Through Pearson Education at www.informit.com. To Order,

Buy at InformIT.com


 "Would you rather not reinvent the wheel? Do you have better things to do with your time? If so, you may be interested in David Hay's book Data Model Patterns. . . . Hay does an excellent job of extracting the essence of each 'thing' in order to deal with it as more of an abstraction. This results in much simpler and more powerful data models that are less dependent on cosmetic variation. . . . Once you begin to see these new patterns, you will have a new way of viewing the world of data."

 —Patrick O'Brien
St. Louis DAMA Newsletter

"occasionally a book comes along that can be considered a classic; that isn't tied to any particular product or version. David Hay's book, Data Model Patterns: Conventions of Thought, is such a book. . . . This is a book that can and should be used for years. No matter what your job function in the RDBMS industry, you'll find great value from this book. It should be mandatory reading before starting any major data modeling or application development task. No other author has gone beyond the theoretical methodology of creating a data model to actually present and analyze real-world models that we can use every day. This book is well written and well illustrated with numerous examples of the models discussed. This is a 'must buy' for your professional library."

 —Warren Capps
Oracle Developer

". . . one of the practical values of your book is the set of 'ready to use' models for the most typical applications in many industries. . . . You express your ideas in very simple and easy to understand language. This is how I think such books should be written."

 —Mark Gokman
New York Power Authority

"Hay covers a wide range of topics. Patterns includes four chapters on the basic subject areas of people and organizations, products amd inventory, procedures and activities, and accounting. . . . Patterns also includes detailed footnotes and references, a useful bibliography, and a very detailed index . . . The informal writing style of Patterns includes frequent humor . . . For a technical book, it was fun to read."

Data to Knowledge

"This is one of the best practical books on database design I've encountered. . . . includes scads of examples ranging from accounting to inventory to contracts. A well-illustrated, readable 268 pages."

Karen Watterson
Microsoft SQL Server Professional

"I found the book articulate and well-ordered, which for a subject as abstruse as data modelling is quite some achievement."

 —Howard Benbrook
Oracle Corporation

"If analysts use the well-proven modelling approach described in this book, and implement the results on relational or object database management systems, they should be able to develop highly business-oriented systems quickly."

 —Richard Barker
from the foreword



Table of Contents


Dorset House Catalog
This Book's Flyer

Also Recommended

Complete Systems Analysis: The Workbook, the Textbook, the Answers, by James Robertson and Suzanne Robertson

How to Order

To order this book by credit card directly from Dorset House in New York, please call (800) 342-6657 or (212) 620-4053, weekdays, 9am to 6pm. Alternatively, print out our Faxable Order Form and fax to (212) 727-1044.

To order this book from an online bookstore, please see above.

To purchase at a bookstore, contact our Recommended Booksellers to verify availability. Any store can order from Dorset House using the book's title and ISBN number. Also, bookstores can order our books through Baker & Taylor.

We'd like to make it easy for you to order, so please contact us at any time for help!

New:3143 Broadway, Suite 2B  New York, New York 10027  USA
1-800-DH-BOOKS or 212-620-4053, fax 212-727-1044
Copyright © 1996-2008 by Dorset House Publishing Co., Inc. All rights reserved.
Home | Blog | Savings | Stores | Features | Titles | Authors | Subjects | Orders | About | Contact | Legal