Difference between Operational Database System And Data Warehouse

[3952 views]




What is Operational System?

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.

What is Data Warehouse?

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).

Difference between Operational System And Data Warehouse
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
                 

Updated on 25 FEBRUARY, 2021 by Shaddy




AI Search Engine:



Comments










Search Anything:

Sponsored Deals ends in


E-Books & Study Notes:






Technical Quizzes Specially For You:



Online Free Tools:
Search Tags
You Might Also Like