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.|