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

Silverston c09.tex V2 - 11/21/2008 3:16am Page 535

Master Data Management 535

other type of contact information. The customers of Sands Distribution

are in many different locations around the world, so the address infor-

mation must accommodate international requirements that reflect the

different address structures around the world.

The different business rules applicable to master data management.

These may include rules specifying how matching of records between

different source systems occurs and rules that can be applied to cus-

tomers or other party roles.

So, to support these different needs for customer master data management,

we will describe how the data team applied more generalized patterns to

model the above types of data, namely how they modeled:

Customer statuses

Customer relationships

Customer classifications

Customer contact information (contact mechanisms)

Customer business rules (especially for determining system of record

and customer valuation)

The data team developed the model that is in Figure 9-8 to accommodate

the preceding needs for master data management. You can see that the

Level 3 Status Pattern was applied, and this allowed any PARTY ROLE to be

related to any number of STATUS TYPE(s), and any STATUS TYPE may apply

to more than one PARTY ROLE. For example, customer master data involves

many different types of customer statuses such as ‘‘Active,’’ Credit approved,’’

‘‘In Abeyance,’’ ...