Golden records management system3/6/2023 ![]() Single Source of Truth can also be a Data Architecture and Modelling constraint in which every data element is stored exactly once across the organisation. System of Reference is supposed to be = Source of Truth and is supposed to be = the Single Source of Truth. System of Record = Source System of Record = System of Origin = System of Entry. But the dilemma is that you may also hear/read terms like source system of record, source of record, source of truth, single source of truth, system of origin, and others I am yet to hear/read! Ideally, we should end this article here. Hence, a system of reference for an entity should be a collection of golden records. But this is not consistent with other articles and the Data Management Body of Knowledge which is my system of reference for Master Data (if Medium had emojis I sure would have inserted one here).Ī golden record is a single record that provides correct and complete data about an instance of the entity. But this sentence makes me a bit confused about what a golden record is: is it a collection of records or a single record? From further explanation in the article, a golden record is portrayed as a system, and if that is correct, then golden record = system of reference. With respect to ‘single well-defined version’, it is clear and I agree as well. According to whatis(tech target), a golden record is (at least supposed to be) the “single, well-defined version of all the data entities in an organizational ecosystem….The golden record encompasses all the data in every system of record within a particular organization”. This best version is another name for Golden Record. For our customer data example, we may define the finance-team system as the system of reference because it contains the most accurate and current data about customers or we may create a new system which contains the best version of the customer data from the finance and sales teams systems. Hence, the sales-team system is the system of record.Ī system of reference for an entity is the authoritative system that is expected to contain correct, complete and current data about an entity which can be used for transactional, operational or analytical purposes.Ī system can be designated as the system of reference based on certain considerations or efforts that confirm the reliability of the data. However, the sales-team system may be the originating source of customer data from which customer data is passed to other systems where the data may be replicated, further processed/enriched, etc. The finance department may have its own system for billing customers which is not only based on sales but other offerings & subscriptions. We classify them into two: System(s) of Record, and System(s) of Reference.Ī system of record for an entity is the authoritative system where data about the entity is created/captured and maintained.Į.g: The sales team might have a system that facilitates its operations and this system will most likely process and store customer and product data. In an organisation, various information systems exist that generate, process and/or store data about various entities (referring to Master Data), operations and transactions. If you’re asking what all that means, let’s get to the details. To do this, Master Data values from various ‘ Systems of Record’ are resolved into a ‘ System of Reference’ which is supposed to be a ‘ Trusted Source’ that provides users with ‘ Golden Records’. This is what ‘we’ mean when it is said that the organisation is developing a single 360° view of an entity ee.g: the customer. In Master Data Management, the aim is to control Master Data identifiers and values and ensure availability and access to accurate and current values across various systems or domains. For more on Data Taxonomy, you can check Malcolm Chisholm’s article. ![]() Hence, data about the customer and product - which will most likely be reused in other transactions are part of the company Master Data. E.g: If product B was sold to customer C on Feb 2, 2019, via the e-commerce channel, the ‘things’ participating in that transaction are the customer and the product. It is data about the nouns of an organisation. ![]() Master Data is a category of data that provides context for transactions and events. If you are reading this, you probably know what Master Data is. So, let’s hope that this article is your article of reference for the terms explained in it! But it gets worst when the articles are too high-level or high-sounding and you need to have five tabs open in order to understand one term. It gets worse when words are not used intuitively in naming these concepts! Well, if this dilemma did not exist, there would not be any need for the many articles that define and differentiate concepts. It can get frustrating when trying to understand the subtle differences between various IT concepts. based on Data Taxonomy by Malcolm Chisholm
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |