- Published on
Database Design Fundamentals For Software Engineers | Database Management System (DBMS)
- Authors
- Name
- Milad E. Fahmy
- @miladezzat12
3 - Database Management System (DBMS)
| Index | Content |
|---|---|
| 1 | Introduction & File-based system |
| 2 | What is Database? |
| 3 | Database Management System (DBMS) |
| 4 | Characteristics of the Database Approach |
| 5 | Benefits of the Database Approach |
Database Management System
It's a collection of programs that enable the users of the organization to create and maintain databases and control all access to them.
A database management system (or DBMS) is essentially nothing more than a computerized data-keeping system. Users of the system are given facilities to perform several kinds of operations on such a system for either manipulation of the data in the database or the management of the database structure itself.
Facilities provided by a DBMS
-
Defining A database involves defining the data types, structures, and constraints of the data to be stored in the database.
-
Constructing The database is the process of storing the data on a storage device that is controlled by the DBMS.
-
Manipulating A database involves querying the database to retrieve specific data, updating the database, etc.
-
Sharing A database allows multiple users and programs to access the database simultaneously.
Notes
we call the database together with DBMS software a database system