What is system of record (SOR)? - Definition from WhatIs.com

Definition

system of record (SOR)

Part of the Database glossary:

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.

This was last updated in March 2013
Contributor(s): Stan Gibilisco
Posted by: Margaret Rouse

Related Terms

Definitions

  • data set

    - A data set is a collection of data that contains individual data units organized (formatted) in a specific way and accessed by one or more specific access methods based on the data set organization... (WhatIs.com)

  • Oracle RMAN (Oracle Recovery Manager)

    - Oracle Recovery Manager performs backup and recovery of database files. Among RMAN's many features, this utility -- which is built into Oracle databases -- automates administration of backup strate... (SearchDataBackup.com)

  • machine learning

    - Machine learning is a type of artificial intelligence (AI) that provides computers with the ability to learn without being explicitly programmed. This area of AI focuses on the development of compu... (WhatIs.com)

Glossaries

  • Database

    - Terms related to databases, including definitions about relational databases and words and phrases about database management.

  • Internet applications

    - This WhatIs.com glossary contains terms related to Internet applications, including definitions about Software as a Service (SaaS) delivery models and words and phrases about web sites, e-commerce ...

Ask a Question About system of record (SOR)Powered by ITKnowledgeExchange.com

Get answers from your peers on your most technical challenges

Tech TalkComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.