Concurrent access and crash recovery:
- 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.
- Further, the DBMS protects users from the effects of system failures.
Reduced application development time:
- Clearly, the DBMS supports many important functions that are common to many applications accessing data stored in the DBMS.
- This, in conjunction with the high-level interface to the data, facilitates quick development of applications.
Disadvantages of DBMS
Danger of a Overkill:
- For small and simple applications for single users a database system is often not advisable.
Complexity:
- A database system creates additional complexity and requirements.
- The supply and operation of a database management system with several users and databases is quite costly and demanding.
Qualified Personnel:
- The professional operation of a database system requires appropriately trained staff.
Without a qualified database administrator nothing will work for long.
Costs:
- 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:
- database system is a multi-use software which is often less efficient than specialised software which is produced and optimised exactly for one problem.