1. HBase :
This model is used to provide random access to large amount of structured data. It build on the top of the hadoop file system and column-oriented in nature. It used to store the data in HDFS. It is open source database that provide the data replication. Three important components of HBase are HMaster, Region server, Zookeeper.
2. PostgreSQL :
PostgreSQL is a powerful, open-source Object-relational database system. It provides good performance with low maintenance efforts because of its high stability. PostgreSQL was the first DBMS that implemented multi-version concurrency control (MVCC) feature.
Difference between PostgreSQL and HBase :
|1.||HBase is written in JAVA.||PostgreSQL is written in C languages.|
|2.||It does not supports SQL query language.||It supports SQL query language.|
|3.||It does not support XML Format.||It supports XML Format.|
|4.||It has no Secondary database models.||It has Document store as Secondary database models.|
|5.||It supports in-memory capabilities.||It does not supports in-memory capabilities.|
|6.||HBase uses a selectable replication factor.||It doesn’t use selectable replication factor.|
|7.||HBase is less complex than PostgreSQL.||It is more complex than HBase.|
|8.||HBase has triggers.||PostgreSQL doesn’t have triggers.|
|9.||HBase is based on Bigtable.||PostgreSQL is based on RDBMS.|
|10.||HBase provide more consistency.||It provide less consistency.|
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.