Reference data

From Wikipedia, the free encyclopedia
Jump to navigation Jump to search

Reference data are data that define the set of permissible values to be used by other data fields. Reference data gain in value when they are widely re-used and widely referenced. Typically, they do not change overly much in terms of definition, apart from occasional revisions. Reference data are often defined by standards organizations, such as country codes as defined in ISO 3166-1.[1][2]

Examples of reference data include:

Reference data management[edit]

As any other data, if it is not managed, it can lead to poor quality data. Here are some best practices to follow:

  1. Formalize the reference data management
  2. Use external reference data as much as possible
  3. Govern the reference data specific to your enterprise
  4. Manage reference data at enterprise level
  5. Version control your reference data[3]

Differences with master data[edit]

Reference data should be distinguished from master data, which represent key business entities such as customers and materials in all their necessary detail (e.g., for customers: number, name, address, and date of account creation). In contrast, reference data usually consist only of a list of permissible values and attached textual descriptions. A further difference between reference data and master data is that a change to the reference data values may require an associated change in business process to support the change; a change in master data will always be managed as part of existing business processes. For example, adding a new customer or sales product is part of the standard business process. However, adding a new product classification (e.g. restricted sales item) or a new customer type (e.g. gold level customer) will result in a modification to the business processes to manage those items.

References[edit]

  1. ^ "IBM Redbooks | Reference Data Management". www.redbooks.ibm.com. 2013-05-16. Retrieved 2015-12-09.
  2. ^ "Reference Data Management and Master Data: Are they Related ? (Oracle Master Data Management)". blogs.oracle.com. Archived from the original on 2015-10-11. Retrieved 2015-12-09.
  3. ^ "5 best practices for managing reference data - LightsOnData". LightsOnData. 2018-07-25. Retrieved 2018-08-17.

Further reading[edit]

  • Chisholm, Malcolm (2001). Managing Reference Data in Enterprise Databases. Morgan Kaufmann Publishers. ISBN 1558606971.
  • Whei-Jen, Chen (2014). Master Data Management for SaaS Applications. IBM Redbooks. ISBN 978-0738440040.
  • Berson, Alex (2011). Master Data Management and Data Governance. McGraw-Hill Osborne Media. ISBN 978-0071744584.

See also[edit]

External links[edit]