DBMS

A Database Management System (DBMS) is a set of services (software applications) that allow databases to be managed, i.e. to provide easy access to data, to allow multiple users to access the information and to manipulate the data in the database (insert, delete, modify). Many DBMS exist, such as Filemaker, Microsoft Access, MySQL and Oracle.

DBMS Architecture (Server-Client Type)

A Relational Database Management System (RDBMS) – also called a database server – is an advanced version of a DBMS. Unlike a DBMS, which manages the databases on the computer network and hard drives, an RDBMS maintains the relationships between its tables. This offers several advantages, such as speed and flexibility in handling a large volume of information. Tables are linked by relationships that make it possible, by means of a query, to combine data between several tables. Queries use the SQL.