Skip to Content
The Data Model Resource Book, Volume 3: Universal Patterns for Data Modeling
book

The Data Model Resource Book, Volume 3: Universal Patterns for Data Modeling

by Paul Agnew, Len Silverston
January 2009
Beginner to intermediate
641 pages
26h 48m
English
Wiley
Content preview from The Data Model Resource Book, Volume 3: Universal Patterns for Data Modeling
Silverston c01.tex V2 - 11/21/2008 2:57am Page 6
6 Chapter 1 Introduction
What Is the Significance of Patterns?
The Universal Patterns for Data Modeling are analogous to the blueprints
engineers use for building bridges. An engineer has a basic blueprint for
building any type of suspension bridge. Every time an engineer has to build
a particular suspension bridge, that engineer doesn’t try to come up with a
new solution; he or she uses the existing design pattern. The facing on the
bridge may be different, but many of the underlying structures are the same.
For example, Akashi-Kaikyo Bridge in Tokyo and the Brooklyn Bridge in New
York are both suspension bridges, and the same basic design patterns were
used for both.
The Universal Patterns for Data Modeling represent effective practices and
alternatives for modeling very common types of data models. The underlying
data model showing how a PARTY is related to an INVOICE is very similar to
how PARTY(s) are related to SHIPMENT(s), which is also very similar to how
PARTY(s) are related to PAYMENT(s), AGREEMENT(s), or other entities. For
example, parties (people or organizations) may have certain roles within the
context of a particular transaction or with regards to another entity, and there
are very common ways to model this type of data requirement. We call this
particular example the Contextual Role Pattern. Another example is that the
status of
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

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

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

Len Silverston
The Data Model Resource Book, Volume 1

The Data Model Resource Book, Volume 1

Len Silverston, Graeme Simsion
Data Model Patterns

Data Model Patterns

David C. Hay, Richard Barker

Publisher Resources

ISBN: 9780470178454Other