relational databases (MySQL and Oracle)
1. There is a relationship between tables and tables, tables and fields, data and data
Advantages:
1. There is a relationship between the data, the data can be deleted and modified to check the time is very convenient
2. Relational databases have transactional operations that ensure data integrity and consistency.
Disadvantages:
1. Because the data and data are related, the bottom is a large number of algorithms run
A large number of algorithms can reduce system efficiency and degrade performance
2. The face of massive data and additions and deletions will be significantly powerless to check
3. Massive data maintenance of data has become very weak
Suitable for handling general level of data (bank transfer and money)
Non-relational database (Redis and MANGDB)
In order to deal with the massive data, the design of the non relational database is to replace the relational database.
Advantages:
1. A large number of data additions and deletions can be changed
2. The maintenance and processing of massive data is very easy
Disadvantages:
1. Data and data are not related, they exist in isolation
2. Non-relational databases have no relationship, no strong transactional relationships, no guarantee of data integrity and security
Suitable for handling massive data, ensuring efficiency, not necessarily security (statistical data, such as micro-blog data)