Advantages of DBMS:
Controlling of Redundancy: Data redundancy refers to the
duplication of data (i.e storing same data multiple times). In a database
system, by having a centralized database and centralized control of data by the
DBA the unnecessary duplication of data is avoided. It also eliminates the
extra time for processing the large volume of data. It results in saving the
storage space.
Improved Data Sharing : DBMS allows a user to
share the data in any number of application programs.
Data Integrity : Integrity means that the
data in the database is accurate. Centralized control of the data helps in
permitting the administrator to define integrity constraints to the data in the
database. For example: in customer database we can can enforce an integrity that
it must accept the customer only from Noida and Meerut city.
Security : Having complete authority
over the operational data, enables the DBA in ensuring that the only mean of
access to the database is through proper channels. The DBA can define authorization
checks to be carried out whenever access to sensitive data is attempted.
Data Consistency : By eliminating data
redundancy, we greatly reduce the opportunities for inconsistency. For example:
is a customer address is stored only once, we cannot have disagreement on the
stored values. Also updating data values is greatly simplified when each value
is stored in one place only. Finally, we avoid the wasted storage that results
from redundant data storage.
Efficient Data Access : In a database system, the
data is managed by the DBMS and all access to the data is through the DBMS
providing a key to effective data processing
Enforcements of Standards : With the centralized of
data, DBA can establish and enforce the data standards which may include the
naming conventions, data quality standards etc.
Data Independence : Ina database system, the
database management system provides the interface between the application
programs and the data. When changes are made to the data representation, the meta
data obtained by the DBMS is changed but the DBMS is continues to provide the
data to application program in the previously used way. The DBMs handles the
task of transformation of data wherever necessary.
Reduced Application
Development and Maintenance Time : DBMS supports many important functions that are
common to many applications, accessing data stored in the DBMS, which
facilitates the quick development of application.
Disadvantages
of DBMS
1) It is bit complex. Since it
supports multiple functionality to give the user the best, the underlying
software has become complex. The designers and developers should have thorough
knowledge about the software to get the most out of it.
2) Because of its complexity and
functionality, it uses large amount of memory. It also needs large memory to
run efficiently.
3) DBMS system works on the
centralized system, i.e.; all the users from all over the world access this
database. Hence any failure of the DBMS, will impact all the users.
4) DBMS is generalized software,
i.e.; it is written work on the entire systems rather specific one. Hence some
of the application will run slow.