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