Shulou(Shulou.com)05/31 Report--

This article mainly explains "what are the latest database popular trend rankings and application scenarios". Interested friends might as well take a look. The method introduced in this paper is simple, fast and practical. Next, let the editor take you to learn "what are the latest database trend rankings and application scenarios?"

Relational database

Relational database, a database that uses a relational model to organize data, which stores data in the form of rows and columns. The commonly used relational databases are Oracle, MySQL, Microsoft SQL Server, PostgreSQL, Db2 and so on.

Relational database is suitable for database query scenarios with particularly complex relationships, such as our common business systems and management systems.

Judging from the database popularity ranking published by db-engines, the top three relational databases are Oracle, MySQL and Microsoft SQL Server, with a score far higher than that of other databases behind. In addition, mysql tends to catch up with Oracle. In addition, we can see PostgreSQL, Db2, SQLite, Microsoft Access, MariaDB (a branch of MySQL), the use of SAP is also very popular and relatively common.

Relational database ranking

Key-value database

Non-relational database model (NoSQL), whose data is organized, indexed, and stored in the form of Key-Value according to key values.

The main characteristic of key-value database is that it has extremely high concurrent read and write performance, so it is very suitable for use in distributed high concurrency scenarios. Common key-value databases include Redis, Memcached, etc. The popularity ranking of Key-value database published by db-engines in March is shown below:

Nosql database ranking

Document database

Document database is a very important branch of NoSQL, which is mainly used to store, index and manage document-oriented data or similar semi-structured data. MongoDB, which you may be familiar with, is a typical document database.

Mongodb distributed file storage database is suitable for scenarios where the business module may change greatly in the later stage, real-time insertion, update and query scenarios, and highly scalable scenarios.

Ranking of document databases

Time series database

The full name of time series database is time series database. Time series database is mainly used to deal with data with time tags (changing according to the order of time, that is, time serialization). Data with time tags is also called time series data.

Usage scenario: time series data are mainly collected and generated by various types of equipment, such as electric power industry, chemical industry and so on. The typical characteristics of these industrial data are: fast generation frequency, heavy dependence on collection time, large amount of information, need to be updated and queried in real time. The typical representative of time series database is influxdb.

Time series database ranking

Graphic database

Graphic database is a type of NoSQL database, which applies graphics theory to store the relationship information between entities. Graphic database is a kind of non-relational database, which applies graphics theory to store the relationship information between entities.

Common graphic databases are Neo4j and ArangoDB, which are used in many-to-many relational database scenarios such as social relational networks.

Ranking of graphic database

Retrieval database

Retrieval database is a typical representative of Elasticseach, its application scene search services, log analysis, such as documents based on ES for full-text search, e-commerce massive commodity search. Typical search scenario Elasticseach has the characteristics of high availability, high expansibility, fast query speed, powerful search function and so on.

Search database ranking

In addition to the above-mentioned databases, ClickHouse (db-engines ranks it 31st in the relational database ranking), ClickHouse is a column database management system, which is very suitable for scenarios with more read operations and less updates, such as analyzing BI reports and monitoring systems.

At this point, I believe you have a deeper understanding of "the latest database popular trend ranking and application scenarios". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.