What is Database Management System(DBMS)

In its simplest terms a Database Management System or DBMS is an aid in the creation and the storage of data in databases. This works by enabling users to reach actual data in data repositories where users are given the permissions to read data as well as write such data and modify such data as they wish.

Key Components of a DBMS:

Components:

A DBMS is made up of several parts or elements that are vital to its smooth operation and the functionality of the database.

Data Definition Language (DDL):

It offers an opportunity to add or change the application if necessary to include further or change several users’ requests and change the database structure.

Data Manipulation Language (DML):

These are the statements that are used in interacting with the database and has the capability of performing read, writing and modifying data stored in it and include SELECT, INSERT, UPDATE and DELETE statements.

Data Control Language (DCL):

Being accountable of the access – that is, to decide who should have permission to get access to the database along with the operations which can be performed on the data.

Transaction Management:

Facilitates the changes to guarantee the practicable and unswerving database integrity through transactions: which are a sequence of activities that is atomic and sequentially containing only a single operation where a transaction will not have an influence on the rest of the transactions and also characterized by consistency, isolation and durability or also called as ACID.

Concurrency Control:

Supervises use of the database by the multiple users in order to exclude problems such as overloading or embarrassment for timeliness, accuracy and integrity of data.

Backup and Recovery:

It is a place for information placing and has ways of storing these data in copies and therefore has an ability to retrieve the data in the event that the system or the data is lost.

Query Optimization:

It depends on the kind of request that is to be made to the database or the type of command that is likely to be issued to the database and chooses the manner in which the request is to be handled in order to arrive at the desired result set.

Thanks for reading….