Database management system (DBMS)

DBMS is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data. DBMS allow the definition, creation, querying, update, and administration of databases. Some of the popular DBMSs are MySQL, Oracle, MariaDB, Microsoft SQL Server, PostgreSQL, MongoDB.

Database systems should have the following properties:

Reliability

Efficiency

Scalability

Concurrency control

Data abstractions

High-level query languages.

Relational database management system (RDBMS)

RDBMS is a type of database management system (DBMS) that lets you create, update, and administer a relational database. It is based on the relational model as invented by E. F. Codd, of IBM’s San Jose Research Laboratory.

One of the feature of RDBMS is that a single database can be spread across several tables. The data are stored into collection of tables, which might be related by common fields. RDBMS also provide relational operators to manipulate the data stored into the database tables. Generally, SQL is used as database query language in RDBMS.