What kind of software is the database management system?
This article mainly introduces what kind of software the database management system is, which has a certain reference value. Interested friends can refer to it. I hope you will gain a lot after reading this article. Let the editor take you to know it.
Database management system is a large-scale software that manipulates and manages the database, which is used to establish, use and maintain the database. It unifies the management and control of the database to ensure the security and integrity of the database.
Users access the data in the database through DBMS (database management system), and the database administrator also maintains the database through DBMS. It can support multiple applications and users to build, modify and query databases at the same time or at different times in different ways. Most DBMS provide data definition language DDL (Data Definition Language) and data manipulation language DML (Data Manipulation Language) for users to define the schema structure and permission constraints of the database and to implement operations such as appending and deleting data.
According to the function, the database management system can be divided into six parts:
(1) schema translation: provide data definition language (ddl). The database schema written in it is translated into an internal representation. The logical structure, integrity constraints, and physical storage structure of the database are stored in an internal data dictionary. Various data operations of the database (such as finding, modifying, inserting and deleting, etc.) and the maintenance and management of the database are based on the database schema.
(2) Application compilation: the application program that contains the database access statement is compiled into an object program that can be run under the support of dbms.
(3) Interactive query: provide an interactive query language that is easy to use, such as SQL.DBMS is responsible for executing query commands and displaying the query results on the screen.
(4) Organization and access of data: provide physical organization and access methods of data on peripheral storage devices.
(5) transaction operation management: provide transaction operation management and operation log, 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 data security control, integrity guarantee, database backup, database reorganization and performance monitoring and other maintenance tools.
Thank you for reading this article carefully. I hope the article "what kind of software the database management system is" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!
