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 c07.tex V2 - 11/20/2008 5:44pm Page 345
Level 3 Contact Mechanism Pattern 345
CONTACT MECHANISM 2) may have one or more CONTACT MECHANISM
PURPOSE(s) and one and only one CONTACT MECHANISM USAGE. This
supports the possible need to specify an intention(s) or a reason(s) for which a
particular contact mechanism is used. For example, a telephone number may
be used for the CONTACT MECHANISM USAGE TYPE of ‘‘Business,’’ and
addresses may have multiple CONTACT MECHANISM PURPOSE TYPE(s) of
‘‘Bill to’’ (the address to send bills) and ‘‘Ship to’’ (the address to send products).
The strength of t his pattern lies in the fact that it goes some way toward
modeling contact mechanisms in a specific manner and yet still provides
a reasonable amount of flexibility to add new contact mechanisms, contact
mechanism types, p urposes, and/or usages. We would not have much problem
showing a model like this to stake holders with only a modicum of data
modeling experience.
The weaknesses of the pattern are that it is specific in some ways and
thus includes business rules that may change and that in other ways it is
not as flexible as the level 3 and level 4 patterns. For instance, each type
of contact mechanism (telecommunications number, electronic address, and
postal address) has its own data model structure and may be managed in
different ways. If the enterprise is somewhat mercurial in nature but desires
some
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