Database principle-the hierarchy and structure of database management system

Hierarchical structure of the database management system

Figure 1: Hierarchical structure of the data management system

Figure 2: The running process of the relational data management system

The role of each layer:

According to the different processing objects, the hierarchical structure of database management system is the application layer, the Language translation processing layer, the data access layer, the data storage layer and the operating system.

(1) Application layer

The application layer is the interface layer between the DBMS and the end user and the application, and the objects are processed in a variety of database applications.

(2) Language translation processing layer

The language translation processing layer is the syntax analysis, the view transformation, the authorization check, the completeness check and so on the various statements of the database language.

(3) Data access layer

The data access layer handles an object that is a single tuple that transforms the upper-level collection operation into a single-record operation.

(4) Data storage layer

The data storage layer processes objects that are data pages and system buffers.

(5) Operating system

The operating system is the basis of the DBMS. The access primitives and basic access methods provided by the operating system are often used as interfaces to the DBMS storage layer.

Database principle-the hierarchy and structure of database management system