DBMS

Advantage and Disadvantage Of DBMS

DBMS stands for Data Base Management System. In this post, we are going to learn about the Advantage and Disadvantage Of DBMS in simple terms, but before this have a look at Important terminology.

Important Terminology

Database

As the name suggests, Database is a collection of inter-related data which helps the user to perform operations on data in a very easy manner such as insertion, retrieval, update, delete, etc.

Database Management System

Software that is used to manage the database is known as Database Management System Software. Nowadays there are many DBMS software available such as MySql, MongoDB, etc. DBMS helps in efficient organization of data in database.

We are completely covered with data and databases. Let’s take an example you want to order food from any app, then what happens is the database awake. Let you log in by matching your email and password from the data and after that, It shows you all the food available in the database and then you place an order, and then database update their ordered item.

In all this Data Retrieval, Data Matching, Data Updating happens and all this is done in a very efficient way with the help of DBMS.

DBMS allows users the following tasks:

Updating the Data:

This helps user to update, insert, modify, or delete the data from the database.

Retrieving The Data

This helps user to retrieve the data from database, such as list of food available, etc.

User Administration

This is only for administration purpose to track the activity of user, providing security etc.

Now, coming to our actual point that is advantage and disadvantage of DBMS

Advantage Of DBMS

Here, I am going to list 5 advantages of Database Management System

Ease in Accessing Data

Data access refers to user ability to access the data from database.

DBMS provide quick answer or response to query. A query for database is a request issued by the user to update, read, delete or manipulate the data.

Some example of Query for MySql database is

SELECT * FROM User Where user_name = “geeks”;

given query will only show the user details whose username is geeks.

Providing Data Security

securing data from hackers is also very important. Having loopholes in designing the database is not good. So, DBMS provides a way for securing your data like, only authorized user will access the database, Data entered in the database is encrypted by SHA-256 encryption this method is known as Cryptography.

Some of the threats in database are –

  • Availability Loss
  • Integrity Loss
  • Confidentiality loss

Method to safe DBMS from Threats:

  • Authentication – Permit only authorized user to access the data
  • Backups – backups help you in the recovery of the lost data
  • Encryption – such as SHA – 256 encryption also known as cryptography

Multiple Data View

For example, you have your banking app and you want to know balance in your account . you simply know this by checking in your app but if you want to check the balance in your neighbor account, you can’t access to his data because it is hidden from you and only authorized person can access to these.

Different views of same data can be created to cater the needs of different users

In SQL you can create View by using CREATE VIEW syntax. A view can contain all rows of a table or select rows from a table

Providing Data Concurrency and Data Consistency

Relational Database allow you to concurrent access to database.

Data concurrency means any number of users can access the same data at the same time without any hindrance.

Data Consistency means that each user sees a consistent view of data, including visible changes made by the user’s own transactions and transactions of other users.

Cache Fusion and locking mechanism are used for Data concurrency and consistency

Better Decision Making

As the database starts growing, your business start growing, and then you want to use your database to

  1. Keep track of transactions
  2. Provide information that will help the company run the business more efficiently
  3. Help managers and employees make better decisions

So, designing the better database is important for making better decision in future.

Disadvantage Of DBMS

Here, I am going to list 2 Dis-advantages of Database Management System

Increased costs

Creating the database required excellent hardware and software too. For maintaining the Database you will need highly skilled people to operate that will create a good amount of cost. You also need to take care of Training, licensing, and regulatory compliance costs when database systems are implemented.

Maintaining currency

To maximize the efficiency of the database system, you must keep your system current. Therefore, you must perform frequent updates and apply the latest patches and security measures to all components.

Because database technology advances rapidly, personnel training costs tend to be significant. Vendor dependence. Given the heavy investment in technology and personnel training, companies might be reluctant to change database vendors.

This is all about advantage and disadvantage of DBMS. Hope you like it, comment in case of any doubt.

Leave a Comment

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