Shulou(Shulou.com)06/02 Report--

This article is to share with you about the use of database management systems. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

The work of a database management system does not include providing an operating system for a defined database. Database management system can: 1, define the database; 2, manage, protect and maintain the defined database; 3, data organization, storage, management and communication.

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

Database Management system (Database Management System) is a large-scale software that manipulates and manages the database, which is used to establish, use and maintain the database, referred to as DBMS. 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, 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.

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, two-level image, integrity constraints and confidentiality restrictions of the database. DDL is mainly used to establish and modify the database structure. The library structure described by DDL only gives the framework of the database, and the frame information of the database is stored in the data dictionary (Data Dictionary).

2. Data manipulation: DBMS provides data manipulation language DML (Data Manipulation Language) for users to append, delete, update and query data.

3. Database operation management: the database operation management function is the operation control and management function of DBMS, including concurrency control, security check and access restriction control, integrity check and execution, operation log organization and management, transaction management and automatic recovery, that is, to ensure the atomicity of transactions. These functions ensure the normal operation of the database system.

4. Data organization, storage and management: DBMS classifies, organizes, stores and manages all kinds of data, including data dictionaries, user data, access paths, etc., and needs to determine what file structure and access mode to organize the data at the storage level, and how to realize the relationship between the data. The basic goal of data organization and storage is to improve the utilization of storage space and choose appropriate access methods to improve access efficiency.

5. The protection of the database: the data in the database is the strategic resource of the information society, so the data protection is very important. The database protection of DBMS is realized 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 the functions of database loading, conversion, dump, database reconfiguration and performance monitoring, which are completed by each user program.

7. Communication: DBMS has relevant interfaces with online processing, time-sharing system and remote job input of the operating system, which is responsible for data transmission. The database system under the network environment should also include the communication function between DBMS and other software systems in the network and the interoperation function between the database.

Thank you for reading! This is the end of this article on "what is the use of database management system". I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it out for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.