Home >Database >Mysql Tutorial >What is the relationship between db, dbms and dbs in the database?
The relationship between db, dbms and dbs in the database is: DBS includes DB and DBMS; database system DBS is a general term, including database DB, database management system DBMS, database administrator DBA, etc. , is the largest category.
#DBS (database system) includes DB (database) and DBMS (database management system). Database system is a general term that includes databases, database management systems, database managers, etc. It is the largest category.
1. The relationship between DBMS and DB: DBMS database management system (database management system) is a large-scale software for manipulating and managing databases. It is used to establish, use and maintain databases (DB). It provides unified management and control of the database to ensure the security and integrity of the database. Users access data in a database (DB) through a DBMS.
2. The relationship between DBS and DB: Database system DBS (Data Base System, referred to as DBS) is an actual runnable software system that provides data for storage, maintenance and application systems. It is a storage medium, processing object and A collection of management systems. It usually consists of software, database (DB) and data administrator.
The concepts related to database are as follows.
1. Database (DB): A database is a structured collection of related data stored on a computer storage device. It includes not only the data itself describing things, but also the connections between related things.
2. Database management system (DBMS): The database management system can manage the establishment, use and maintenance of the database.
3. Database application system (DBAS): Database application system refers to application system software developed by system developers using database system resources and oriented to a certain type of practical application.
4. Database system (DBS): Database system refers to a computer system that introduces database technology to achieve organized and dynamic storage of large amounts of relevant data, and provides convenient means for data processing and information resource sharing. The database system consists of 5 parts: computer hardware system, database, database management system, database administrator and user.
5. Database Administrator (DBA): Has the ability to reorganize data and change the data storage structure or data storage location.
Recommended tutorial: mysql video tutorial
The above is the detailed content of What is the relationship between db, dbms and dbs in the database?. For more information, please follow other related articles on the PHP Chinese website!