Difference between DBMS and RDBMS

DataBase Management System (DBMS)

Database management systems are specially designed applications that interact with the user, other applications, and the database itself to capture and analyze data. A general-purpose database management system (DBMS) is a software system designed to allow the definition, creation, querying, update, and administration of databases. Well-known DBMSs include MySQL, PostgreSQL, SQLite, Microsoft SQL Server, Oracle, SAP, dBASE, FoxPro, IBM DB2, LibreOffice Base and FileMaker Pro. A database is not generally portable across different DBMS, but different DBMSs can interoperate by using standards such as SQL and ODBC or JDBC to allow a single application to work with more than one database.

A “database management system” is a suite of computer software providing the interface between users and a database or databases. Because they are so closely related, the term “database” when used casually often refers to both a DBMS and the data it manipulates.

Relational DataBase Management System (RDBMS)

A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd, of IBM’s San Jose Research Laboratory. Many popular databases currently in use are based on the relational database model. The most popular RDBMS are Microsoft SQL Server, Oracle, MySQL, IBM DB2 and PostgreSQL.

The three leading open source database management system are MySQL, PostgreSQL, and SQLite.

DBMS vs RDBMS

DBMS vs. RDBMS

  1. Relationship among tables is maintained in a RDBMS whereas this not the case DBMS as it is used to manage the database.
  2. DBMS accepts the ‘flat file’ data that means there is no relation among different data whereas RDBMS does not accepts this type of design.
  3. DBMS is used for simpler business applications whereas RDBMS is used for more complex applications.
  4. Although the foreign key concept is supported by both DBMS and RDBMS but its only RDBMS that enforces the rules.
  5. RDBMS solution is required by large sets of data whereas small sets of data can be managed by DBMS.

Published by Abdul Samad

Having 17+ years of extensive experience in IT industry, enabled to enhance the team performance and maximize customer satisfaction by strategically managing calls and implementing process improvements. Demonstrated ability to solve problems, meets challenging goals, and expedites delivery. Skilled MSSQL administrator guide team during the crisis situation. Apply Creative thoughts process in re-designing the workflow system to eliminate duplication of effort and increase productivity.

Leave a Reply