?
Solved

system of record vs operational database

Posted on 2014-12-04
8
Medium Priority
?
356 Views
Last Modified: 2015-01-09
Just wanted to confirm with the experts here.

If I understand correctly system of records(SORS) is where the data element first appears and is stored.  Operational database or OLTP is where data you manage dynamic data in real time where insert, delete , update can be done in real time.
 
Now my question is , isn't System of Record and OLTP basically the same? I am bit confused with SORs which is where data first appears but then OLTP system also houses data whenever any inserts, updates, deletes are perfomed.
0
Comment
Question by:techEverest
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
8 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40482020
In my environment the System of Record is the origination point for the data.  It may or may not be an OLTP system.

Maybe the data into my organization is a huge batch feed from another system.  Really not OLTP but still new data.

It is almost always 'Operational' in that some app submitted some data to some database for the first time.

Where OLTP and SORS aren't the same:  Can your SORS not send data to another system  where it is further processed but has no additional data added to the original record?  It can add additional data as it is processed as meta data but not modify the original.
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 40483053
SOR is simply whatever database is the final authority for data.  Where it originated isn't usually a factor.

That might be an OLTP system, it might be a data warehouse, it might be a set of flat files.
0
 

Author Comment

by:techEverest
ID: 40522332
Thanks for your quick response.I was away so could not get back to this site soon enough. I am not still clear . The SORs are referenced by another system through ETL process and called authoritative source which is the data source that analytical tools such as Cognos, Business objects reporting tools use it to develop reports. For example a point of sale(POS) application at supermarkets, arent they the original source of data thus a SOR as well as the new data inserts every few seconds or minutes are OLTP?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 74

Expert Comment

by:sdstuber
ID: 40522763
original source and system of record are not the same thing.

so in your example - NO, the POS application is NOT a system of record.


the SOR is the FINAL system, not the first system.
0
 

Author Comment

by:techEverest
ID: 40537049
I cant still understand clearly the SOR. I do understand OLTP system where CRUD operations can be performed. Can you please provide and example for example with scenario such as POS at a store and the backend system where data is stored , the datawarehouse that is populated from OLTP system. At what point and where can we call a system SOR?

Thanks,
0
 
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 1000 total points
ID: 40537093
In a nutshell an SOR is what your organization defines it as.  For me I tend to think of them as the first 'permanent' home for a piece of data.  When I mentioned 'origination point for the data' I sort of misspoke.  I sort of meant 'original permanent source'.

To me a POS system captures data real-time and eventually feeds it into a centralized system and once 'confirmed', it is removed from the POS system.  To me that centralized system should the to SOR since it is the first 'permanent' location.

Then the data can be further dispersed to ancillary systems for whatever purposes like marketing, sales, etc...  (your data warehouse).  These ancillary systems are working only on a 'copy' of the data and not the source.

Start with:
http://en.wikipedia.org/wiki/System_of_record
0
 
LVL 74

Accepted Solution

by:
sdstuber earned 1000 total points
ID: 40537846
POS example:

POS collects sales info: items, quantity, price, time, method of payment, discounts applied, etc.

POS is NOT the SOR.

Each day at midnight, POS data is transferred to the "Sales History" database which maintains all of the above information for all sales, for all stores for all time (or as far back as legally required.)

"Sales History" IS the SOR.


Each month, ETL process pulls data from Sales History and loads to Data Warehouse with aggregates of items, stores, discounts etc.  Reporting tables/materialized views are populated with data.  Data cubes are constructed for analysis of sales trends,  event/price/discount impacts and inter-item purchase correlations.

Warehouse is NOT the SOR (mostly)

I add the "mostly" part because some data analysis may be too complicated to run on the SOR directly, thus necessitating the warehouse.  In these cases, the specific results of a Warehouse run may implicitly become the SOR.
0
 

Author Closing Comment

by:techEverest
ID: 40540341
Thanks, these examples helped me understand it well.
0

Featured Post

Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question