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

Source: Internet
Author: User
Keywords Difference write insert merge

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!

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.