Help Center > > FAQs> General FAQs> What Are the Differences Between Data Warehouses and the Hadoop Big Data Platform?

What Are the Differences Between Data Warehouses and the Hadoop Big Data Platform?

Updated at: Nov 14, 2019 GMT+08:00

Generally, the Hadoop big data platform can be regarded as a new-generation data warehousing system. It shares the characteristics of modern data warehouses and is widely used by enterprises. Because of the scalability of MPP, the MPP-based data warehousing system is grouped into the big data platform sometimes.

However, data warehouses greatly differ from the Hadoop platform in terms of functions and user experience in different scenarios. You can determine which one is more appropriate for your specific situation according to the following table.

Table 1 Feature comparison between data warehouses and the Hadoop big data platform

Feature

Hadoop

Data Warehouse

Number of compute nodes

Thousands

256 or less

Data volume

Greater than 10 PB

10 PB or less

Data type

Relational, semi-relational, and unstructured data such as voice, images, and videos

Relational data

Latency

Medium to high

Low

Application ecosystem

Innovative/artificial intelligence

Traditional database/BI

Application development API

Various programming language APIs, such as SQL and MapReduce

Standard database SQL

Scalability

Unlimited scalability with its comprehensive programming APIs

Limited scalability supported by UDF

Transaction support

Limited

Comprehensive

Data warehouses and the Hadoop platform work together to meet customers' service requirements in different scenarios. DWSon the public cloud can seamlessly integrate with Hadoop-based MRS on the public cloud to provide the SQL-over-Hadoop feature, allowing data sharing cross platforms and services. Therefore, you can enjoy not only openness, convenience, and innovation of the Hadoop platform, but also manage and use your massive volumes of data using data warehouses. Additionally, you can use upper-layer applications of conventional data warehouses, especially BI applications.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel