Database Chapter 12 Database management System

12th Chapter Database Management System

The basic functions, system structure and main implementation techniques of DBMS are expounded.

Basic functions that a DBMS should have

Database Definition and Creation

Data organization, storage, and management

Data access

Database transaction management and operation management

Establishment and maintenance of database

Other features

The process structure of the DBMS

In real-world applications, both the DBMS and the application must enter a specific operating system environment where the application passes through the DBMS. The DBMS deals with the data in the database through the operating system. According to the three relations, there are generally four kinds of process organization plan.

N Scenario: A scenario in which a DBMS integrates with an application

Multi-clue (multi-threaded) DBMS

It's like the library and the student's relationship. Book sharing students can borrow to do their own tasks

Advantages of multiple clues:

The thread consumes less resources than the process

Lead scheduling is more flexible and controllable

Less thread switching overhead

Easy communication between clues

DBMS System Architecture

Data Access Layer

Database Physical organization

Database to store 4 aspects of data

Data description, i.e. data outside mode, mode, internal mode

The data itself

The link between data

Access path

Database Chapter 12 Database management System