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
    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 and remote work
    Data Helps Speech-Language Pathologists Deliver Better Results
    6 Min Read
    data driven insights
    How Data-Driven Insights Are Addressing Gaps in Patient Communication and Equity
    8 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

Clinical Reporting with R
“For years, Western governments have used supercomputers to model weapons of nuclear war.Now a…”
The Fascinating Role of AI in the Evolution of Computer-Aided Designs
Analysts Don’t Get No Respect – SDC Blogarama topic for November 14
Data Lakes and Network Optimization: What’s Next for Telecommunications and Big Data

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 supply chain
AI Tools Are Strengthening Global Supply Chains
Artificial Intelligence Exclusive
data analytics and truck accident claims
How Data Analytics Reduces Truck Accidents and Speeds Up Claims
Analytics Big Data Exclusive
predictive analytics for interior designers
Interior Designers Boost Profits with Predictive Analytics
Analytics Exclusive Predictive Analytics
big data and cybercrime
Stopping Lateral Movement in a Data-Heavy, Edge-First World
Big Data Exclusive

Stay Connected

1.2kFollowersLike
33.7kFollowersFollow
222FollowersPin

You Might also Like

cloud computing
Business IntelligenceCloud ComputingComputingIT

Why your Cloud Strategy Should Include Multiple Vendors

7 Min Read
Image
Big DataData QualityData VisualizationData Warehousing

Demystifying Data Warehouses, Data Lakes and Data Marts

11 Min Read

Greening the Workplace 1.0: Going Paperless

7 Min Read

Business Intelligence, a Maturing Industry?

5 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
Big Data
AI chatbots
AI Chatbots Can Help Retailers Convert Live Broadcast Viewers into Sales!
Chatbots

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?