Skip to content

What is a Relational Database Management System (RDBMS)?

Relational Database Management System (RDBMS)

Relational Database Management Systems (RDBMS) are the most widely used database management systems in the world. They have been instrumental in the development of modern computing and data management.

An RDBMS uses a relational model to organize and manipulate data. This model represents data as sets of interrelated tables or relations, with each relation consisting of rows (tuples) and columns (attributes). The relational model offers several advantages, including the ability to efficiently store and retrieve large amounts of data, enforce data integrity and consistency, and support powerful querying and reporting capabilities.

In this article, we will provide an introduction, covering the key concepts and components of this type of database system. Whether you’re a database administrator, a developer, or simply interested in learning more about databases, this article will provide you with a solid foundation in RDBMS.

Examples of Relational Database Management Systems

Just to name a few,

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

are Relational Database Management Systems. With their help, you can create, host, and manage your databases.

Read more

The table below briefly describes each of these RDBMS and gives some information about the first and the latest releases. I also provided a few latest features so you could get an idea of what challenges the creators are working on.

LogoLicenseDescriptionReleasesLatest Features
Production and Test environments: Oracle Master Agreement (OMA) or Oracle License and Services Agreement (OLSA)

Development Environment: OTN (free, limited license)
Multi-model database management system produced by Oracle CorporationOracleV2 in 1979
->
Oracle Database 21C, 2021
Automatic Materialized Views, Binary JSON Data Type, Blockchain Tables, Sharding advisor tool, SQL macros, and others
PostgreSQL License (similar to BSD or MIT licenses)Free, open-source system implemented as a post-Ingres project by Michael Stonebraker
PostgreSQL 6.0, 1997
->
PostgreSQL 15.1, 2022
SQL-standard MERGE statement supports Python 3
Proprietary editions:
Enterprise
Standard
Web

Free editions:
Express
Developer
Proprietary, implemented by Microsoft
SQL Server 1.0, 1989
->
SQL Server 2022
Azure Active Directory authentication, Multi-Write Replication, Contained Availability Groups, Query Store Enhancements
GPLFree, open-source. The name comes from a combination of “My” the name of co-founder Michal Widenius’s daughter My and “SQL”MySQL 5.1, 2008
->
MySQL 8.0, 2022
– InnoDB, Optimizer, JSON enhancements
– Table encryption management-
SQLitePublic domain, a license is not requiredBelongs to a family of embedded databases. It means the RDBMS is not a standalone app but a small library of 700 KiB that you can embed to your apps.SQLite 1.0, 2000
->
SQLite 3.40.0 2022
– Full-text searches on documents
– Support creating tables without rowid
Examples of RDBMS

What are relational databases?

Relational databases store their data in tables formed by rows and columns. The place where a row crosses a column is called a field.

The structure of a table in relational databases
Database table structure – rows, columns, and fields

Each table represents some entity from the real world. For example, a University database can contain such tables as Students, Subjects, Teachers, Classes, etc.

Tables in relational databases can contain links to other tables. The links form relations between the tables as entities in the real world do. That’s why this type of database is called Relational Database.

Are RDBMS and Database the same things?

Many people often confuse the terms Database and RDBMS and are far more likely to use the first one than the latter. In fact, these are two very different things. 

A database is a logical unit where your data is stored. Relational Database Management Systems, in contrast, a product that allows you to host your databases, and access and manage them. It defines the internal services, algorithms, and rules of how the database objects are implemented and controlled.

RDBMS can host and handle multiple databases at the same time
RDBMS vs Database

In other words, a database holds and controls data while RDBMS holds and controls the databases.

How many databases can an RDBMS control?

MySQL, PostgreSQL, Oracle

In some Relational Database Management Systems like MySQL and PostgreSQL, you can create as many databases per server instance as you like unless you reach the physical limitations like the memory, storage size of the server, the maximum number of data files, etc.

MS SQL Server

Thus, MS SQL Server does not allow you to have more than 32,767 databases per RDBMS instance. Though you can hardly exhaust this limit, if you do, it is not a problem as SQL Server allows you to detach a database, transfer it to another server and attach it there.

SQLite

As was mentioned before, SQLite is a library rather than a database server, so the limit is related to the maximum number of attached databases per connection. It is 10 by default but can be extended to 125.

How did RDBMS appear?

While each RDBMS is owned by its own company or community, all of them owe their existence to Mr. Edgar Frank Codd, who introduced the relational model in the June of 1972 in his article  “A Relational Model of Data Large Shared Data Banks”.

Conclusion

  • RDBMS stands for Relational Database Management System
  • It is a system providing decent means to host, manage, and access relational databases
  • There are multiple Relational DBMSs. Some popular examples are Oracle, Microsoft SQL Server, MySQL, PostgreSQL, and SQLite.
  • Most management systems are usually installed as Server Software hosting multiple databases of the same type. The embedded DBMS are exceptional as they are represented only by a library you can use to access a database file via special programming API.
  • The history starts from a paper about the relational database model released by Edgar Codd in June of 1980.
  • They make data updates slower and require additional space on disk, though. However, it is another story

3 thoughts on “What is a Relational Database Management System (RDBMS)?”

  1. We use things and rarely think about why they are what they are, don’t we?

    The two of the most popular RDBMS 😎 in the world – MySQL and PostgreSQL have quite a story behind them.

    PostgreSQL was created by Michael Stonebraker, a computer science professor 👨‍🏫 who previously worked on the Ingres database project. The new database engine was supposed to solve the contemporary problems of relational database systems by adding support for multiple data types. It was a revolutionary thing breeding from the Ingres project. As it was a post-Ingres deal, it was called Postgres in 1986. Later, when it began to support SQL, it was renamed to PostgreSQL.

    MySQL, in turn, has quite a sentimental reason to be called like that. One of the co-founders, Michael “Monty” Widenius gave it the name MySQL which was a combination of his daughter’s name ‘My’ and ‘SQL’. Nowadays this name is in second place after Oracle in the list of the most popular RDBMS❕

    Pretty amazing stories aren’t they? 😉
    Stay inspired!

    1. Hahaha, check this out homes, we got ourselves a blog post that’s actually useful for beginners, muy bueno! But let me ask you this, since you’re so good at explaining things: what about database normalization? Can you give us a rundown on that too, or is that too advanced for your taste? Come on, don’t leave us hanging here, manito!

Leave a Reply

Your email address will not be published.