Difference between Operational Database System And Data Warehouse


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

Solution Worked 0 UpvotesUpvote


Solution Didn't Worked 0 DownvotesDownvote


Play 2048 Game Online

Search Tags