Shulou(Shulou.com)06/02 Report--

This article mainly explains the "Redis, relational database, HBase, Hive what is the difference", the content of the article is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "what is the difference between Redis, relational database, HBase, Hive"!

What is the difference between Redis, relational database, HBase, and Hive? In interviews with big data related industries, programmers are often asked: do you know the difference between Redis, traditional database, HBase and Hive? This question examines the understanding and application of different data storage technologies, and the concepts and characteristics need to be answered. At the same time, it can be extended to the business scenario to examine how the interviewees distinguish and cooperate with different services in the project. Let's first take a look at the concept and definition.

Redis concept: distributed cache, memory-based, emphasis on caching, support for data persistence, support for transaction operations, Key/vale database of NoSQL type, and support for more rich types such as List, Set, etc.

HBase concept: HBase is a database system based on HDFS, which provides highly reliable column storage and real-time read and write. It is between Nosql and relational database, retrieves data only through primary key and primary key range, and supports only single-row transactions. It is mainly used to store unstructured and semi-structured loose data.

Relational database concept: there are mysql, Oracle, SqlServer, etc., supporting transactional operations, belonging to write mode, that is, checking when writing data. It is aimed at the daily operation of specific business online in the database, and usually queries and modifies a small number of records. Support perfect sql function, can carry on the statistical analysis to a small amount of data.

Hive concept: Hive is a Hadoop-based data warehouse tool that maps structured data files to database tables. And provide a simple sql function, you can convert sql into mr tasks to run. Because of the low cost of sql learning, it is not necessary to develop mr applications, so it is very suitable for statistical analysis of data warehouse.

Differences between Redis, Relational Database, HBase, and Hive:

There are two main categories here: relational data and Hive are databases that support SQL engine; Redis and Hbase are Key/vale databases of NoSQL type, which support simple row and row operations, but do not support SQL engine.

In SQL database, relational database pays more attention to transactional operation and belongs to write mode, which supports small amount of data and low index latency, while Hive focuses more on query and analysis operation, belongs to read mode, does not support high index delay and supports large amount of data, so it is designed for data warehouse.

In K Set V database, the read and write performance of Redis is higher, usually tens of microseconds, while Hbase is a few milliseconds; Redis not only supports K hand V operation, but also supports more abundant types such as List, Set, etc. Redis has a small amount of data because it is stored in memory, while the storage of Hbase far exceeds the size of memory. HBase is suitable for big data's persistent storage, while Redis is more suitable for caching.

There are many similar storage services, in addition to es and solr and so on. We need to first answer the concepts of the two storage services, and then answer the differences between the two according to the differences in core functions and features.

Combined with the use in the project, which technology is used in which scenario. Traditional database is used for transaction processing of real-time business, Redis is used for real-time cache with high performance requirements, Hive is used for offline statistical query, HBase can be used for historical data solidification and fast query, and can also be used together.

Thank you for your reading, the above is the content of "what's the difference between Redis, relational database, HBase and Hive". After the study of this article, I believe you have a deeper understanding of the difference between Redis, relational database, HBase and Hive. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.