What is DBMS? and  How DBMS works?

DBMS stands for Database Management System. And to understand Database Management System we have to understand Database and to understand Database first of all we have to understand What is Data?

So Data is a small part of information about anything like person, place, or things. Example- for any person -Name, DOB, height, add, income, mob, etc. will be data. Data may be in various types like Numeric, Text, Image, Pie-chart, and video.

And when we systematically organize data it becomes a Database. The database is used to store data and when we want some information we can take it from Database.

To store data or information in a Database we use software like Oracle, MySQL, MS-Access, MaxDB, PostgreSQL, etc.

 With the help of this software, we can insert, access, modify, delete and update information in the Database and all these software called DBMS.

In simple Terms, DBMS is software that is used to create, manage, and administrate the Database.

Types of DBMS Model 

There are four types of DBMS Model

1. Hierarchical Model :-

In this form of Database, information is stored in a Tree form. Data are recorded in the nodes and the relationship between nodes shows as a parent and child.

2. Network Model :-

In-Network model information is organized as a graph. And the relationship between them is shown from links. It is more efficient than the Hierarchical Model. It supports the Many-to-Many relationships.

3. Relational Model :-

In this type of Database, information is stored or organized in a table called relation. And each relationship or table contains a set of records called “Tuple”. Most of DBMS is based on RDBMS and we will also study RDBMS in my next upcoming posts.

4. Object-Oriented Model:-

It is a combination of RDBMS and OOPs.Where data is stored in the form of  Objects and each object has a number of attributes and functions.

 How DBMS works?

 Any Software program stores Data in a Database with the help of DBMS. A software application can store, retrieve, manage, and administrate information in a database via SQL. SQL (Structured Query Language) is a query language that is used to perform various types of operations on a Database. The queries fired by SQL are divided into four groups.

How DBMS works

1. DDL (Data Definition Language):- Create, Alter, Drop, Rename falls in this group.

2. DML (Data Modification Language):-  Insert, Select, Update, etc fall in this group.

3. DCL (Data Control Language):-  Grant and Revoke.

4. DTCL (Data Transaction Control Language):-  Commit and Rollback.

For More detail, you can watch the video on Database Management System