What is an RDBMS?

RDBMS stands for Relational Database Management System.

An RDBMS is a particular type of DBMS that uses a relational model for its databases. An RDBMS therefore enables you to create relational databases.

Relational database management systems have become the most popular type of database system. Most major database management systems are relational. Popular examples include Microsoft Access, SQL Server, Oracle DatabaseMySQL, FileMaker, PostgreSQL, and more below.

A relational database is a  database that allows related data to be stored across multiple tables, and linked by establishing a relationship between the tables. This provides an efficient way to store data, as you can enter data once, then reference it from elsewhere in the database.

This is in contrast to say, a flat-file database where all data resides within a single file with no tables.

Screenshot of one-to-many relationship diagram.
A relational database will typically contain many relationships like this one.

In the above example, the Countries table stores a list of all countries – each country with its own unique CountryId. Because the CountryId is a unique value (i.e. no two countries will share a CountryId), other tables (such as the Person table) can reference a country by using its CountryId. To achieve this, other tables can contain their own CountryId field. Any value in this field must match a value in the CountryId field in the Countries table.

Most modern RDBMSs provide the ability for you to create a relationship either programatically, or via a graphical user interface (GUI). Using the GUI, you can see the relationship represented in a visual diagram.

Here’s how Microsoft Access displays relationships:

Screenshot of a many-to-many relationship in the Relationships tab.
The “Relationships” tab in Microsoft Access showing a many-to-many relationship.

The little key icons represent the primary key of each table. The primary key is an important element of relational database design (as is the foreign key).

Other Data Models

Although the relational model is the most common model in use today, it is not the only model. Other types of DBMSs include:

 

List of RDBMSs

Below is a list of relational database management systems in alphabetical order.

You can see a full list with a description of each RDBMS here.

  • 1010data
  • 4D
  • ActorDB
  • Akiban
  • AlaSQL
  • Altibase
  • Amazon Aurora
  • Amazon Redshift
  • Amisa Server
  • Apache Drill
  • BigObject
  • c-treeACE
  • CitusDB
  • Clustrix
  • Crate.IO
  • Cubrid
  • DaggerDB
  • Datacom/DB
  • DataEase
  • Dataupia
  • Datomic
  • DB2
  • dBASE
  • DBISAM
  • DeepSQL
  • Derby
  • Drizzle
  • ElevateDB
  • Empress
  • EnterpriseDB
  • EXASolution
  • eXtremeDB
  • FileMaker
  • Firebird
  • FrontBase
  • GenieDB
  • Google BigQuery
  • Greenplum
  • H2
  • Hadapt
  • HAWQ
  • HFSQL
  • Hive
  • HyperSQL
  • IBM dashDB
  • Impala
  • InfiniDB
  • Infobright
  • Informix
  • Ingres
  • Interbase
  • ITTIA
  • JethroData
  • JustOneDB
  • K-DB
  • Kdb+
  • Kognitio
  • Linter
  • LucidDB
  • MariaDB
  • MaxDB
  • MemSQL
  • Microsoft Access
  • Microsoft Azure SQL Database
  • Microsoft SQL Server
  • Mimer SQL
  • MonetDB
  • mSQL
  • MySQL
  • Netezza
  • NexusDB
  • NonStop SQL
  • NuoDB
  • OpenBase
  • OpenEdge
  • Oracle
  • Oracle Rdb
  • ParAccel
  • Percona Server
  • Pervasive PSQL
  • PipelineDB
  • Postgres-XL
  • PostgreSQL
  • PrestoDB
  • R:BASE
  • Raima Database Manager
  • Rainstor
  • Realm
  • Red Brick
  • SAP Adaptive Server
  • SAP Advantage Database Server
  • SAP HANA
  • SAP IQ
  • SAP SQL Anywhere
  • ScaleBase
  • ScaleDB
  • ScimoreDB
  • SmallSQL
  • solidDB
  • Spark SQL
  • Splice Machine
  • SQL.JS
  • SQLBase
  • SQLite
  • Tajo
  • Teradata
  • Teradata Aster
  • Tibero
  • TimesTen
  • TokuDB
  • Trafodion
  • Transbase
  • TransLattice
  • Valentina Server
  • Vectorwise
  • Vertica
  • Virtuoso
  • VistaDB
  • VoltDB
  • WebScaleSQL
  • XtremeData