What does a database management system job not include?

The work of the database management system does not include: providing an operating system for the defined database. The database management system can: 1. Define the database; 2. Manage, protect, and maintain the defined database; 3. Data organization, storage, management, and communication.

The operating environment of this article: Windows 7 system, Dell G3 computer.

The work of the database management system does not include: providing an operating system for the defined database.

Database Management System (Database Management System) is a large-scale software that manipulates and manages databases. It is used to establish, use and maintain databases, referred to as DBMS. It provides unified management and control of the database to ensure the security and integrity of the database.

Users access data in the database through DBMS, and database administrators also perform database maintenance through DBMS. It can support multiple applications and users using different methods to create, modify and query the database at the same time or at different times.

Main functions of database management system

1. Data definition: DBMS provides data definition language DDL (Data Definition Language) for users to define the three-level schema structure of the database , two-level images, and constraints such as integrity constraints and confidentiality constraints. DDL is mainly used to create and modify the library structure of the database. The library structure described by DDL only provides the framework of the database, and the framework information of the database is stored in the data dictionary (Data Dictionary).

2. Data operation: DBMS provides data operation language DML (Data Manipulation Language) for users to perform operations such as appending, deleting, updating, and querying data.

3. Database operation management: The operation management function of the database is the operation control and management function of the DBMS, including concurrency control, security check and access restriction control, integrity check and execution in a multi-user environment. , Organization and management of running logs, transaction management and automatic recovery, that is, ensuring the atomicity of transactions. These functions ensure the normal operation of the database system.

4. Data organization, storage and management: DBMS needs to classify, store and manage various data, including data dictionary, user data, access paths, etc. It needs to determine the file structure and access method. How to organize these data at the storage level and how to realize the connection between data. The basic goal of data organization and storage is to improve storage space utilization and choose appropriate access methods to improve access efficiency.

5. Database protection: The data in the database is a strategic resource in the information society, so data protection is crucial. DBMS protects the database through four aspects: database recovery, database concurrency control, database integrity control, and database security control. Other protection functions of DBMS include the management of system buffers and some adaptive adjustment mechanisms for data storage.

6. Database maintenance: This part includes functions such as database data loading, conversion, dumping, database recombination and reconstruction, and performance monitoring. These functions are completed by each user program.

7. Communication: DBMS has related interfaces with the operating system's online processing, time-sharing system and remote job input, and is responsible for processing data transmission. For database systems in a network environment, it should also include communication functions between the DBMS and other software systems in the network and interoperability functions between databases.

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

The above is the detailed content of What does a database management system job not include?. For more information, please follow other related articles on the PHP Chinese website!