What are the advantages and disadvantages of relational databases?

The most typical data structure of relational database is table, which is a data organization composed of two-dimensional tables and their relationships.

Advantages:

1, easy to maintain: all tables are in the same format;

2. Ease of use: SQL language is universal and can be used for complex queries;

3. Complex operation: supports SQL and can be used for very complex queries between one table and multiple tables.

Disadvantages:

1, poor reading and writing performance, especially efficient reading and writing of massive data;

2. Fixed table structure, less flexibility;

3. High concurrent reading and writing requirements. For the traditional relational database, hard disk I/O is a big bottleneck.

I talked about it in the open class of dark horse programmers, and I understood it in detail.