Database systems can be divided into two types in terms of use and operation. What are their two types? Solve.

It is divided into relational database and non-relational database.

1, relational database:

Relational database refers to a database that uses relational models to organize data. It stores data in the form of rows and columns, which is convenient for users to understand. A series of rows and columns in a relational database are called tables, and a group of tables constitutes the database. Users retrieve data in the database through queries, and queries are used to restrict the execution of code in some areas of the database.

2. Non-relational database:

Generally refers to a non-relational database. With the rise of Internet web2.0 websites, traditional relational databases have been unable to cope with web2.0 websites, especially the super-large and highly concurrent SNS web2.0 purely dynamic websites, and many insurmountable problems have emerged, while non-relational databases have developed very rapidly due to their own characteristics.

Extended data

The biggest feature of relational database is the consistency of transactions: the traditional reading and writing operations of relational database are transactional and have the characteristics of ACID, which makes relational database can be used in almost all systems that require consistency, such as typical banking systems.

Another characteristic of relational database is that it has a fixed table structure, so its scalability is poor. In SNS, the upgrade of the system and the increase of functions often mean great changes in the data structure, which is difficult for relational databases to cope with and requires new structured data storage.

Therefore, non-relational database came into being. Because a structured data storage can't meet all the new requirements, a non-relational database is not a database strictly, but a collection of structured data storage methods.

Baidu encyclopedia-relational database

Baidu encyclopedia -NoSQL