In this series, we’ve discussed developing the MDM blueprint by developing the Common Information (Part 2), Canonical (Part 3) , and Operating (Part 4) models in our work. Part 5 introduced the Reference Architecture model into the mix to apply the technical infrastructure or patterns we plan on using.
The blueprint has now moved from being computation and platform independent to one that expresses intent through the use of more concrete platform-specific models. The solution specification is now documented (independent of the functional Business Requirements) to provide shared insight into the overall design.
Now, it’s time to bring the modeling products together and incorporate them into a MDM solution specification we can use in many ways to communicate the intent of the project.
First, the MDM blueprint specification becomes the vehicle for communicating the system’s design to interested stakeholders at each stage of its evolution. The blueprint can be used by:
- Downstream designers and implementers to provide overall policy and design guidance. This establishes inviolable constraints (and a certain amount of freedom) on downstream development activities.
- Testers and integrators to dictate the correct black-box behavior of the pieces that must fit together.
- Technical managers as the basis for forming development teams corresponding to the work assignments identified.
- Project managers as the basis for a work breakdown structure, planning, allocation of project resources, and tracking of progress by the various teams.
- Designers of other systems with which this one must interoperate to define the set of operations provided and required, and the protocols for their operation, that allows the inter-operation to take place.
Second, the MDM blueprint specification provides a basis for performing up-front analysis to validate (or uncover deficiencies in) design decisions and refine or alter those decisions where necessary. The blueprint could be used by:
- Architects and requirements engineers who represent the customer. The MDM blueprint specification becomes the forum for negotiating and making trade-offs among competing requirements.
- Architects and component designers as a vehicle for arbitrating resource contention and establishing performance and other kinds of run-time resource consumption budgets.
- Development using vendor-provided products from the commercial marketplace to establish the possibilities for commercial off-the-shelf (COTS) component integration by setting system and component boundaries and establishing requirements for the required behavior and quality properties of those components.
- Architects to evaluate the ability of the design to meet the system’s quality objectives. The MDM blueprint specification serves as the input for architectural evaluation methods such as the Software Architecture Analysis Method [and the Architecture Tradeoff Analysis Method (ATAM-SM) and Software Performance Engineering (SPE) as well as less ambitious (and less effective) activities such as unfocused design walkthroughs.
- Performance engineers as the formal model that drives analytical tools such as rate schedulers, simulations, and simulation generators.
- Development product line managers to determine whether a potential new member of a product family is in or out of scope, and if out, by how much.
Third, the MDM blueprint becomes the first artifact used to achieve system understanding for:
- Technical managers, as the basis for conformance checking, for assurance that implementations have in fact been faithful to the architectural prescriptions.
- Maintainers, as a starting point for maintenance activities, revealing the areas a prospective change will affect.
- New project members, as the first artifact for familiarization with a system’s design.
- New architects, as the artifacts that (if properly documented) preserve and capture the previous incumbent’s knowledge and rationale.
- Re-engineers, as the first artifact recovered from a program understanding activity or (in the event that the architecture is known or has already been recovered) the artifact that drives program understanding activities at the appropriate level of component granularity.
Blueprint for MDM - Where this fits within a larger program
Developing and refining the MDM blueprint is typically associated with larger programs or strategic initiatives. In this last part of the series, I'll discuss where all this typically fits within a larger program and how to organize and plan this work within context.
The following diagram (click to enlarge and use your browser to magnify the png file) puts our modeling efforts within the context of a larger program taken from a mix of actual engagements with large, global customers. The key MDM blueprint components are highlighted with numbers representing:
- Common Information Model
- The Canonical Model
- The Operating Model
- The Reference Architecture
I have also assumed a business case exists (you have this right?) and the functional requirements are known. Taken together with the MDM blueprint, we now have a powerful arsenal of robust information products we can use to prepare a high quality solution specification that is relevant and can be used to meet a wide variety of needs.
Typically, use of the MDM blueprint may include:
- Identifying all necessary components and services
- Reviewing existing progress to validate (or uncover deficiencies in) design decisions; refine or alter those decisions where necessary
- Preparation of detailed planning products (Product, Organization, and Work Breakdown structures)
- Program planning and coordination of resources
- Facilitating prioritization of key requirements – technical and business
- Development of Request for Quotation, Request for Information products (make vs. buy)
- Preparing funding estimates (Capital and Operating Expense) and program budget preparation
- Understanding a vendor’s contribution to the solution and pricing accordingly (for example, repurpose as needed in contract and licensing activities and decouple supplier proprietary lock-in from the solution where appropriate)
We are also helping to ensure the business needs drive the solution by mitigating the impact of the dreaded Vendor Driven Architecture (VDA) in the MDM solution specification.
Summary
I hope you have enjoyed this brief journey through “Modeling the MDM Blueprint” and have gained something from my experience. I’m always interested in learning from others, so please let me know what you’ve encountered yourself, and maybe we can help others avoid the pitfalls and pain in this difficult demanding work.
The difference between success and failure on an MDM journey is taking the time to model the blueprint and share this early and often with the business. This is after all a business project, not an elegant technical exercise. In an early reference, I mentioned Ward Cunningham’s Technical Debt concept. Recall this metaphor means doing things the quick and dirty way sets us up with a technical debt, which is similar to a financial debt. Like a financial debt, the technical debt incurs interest payments, which come in the form of the extra effort we have to do in future development because of the quick and dirty design choices we have made. The technical debt and resulting interest due in MDM initiative with this kind of far-reaching impact across the enterprise is, well, unthinkable.
Take the time to develop your MDM blueprint and use this product to ensure success by clearly communicating business and technical intent with your stakeholders.
Go back to Part 5.
Editor’s Note: Today’s post was written by Jeff Schaffzin. Jeff is an independent consultant with over 15 years of experience in high tech. He’s worked with a number of leading software vendors in roles such as product marketing, professional services and information technology. Specializing in data management, Jeff has spent the last three years focusing on Customer Data Integration and Master Data Management and has worked with a number of high profile companies in the United States and abroad.
Since I’m a consultant, I have the chance to meet with a wide variety of people at different companies in various industries. About a month ago, I talked with someone I worked with a number of years ago who wanted to know more about Master Data Management. Since he’s worked more as a “functional” person for most of his career (as opposed to a “technical” one), he asked me exactly what an MDM solution would provide his company.
MDM, I told him, is not simply a software application that you ‘buy’ from a software vendor like you might with a CRM or ERP solution. You can’t just decide one day that you want to buy a “customer hub” or a “product information manager” because you heard from your IT Director (or even CIO) that it will save your company millions and cure world hunger. It’s vital to understand why your company might need an MDM solution.
You need to look at your company and do some good old-fashioned detective work. Before you take that journey, take the time to understand how your company works and more importantly, why it isn’t as efficient as it could be. Perhaps management wants to know more about your customers, but can’t do it because customer data is stored in three different applications, and even then it takes two or three months to get an out-of-date report. Maybe your company is paying too much in commissions with multiple reps getting paid for the same deal. Has your company grown so fast that you have multiple purchasing and inventory management systems and hundreds of Excel spreadsheets that have all the answers – if only you could piece them together?
Perhaps you have a more urgent need to understand your customers. If you’re a pharmaceutical company, you need to follow strict spend management guidelines related to marketing to your customers. If you’re a financial services provider, you need to comply with capital management standards like Basel II and to understand your clients as mandated by federal Anti-Money Laundering legislation. Perhaps you’re a publicly held company and need to ensure that you comply with Sarbanes-Oxley. In any case, failure to comply with such legislation can lead to fines, damaged reputations or even imprisonment of top executives.
These all are commonly found reasons for pursuing an MDM solution. Take a moment – what reasons do you have for exploring MDM? If your company is like most that I talk to, you’ve got the problems that master data management can help solve.
I’m sure regular readers of this blog have noticed the reduced frequency of new articles in the past few weeks. It doesn’t mean that I don’t care about you, the reader – honestly!
But it does mean that it’s gotten much harder for me to write for this blog, because I’m typically at a client site Monday – Thursday, and correspondingly, life seems as it’s on “fast forward” lately, as I try to squeeze everything else into weekday evenings and Friday – Sunday.
I did find time to write a guest post for Identity Resolution Daily, a great blog maintained by Infoglide Software.
Here’s a brief excerpt:
There definitely seems to be a trend lately with small companies in the master data management (MDM) and data quality space being purchased (as in the asset acquisition of Exeros by IBM) or partnering with larger firms (such as Silver Creek Systems’ OEM relationship with Oracle).
I think this is a good thing. Using the classic “build, buy or ally” strategy, it isn’t surprising that sometimes companies will conclude that it’s faster and/or cheaper to buy a technology, or partner with another company that has that technology, rather than build it themselves internally.
For the complete article, please click “The Growing Role of Identity Resolution in MDM“.
Thanks for being patient with me as I re-adapt to life as a road warrior!
digg this |
del.icio.us |
Reddit |
Stumble It!
Editor’s note: from time to time, the Hub Designs Blog profiles companies and solutions you may not have heard of yet that are relevant to master data management (MDM).
Company & location: Gryphon Networks, headquartered in Norwood, Massachusetts, provides “on demand contact governance” solutions.
Value proposition: Gryphon’s approach combines compliance and preference management, converting consumer contact preferences, compliance policies, and corporate governance into a consumer contact database, tracking the legal methods for contact. This gives you a “safe” list that expands your marketable base.
What point in MDM lifecycle: This is particularly useful when you’re using an MDM hub to support marketing activities and you’re concerned about maintaining a “single source of truth” on “Do Not Call” status, as well as opt-in / opt-out status for fax, email, and direct mail campaigns.
Relevance to MDM: Today’s hubs are evolving into “policy hubs”, where the enterprise can go beyond basic customer name & address data to tracking advanced attributes like contact preferences and managing compliance with a growing list of privacy regulations. But for a lot of industries, the current generation of MDM hubs doesn’t go far enough. That’s where Gryphon Networks comes in – it provides a real-time, on-demand contact governance capability that your MDM hub can interact with via Web Services.
If you’re in an industry like financial services, hotels, healthcare, telecommunications, insurance, etc. where there’s a need for a lot of outbound marketing activities and at the same time, strict privacy regulations around “Do Not Call” and opt-out status for e-mail, fax and direct mail marketing, your MDM strategy should probably include integration with Gryphon Networks’ platform.
For more information, contact Bob Hadden at rhadden@gryphonnetworks.com.
digg this |
del.icio.us |
Reddit |
Stumble It!
The Oracle Applications Users Group (OAUG) COLLABORATE 09 conference has wrapped up, and this year was a good one.
Attendance was down overall, from about 7,500 people last year to roughly 4,500 this year (caution, these are unofficial “word of mouth” numbers). But given the gloomy economic picture over the last 6-8 months, I was just happy the conference wasn’t canceled altogether. And I noticed that the people who were there were more engaged. These are the folks who had to fight to attend, so once they got there, they were more focused on getting the most out of it.
On the Master Data Management front, we had a great roster of presentations this year.
I particularly enjoyed Bob Barnett on “Design Guidelines for Oracle PIM MDM Processes”, Shyam Kadigari on “Oracle Customers Online Implementation”, Mani Kumar Manda on “Golden Rules to Tame the MDM Beast” and William McKnight on “Top 10 Mistakes Companies make in forming Enterprise Data Governance”.
I thought Pascal Laik, VP of MDM Product Strategy at Oracle, did a great job on “Rapid ROI with Oracle Master Data Management”. He did a demo of the ROI Analysis tool that Oracle has created, which looked very comprehensive and should save MDM teams a lot of time. Oracle customers can get access to this through their Oracle sales team.
There were a couple of presentations I was looking forward to but had to miss, including Bill Swanton from AMR Research on “Master Data Management for ERP Suites – It’s Different” and Brent Zionic from Sun Microsystems on “The Lunatic, the Lover & the Poet – Beyond Imagining Data Management”. Word of mouth feedback on these presentations was very good.
The OAUG is planning to offer a number of eLearning webinars over the rest of 2009, so we’re inviting all of the presenters (and anyone else interested in doing an eLearning session) to submit their ideas at http://secure.meetingexpectations.com/oaug/elearning/elSubmission.aspx.
I’ve been a member of the OAUG’s Education Committee for several years, and with the aid of the OAUG Special Interest Group (SIG) coordinators for Customer Data Management and Product Lifecycle Management / PIM, I’ve been planning the MDM track at each year’s conference. So if you’re interested in presenting at a future OAUG COLLABORATE conference, please sign up for Hub Designs’ newsletter, so I can keep you posted on the next Call for Papers.
digg this |
del.icio.us |
Reddit |
Stumble It!
I’m heading to Orlando, FL this Sunday to attend and speak at the annual Oracle Applications Users Group (OAUG) conference.
I’m a volunteer member of the OAUG Education Committee, managing the Master Data Management track. As such, I get to work closely with the Special Interest Group coordinators, and have a lot of fun planning the the MDM part of the conference.
This year, I’m very interested in hearing what all of our great MDM track speakers will have to say, and catching some of the Oracle executive presentations on their progress towards the Fusion applications suite.
As you might expect, I’m particularly interested in the Fusion MDM Hub, and Pascal Laik from Oracle will be doing a session on that.
I’ll try to write a few “dispatches from the front lines” here during the conference to share my thoughts on the various sessions.
Hope to see you in Orlando!
digg this |
del.icio.us |
Reddit |
Stumble It!
Here’s a brief except from my monthly column in the May 2009 issue of Information Management magazine.
Master data management for product data (known as PIM, for product information management) is a different kettle of fish altogether from MDM for customer data (also known as customer data integration, or CDI). It is important to recognize and consider the fundamental differences between the two.
Click on “Product Information Challenges” to continue reading.
Please let me know what you think of the article by commenting here.
digg this |
del.icio.us |
Reddit |
Stumble It!
Editor’s note: another in an occasional series where the Hub Designs Blog profiles companies and solutions you may not have heard of that are relevant to master data management (MDM).
Company & location: SmartCo, headquartered in Paris, France, with an office in Boston MA, provides a product called the SmartCo DataHub, a master data management solution for financial institutions.
Value proposition: SmartCo DataHub consists of several data management modules including a Security Master, which handles every type of asset class and manages reference data, market data and corporate actions data. The product can receive information from many different internal or external sources, and then cleanse it, enhance it and distribute it to all departments and systems, so everyone shares the same data.
SmartCo DataHub also provides other modules such as Indices and Benchmarks, and Business Entity Management, which centralizes and consolidates all information about third parties with which the financial institution is directly or indirectly in business. This is linked to the Security Master for monitoring and mitigating credit and operational risks.
SmartCo DataHub has built-in connectors to data sources like Bloomberg, Thomson/Reuters, Factset, Interactive Data, Markit, Six Telekurs / Fininfo, and several others. SmartCo DataHub is designed using the latest SOA technology in order to provide users with more flexibility.
What point in MDM lifecycle: this would be most appropriate for banks and other financial institutions looking to replace one or more internally built security masters. Most financial services companies don’t regard creating their own custom security master as a competitive advantage any more. So a “commercial off-the-shelf” (COTS) solution might be a good fit for companies looking to reduce the number of security masters they’ve got to maintain, and save money vs. developing a new security master internally.
Relevance to MDM: the financial services industry is going through its biggest upheaval in more than 75 years. But consolidating multiple custom built systems that are expensive to maintain can save a lot of money and provide a very strong return on investment.
If you’re in the financial services industry and are investigating master data management as a strategy for cost savings, revenue enhancement or regulatory compliance, SmartCo is an interesting company that is growing its presence in the North American market.
digg this |
del.icio.us |
Reddit |
Stumble It!
Editor’s note: another installment in an ongoing series where the Hub Designs Blog profiles companies and solutions which are relevant to master data management (MDM).
Company & location: Silver Creek Systems, headquartered in Westminster, Colorado, provides automated data mastering solutions which enable enterprise-wide standardization and integration of product information.
Value proposition: I recently had a briefing with several Silver Creek people. Their core product, DataLens™, applies semantic technology to standardize, enrich, match, repurpose and govern product information. I think of it as data quality for product information on steroids.
The semantic approach makes a lot of sense. I remember from my ERP days how painful dealing with product information can be (requiring endless massaging in Excel or complex SQL queries to extract and reformat it). Silver Creek seems to have an intelligent solution to one of the thorniest issues in MDM.
What point in MDM lifecycle: if your MDM initiative involves product information, you’ll quickly find out that Product MDM is very different from Customer MDM. It’s common for product data to have dozens or even hundreds of required attributes. The hierarchy management requirements for product data are typically more complex. And because a lot of product data is unstructured or semi-structured, you need a specialized parsing engine if you want to automate the standardization of your data.
Relevance to MDM: data quality tools designed for customer information have a hard time handling the widespread variability of product data, its relative lack of structure, the dearth of referential data from third-party sources, the overloading of the “description” field, the classification and categorization requirements and the added complexity in hierarchy management.
As I do more work in the Product MDM area, I’m impressed with Silver Creek Systems and its DataLens solution.
Update on 04/14/09: Silver Creek Systems announced today that its DataLens™ System was named the top Data Quality product by SearchDataManagement.com’s 2008 Products of the Year program. The awards were judged by a team of industry analysts and consultants and presented by the editors of TechTarget’s Enterprise Applications Media Group. For more information, please visit http://www.silvercreeksystems.com/PR_SDMPOY2008/.
digg this |
del.icio.us |
Reddit |
Stumble It!
Usually, when I’ve written a magazine article, I’ll post a brief excerpt here, with a link to the full article. When I moved from the online edition of DM Review (now known as Information Management) to writing a monthly column in the print edition, somehow I forgot to keep doing that.
So here are brief excepts and links to the full articles for the past few months, in case you haven’t already seen them.
Feb. 2009: For years I’ve been recommending that companies investigating or implementing MDM should include business process management in their plans. BPM allows an organization to model, deploy and manage mission-critical processes that span multiple applications, departments and business partners – behind the firewall and over the Internet.
Click on “Business Process Management and MDM” to continue reading.
Mar. 2009: I recently came across a great quote on data quality by Ken Orr in “The Good, the Bad and the Data Quality” from the Cutter Consortium: “Ultimately, poor data quality is like dirt on the windshield. You may be able to drive for a long time with slowly degrading vision, but at some point, you either have to stop and clear the windshield or risk everything.”
Click on “Data Quality and Master Data Management” to continue reading.
Apr. 2009: Third party content is an area that’s close to my heart. I started working intensively with customer and product information more than 20 years ago and was one of the first consultants to integrate Dun & Bradstreet data with Oracle’s applications suite (about seven years ago).
Click on “Filling in the Gaps” to continue reading.
As always, please let me know what you think by commenting here.
digg this |
del.icio.us |
Reddit |
Stumble It!
Data Quality ProTM is a free, independent community resource dedicated to helping data quality professionals take their career or business to the next level. Founded and managed by data quality professionals, its mission is to create the most beneficial data quality resource that is freely available to members around the world.
Dylan Jones, founder & editor, interviewed me recently, and the interview appears on the Data Quality Pro site today.
Please click here to read the full interview.







In 
among other applications. In addition to externalizing business rules locked in proprietary applications (for example, ERP or CRM), we also use design patterns defined here to communicate between different data formats. Instead of writing translators between each and every format (with potential for a combinatorial explosion), use this in combination with the
In
in which the organization operates. Expressed in business terms, this model represents a “foundation principal” or theme we can pivot around to understand each facet in the proper context. This is not easy to pull off, but will provide a fighting chance to resolve semantic differences in a way that helps focus the business on the real matters at hand. This is especially important when developing the Canonical model introduced in the next step.

