Concurrent access and crash recovery:

    1. A DBMS schedules concurrent accesses to the data in such a manner that users can think of the data as being accessed by only one user at a time.
  1. Further, the DBMS protects users from the effects of system failures.

Reduced application development time:

    1. Clearly, the DBMS supports many important functions that are common to many applications accessing data stored in the DBMS.
    2. This, in conjunction with the high-level interface to the data, facilitates quick development of applications.

 

Disadvantages of DBMS

Danger of a Overkill:

  1.  For small and simple applications for single users a database system is often not advisable.

Complexity:

  1.  A database system creates additional complexity and requirements.
  2. The supply and operation of a database management system with several users and databases is quite costly and demanding.

Qualified Personnel:

  1. The professional operation of a database system requires appropriately trained staff.
    Without a qualified database administrator nothing will work for long.

 

Costs:

  1. Through the use of a database system new costs are generated for the system itselfs but also for additional hardware and the more complex handling of the system.

 

Lower Efficiency:

  1. database system is a multi-use software which is often less efficient than specialised software which is produced and optimised exactly for one problem.

 

Back

 

DBMS & SQl by P. Muthulakshmi & v. vanthana