What is the software system that supports various database operations?

What is the software system that supports various database operations?

The software system that supports various operations of the database is called a database management system.

Database Management System (DBMS) is a large-scale software that manipulates and manages databases and is used to establish, use and maintain databases. 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 provides a variety of functions that enable multiple applications and users to use different methods to create, modify and query the database at the same time or at different times. It enables users to easily define and manipulate data, maintain data security and integrity, and perform concurrency control and database recovery under multi-user conditions.

Extended information

According to functions, the database management system can be roughly divided into 6 parts:

(1) Schema translation: Provides data definition language (ddl). Database schemas written in it are translated into internal representations. The logical structure, integrity constraints and physical storage structure of the database are stored in the internal data dictionary. Various data operations of the database (such as search, modification, insertion and deletion, etc.) and database maintenance and management are based on the database schema.

(2) Application program compilation: Compile the application program containing database access statements into a target program that can be run with the support of dbms.

(3) Interactive query: Provides easy-to-use interactive query language, such as sql. The dbms is responsible for executing query commands and displaying the query results on the screen.

(4) Data organization and access: Provide physical organization and access methods of data on peripheral storage devices.

⑸Transaction operation management: Provides transaction operation management and operation logs, transaction operation security monitoring and data integrity check, transaction concurrency control and system recovery and other functions.

(6) Database maintenance: Provide software support for database administrators, including maintenance tools such as data security control, integrity assurance, database backup, database reorganization, and performance monitoring.

The above is the detailed content of What is the software system that supports various database operations?. For more information, please follow other related articles on the PHP Chinese website!