An operational system is a term used in data warehousing to refer to a system that is used to process the day-to-day transactions of an organization.
Data Warehouse is a Relational Database that maintains huge volume of historical data so as to simplify the process of analysis and decision making.
Now, let's see the difference between Operational Database System (OLTP) And Data Warehouse (OLAP).
|Operational Database System (OLTP)||Data Warehouses (OLAP)|
|Day to Day Operations||Strong Analysis and Decision Making|
|Normalized System||De-Normalized System|
|More Tables||Less Tables|
|More Joins||Less Joins|
|Many Updates||Less Updates|
|Users are Data-entry Operators||Users are Analyst, Managers, executes, etc|
|More Users||Less Users|
|It maintains Transaction Level Data||It maintains Transaction Level and Aggregration Level Data|
|Usually Depicted using ER Modelling||Usually Depicted using Dimensional Modelling|
|Maintains Recent Data||Maintains Historical Data|