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 the advantages and disadvantages of DBMS. Hope you like it, comment in case of any doubt. Read applications of the array.

28 Comments

  1. Some truly interesting points you have written. Aided me a lot, just what I was looking for : D. Odille Neale Zoes

  2. I have been examinating out a few of your articles and i can state clever stuff. I will surely bookmark your website. Allie Nikolaus Benedetto

  3. Its not my first time to go to see this site, i am browsing this web page dailly and obtain pleasant information from here daily. Diana Elroy Heger

  4. Hi my loved one! I wish to say that this article is amazing, nice written and include approximately all vital infos.

  5. I think the admin of this website is truly working hard
    in support of his website, for the reason that
    here every material is quality based data.

  6. Valuable information. Lucky me I found your site by accident, and I am shocked why this accident didn’t happened earlier! I bookmarked it. Jewell Ee

  7. I really appreciate this post. I have been looking everywhere for this! Thank goodness I found it on Bing. You have made my day! Thank you again

  8. I think the admin of this web site is actually working hard for his web page, as here every data is quality based data. Sharleen Alexandr Johnathan

  9. Hello, I wish for too subscribe for this website to obtain most recent updates, therefore where can i do it please assist. Sean Borden Bergin

  10. Way cool! Some extremely valid points! I appreciate you penning this write-up plus the rest of the website is also really good. Bernardina Morten Klug

  11. People with high intuition are not liked very much, they are secretly admired, but most of the time they are not loved because they do not come to their job, they are also distant to those around them because they know the facts, life for these people is extra difficult and tiring.People with high intuition are not liked very much, they are secretly admired, but most of the time they are not loved because they do not come to their job, they are also distant to those around them because they know the facts, life for these people is extra difficult and tiring.

  12. People with high intuition are not liked very much, they are secretly admired, but most of the time they are not loved because they do not come to their job, they are also distant to those around them because they know the facts, life for these people is extra difficult and tiring.

  13. You made some decent points there. I looked on the internet for the topic and found most guys will agree with your site. Mareah Rossie Elfie

  14. People with high intuition are not liked very much, they are secretly admired, but most of the time they are not loved because they do not come to their job, they are also distant to those around them because they know the facts, life for these people is extra difficult and tiring.

  15. People with high intuition are not liked very much, they are secretly admired, but most of the time they are not loved because they do not come to their job, they are also distant to those around them because they know the facts, life for these people is extra difficult and tiring.

  16. This is my first time go to see at here and i am truly pleassant to read everthing at single place. Van Gar Jacobba

  17. I was just seeking this information for some time. After six hours of continuous Googleing, at last I got it in your site. I wonder what is the lack of Google strategy that do not rank this kind of informative web sites in top of the list. Generally the top websites are full of garbage. Drusie Brendin Sandi

Leave a Comment

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