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?
Introduction:
• 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
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
FDMA vs TDMA vs CDMA
FDM vs TDM
CDMA vs GSM