Skip to content
Related Articles

Related Articles

Difference between Data Warehouse and Hadoop

View Discussion
Improve Article
Save Article
  • Difficulty Level : Basic
  • Last Updated : 28 Jul, 2020
View Discussion
Improve Article
Save Article

1. Data Warehouse :
It is a technique for gathering and managing information from different sources to supply significant commercial enterprise insights. A Data warehouse is commonly used to join and analyze commercial enterprise information from heterogeneous sources. It acts as the heart of the BI system which is constructed for data evaluation and reporting.

2. Hadoop :
It is an open-source software program framework for storing information and strolling applications on clusters of commodity hardware. It offers large storage for any sort of data, extensive processing strength, and the potential to deal with actually limitless concurrent duties or jobs.

Difference between Data Warehouse and Hadoop:

S.No.Data WarehouseHadoop
1.In this, we first analyze the data and then further do the processing.It can process various types of data such as Structured data, unstructured data, or raw data.
2.It is convenient for storing a small volume of data.It deals with a large volume of data.
3.It uses schema-for-write logic to process the data.It deals with schema-for-read logic to process the data.
4.It is very less agile as compared to Hadoop.It is more agile as compared to Data Warehouse.
5.It is of fixed configuration.It can be configured or reconfigured, accordingly.
6.It has high security for storing different data.Security is a great concern and It is improving and working on it.
7.It is mainly used by business professionals.It mainly deals with Data Engineering and Data Science.

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!