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

Next Generation Warranty Systemsv
As Data.gov Goes Dark, 50 Startups Prepare to Take its Place
Defending Your Analytics: Handling Hecklers
Here’s what different in next generation warranty systems
On-Demand Index: YTD is in the green (and it’s not St Patty’s Day)

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

AI technology and ecommerce
Artificial Intelligence

AI Technology Helps eCommerce Brands Optimize for Mobile

5 Min Read
networking technologies
Artificial Intelligence

5 Powerful Networking Technologies That Are Disrupted By AI

5 Min Read

TDWI in San Diego

4 Min Read

How The Museum of Modern Art is Online

3 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 in ecommerce
Artificial Intelligence for eCommerce: A Closer Look
Artificial Intelligence
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?