Difference Between RDBMS and HBase



Both RDBMS and HBase, both are database management systems. RDBMS uses tables to represent data and their relationships. HBase is a column-oriented dbms and it works on top of Hadoop Distributed File System (HDFS).

Following are the important differences between RDBMS and HBase.

Sr. No. Key RDBMS HBase
1 Definition RDBMS stands for Relational DataBase Management System. HBase has no full form.
2 SQL RDBMS requires SQL, Structured Query Language. HBase does not need SQL.
3 Schema RDBMS has a fixed schema. HBase has no fixed schema.
4 Orientation RDBMS is row oriented. HBase is column oriented.
5 Scalablity RDBMS faces problems in scalablity. HBase is highly scalable.
6 Nature DBMS is static in nature. HBase is dynamic in nature.
7 Data Retrieval RDBMS data retrieval is slow. HBase data retrieval is fast.
8 RULE RDBMS follws ACID(Atomicity, Consistency, Isolation and Durability) Rule. HBase follows CAP(Consistency, Availability, Partition-tolerance) Rule.
9 Data structure RDBMS handles structural data. HBase handles structural, non-structural and semi-structural data.
10 Sparse Data Handling Sparse data handling is not present. Sparse data handling is present.
Updated on: 2019-11-27T07:20:14+05:30

4K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements