Main DBMS Functions

A DBMS is a set of procedures for :

  • Description of data and data relations.

  • Querying the database.

  • Updating.

  • Data sharing.

  • database data protection.

Today, most RDBMSs use SQL (Structured Query Language) to perform the main functions of a DBMS.

Data description

The DBMS provides a data description language (LDD) for describing data (Type, Length, Nature, etc.), relationships between data, management rules, value domains, etc...

This description is based on a data model.

A data model is a set of concepts used to describe the structure of a database. Most data models include operations for updating and querying the database. The most widely used data model is the relational model.

Data handling

Data Manipulation Language: the DBMS must be equipped with a Data Manipulation Language (DML), enabling data to be added, deleted or modified. It can also be used to query data.

Control (sharing, integrity, confidentiality, security)

Data sharing: access to the same information by several users at the same time. The DBMS includes a concurrency control mechanism based on data locking techniques (to prevent anyone from reading information that is currently being updated, for example).

Data integrity through the definition of data constraints. The DBMS ensures that all constraints are checked each time data is inserted, deleted or modified.

Confidentiality: several users can use a database at the same time, raising the issue of data confidentiality. Data rights need to be managed: read, update, create rights, etc., which can be fine-tuned.

(manage data access).

Security: a database is often vital to the functioning of an organization, and it's unacceptable for a breakdown to jeopardize its long-term operation. DBMSs provide mechanisms to ensure this security.