By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData Collective
  • Analytics
    AnalyticsShow More
    construction analytics
    5 Benefits of Analytics to Manage Commercial Construction
    5 Min Read
    benefits of data analytics for financial industry
    Fascinating Changes Data Analytics Brings to Finance
    7 Min Read
    analyzing big data for its quality and value
    Use this Strategic Approach to Maximize Your Data’s Value
    6 Min Read
    data-driven seo for product pages
    6 Tips for Using Data Analytics for Product Page SEO
    11 Min Read
    big data analytics in business
    5 Ways to Utilize Data Analytics to Grow Your Business
    6 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
Latest News
construction analytics
5 Benefits of Analytics to Manage Commercial Construction
Analytics
database compliance guide
Four Strategies For Effective Database Compliance
Data Management
Digital Security From Weaponized AI
Fortifying Enterprise Digital Security Against Hackers Weaponizing AI
Security
DevOps on cloud
Optimizing Cost with DevOps on the Cloud
Cloud Computing Development Exclusive IT
machine learning seo
7 Mistakes to Avoid When Using Machine Learning for SEO
Exclusive Machine Learning
Aa
SmartData 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
- Advertisement -

- Advertisement -

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 . …

- Advertisement -

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.

- Advertisement -

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

- Advertisement -

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.

- Advertisement -

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.
- Advertisement -

Follow us on Facebook

Latest News

construction analytics
5 Benefits of Analytics to Manage Commercial Construction
Analytics
database compliance guide
Four Strategies For Effective Database Compliance
Data Management
Digital Security From Weaponized AI
Fortifying Enterprise Digital Security Against Hackers Weaponizing AI
Security
DevOps on cloud
Optimizing Cost with DevOps on the Cloud
Cloud Computing Development Exclusive IT

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.

data-driven web design
5 Great Tips for Using Data Analytics for Website UX
Analytics Big Data Chatbots Exclusive
ai in ecommerce
Artificial Intelligence for eCommerce: A Closer Look
Artificial Intelligence Chatbots Exclusive

Quick Link

  • About
  • Contact
  • Privacy
Follow US

© 2008-23 SmartData Collective. All Rights Reserved.

Removed from reading list

Undo
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?