Describe The Advantages Of DBMS?

There are some features of a database management system which make it attractive for using a DBMS in preference to other systems. They are given below:

They are Centralized data management, Data independence, and Systems integration.

In a database system, the DBMS manages the data and all access of data is through the DBMS providing a key to effective data processing. It contrasts with conventional data processing systems where each application program has a direct access to the data when it reads or manipulates it.

In the conventional data processing application programs, the programs are usually based on extensive knowledge of data structure and format. In such an environment any change in data structure or format would entail appropriate changes to the application programs. If major changes are to be made to the data, the application programs may have to to be rewritten.

The database management system provides the interface between the application programs and the data, in a database system. When there are changes made to the data representation, the metadata maintained by the DBMS is altered but the DBMS continues the process of providing data to application programs in the previous used ways. The wherever it is necessary, DBMS handles the task of transforming of data.

The independence between programs and the data is called data independence. It is important because every time some change is required to be made to the data structure. The programs that were being used before the change would go on to work. For providing a high degree of data independence, a DBMS must take account of a sophisticated metadata management system.

In DBMS, all files are integrated into one system to reduce redundancies and make the data management system more efficient. DBMS also provides centralized control of the operational data. There are some of the advantages of data independence, integration and centralized control:

Redundancies and inconsistencies can be reduced by using it. It provides better service to the Users. Flexibility of the system is also improved.

Cost of system development and maintenance is lower than the other. Standards are enforced. Security system and integrity can be improved. Project requirements can be identified and data model are developed.

Advantages of DBMS are given below.
(1) DBMS provides "Potential for Enforcing Standards". In large organization, database approach allows a Database Administrator to define standards as well as gives freedom of enforcing standards among database users. In a centralized database environment, it is easy for a DBA to enforce standards than in those environments where each user has control over his own files.

(2) DBMS Provides "Reduced Application Development Time". No doubt it takes more time for designing a database than making a single application but once a database is created then it becomes very easy to make new application by using facilities provided by DBMS.
(3) DBMS provides flexibility. To the requirements we have to do changes in database. Using DBMS, we can change the structure of database and advantage is that it will not affect on the existing database.

(4) When a single user modifies the database then all the other users of database can see this modification (update).
(5) DBMS provides multiple user interfaces.
(6) DBMS provides storage structure for Efficient Query Processing.
(7) DBMS provide a mechanism for controlling redundancy.
(8) DBMS provides backup and recovery.
(9) DBMS enforce integrity constraints.
(10) DBMS provides Persistent storage for program objects.

Security is important advantage of DBMS.
Next, We may see data in different view...
Example:
  All the Bank Database can't see by the Pune. But some of the details about the clients of the bank like name and addresses may see by the pune.
  But entire database can view by the manager of the Bank.
  This will done with the help of db.



Data Integrity
Functional Dependency....