Skip to main content

Database and SQL Definitions

DBMS (Database Management System)​

A Database Management System (DBMS) is software responsible for creating, managing, and manipulating databases.
It provides an interface between the data, users, and applications, enabling efficient and secure storage, querying, updating, and deletion of data.

Main Functions of a DBMS​

  • Store and organize data
  • Control access and security
  • Handle backup and recovery
  • Ensure data integrity and consistency
  • Support transactions

Examples of DBMS​

  • MySQL
  • PostgreSQL
  • Oracle Database
  • Microsoft SQL Server
  • MongoDB

RDBMS​

A Relational Database Management System (RDBMS) is a specific type of DBMS based on the relational model, where data is organized in tables (rows and columns) and relationships are defined through primary and foreign keys.

Main Characteristics of an RDBMS​

  • Table-based data structure
  • Support for SQL (Structured Query Language) to query and manipulate data
  • Referential integrity through primary and foreign keys
  • Support for ACID transactions (Atomicity, Consistency, Isolation, Durability)
  • Strong guarantees of data integrity and consistency

Examples of RDBMS​

  • MySQL
  • PostgreSQL
  • Oracle Database
  • Microsoft SQL Server
  • SQLite