Thursday, October 8, 2015

Traditional Databases vs HBase

For the ones working on tradional databases, I have listed down the differences I have found to begin with HBase
Tradional DBs, Oracle, MSSQL, etc
HBase
Structured Data
Semi-structured and unstructured data
Schema on Write
Schema on Read
Fixed Schema
Schema-less
Fixed Columns
Millions of columns can be added dynamically
Suitable for limited volume of data
Billions of rows, millions of columns. Tables can spread across regions on multiple nodes
Primary key based scanning of the whole table or indexing
Row key based scanning
SQL query language used
Basic Hbase shell commands – put, get, scan. Java programming needed to scan data.
Normalized
Denormalized