The difference between database, database system and database management system

In the database application, commonly used in db, DBMS, DBS and other terms, the form is defined as follows.

Database abbreviation DB

Databases (database, or db) strictly speaking, a database is "a warehouse that organizes, stores, and manages data according to its structure." The database can be shared with a variety of users, with small redundancy, close connection between data and high data independence. 

Database management System (DataBasemangement System (DBMS) database management systems (Databasemanagement System) is a software that manipulates and manages databases for the establishment, use, and maintenance of databases, referred to as DBMS. It has unified management and control of the database to ensure the security and integrity of the database. The user accesses the data in the database through the DBMS, and the database administrator maintains the database through the DBMS. It allows multiple applications and users to create, modify, and interrogate databases in different ways, at the same time or at different times. The database management system mainly provides the following functions. 1. Data definition: The DBMS provides data definition language DDL (Language) for user-defined three-level schema structures, two-level images, and integrity constraints and confidentiality restrictions. 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 framework information of the database is stored in the data Dictionary. 2data manipulation: The DBMS provides data manipulation language (manipulation Language) to enable users to append, delete, update, and query data. 3. Database operation Management: Database operation management function is DBMS's operation control, management function, including concurrency control in multiuser environment, security check and access limit control, integrity check and execution, organization management of running log, transaction management and automatic recovery, that is to guarantee the atomicity of transaction. These functions ensure the normal operation of the database system. 4data organization, storage, and management: The DBMS organizes, stores, and manages a variety of data, including data dictionaries, user data, access paths, and so on, to determine how the file structure and access methods organize the data at the storage level, and how the data can be connected. The basic goal of data organization and storage is to improve storage space utilization and choose appropriate access method to improve access efficiency. 5Database protection: Data in a database is a strategic resource in the information society, which is critical to the protection of data. The DBMS protects the database through 4 aspects: Database recovery, database concurrency control, database integrity control, database security control. Other protection functions of DBMS include the management of system buffers and some adaptive regulation mechanism of data storage. 6. Database maintenance: This section includes data loading, conversion, dump, refactoring, and performance monitoring of the database, each of which is done by various user programs. 7Communication: The DBMS has an interface with the operating system's online processing, time-sharing system and remote job input, which is responsible for processing the data transmission. The database system in the network environment should also include the communication function between DBMS and other software systems in the network, and the interoperability function between the databases.

Database System (DataBasesystem, referred to as DBS) database systems generally consist of 4 parts: (1DatabaseDatabase, DB) is a collection of organized, shareable data that is stored in a computer for a long period of time. The data in the database is organized, described and stored in a certain mathematical model, with small redundancy, high data independence and extensibility, and can be shared by various users. (2Hardware: A variety of physical devices that comprise a computer system, including the external devices required for storage. The hardware configuration should meet the needs of the whole database system. (3) Software: Includes operating system, database management system and application program. Database management System (DatabaseManagement System,dbms) is the core software of database system, it is the system software that works with the support of operating system (such as Windows, Linux and so on), solves how to organize and store data scientifically, how to obtain and maintain data efficiently. Its main functions include: data definition function, data manipulation function, database operation management and database establishment and maintenance. (4) Personnel: There are 4 main categories. The first category is System analyst and Database Designer: The system analyst is responsible for the application system requirements analysis and specification, they and the user and the database administrator to determine the system hardware configuration, and participate in the database system summary design. The Database Designer is responsible for the data determination in the database and the design of the database models at all levels. The second class is the application staff, responsible for writing applications that use the database. These applications can retrieve, create, delete, or modify data. The third type is the end user, who uses the system's interface or query language to access the database. The fourth type of user is the database administrator (data base administrator,dba), which is responsible for the overall information control of the database. DBA's specific responsibilities include: information content and structure in the database, determine the database storage structure and access policy, define the database security requirements and integrity constraints, monitoring the use and operation of the database, responsible for database performance improvement, database reorganization and reconstruction, in order to improve the performance of the system. 

The difference between database, database system and database management system