Database Management System

Database: 

Database is a collection of inter-related data which helps in efficient retrieval, insertion and deletion of data from database and organizes the data in the form of tables, views, schemas, reports etc. For Example, university database organizes the data about students, faculty, and admin staff etc. which helps in efficient retrieval, insertion and deletion of data from it.

Database Management System: 

A Database Management System (DBMS) is a collection of programs that manages the database

structure and controls access to the data stored in the database.

The software which is used to manage database is called Database Management System (DBMS). For Example, MySQL, Oracle etc. are popular commercial DBMS used in different applications.

The DBMS serves as the intermediary between the user and database. The database structure itself is

stored as a collection of files and the only way to access the data in those files is through the DBMS. It

presents the end user or application program with single, integrated view of data in the database. 

The DBMS receives all application requests and translates them into the complex operations to fulfill those requests. The DBMS hides much of the database’s internal complexity from the application programs and users. 

 

DBMS allows users the following tasks:

 

Data Definition: It helps in creation, modification and removal of definitions that define the organization of data in database.

 

Data Updation: It helps in insertion, modification and deletion of the actual data in the database.

 

Data Retrieval: It helps in retrieval of data from the database which can be used by applications for various purposes.

 

User Administration: It helps in registering and monitoring users, enforcing data security, monitoring performance, maintaining data integrity, dealing with concurrency control and recovering information corrupted by unexpected failure.