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.
|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.|