Advantages and disadvantages of dbms

Advantages and disadvantages of dbms

Hello friends! Today I will tell you about Advantages and Disadvantage of DBMS in this post, and will also read its example,

What do you mean By DBMS

Advantage of DBMS

Database is a way to consolidate and control the operational data centrally. It is a better way to control the operational data then the one in which data is widely spread across various flat files, as these are difficult to control and manage. A person who will control the consolidated data will also be required in the organization. This person is Data Base Administrator (DBA) who is supposed to be a man with high degree of technical acumanship. He has in-depth knowledge of user’s requirements. DBA role can be performed by a group of people rather than by just one person. The advantages of having a centralized control of data are:

1-Redundancy can be minimized

If each department maintains files of employees individually, it can lead to wastage of space as also considerable redundancy of data. Suppose Administration department has its own file containing administration information, and Finance department contains salary related information about all employees of the organization, the DBA can integrate these two files and eliminate the redundancy.

2-Inconsistency can be avoided

Suppose in the file of Administration department, the designation of employee John is shown as Dy. CSM and if the same for John in department Finance is shown as CSM. then it is an example of inconsistency in the database. Thus, it is clear that if a given fact is represented by a single entry inconsistency can be removed.

3-The data can be shared

The data stored for one application, can be used for another application. Thus, the data of database stored for one application can be shared with new applications.

4-Standards can be enforced

DBA can ensure that company, industry, national and international standards are followed while developing applications For example, in an application written in C, all the data items which are declared as small int, and character, can be declared as

short. int si_x;

Char.       Ch_x;

All declaration of short int can be prefixed with si and those of char type can be prefixed with ch for the programmers to know the type of data items, just by seeing its prefis anywhere in the body of program.

5-Security can be enforced

Once the DBA has full control of operational data, DBA can define the access paths for accessing the data stored in database and he/she can define authorization checks whenever access to sensitive data in attempted.

6-Integrity can be kept intact

Supposing an employee is shown as drawing salary Rs. 10,000/- in Finance Department whereas it is shown that no such employee exists in Administration department when it is updated.

Centralized control of data helps in avoiding such cases, since DBA can define validation procedures to be executed whenever any update operation is done.

Disadvantage of DBMS

1- The cost of software

The cost of database management system software is very high.

2- the cost of hardware

In the hardware of dbms computer, hard disk, server, ….etc these things increase the cost of hardware.

3-complex backup and recovery

DBMS keeps the data centralized, due to which it is very difficult to back up the data or recover it if it fails.

4- Problem of centralization

Security problems arise due to centralizing dbms. And if that centralized database fails, there is no other option left.

5-Database Environment

Implementing backup and recovery operations in the database environment is quite a complex task.

6-Performance

The traditional file system was very good for small organizations as it gave very good performance. But DBMS does not give good performance for small scale firms as its speed is slow and for this reason it is favorable for big companies.

7-Lower Efficiency

There are many software and application programs which are made for any problem. But DBMS is a very useful software which is used for many purposes.

Request:-

If this article has been useful for you, then definitely share it with your friends and classmates, or if you have any question related to other subjects, then tell through comment below. thanks.

Previous articlewhat do you mean by DBMS
Next articleC टोकन क्या है(tokens in c language in hindi)

1 COMMENT

LEAVE A REPLY

Please enter your comment!
Please enter your name here