Master and Reference Data Flashcards
Two types of master data platforms
- single domain
- mutli domain master data tool
Single domain master data platform
focussed towards one area, comes with a power data model with lots of functionality associated to specific tasks/ systems.
Multi domain master data platform
informed by your data model, configure the tool base on your needs. Not the cutting edge, more general.
What is event / transaction data?
Large volume data that identifies a transaction that took place. Data that describes/measures a verb. Identifies the nouns that were involved in the event e.g., person, item, location, date
What are the four types of data?
metadata
reference data
master data
transaction data
What is master and reference data?
defines and describes the nouns (things) of the business - contextual information about events transactions.
WHat is master data management?
the ongoing reconciliation and maintenance of master data
Rate of change of reference vs master data
reference - low
master - frequent
Number of values of reference vs master data
reference - low and fixed
Master - medium/high and variable
Source of reference vs master data
reference - external
master - internal
(mostly)
Ownership of reference vs master data
reference - none
master - split between the business (federated out)
Ease of governance of reference vs master data
reference - easy
master - harder (higher numbers of stakeholders)
Tool complexity/ cost of reference vs master data
reference - low
master - high
Business Drivers of master data management (MDM)
- consistency & confidence of data (organisation data requirements)
- Managing data quality
- managing the cost of data integration (integrating new data sources)
- reducing risk
Managing data quality is an…
ongoing exercise
MDM standard architecture types
- Repository
- Registry
- hybrid
- virtualised
Immutable minimum (identifiera)
the minimum fields which HAVE to be populated in a DB
Core fields
the fields that are used the most for important business processes
Repository archtechture
All the fields in the central hub
Hybrid archtiechture
Core fields in the central hub
Registry architechture
identifiers (immutable minimum) in the central hub
Virtualised architechture
none of the fields are stored in the central hub
System of origin
a contributing system, one that GIVES data to the MDM
Subscriber
A consuming system, one that TAKES data from the MDM
Golden Records
The best attempt at storing a record from all the contributing systems
System of Record
The system that stores the golden records/ master data (after being processed by the MDM).