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.
- 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 firstname.lastname@example.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.