By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    data Analytics instagram stories
    Data Analytics Helps Marketers Make the Most of Instagram Stories
    15 Min Read
    analyst,women,looking,at,kpi,data,on,computer,screen
    What to Know Before Recruiting an Analyst to Handle Company Data
    6 Min Read
    AI analytics
    AI-Based Analytics Are Changing the Future of Credit Cards
    6 Min Read
    data overload showing data analytics
    How Does Next-Gen SIEM Prevent Data Overload For Security Analysts?
    8 Min Read
    hire a marketing agency with a background in data analytics
    5 Reasons to Hire a Marketing Agency that Knows Data Analytics
    7 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: Master Data Management
Share
Notification Show More
Aa
SmartData CollectiveSmartData Collective
Aa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Uncategorized > Master Data Management
Uncategorized

Master Data Management

PhilSimon
Last updated: 2009/07/02 at 1:19 AM
PhilSimon
7 Min Read
SHARE

Master Data Management has been getting a decent amount of play recently and I figure that I’ll chime in with my opinion on it. First, a definition from Wikipedia is in order:

In computing, master data management (MDM) comprises a set of processes and tools that consistently defines and manages the non-transactional data entities of an organization (also called reference data). MDM has the objective of providing processes for collecting, aggregating, matching, consolidating, quality-assuring, persisting, and distributing such data throughout an organization to ensure consistency and control in the ongoing maintenance and application use of this information.

More Read

big data improves

3 Ways Big Data Improves Leadership Within Companies

IT Is Not Analytics. Here’s Why.
Romney Invokes Analytics in Rebuke of Trump
WEF Davos 2016: Top 100 CEO bloggers
In Memoriam: Robin Fray Carey

That’s a mouthful, eh? As I am wont to do, let’s personalize this a bit. I will use an example of a situation that may benefit from the introduction of an MDM tool.

YYZ Enterprises is a standard moving company with its own enterprise systems. It is looking to carve out a niche for itself. To that end, it purchases Limelight, Inc., a small moving company that specializes in transporting high-priced art. Like YYZ, Limelight has its own back office systems–different than those of YYZ. The new company, Moving Pictures, is poised for . …

Master Data Management has been getting a decent amount of play recently and I figure that I’ll chime in with my opinion on it. First, a definition from Wikipedia is in order:

In computing, master data management (MDM) comprises a set of processes and tools that consistently defines and manages the non-transactional data entities of an organization (also called reference data). MDM has the objective of providing processes for collecting, aggregating, matching, consolidating, quality-assuring, persisting, and distributing such data throughout an organization to ensure consistency and control in the ongoing maintenance and application use of this information.

That’s a mouthful, eh? As I am wont to do, let’s personalize this a bit. I will use an example of a situation that may benefit from the introduction of an MDM tool.

YYZ Enterprises is a standard moving company with its own enterprise systems. It is looking to carve out a niche for itself. To that end, it purchases Limelight, Inc., a small moving company that specializes in transporting high-priced art. Like YYZ, Limelight has its own back office systems–different than those of YYZ. The new company, Moving Pictures, is poised for growth but has to deal with regular M&A issues. Here’s where the prospect of MDM comes in.

Because both YYZ and Limelight have disparate systems (with considerable overlap in terms of customer bases and vendors), complete data and system integration at Moving Pictures would be wise. Maintaining two different systems is ill-advised for a number of reasons:

  • dual maintenance costs
  • lack of a central data repository
  • data overlap and inconsistency
  • complicated reporting
  • increased demands placed on IT for system maintenance

I could go on, but the fundamental point is this: Moving Pictures should clean up all data and bring it into one place. Doing so would allow the new company to realize a number of considerable benefits:

  • minimize administrative costs
  • provide its employees with a simple, consolidated view of its operations
  • give the new company every opportunity to succeed

The last thing that Moving Pictures wants is spaghetti architecture.

Economic Pressures and System/Data Realities

Merging systems takes time. So does cleaning up data. Converting data from Limelight’s system into YYZ’s is not a simple export and load process. Data needs to be mapped, analyzed, and transformed into a format that Limelight’s system can accept. Duplicate vendor, employee, and customer records should be consolidated. What’s more, beyond mere data work, Limelight end-users need to be trained in how to operate YYZ’s system. Finally, on the hardware front, perhaps Moving Pictures need to purchase more powerful servers and a new database to support the business.

Moving Pictures’ management may not provide the time or resources to allow this essential consolidation and system integration to take place. To that end, an MDM tool may provide a ‘band-aid’ solution to the new organization’s underlying issue: disparate data sources and inconsistent data in each. An MDM application can read vendor or customer information from both systems and possibly prevent it from getting worse. Such a tool may be a good stopgap. For example, it may prevent the following scenario from happening: Geddy–a sales rep–enters a sale for a sale to Dreamline Inc., a customer that (behind the scenes) is linked to the ‘old’ CUSTOMERID field on the CUSOTMER table. As a result, he does not get credit for his sale. Consider a related consequence: Dreamline does not receive its order because Moving Pictures ships it to Dreamline’s old address. Dreamline’s CEO (Neil) is so upset that he takes his business elsewhere.

Conclusion

MDM is a relatively new technology and I’d be lying if I claimed to have used it. From what I understand of it, however, MDM is quite a bit like a business intelligence (BI) tool, at least in concept. MDM allows organizations to do some things  that they otherwise would not be able to do, such as checking for errors and transforming data elements.

That’s all fine and dandy. However, let’s not forget the underlying premise of these tools: they exist to account for-and ultimately deal with-data discrepancies or redundancies in multiple systems. It’s probably easiest to go ‘old school’ and simply clean up and map enterprise data when an organization mergers with–or acquires–another.

PhilSimon July 2, 2009
Share This Article
Facebook Twitter Pinterest LinkedIn
Share
By PhilSimon
Phil Simon is a recognized technology authority. He is the award-winning author of eight management books, most recentlyAnalytics: The Agile Way. He <consults organizations on matters related to communications, strategy, data, and technology. His contributions have been featured on The Harvard Business Review, CNN, The New York Times, Fox News, and many other sites. In the fall of 2016, he joined the faculty at Arizona State University’s W. P. Carey School of Business.

Follow us on Facebook

Latest News

ai low code frameworks
AI Can Help Accelerate Development with Low-Code Frameworks
Artificial Intelligence
data Analytics instagram stories
Data Analytics Helps Marketers Make the Most of Instagram Stories
Analytics
data breaches
How Hospital Security Breaches Devastate Local Communities
Policy and Governance
analyst,women,looking,at,kpi,data,on,computer,screen
What to Know Before Recruiting an Analyst to Handle Company Data
Analytics

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

big data improves
Big DataJobsKnowledge ManagementUncategorized

3 Ways Big Data Improves Leadership Within Companies

6 Min Read
Image
Uncategorized

IT Is Not Analytics. Here’s Why.

7 Min Read

Romney Invokes Analytics in Rebuke of Trump

4 Min Read

WEF Davos 2016: Top 100 CEO bloggers

14 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

AI chatbots
AI Chatbots Can Help Retailers Convert Live Broadcast Viewers into Sales!
Chatbots
AI and chatbots
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?