What are the main characteristics of relational databases in databases?

This article is about the main features of relational databases in databases. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

The main characteristics of relational database are: 1, centralized data control, maintenance and management; 2, data independence; 3, data sharing; 4, reducing data redundancy; 5, data structure; 6, unified data protection function.

The main characteristics of Relational Database

1) centralized data control

In the file management method, files are scattered, each user or each processing has its own files, these files are generally not related, therefore, can not be controlled, maintained and managed in a unified way. The database overcomes this shortcoming and can centrally control, maintain and manage the relevant data.

2) data independence

The data in the database is independent of the application program, including the physical and logical independence of the data, which provides convenience for the use, adjustment, optimization and further expansion of the database, and improves the stability of the database application system.

3) data sharing

The data in the database can be used by multiple users, and each user is only connected with a part of the data in the database; the user data can overlap, and the user can access the data at the same time without affecting each other, which greatly improves the efficiency of the database.

4) reduce data redundancy

The data in the database is not application-oriented but system-oriented. Unified definition, organization and storage of data, centralized management, avoid unnecessary data redundancy, but also improve the consistency of data.

5) data structure

The whole database is composed of a certain structure, and the data are related to each other within the record and between the record types, and users can access the data through different paths.

6) Unified data protection function

In the case of multi-user sharing data resources, there is a strict check on the data used by users, stipulate a password or access authority on the database, and refuse illegal users to enter the database, so as to ensure the security, consistency and concurrency control of the data.

Thank you for reading! This is the end of the article on "what are the main characteristics of the relational database in the database". I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it for more people to see!