Gyan

What is Database Management System (DBMS)

WHAT IS DBMS
Written by Satish Pandey

Hello friends, in this article we will know what is database and how it works.

What is database management system (DBMS)

This is system software for creating and managing databases that’s called database management system (DBMS). Database Management System does all the work from creating, maintaining and deleting data. A software that can Create, Manage, Control, Delete and Update data.

Database Management System (DBMS)
DBMS

for example:

If we have the marks of a class, then we can conclude who are the toppers and who are the average marks. This database management system stores data in such a way that it becomes easy to retrieve, manipulate, and produce information from it.

Full Form of DBMS?

The full form of DBMS is Database Management System.

When the definition of database is understood, it is a collection of related data which is organized in such a way that it can be easily accessed, managed and updated.

What are the components of a DBMS?

Following are the components of database management system:-

  • Hardware
  • Software
  • Data
  • Users
  • Procedures

Hardware

Hardware includes our computer system which is used to store and access our database. Under this come physical electronic devices such as – computer, I/O channels, storage devices etc. Mostly hard disk is used to store data in computer system.

Software

It is the most important component of DBMS. It is a group of programs that is used to control and manage the entire database. Under this comes DBMS software, operating system, and application programs.

DBMS software is located between the database and the users. It provides a very easy interface to store, update, and retrieve data in the database.

Data

Data is a main important component of DBMS. DBMS collects, stores, processes and accesses the data. Actual data, operational data, and metadata are stored in the database.

Users

There are many users in this who access the data according to their needs. The capability and need of each user is different. In this the users are as follows:-

  1. Database administrator
  2. Database designers
  3. End-users
  4. Application programmers

Procedures

Procedures come with rules and instructions for using the database management system. Procedures tell how to use the database in the system. Such as: – Installing and setting up DBMS, logging in to the database, logging out, backing up the database, and handling the database etc.

  1. Tables
    In DBMS all the data is kept in tables. Data collection, filter, editing, retrieving etc. all the work is done on the tables only. Tables are made up of Rows and Columns inside which all the data is stored.
  2. Field
    Each column inside the table is called a field. Every specific piece of data is stored in it like customer number, customer name, street address, state etc.
  3. Record
    The data contained in the rows inside the table is called record. A record is a type of entry that can contain a person’s name, phone number, etc.
  4. Queries
    Extracting data according to the requirement from a table or database is called query. For example, if you want to extract the list of friends living in the same city, then it will be called query.
  5. Forms
    You can enter data in the table but it is not easy to modify and store in it. That’s why forms are used to remove this time. Data is entered in forms just like tables.
  6. Reports
    When you print the records of the database on paper, it is called a report.

What are the characteristics of Database System?

  • Being of Self Describing Nature: A database system not only contains data but also stores the description of database structure and constraints along with it. In this, the definition is stored in the DBMS catalog, which contains information such as structure of each file, type and storage format of each data and constraint. The information stored in the catalog is called meta data.
  • Having Program Data Independence: If I talk about traditional file processing, then the structure of each file is embedded in the application program. Therefore, due to any change in the file, it becomes necessary to make necessary changes in the programs to access that file. Whereas in DBMS, we have program data independence because in this the structure of data files is stored separately in system catalog, if we compare it with access programs then.
  • It supports Multiple Views of Data: There are many users of a database in which each requires a different view or perspective for the database.
  • Sharing of Database can be between Multiple Users: DBMS allows multiple users to access the database at the same time.
  • There is no data redundancy in this. That is, there is no duplicate data.
  • There is security in it, that is, no unauthorized user can access it.
  • If for some reason the database gets deleted or becomes corrupt, then we can take a backup of it.

>> Top 10 Indian Technology Companies | IT Special

What is the function of DBMS

It is a general purpose software system which provides us with the following features:-

Data Redundancy

Each application has its own personal files in the file system and in such a situation, duplicate files of the same data are created at many places. In DBMS, the same type of files are kept at one place, that is, it is not repeated, due to which the redundancy of data is reduced.

Sharing Of Data

Data is shared by the authorized user of the organization in DBMS. In this, the data administrator controls the data and gives rights to the user to access the data.

Data Consistency

Through DBMS, the same type of data can be prevented from being stored repeatedly in the database.

Integration Of Data

In DBMS, all the data is in the table and there is more than one table in a database. Relationships can be created between all these tables, which makes it easy to retrieve and update data.

data security

Data in DBMS is completely controlled by the data administrator. In this, only the administrator makes sure that to which user the data has to be given and how much data has to be given. The database administrator controls all this on which part of the database is to be given to the user and which part is not. This increases the security of the database and the data does not go into the wrong hands.

Remove Procedures

You all know that computer is a kind of machine and it can malfunction anytime and hardware or software failure can happen anytime, in which case data can be destroyed. Through DBMS, you can easily recover data in such condition.

  • Create Data: Data is created by DBMS, that is, it is stored in the table.
  • Manage Data: In this the data is managed so that it can be accessed easily.
  • Update Data: In this the data can be updated as per the need.
  • Delete Data: The data which is not needed in this is deleted.
  • Data Backup: Data is backed up in this so that it can be recovered when the system fails.
  • Data Recovery: In this, data is recovered when the system fails.

Where is DBMS used?

It is used at the following places:-

  • It is used in Banking to store customer information, payment, account activities, deposits and loans.
  • It is used for ticket booking and reservation in airlines.
  • In college and school, it is done for student information, course registration, and result.
  • DBMS is used to store call records, bills and balance information in telecommunication.
  • It is used to store the information of stock, sales, and purchase in finance.
  • In Sales it is used to store the information of customer, product and sales.
  • In manufacturing, it is used for supply chain management and to track the product.
  • In HR management, it is used to store the information of employees, salary, payroll and paycheck etc.

The history of databases System

The history of databases begins with the two earliest computerised examples. Charles Bachman designed the first computerised database in the early 1960s. This first database was known as the Integrated Data Store, or IDS. This was shortly followed by the Information Management System, a database created by IBM.

I will keep writing more posts related to this, so do not forget to bookmark (Ctrl + D) our blog “EduTechGyan.COM” on your mobile or computer and subscribe us now to get all the posts in your email.
If you like this post, then do not forget to share it with your friends. You can help us reach more people by sharing it on social networking sites like Facebook or Twitter. Thank you !

About the author

Satish Pandey

Learn More About Technology with Edu Tech Gyan. We have a team of writers who write informative posts for you all. Keep Reading and Sharing.

Leave a Comment