Advantages of RDBMS | disadvantages of RDBMS
This page covers advantages and disadvantages of RDBMS and its basics. It mentions benefits or advantages of RDBMS and drawbacks or disadvantages of RDBMS.
What is RDBMS?
• RDBMS stands for Relational Database management system.
• It is relational model in which data is stored in multiple tables where tables are related to each other using primary keys and foreign keys and indexes.
• RDBMS uses database normalization techniques to avoid redundancy in tables. It helps to fetch data faster using SQL query.
• It is widely used by enterprises and software developers to store large amount of complex data.
• Examples: SQL server, Oracle, MySQL, MariaDB, SQLite
RDBMS is one of the types of DBMS, the other types are Navigational, OODBMS, ORDBMS, Hierarchical DBMS and network DBMS. The figure-1 depicts components used in RDBMS.
Benefits or advantages of RDBMS
Following are the benefits or advantages of RDBMS:
➨It is easy to use.
➨It is secured in nature.
➨The data manipulation can be done.
➨It limits redundancy and replication of the data.
➨It offers better data integrity.
➨It provides better physical data independence.
➨It offers logical database independence i.e. data can be viewed in different ways by the different users.
➨It provides better backup and recovery procedures.
➨It provides multiple interfaces.
➨Multiple users can access the database which is not possible in DBMS.
Drawbacks or disadvantages of RDBMS
Following are the disadvantages of RDBMS:
➨Software is expensive.
➨Complex software refers to expensive hardware and hence increases overall cost to avail the RDBMS service.
➨It requires skilled human resources to implement.
➨Certain applications are slow in processing.
➨It is difficult to recover the lost data.