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.
