Hadoop Hbase vs Oracle differences, advantages and disadvantages of 2 databases
Source: Internet
Author: User
KeywordsDifference 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!
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.