Skip to main content

Advantages and Disadvantages of DBMS

In this article you will know about advantages and disadvantages of DBMS.

Database management system is an efficient way to create, manage and update databases and also is a prolific replacement of the old file systems which were earlier used to store and retrieve records. The DBMS facilitates the users to work with large amount of databases with much ease and efficiency but it is very important to know the advantages and disadvantages of the same before we start working with it. So, let have a look on it.

Also Read: Difference between File System and DBMS

Advantages of DBMS

1. Data Abstraction

This is one of the most required characteristics of any software system and DBMS works quite efficiently in this field too. It hides the unnecessary details from the end user and just shows what is useful to him for completion of his task. Thus, it also reduces the overhead of hidden complexities and makes it an easy system to work with.

2. Data Redundancy Control

Database Management System also removes the redundancy in the record system efficiently by using the ACID  (Atomicity, Consistency, Isolation and Durability) and normalization properties.

3. Minimization of Data Inconsistency

Since the Database Management System reduces the redundancy of the system it also easily makes the system consistent by removing all the inconsistencies.

4. Ease in Data Manipulation

The DBMS uses database manipulative languages such as SQL with commands like SELECT (used for selection of records from one or more tables), INSERT (for insertion of a record into tables), UPDATE (updates the existing information of records) and DELETE (for removing one or more records from a table) to manipulate the information of the database so that it is always easily updated.

5. Data Security

The Database Management System, unlike the former file system comes with a secured login password (separate for admin and the user), through which the user and admin (also for changes) access can be secured up to a large extent.

6. Concurrent Access of Database

Multiple users can access the same database and thus data sharing is made possible easily. Users don’t have to worry about being only at a particular place for using the database; they may use it according to their ease and as per the basic software and hardware requirements of the database.

7. Improved Data Access

The data is stored in a sorted manner which makes the data access very efficient and easy. The user can directly retrieve what he wants to without bothering about the excess and redundant records other than what is required by him. This also saves a lot of time.

8. Data Independence

The data stored in a particular database is totally independent of any other data. We can look for the data of our choice without considering any other data.

Disadvantages of DBMS

1. Increased Cost

In order to have a Database Management System, we need to have a high speed processor along with a large memory size which requires an expensive hardware and hence correspondingly expensive software too.

Also, in order to convert our data into a Database Management System we need to spend a lot which adds on to the cost of the Database Management System.

In order to work with a Database Management System we also require a trained and educated staff and this also requires a good amount.

So, Database Management System results in a costlier system altogether.

2. Management Complexity

Once you have equipped Database Management System it is not a child’s game to manage the same. You need to have good staff with management capabilities; at times it becomes quite complicated to decide from where to pick data and where to save that data.

3. Maintenance Cost

Database Management System also calls for a high maintenance cost which includes the cost to maintain the Database Management System once it is made.

4. Frequency Upgrade/Replacement Cycle

There need to be frequent upgrades and changes in the Database Management System in order to stay up-to-date and in accordance with the latest technological trends and developments in the markets. Sometimes these changes and updating are so fast that the users don’t feel easy working with the systems and even the admin may find it a bit difficult to keep up with the system’s changes (learning new commands and understanding them every time a new update is made).

DBMS is a wide area and before working in this field it is very important how it can be useful to us as per our needs. The above points give a great idea around that prospect.

The post Advantages and Disadvantages of DBMS appeared first on The Crazy Programmer.



from The Crazy Programmer https://www.thecrazyprogrammer.com/2018/12/advantages-and-disadvantages-of-dbms.html
Labels:

Comments

Post a Comment

Popular posts from this blog

Rail Fence Cipher Program in C and C++[Encryption & Decryption]

Here you will get rail fence cipher program in C and C++ for encryption and decryption. It is a kind of transposition cipher which is also known as zigzag cipher. Below is an example. Here Key = 3. For encryption we write the message diagonally in zigzag form in a matrix having total rows = key and total columns = message length. Then read the matrix row wise horizontally to get encrypted message. Rail Fence Cipher Program in C #include<stdio.h> #include<string.h> void encryptMsg(char msg[], int key){ int msgLen = strlen(msg), i, j, k = -1, row = 0, col = 0; char railMatrix[key][msgLen]; for(i = 0; i < key; ++i) for(j = 0; j < msgLen; ++j) railMatrix[i][j] = '\n'; for(i = 0; i < msgLen; ++i){ railMatrix[row][col++] = msg[i]; if(row == 0 || row == key-1) k= k * (-1); row = row + k; } printf("\nEncrypted Message: "); for(i = 0; i < key; ++i) f...
3 comments
Read more

Data Encryption Standard (DES) Algorithm

Data Encryption Standard is a symmetric-key algorithm for the encrypting the data. It comes under block cipher algorithm which follows Feistel structure. Here is the block diagram of Data Encryption Standard. Fig1: DES Algorithm Block Diagram [Image Source: Cryptography and Network Security Principles and Practices 4 th Ed by William Stallings] Explanation for above diagram: Each character of plain text converted into binary format. Every time we take 64 bits from that and give as input to DES algorithm, then it processed through 16 rounds and then converted to cipher text. Initial Permutation: 64 bit plain text goes under initial permutation and then given to round 1. Since initial permutation step receiving 64 bits, it contains an 1×64 matrix which contains numbers from 1 to 64 but in shuffled order. After that, we arrange our original 64 bit text in the order mentioned in that matrix. [You can see the matrix in below code] After initial permutation, 64 bit text passed throug...
Post a Comment
Read more

Accessibility Insights for the Web and Windows makes accessibility even easier

I recently stumbled upon https://accessibilityinsights.io . There's both a Chrome/ Edge extension and a Windows app, both designed to make it easier to find and fix accessibility issues in your websites and apps. The GitHub for the Accessibility Insights extension for the web is at https://github.com/Microsoft/accessibility-insights-web and they have three trains you can get on: Canary (released continuously) Insider (on feature completion) Production (after validation in Insider) It builds on top of the Deque Axe core engine with a really fresh UI. The "FastPass" found these issues with my podcast site in seconds - which kind of makes me feel bad, but at least I know what's wrong! However, the most impressive visualization in my opinion was the Tab Stop test! See below how it draws clear numbered line segments as you Tab from element. This is a brilliant way to understand exactly how someone without a mouse would move through your site. I can easily s...
1 comment
Read more