By Bob Wall, Senior Consultant
Years ago, I regularly watched a television show called “What’s My Line”, moderated by John Charles Daly. The show featured a panel of four celebrities (e.g. Bennet Cerf, Steve Allen, Dorothy Kilgallen and Arlene Francis) who questioned the contestants and tried to discern their occupation. The panelist would begin asking the contestant yes-or-no questions. If they received a “yes” answer they continued, but if they received a “no” questioning passed to the next panelist and $5 was added to the prize tallied on cards Daly would flip over. A contestant won by receiving ten "no" answers (as Daly occasionally noted, "10 flips and they are a flop!") or if time ran out.
If you’ve worked on a Master Data Management (MDM) project, specifically a Customer Data Integration (CDI) effort, you may think you’re in a remake of “What’s My Line”, but now it is called “What’s My Role.” Because we are trying to integrate customer data from possibly dozens of systems, we need to understand what role the customer played in that system.
For instance, we may designate Jane Doe as a customer. For argument’s sake, a customer defined as a person or organization who has purchased one of our products, but in the shipping system she shows up as ship-to-customer, in the accounts payable system as a bill-to-customer, and in the HR system as an employee.
One way to get around this is to use a generic Party data model (with subtypes of Person or Organization) and to use 2 types of roles for that Party; Declarative and Contextual. For a Party, we might define a “role” for the party, and declare that role as “customer,” the part that an organization or person plays within the enterprise. We then might look at the associative relationship between a source application system and Party and define a contextual role, how a party is or was involved within the context of another entity. Here the roles might be ship-to, billed-to, or employee, but we always establish one instance of the specific party, in this case Jane Doe. A good discussion of using roles can be found in Len Silverston’s “The Data Model Resource Book, Volume 3, Universal Patterns for Data Modeling.”
Using a generic approach to roles for your MDM/CDI project may help you to integrate these roles and not wind up like panelists on “What’s My Role,” where you could face 10 flips and you’re out!
Bob Wall is a senior consultant with Baseline Consulting. He is an information technology specialist with 30 years experience in all areas of data warehouse administration, data architecture, data resource management, training, and applications systems development, as well as in corporate management.
Comments