Hadoop Hbase vs Oracle differences, advantages and disadvantages of 2 databases

HBase as a subproject under Hadoop, the current development is more powerful, and traditional relational database Oracle to compare, both have advantages and disadvantages, we first look at a simple table.

Data maintenance: For example, UPDATE, just insert a new record according to key value, the old version is still in, will be in the process of storefile merge delete data maintenance: Add and remove check change very convenient, direct modification

The above is a simple list of the differences between HBase and Oracle, and there are other details where there is no description, which can be seen from the above, which is completely applied to different scenarios.

In the HBase schema, updates are not supported because the underlying HDFS does not support appending. So in HBase, all the operations are written, write operations are written in Memstore memory, when the threshold is reached, only poor flashcache process to write storefile, each write will form a new storefile, when need to update, delete, According to the key value to insert a new record according to the time stamp, the old version of the record still exists, you can query the old version of the record, when the storefile reached a certain threshold, the system will be merged, the merger process will be the version of the merger and deletion work, to form a larger storefile.

Oracle in the insertion, write operations, the general will also be written to memory, and then by the DBWR process scheduling to write to the data file, if inserted in the use of append append, then the data will not pass the SGA, directly appended to the data file, in the HBase does not have this function.

For HBase and Oracle architectures, please refer to this blog www.savedba.com other articles, not to be explained here.

This article fixed link: http://www.savedba.com/hadoop-hbase-vs-oracle difference, 2 database advantages and disadvantages!/

Reprint Please specify: Copyright, the article is allowed to reprint, but must be linked to the source address, or to investigate legal responsibility!