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.

Advantages and Disadvantages of other wireless technologies

IrDA    HomeRF    Bluetooth    Radar    RF    Wireless    Internet    Mobile Phone    IoT    Solar Energy    Fiber Optic    Microwave    Satellite    GPS    RFID    AM and FM    LTE   

What is Difference between

difference between OFDM and OFDMA
Difference between SC-FDMA and OFDM
Difference between SISO and MIMO
Difference between TDD and FDD

RF and Wireless Terminologies