1. MySQL :
MySQL is an open-source relational database management system based on Structured Query Language (SQL). It is developed and managed by oracle corporation and initially released on 23 may, 1995. It is widely being used in many small and large scale industrial applications and capable of handling a large volume of data.
2. HBase :
This model is used to provide random access to a 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 provides the data replication. Three important components of HBase are HMaster, Region server, Zookeeper.
Difference between MySQL and HBase :
|MySQL manages Structured data.||HBase manages Structured data, Unstructured data.|
|It requires structured query language.||It doesn’t require structured query language.|
|The operating systems supported by MySQL are Windows, macOs, Linux, Unix, AmigaOS, BSD, z/OS and Android.||The operating systems supported by HBase are Windows, macOs, Linux, Unix, BSD and z/OS.|
|It follows the ACID property.||It doesn’t follow the ACID property.|
|Replication methods used here are Master-Master Replication and Master-Slave Replication.||Replication method used here is Master-Slave Replication.|
|It is implemented in C/C++ programming Languages.||It is implemented in Java programming language.|
|It handles data in less volume.||It handles data in high volume.|
|The secondary database model supported is Document Store.||No secondary database model is used.|
|APIs and other access methods used by MySQL are ADO.NET, JDBC and ODBC.||APIs and other access methods used by HBase is JDBC.|
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.