What is the structure and nature of the data in the database?

The data in the database is structured, independent and shared. The basic characteristics of the database are: data structure, connections between data, and oriented to the entire system; high data sharing, low redundancy, and easy expansion; high data independence.

The operating environment of this tutorial: Windows 7 system, mysql version 5.8, Dell G3 computer.

The data in the database is structured, independent and shared.

(Recommended tutorial: mysql video tutorial)

A database is a "warehouse that organizes, stores and manages data according to the data structure". It is a collection of large amounts of data that is stored in a computer for a long time, is organized, shareable, and unified management.

A database is a computer software system that stores and manages data according to a data structure. The concept of database actually includes two meanings:

(1) Database is an entity, which is a "warehouse" that can reasonably store data. Users store transaction data to be managed in this "warehouse". "Data" " and "library" are combined into a database.

(2) Database is a new method and technology for data management. It can organize data more appropriately, maintain data more conveniently, control data more closely and utilize data more effectively.

Characteristics of the database:

1. Data structuring

The database system realizes the structuring of the overall data, which is the most important thing of the database One of the characteristics. The "holistic" structuring mentioned here means that the data in the database is no longer just for a certain application, but for the entire organization; not only is the data internally structured, but it is also structured holistically, and there are connections between the data.

2. Data has high shareability, low redundancy, and is easy to expand

Because the data is oriented to the whole, the data can be shared and used by multiple users and multiple applications. Greatly reduce data redundancy, save storage space, and avoid incompatibility and inconsistency between data.

3. High data independence

Data independence includes the physical independence and logical independence of data.

Physical independence means that how the data is stored in the database on the disk is managed by the DBMS. The user program does not need to understand. What the application has to deal with is only the logical structure of the data. In this way, when the physical structure of the data is When the storage structure changes, the user's program does not need to change.

Logical independence means that the user's application program and the logical structure of the database are independent of each other. That is to say, if the logical structure of the data changes, the user program does not need to change.

The independence of data and program separates the definition of data from the program, and the DBMS is responsible for providing access to data, thus simplifying the preparation of application programs and greatly reducing the maintenance and modification of application programs. .

4. Data is managed and controlled uniformly by DBMS

The sharing of the database is concurrent (concurrency) sharing, that is, multiple users can access the data in the database at the same time, or even at the same time. The same data in the database.

DBMS must provide the following aspects of data control functions:

• Data security protection (security)

• Data Integrity check (integrity)

• Database concurrent access control (concurrency)

• Database failure recovery (recovery)

For more programming-related knowledge, please visit: Programming Teaching! !

The above is the detailed content of What is the structure and nature of the data in the database?. For more information, please follow other related articles on the PHP Chinese website!