DBMS – Data Base Management System
RDBMS – Relational Data Base Management System or Relational DBMS
A DBMS has to be persistent, that is it should be accessible when the program created the data ceases to exist or even the application that created the data restarted. A DBMS also has to provide some uniform methods independent of a specific application for accessing the information that is stored.
RDBMS adds the additional condition that the system supports a tabular structure of the data, with enforced relationships between the tables. This excludes the databases that don’t support a tabular structure or don’t enforce relationships between tables.
DBMS originated in early 1960s when computers just came into the market. With growing data, it became costlier to store the data. Therefore, Relational DBMS concept came into picture.
1. A DBMS stored data primarily into a file based structure whereas an RDBMS stores data into tables structure where tables are interlinked.
2. A DBMS does not support client server architecture whereas an RDBMS does.
3. Data in stored in hierarchical format in a DBMS but in an RDBMS, tables are linked which helps retrieval of data efficiently.
4. An RDBMS is much more stable, robust and secure as compared to a DBMS.
5. An RDBMS naturally follows normalization whereas a DBMS does not.
6. DBMS Examples: FoxPro, dBase, Libre Office, etc; RDBMS Examples: SQL Server, Teradata, MySQL, etc.
Read More:
- What Is The Difference Between JDBC and ODBC
- Database Optimization Advanced Level Interview Questions
- Difference Between System Software and Application Software
So, naturally an RDBMS is used in companies having large data requirements whereas for companies with a small database requirements where they just need to keep records, a DBMS would be sufficient.
An RDBMS application is comparatively costlier to implement as compared to a DBMS application.