Reference data

For use in finance, see Reference data (financial markets).

Reference data is data used to classify or categorize other data.[1] Typically, they are static or slowly changing over time.

Examples of reference data include:

Reference data sets are sometimes alternatively referred to as a "controlled vocabulary"[2] or "lookup" data.[3]

Reference data differs from master data. While both provide context for business transactions, reference data is concerned with classification and categorisation, while master data is concerned with business entities.[4] 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, while 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.

Externally-defined reference data

For most organisations, most or all reference data is defined and managed within that organisation. Some reference data, however, may be externally defined and managed, for example by standards organizations.[5] An example of externally defined reference data is the set of country codes as defined in ISO 3166-1.[6][7]

Reference data management

Curating and managing reference data is key to ensuring its quality and thus fitness for purpose. All aspects of an organisation, operational and analytical, are greatly dependent on the quality of an organization's reference data. Without consistency across business process or applications, for example, similar things may be described in quite different ways. Reference data gain in value when they are widely re-used and widely referenced.

Examples of good practice in reference data management include:

  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[8]

See also

References

  1. ^ DAMA-DMBOK: Data Management Body of Knowledge (2nd ed.). Data Management Association. 2017. ISBN 978-1634622349.
  2. ^ "Multilingual reference data". EU Open Data Portal. European Commission. Retrieved 2020-06-07.
  3. ^ "Using reference data for lookups in Stream Analytics". Microsoft. Microsoft. Retrieved 2020-06-07.
  4. ^ DAMA-DMBOK: Data Management Body of Knowledge (2nd ed.). Data Management Association. 2017. ISBN 978-1634622349.
  5. ^ Chisholm, Malcolm. "The Foundations of Successful Reference Data Management" (PDF). TopQuadrant. TopQuadrant. Retrieved 2020-06-07.
  6. ^ "IBM Redbooks | Reference Data Management". www.redbooks.ibm.com. 2013-05-16. Retrieved 2015-12-09.
  7. ^ "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.
  8. ^ "5 best practices for managing reference data - LightsOnData". LightsOnData. 2018-07-25. Retrieved 2018-08-17.

Further reading

  • Chisholm, Malcolm (2001). Managing Reference Data in Enterprise Databases. Morgan Kaufmann Publishers. ISBN 1558606971.

Content Disclaimer

Informasi ini disarikan dari Wikipedia dan disajikan kembali untuk tujuan edukasi. Konten tersedia di bawah lisensi CC BY-SA 3.0. Kami tidak bertanggung jawab atas ketidakakuratan data yang bersumber dari kontribusi publik tersebut.

  1. The information displayed on this website is sourced in part or in whole from Wikipedia and has been adapted for the purpose of restating it. We strive to provide accurate and relevant information, however:
  2. There is no guarantee of absolute accuracy. Wikipedia is an open, collaborative project that can be edited by anyone, so information is subject to change.
  3. It is not intended to constitute professional advice. The content displayed is for informational and educational purposes only. For important decisions (e.g., medical, legal, or financial), please consult a professional.
  4. Content copyright. Wikipedia is licensed under the Creative Commons Attribution-ShareAlike License (CC BY-SA). This means that content may be reused with appropriate attribution and shared under a similar license.
  5. Responsible use. Any risk arising from the use of information from this website is entirely the responsibility of the user.