Difference between Data Warehousing and Online transaction processing (OLTP)
Last Updated :
12 Sep, 2022
1. Data Warehousing : Data Warehousing is a technique that gathers or collects data from different sources into a central repository, or, in other words, a single, complete, and consistent store of data that is obtained from different sources. It is a powerful database model that enhances the user ability to analyze huge, multidimensional datasets; allowing the user to make a business decision based on facts, for tracking quick and effective decisions, or providing necessary information. 2. Online-Transaction processing (OLTP) : Online-Transaction Processing is a technique used for detailed day-to-day transactions of data which continuously chain on an everyday-basis. We can describe OLTP as a large number of short, online transactions in which there are detailed and current schematics used to store data into a transaction database like Third Normal Form (3NF). It typically uses a traditional database that includes insertion, deletion, and update while 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. |
Share your thoughts in the comments
Please Login to comment...