top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What’s the difference between master data and reference data?

+1 vote
487 views
What’s the difference between master data and reference data?
posted Aug 23, 2016 by Mohammed Hussain

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote

Master data is defined as data about the key business entities of an organization. Examples include customer, product, organizational structure, and chart of accounts.

Reference data is data that defines the set of permissible values to be used by other data fields. Reference data gains in value when it is widely re-used and widely referenced. Typically, it does not change overly much in terms of definition (apart from occasional revisions). Reference data often is defined by standards organizations.

A common question about master data is what is the difference between master data and reference data?
Some people take the position that they are the same thing, but it can be argued that not all reference data is master data. For example, lookup and code tables that are used to encode information, such as state names and order codes, are not strictly master data tables.

The diving line between master data and reference data is not always clear cut. One solution is to break master data into two types: master reference data and master business entity data. Master reference data has well defined and simple data structures, has simple keys and governance rules, is often standardized (US state codes, for example), involves only a few applications, and is reasonably stable. Master business entity data, such as customer, on the other hand, is usually ill-defined, has complex data structures and relationships, requires compound and intelligent keys and complex governance rules, is not usually standardized, involves many business processes, and changes frequently.

Ref: http://www.b-eye-network.com/blogs/white/archives/2007/11/master_data_ver.php

answer Aug 24, 2016 by Salil Agrawal
...