The advantages and disadvantages of relational database and NoSQL database

relational database
Advantage:
1. Good at handling small data volumes
2. Good at complex SQL operations, can make complex queries such as joins
3. Can easily generate a variety of data objects, the use of stored data to build forms and reports, the visibility of good
Disadvantage:
1. It is difficult to write processing for distributed applications and large amounts of data
2. Indexing and structural changes to tables with data updates
3. Application with Field not fixed
4. Handling of Quick return results for simple queries

NoSQL Database
Advantage:
1. Good at writing and reading large amounts of data
2. Fast query response, flexible data model
3. Data structure change or update is very convenient, do not need to change the data structure
4. Smash performance bottlenecks to make execution faster

Disadvantage:
1. Do not provide a complex API interface
2. Usually only the key index is provided
3. Not suitable for small data processing
4. The existing product is not mature enough, most of the products are still in the start-up period

The advantages and disadvantages of relational database and NoSQL database