Advantages and Disadvantages of DBMS

ADVANTAGES AND DISADVANTAGES OF DBMS

Advantages of DBMS

1. DBMS offers a variety of techniques to store & retrieve data
2. DBMS serves as an efficient handler to balance the needs of multiple applications using the same data
3. Uniform administration procedures for data
4. Application programmers never exposed to details of data representation and storage.
5. A DBMS uses various powerful functions to store and retrieve data efficiently.
6. Offers Data Integrity and Security
7. The DBMS implies integrity constraints to get a high level of protection against prohibited access to data.
8. A DBMS schedules concurrent access to the data in such a manner that only one user can access the same data at a time
9. Reduced Application Development Time

Disadvantages of DBMS

1. Cost of Hardware and Software of a DBMS is quite high which increases the budget of your organization.
2. Most database management systems are often complex systems, so the training for users to use the DBMS is required.
3. In some organizations, all data is integrated into a single database which can be damaged because of electric failure or database is corrupted on the storage media
4. Use of the same program at a time by many users sometimes lead to the loss of some data.
5. DBMS can't perform sophisticated calculations

More topics from DBMS to read:

EasyExamNotes.com covered following topics in these notes.

1. Introduction to Database
2. Introduction to DBMS
3. Advantages and disadvantages of DBMS
4. DML, DDL and DCL
5. Domains
6. Introduction to data models
7. Entities and Attributes
8. Relationship among entities 
9. Tuples
10. Attributes
11. Relation
12. Keys
13. Relational Database
14. Twelve rules of CODD
15. Schemas
16. Integrity Constraints
17. Normalization
18. Functional dependency
19. Transaction processing concepts
20. Schedule
21. Serializability
22. OODBMS vs RDBMS
23. RDBMS
24. SQL join
25. SQL functions: SUM(), AVG(), MAX(), MIN(), COUNT().
26. Block, Extent, Segment
27. Oracle Background processes
28. Trigger
29. Oracle cursor
30. Introduction to Concurrency Control

A list of Video lectures

• Click here

References:

1. Korth, Silbertz,Sudarshan, “Fundamental of Database System”, McGraw Hill
2. Atul Kahate , “ Introduction to Database Management System”, Pearson Educations