Cookies help us display personalized product recommendations and ensure you have great shopping experience.

By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    big data analytics in transporation
    Turning Data Into Decisions: How Analytics Improves Transportation Strategy
    3 Min Read
    sales and data analytics
    How Data Analytics Improves Lead Management and Sales Results
    9 Min Read
    data analytics and truck accident claims
    How Data Analytics Reduces Truck Accidents and Speeds Up Claims
    7 Min Read
    predictive analytics for interior designers
    Interior Designers Boost Profits with Predictive Analytics
    8 Min Read
    image fx (67)
    Improving LinkedIn Ad Strategies with Data Analytics
    9 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: Master Data Management (MDM) – Going Where the Enterprise Data Warehouse has Gone Before
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Big Data > Data Warehousing > Master Data Management (MDM) – Going Where the Enterprise Data Warehouse has Gone Before
Business IntelligenceData Warehousing

Master Data Management (MDM) – Going Where the Enterprise Data Warehouse has Gone Before

RickSherman
RickSherman
3 Min Read
SHARE

Word_MDM There is a lot of industry buzz on Master Data Management (MDM). It would appear from this chatter that MDM is a new thing. But if you look under the covers, you’ll see some aspects of MDM that look mighty familiar.

Word_MDM There is a lot of industry buzz on Master Data Management (MDM). It would appear from this chatter that MDM is a new thing. But if you look under the covers, you’ll see some aspects of MDM that look mighty familiar.

The reality is that for many years, whether people realized it or not, the Enterprise Data Warehouse (EDW) has served as the default MDM repository. This happened because the EDW has to reconcile and produce a master list of data for every data subject area that the business needs for performing enterprise analytics. Most of my customers referred to this as reference data management years before the term MDM was coined.

More Read

Image
Why This Cloud ERP Provider Is Getting Interested in eCommerce
AI-Based Staff Scheduling Tools Give Businesses Regional Scalability
Apple, DRM & Content Protection
Data Lakes and Network Optimization: What’s Next for Telecommunications and Big Data
Optimal Technologies International Inc. – SMARTGRID Our Optimal…

These subject areas generally include customers, products, suppliers and employees along with variations based on industry. Each subject typically has hierarchical relationships within it (such as products, marketing, and sales territories) that need to be managed.  Again, all this is done to support enterprise analytics.

Naturally, the data for each master data category has to be consistent. In data management terms the process to achieve a master list for each subject is referred to as conforming dimensions. This means as you gather master data from disparate enterprise applications the data-integration process must create one consistent list for reference data such as products, customers and suppliers. This process usually requires creating a surrogate unique key for each master data row and involves de-duping lists. This master list enables enterprise business intelligence and analysis.

The fact that EDWs have served as default MDM solutions means there’s a history there – a history you can learn from. Before you go out and buy an MDM solution it’s important to be sure about what you need to buy.

The history of having the EDW serve as the default MDM solution shows that it has encountered two barriers to success:

  • Too many “master” lists or multiple “single versions of the truth”
  • The assumption that technology would be a silver bullet

See my post next week for an explanation of these two barriers faced by enterprise data warehouses serving as default MDM solutions, and a wrap-up of my thoughts on the subject.

Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

ai for building crypto banks
Building Your Own Crypto Bank with AI
Blockchain Exclusive
julia taubitz vn5s g5spky unsplash
Benefits of AI in Nursing Education Amid Medicaid Cuts
Artificial Intelligence Exclusive News
AI role in medical industry
The Role Of AI In Transforming Medical Manufacturing
Artificial Intelligence Exclusive
b2b sales
Unseen Barriers: Identifying Bottlenecks In B2B Sales
Business Rules Exclusive Infographic

Stay Connected

1.2kFollowersLike
33.7kFollowersFollow
222FollowersPin

You Might also Like

The Netflix Prize: Customer Intelligence for Hire

5 Min Read
ai in designing websites for multilingual users
Artificial Intelligence

Using AI to Build a Successful Multilingual Website in 4 Steps

7 Min Read

The State of Play in Automating Insurance Claims

4 Min Read

Starting Your Business: Data From the Ground Up

4 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 chatbot
The Art of Conversation: Enhancing Chatbots with Advanced AI Prompts
Chatbots
giveaway chatbots
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive

Quick Link

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

Sign in to your account

Username or Email Address
Password

Lost your password?