What are the differences between hbase and relational databases in terms of storage methods

The differences between HBase and traditional relational databases are mainly in the following aspects:1. Data types. Relational databases use a relational model with a rich set of data types and storage. hBase uses a simpler data model, it stores data as an uninterpreted string, the user can be different formats of structured data and unstructured data are serialized into a string to save to HBase, the user needs to write their own program to parse the string into different data types. 2. Data manipulation. Relational databases contain a wealth of operations, such as insertion, deletion, update, query, etc., which will involve complex multi-table connection, usually with the help of multiple tables between the primary and foreign key associations to achieve the HBase operation there is no complex table-to-table relationship, only a simple insertion, query, delete, empty, etc., because the HBase in the design of the avoidance of complex table-to-table.

Column storage is different from traditional relational databases in that data is stored in tables on a row-by-row basis. One of the important benefits of the column approach is that the entire database is automatically indexed because the selection rules in a query are defined by columns.

Storing each field's data aggregated by columns can greatly reduce the amount of data read when the query requires only a few fields, and a field's data aggregated, then it's easier to design better compression/decompression algorithms for this aggregated storage.

The difference between traditional (Oracle) row storage and (Hbase) column storage.

Mainly in the following aspects: 1. Data types. Relational databases use a relational model with a rich variety of data types and storage methods. HBase uses a simpler data model, which stores data as an uninterpreted string, the user can be different formats of structured and unstructured data are serialized into a string saved in HBase, the user needs to write their own program to parse the string into different data types. 2. Data manipulation. Relational database contains rich operations, such as insert, delete, update, query, etc., which will involve complex multi-table connection, usually with the help of primary and foreign key associations between multiple tables to achieve the HBase operation there is no complex table-to-table relationship, only a simple insert, query, delete, empty, etc., because HBase in the design of the avoidance of complex relationships between tables, usually only a single-table primary key associations to achieve the HBase operation. Because HBase is designed to avoid complex table-to-table relationships, it usually uses only single-table primary key queries.