Saturday, September 21, 2019

MDM (Master Data Management) is not DWH

Both MDM and DWH have the same concept (Getting the data form different sources and store it in a separate Database) but purpose of both are different As DWH is to make it easier to perform analytics & BI  on historical data from transnational system as well as MDM system whereas MDM :

MDM:

It is to defining a process of collecting the data from various sources and applying the standard rules and business processes to building a single view of data and finally distributing the golden version of data to various system. MDM is created for data auditing purpose.

Simply can say, MDM reconcile the data from various systems to create a single view of master data for auditing.

How MDM works

MDM creates a new version of data every time changes is made (in the source system) along with information about who is making the changes. You can track it back & look for delta between various version, when it was made & who did it. By having this level of auditing history, you organization is helpful to achieve complete regularly compliance and also to provide enterprise information management program.

MDM store data about entities like
  • People (Customer, Vendors, Employees, Patients)  
  • Things (Product, Business Unit, Parts, Equipment)
  • Place (Location, Stores, GEO Area)
Simple MDM Example:

Let suppose an organization (ABC) have 4 business unit (A Company / A Hospital / A School / Retails store) and A people (M) is an employee of that company, a patient of that Hospital , a teacher in that school and a customer of that Retail store but company ABC don't know about M where this people is part of our Business Unit. So in that case ABC can have a MDM to capture all the details and actions done by M for tracking and audit purpose.

No comments:

Post a Comment