Difference between Data warehouse and Operational database

DatabaseData StorageData Structure

A data warehouse is a repository for structured, filtered data that has already been processed for a specific purpose. Dataware collect the data from multiple sources and transform the data using ETL process then load it to the Data Warehouse for business purpose.

Operational Database are those databases where data changes frequently. They are mainly designed for high volume of data transaction. They are the source database for the data warehouse.It is used for maintaining the online transaction and record integrity in multiple access environments.

Sr. No.KeyData warehouseOperational Database
1
Basic
A data warehouse is a repository for structured, filtered data that has already been processed for a specific purpose
Operational Database are those databases where data changes frequently
2
Data Structure
Data warehouse has denormalized schema
It has normalized schema
3
Performance
It is fast for analysis queries
It is slow for analytics queries
4.
Type of Data
It focuses on historical data
It focuses on current transactional data
5.
Uses Case
It is used for OLAP
It is used for OLTP
raja
Published on 27-Jan-2020 10:54:00
Advertisements