Choose Index below for a list of all words and phrases defined in this glossary.

System of Record

index | Index

System of Record - definition(s)

System of record - See Record of reference. The term system of record is meaningless when defining the authoritative record in an integrated, shared data environment where data may be updated by many different application systems within a single database.

[Category=Data Quality ]

Source: Larry English, External , 11-Feb-2009 14:15

These advertisers support this free service

system of record (SOR) - A system of record (SOR) is an ISRS (information storage and retrieval system) that is the authoritative source for a particular data element in a system containing multiple sources of the same element. To ensure data integrity, there must be one and only one system of record for a given piece of information.

When data exists on multiple computers as a result of editing or data processing, subtle differences often arise. Discrepancies can occur because of bugs, file format conversion idiosyncrasies, multiple edits by humans, or time frame changes such as calendar updates. For information that doesn't change, such as historical data, SOR provides a traceable source of the original data. For information subject to change, such as a bank account balance, the SOR provides the most current information.

According to data warehousing expert Bill Inmon, every system of record shares the following characteristics: it provides the most complete, most accurate and most timely data, it has the best structural conformance to the data model, it is nearest to the point of operational entry and it can be used to feed other systems.

[Category=Data Management ]

Source:, 11 September 2013 09:24:26, External  



Data Quality Glossary.  A free resource from GRC Data Intelligence. For comments, questions or feedback: