Master data explained

Master data represents "data about the business entities that provide context for business transactions".[1] The most commonly found categories of master data are parties (individuals and organisations, and their roles, such as customers, suppliers, employees), products, financial structures (such as ledgers and cost centres) and locational concepts.[2]

Master data should be distinguished from reference data. While both provide context for business transactions, reference data is concerned with classification and categorisation, while master data is concerned with business entities.

Master data is, by its nature, almost always non-transactional in nature. There exist edge cases where an organization may need to treat certain transactional processes and operations as "master data". This arises, for example, where information about master data entities, such as customers or products, is only contained within transactional data such as orders and receipts and is not housed separately.[3]

Alternative definition

An alternative definition of the term master data is that it represents the business objects that contain the most valuable, agreed upon information shared across an organization.[4] In this sense, it gives context to business activities and transactions, answering questions like who, what, when and how as well as expanding the ability to make sense of these activities through categorizations, groupings and hierarchies. It can cover relatively static reference data, transactional, unstructured, analytical, hierarchical and metadata.[5] What constitutes master data under this definition is therefore not about an essential quality of the data (e.g. it is a business entity that provides context for business transactions), but rather about the context in which the organisation has decided to treat the data.

Externally-defined master data

For most organisations, most or all master data is defined and managed within that organisation.

Some master data, however, may be externally defined and managed. This represents the single source of basic business data used across a marketplace, regardless of organisation or location. Thus, it can be used by multiple enterprises within a value chain, facilitating "integration of multiple data sources and literally [putting] everyone in the market on the same page."[6] An example of market master data is the Universal Product Code (UPC) found on consumer products.

Master data management

See main article: Master data management. Curating and managing master 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 master data. Master Data is therefore the focus of the information technology (IT) discipline of master data management (MDM). Without this discipline in place, organisations commonly encounter difficulties with having multiple versions of "the truth" about a business entity, both within individual applications, and distributed across applications.

Further reading

See also

Notes and References

  1. Book: DAMA-DMBOK: Data Management Body of Knowledge. Data Management Association. 2017. 978-1634622349.
  2. Web site: Gartner Glossary: Master Data Management. 6 June 2020.
  3. Book: van der Lans, R.. Data Virtualization for Business Intelligence Systems: Revolutionizing Data Integration for Data Warehouses. Elsevier. 2012. 9780123978172. 119–121.
  4. Book: https://books.google.com/books?id=7AHxq-INaeIC&pg=PT37 . Chapter 1: Introducing Master Data Management . Enterprise Master Data Management: An SOA Approach to Managing Core Information . Dreibelbis, A. . Hechler, E. . Milman, I. . etal. Pearson Education . 1–3 . 2008 . 9780132704274.
  5. Web site: The What, Why, and How of Master Data Management . https://web.archive.org/web/20170714193734/http://msdn.microsoft.com/en-us/library/bb190163.aspx . Wolter, R. . Haselden, K. . Microsoft Corporation . November 2006 . 14 July 2017 . 13 December 2017.
  6. Web site: Taylor, S.. Laylin, R.. 2010. Master Data Management for Media. 27 July 2018. SlideShare. Microsoft Corporation.