The difference between database management system and database system

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

Databases (database, abbreviated DB)

Strictly speaking, a database is "a warehouse that organizes, stores, and manages data in accordance with its data structure." The database can be shared with a variety of users, with small redundancy, close connection between data and high data independence.

Database mangement System (DBMS)

Database management system is a software for manipulating and managing databases that is used to establish, use, and maintain 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.

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

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.

4. Data organization, storage and management: DBMS to classify and organize, store and manage various kinds of data, including data dictionary, user data, access path and so on, need to determine what file structure and access way to organize the data at the storage level, how to realize the connection between data. The basic goal of data organization and storage is to improve storage space utilization and choose appropriate access method to improve access efficiency.

5. Database protection: Data in the database is the strategic resource of the information society, which is crucial 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. Maintenance of the database: This section includes data loading, conversion, dump of database, reconfiguration of database and performance monitoring functions, which are completed by various use programs respectively.

7. Communication: DBMS with the operating system online processing, time-sharing system and remote job input related interface, responsible for processing 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 systems (DB system, referred to as DBS)

The database system generally consists of 4 parts:

(1) a database (DATABASE,DB) is a collection of data that is stored in a computer, organized, and shareable over 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.

(2) Hardware: A variety of physical devices that comprise a computer system, including the external equipment required for storage. The hardware configuration should meet the needs of the whole database system.

(3) Software: including operating system, database management system and application program. Database management System,dbms is the core software of database system, it works with the support of operating system (such as Windows, Linux and so on), solves how to organize and store data scientifically, How to efficiently acquire and maintain data in system software. 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 management system and database system