Advantages of DBMS

Database Management System:( DBMS) :-

Fig : Database Management System

Database Management system is a software which is used for manipulation database. Its is a generalized software for keeping computerized record, Which is store information and allows a users to add, delete, change, retrieve and update that information on demand.

DBMS is a collection of programs that enables users to create and maintain database.

Advantages of DBMS:

Because of centralized management and control, the DBMS has numerous advantages. some of these are as follows:

a) Minimal data redundancy :

In a database system, view of different user groups are integrated during database design into a single, logical, centralised structure.

Because of cntralised database DBA the unnecessary duplication of data are avoided.

The total data storage requirement is effectively reduced.

In a database system, however this redundancy can be carefully controlled.

b) Improve security :

Database security is the protection of database from unauthorized users. The databse administrator(DBA) ensures that proper access procedure is followed, including proper authentication schemes for access to the DBMS and additional checks before permitting access to sensitive data.A DBA can define user name and passwords to identify people authorized to use the database.

c ) Enforcement Of Standards :

Database is a central control so that DBA defines and enforces the necessary standards. Standard can be defined for data formats to facilitate exchange of data between systems, naming conventions, display formats,terminology, update procedures, access rules and son on.

d) Improve Data consistency :

DBMS always support to consistence data . It is ensures that any change made to either of the two entries in the database is automatically applied to the other one , this process is known as propagating updates.

e) Efficient data access:

DBMS utilizes a variety of sophisticated techniques to store and retrieve data efficiently. this feature is especially important if the data is stored on external storage devices.

f) Improved data integrity :

Data integrity related to the term data contained in the database is must accurate and consistent. Integrity is usually expressed in terms of constraints.

g) Improve data sharing :

Database is organised centralized repository. The data belonging to the entire organisation it can be shared by all authorized user. Existing application programs allowed to the authorized users can share the data in the database.

Milan Tomic

Hi. I’m Designer of Blog Magic. I’m CEO/Founder of ThemeXpose. I’m Creative Art Director, Web Designer, UI/UX Designer, Interaction Designer, Industrial Designer, Web Developer, Business Enthusiast, StartUp Enthusiast, Speaker, Writer and Photographer. Inspired to make things looks better.