Sunday, December 15, 2019

Difference between RDBMS and HBase

Here is the article.

I like to read the following content, and then get an idea to search for better content. I like to find out why Facebook messenger system design from grokking system design argues that HBase should be used instead of relational database for messages.


HBase –
HBase is a column-oriented database management system that runs on top of Hadoop Distributed File System (HDFS). It is well suited for sparse data sets, which are common in many big data use cases. It is an opensource, distributed database developed by Apache software foundations. Initially, it was named Google Big Table, afterwards it was re-named as HBase and is primarily written in Java. It can store massive amount of data from terabytes to petabytes. It is built for low-latency operations and is used extensively for read and write operations. It stores large amount of data in the form of tables.
Difference between RDBMS and HBase:
RDBMSHBASE
It requires SQL (structured query language)NO SQL
It has a fixed schemaNo fixed schema
It is row orientedIt is column oriented
It is not scalableIt is scalable
It is static in natureDynamic in nature
Slower retrieval of dataFaster retrieval of data
It follows the ACID (Atomicity, Consistency, Isolation and Durability) property.It follows CAP (Consistency, Availability,Partition-tolerance) theorem.
It can handle structured dataIt can handle structured, unstructured as well as semi-structured data
It cannot handle sparse dataIt can handle sparse data


No comments:

Post a Comment