Database Management System (DBMS)

Database Management System (DBMS) is a software for storing and retrieving users' data while considering appropriate security measures. It consists of a group of programs which manipulate the database. The DBMS accepts the request for data from an application and instructs the operating system to provide the specific data. In large systems, a DBMS helps users and other third-party software to store and retrieve data.

DBMS allows users to create their own databases as per their requirement. The term “DBMS” includes the user of the database and other application programs. It provides an interface between the data and the software application.

Database - A database is a collection of related data which represents some aspect of the real world. A database system is designed to be built and populated with data for a certain task.

Characteristics of Database Management System

  • Provides security and removes redundancy

  • Self-describing nature of a database system

  • Insulation between programs and data abstraction

  • Support of multiple views of the data

  • Sharing of data and multiuser transaction processing

  • DBMS allows entities and relations among them to form tables.

  • It follows the ACID concept ( Atomicity, Consistency, Isolation, and Durability).

  • DBMS supports multi-user environment that allows users to access and manipulate data in parallel.

Application of DBMS

  1. Banking - For customer information, account activities, payments, deposits, loans, etc.

  2. Airlines - For reservations and schedule information.

  3. Universities - For student information, course registrations, colleges and grades.

  4. Telecommunication - It helps to keep call records, monthly bills, maintaining balances, etc.

  5. Finance - For storing information about stock, sales, and purchases of financial instruments like stocks and bonds.

  6. Sales - Use for storing customer, product & sales information.

  7. Manufacturing - It is used for the management of supply chain and for tracking production of items. Inventories status in warehouses.

  8. HR Management - For information about employees, salaries, payroll, deduction, generation of paychecks, etc.

Types of DBMS