RDBMS Vs HBase

roshan
8:49:43 AM



RDBMS  Vs HBase gives a clear difference between HBase and RDBMS




          RDBMS
HBase
Data layout
Row oriented
Column Oriented
Transactions
Yes  
Single row only
Query language
SQL
get/put/scan (or use Hive or Impala)
Security
Authentication  / Authorization 
Kerberos
Indexes
Any column  
Row key only
Max data size
TBs
PBs
Read/write throughput
Thousands
Millions
Scalability
Fixed Schema
Flexible schema, add columns on the Fly
Usability                      
     1)    Good for structured data.
      2)      Not optimized for sparse tables.
      1)    Good for semi-structured data as well as structured data.
      2)      Good with sparse tables.

Share and comment
Tags:
Difference in hadoop,  RDBMS vs HBASE,  HBASE, RDBMS,