Syntax error Difference between RDBMS and HBase

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

5K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements