Difference between Data Warehousing and Online transaction processing (OLTP)

1. Data Warehousing :
It is technique that gathers or collect data from different sources into central repository or simply we can say that it is a single complete and consistent store of data that obtained from different sources. It is a powerful database model that enhances user ability to analyze huge multidimensional data sets to allow user to make a business decision based on facts and for tracking quick and effective decisions or providing necessary information.

2. Online-Transaction processing (OLTP) :
It is technique that is used for detailed day to day transaction data which keep chaining on an everyday basis. It is a large number of short online transaction. In which there is detailed and current data or schema used to store transaction database like (3NF).It uses a traditional database that includes insertion, deletion, update and also supporting query requirements.

Difference between Data Warehousing and Online-Transaction processing (OLTP) :

Data Warehousing DWH	Online transaction
It is technique that gathers or collect data from different sources into central repository.	It is technique that is used for detailed day to day transaction data which keep chaining on everyday.
It is designed for decision making process.	It is designed for business transaction process.
It stores large amount of data or historical data.	It holds current data.
It used for analyzing the business.	It used for running the business.
In Data warehousing, the size of database is around 100GB-2TB .	In Online transaction processing, the size of data base is around 10MB-100GB.
In Data warehousing, denormalized data is present.	In Online transaction processing, normalized data is present.
It uses Query processing.	It uses transaction processing
It is subject-oriented.	It is application-oriented.
In Data warehousing, data redundancy is present.	In Online transaction processing, there is no data redundancy.

My Personal Notes arrow_drop_up

Save