What does dbms include?

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-users. (Recommended learning: MySQL video tutorial)

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

(1) Pattern 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 that contains the database access statement 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 the 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 database management system based on the relational model has become increasingly perfect and has been widely used in various industries as commercial software.

Its application in the distributed multi-user environment of each household server structure further expands the application of the database system. With the advancement of new data models and data management implementation technologies, it can be expected that the performance of dbms software will be updated and improved, and the application fields will be further expanded.

The functions it provides include the following:

(1) Data definition function. DBMS provides corresponding data languages ​​to define (DDL) database structures, which describe the database framework and are stored in the data dictionary.

(2) Data access function. DBMS provides data manipulation language (DML) to implement basic access operations on database data: retrieval, insertion, modification and deletion.

(3) Database operation management function. DBMS provides data control functions, that is, data security, integrity and concurrency control to effectively control and manage database operations to ensure that the data is correct and effective.

(4) Database establishment and maintenance functions. Including the loading of initial data of the database, database dump, recovery, reorganization, system performance monitoring, analysis and other functions.

(5) Database transmission. DBMS provides the transmission of processing data and realizes communication between user programs and DBMS, which is usually completed in coordination with the operating system.

For more MySQL related technical articles, please visit the MySQL Tutorial column to learn!

The above is the detailed content of What does dbms include?. For more information, please follow other related articles on the PHP Chinese website!