Database Management System | Everything About It

To understand a database management system, first all of let’s see what database is.

Database

Database refers to the collection of data which is inter-related. One can retrieve data, insert the same and also delete it as per requirement from the database. A database is helpful in organizing the data in various forms like tables, charts, and reports. It finds use in organizations like schools where there is a need for proper storage of data related to the students.

Database Management System

Now, Database Management System or DBMS is a software that stores and retrieves the data of users. In simple words, DBMS manages the database. It handles the data that is to be added, does the organizing part and helps in making changes as required by the users.

Here are a few examples of DBMS:

Database Management System

MySQL

Importance of DBMS over File System

A file system is what was in use before the introduction of DBMS. But due to many drawbacks of the file system, it has been replaced by the database management system. The reasons for the change are as follows:

1. In the file system, there are a number of copies of the same data. So when the change has to be made, it has to be made individually in every copy.

2. Sometimes, the copies prove to contain differences and are not exactly similar. Hence there can be a confusion of the facts.

3. One of the major reasons is that the file system does not allow multiple users to access the data at the same time.

4. Another reason is that the data in a file system is less secured. It can be changed by an individual in an unauthorized way.

5. In order to reach a certain file, it takes much time and effort to do so.

DBMS and Flat File Management System

Talking of the differences in the file system and DBMS, the database management system is better due to the following reasons:

1. The DBMS is more expensive when compared with the flat file management system. But in the long run, DBMS proves to be more economical.

2. The complex transactions can be made in an easier way in case of DBMS.

3. The database management system allows the small as well as big organizations to get their needs fulfilled, which is not so in case of the file management system that can only serve the smaller ones.

Uses of the DBMS

DBMS is being used extensively in the following sectors:

Management: Whether it is sales, or human resource or finance, DBMS finds use in all these management areas. In sales, one needs to keep records of the customers and their details, products sold, prices and other sales related information. For finance, information about the stocks and financial instruments is stored. In human resource management, the employees’ information, their work details, and salaries have to be stored.

Airlines: Customer information, their reservation details and the schedules of the flights have to be managed. So it is important to keep the records of all these. Database management system forms a base for the data and information records that help them to maintain the work smoothly.

Banking: Banking is dependent upon the DBMS to a great extent. It helps store customer details and details of loans, deposits, payments, and salaries.

Another area of use of the database management system is telecommunication, where it helps maintain records of calls, bills, and balance.

Types of DBMS

There are basically four types of database management system. These are:

Hierarchical DBMS: The data is stored in a structure like that of a tree. It can be from top to bottom or from the bottom to the top.

Object-oriented DBMS: Here the data is stored in the form of objects. Hence this database is a collection of objects.

Network DBMS: In this type of DBMS, the data is inter-related and in connection with each other. It’s not like the tree-structured model, where a child could have only one parent.

Relational DBMS: This one is the most used database management system, as it makes the work easier.

Conclusion

The database management system has proved to be greatly useful in all major organizations. It helps maintain security in storing huge amounts of data. Dealing with the same data is easier due to DBMS characteristics. It has saved time, money and effort. If you like this information then please share it with your mates so that they could also increase their knowledge.

If you have any doubts then write to us on our contact us page directly in the comment section below. We will definitely answer your question.

ACH Money Transfer-Types, Cost, Speed – Full Guide

Computer Full Forms | And It’s Parts

What Is Optical Fiber? Types And Uses

10 Best Shoe Brands In The World 2019

Electronic Fund Transfer | Types | Advantages

Leave a Reply

Your email address will not be published. Required fields are marked *