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.
Recommended Posts:
- Difference between Data Warehousing and Data Mining
- Difference between Batch Processing and Real Time Processing System
- Difference between Traditional Processing and Stream Processing
- Difference between OLAP and OLTP in DBMS
- Difference between Secure Socket Layer (SSL) and Secure Electronic Transaction (SET)
- Difference between Opening and Closing in Digital Image Processing
- Difference between Digital Light Processing (DLP) and Liquid Crystal Display (LCD) Projector
- Difference between Image Processing and Computer Vision
- Difference between Data Scientist, Data Engineer, Data Analyst
- Difference between Online marketing and Offline marketing in SEO
- Difference between data type and data structure
- Difference between Data Warehouse and Data Mart
- Difference between a Data Analyst and a Data Scientist
- Difference Between Data Science and Data Engineering
- Difference Between Data Science and Data Mining
- Difference Between Big Data and Data Science
- Difference Between Big Data and Data Mining
- Difference Between Data Mining and Data Visualization
- Difference Between Data Science and Data Analytics
- Difference between Data Lake and Data Warehouse
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.
