Database management systems (DBMS)

This lesson introduces DBMS and its functionality.

If an organization wants to adopt the database approach, then it needs a collection of programs that enable the users of the organization to create and maintain databases and control all access to them. This is achieved using a database management system (DBMS). The primary goal of a DBMS is to provide an environment that is both convenient and efficient for users to retrieve and store information.

Facilities provided by a DBMS

The DBMS is instrumental in facilitating the processes:

  1. Defining a database involves defining the data types, structures, and constraints of the data to be stored in the database.

  2. Constructing the database is the process of storing the data on a storage device that is controlled by the DBMS.

  3. Manipulating a database involves querying the database to retrieve specific data, updating the database, etc.

  4. Sharing a database allows multiple users and programs to access the database simultaneously.

Other important terms

Furthermore, in order to access the database, we use application programs which send queries (requests) for data to the DBMS. A query causes some data to be retrieved.

To wrap up our discussion on basic terms, we call the database together with DBMS software a database system.

Example

With the database approach, we can have the traditional banking system as shown in the diagram below:

Get hands-on with 1200+ tech skills courses.