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.

Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.

My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.


Article Tags :
Practice Tags :


Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.