Comparison Between Relational databases and NoSQL Databases

Advantages of relational databases: 1. maintaining data consistency (Transaction Processing) [the biggest advantage of relational databases] 2. due to the premise of standardization, the overhead of data update is very small (the same field basically only has one) 3. complex queries such as Join can be performed (Join Processing cannot be performed between different servers) 4. there are many practical achievements and professional technical information (

Advantages of relational databases: 1. maintaining data consistency (Transaction Processing) [the biggest advantage of relational databases] 2. due to the premise of standardization, the overhead of data update is very small (the same field basically only has one) 3. complex queries such as Join can be performed (Join Processing cannot be performed between different servers) 4. there are many practical achievements and professional technical information (

Advantages of relational databases:

1. Maintain data consistency (Transaction Processing) [the biggest advantage of relational databases]

2. Because standardization is the premise, the overhead of data update is very small (the same field basically only has one)

3. complex queries such as Join operations can be performed (Join operations cannot be performed between different servers)

4. There are many practical achievements and professional technical information (mature technologies)

5. All data is expressed in the binary representation of rows and columns, which makes it easier to understand and understand.

Lack of relational databases (not good at processing ):

1. Writing a large amount of data

2. index or schema change for tables with data updates

3. apply when fields are not fixed

4. process the results returned quickly for simple queries

Advantages of NoSQL databases:

1. relational databases have restrictions on the Multi-Table query mechanism like Join, which makes expansion difficult. NoSQL databases do not support Join Processing, and each data is independently designed, data is easily distributed across multiple servers.

2. noSQL storage formats include key-value storage, document-oriented, and column-oriented. Therefore, you can store basic types, objects, collections, and other formats. Relational databases only support basic types.

3. Writing a large amount of data

4. Cache data processing

5. fast processing of array-type data

6. Save and process all the data

NoSQL database limitations:

1. Transaction Processing by relational databases is not provided

2. New Technical maintenance tools and materials are limited, which will produce learning and use costs for certain users.