10 popular database management systems (DBMS)

10 popular database management systems

We have collected some of the most popular database management systems (DBMS) nowadays. Let’s start by defining what a database management system is.

What is a database management system?

A database management system (DBMS) is a software used to define, manipulate, retrieve, store and manage data in databases.

To sum up, database management systems are in charge of:

  • Defining rules to validate and manipulate data.
  • Interacting with databases, applications and end users.
  • Retrieving, storing and analyzing data.
  • Updating data.

Popular database management systems

MySQL

MySQL is a free, open source relational database management system (RDBMS). It was initially owned by MySQL AB, before being acquired by Sun Microsystems (part of Oracle Corporation since 2010). MySQL was originally developed by Ulf Michael Widenius, founder of MySQL AB and current lead developer and CTO of MariaDB.

Developer: Oracle Corporation.

Original author: MySQL AB.

Latest MySQL release: MySQL 8.0.28.

MySQL license: GNU General Public License version 2 and proprietary.

MariaDB

MariaDB is a community-developed, free and open source relational database management system. It is a fork of MySQL. MariaDB was originally developed by Ulf Michael Widenius, founder of MySQL AB and current lead developer and CTO of MariaDB.

MariaDB is also included in numerous Linux distributions, such as CentOS, Debian and RHEL.

Developer: MariaDB Corporation Ab and MariaDB Foundation. 

Latest MariaDB release: MariaDB 10.7.3.

MariaDB license: GPL version 2.

Microsoft SQL Server

Microsoft SQL Server is a commercial relational database management system. It is available in multiple editions, divided into three main categories: mainstream, specialized and discontinued editions.

Developer: Microsoft.

Latest Microsoft SQL Server release: Microsoft SQL Server 2019.

Microsoft SQL Server license: proprietary license.

Oracle DBMS

Oracle DBMS is a commercial, multi-model database management system. It is also known as Oracle Database or just Oracle. It is commonly used for running: online transaction processing (OLTP) and data warehousing (DW).

Developer: Oracle Corporation.

Latest Oracle DBMS long-term release: Oracle DBMS 19c.

Latest Oracle DBMS release: Oracle DBMS 21c.

Oracle DBMS license: proprietary license.

PostgreSQL

PostgreSQL is a free, open source relational database management system (RDBMS). It was initially developed as a successor of the Ingres database, developed at the University of California, Berkeley.

Developer: PostgreSQL Global Development Group.

Latest PostgreSQL release: PostgreSQL 14.2.

PostgreSQL license: PostgreSQL license.

MongoDB

MongoDB is an open source, NoSQL, document-oriented database management system. MongoDB Inc. offers an integrated suite of cloud database services, as well as commercial support. This document-oriented database software is commonly used for high-volume data storage.

Developer: MongoDB Inc.

Latest MongoDB release: MongoDB 5.0.5.

MongoDB license: Server Side Public License (SSPL).

Redis

Redis, short for “Remote Dictionary Server”, is an open source, NoSQL, key-value database management system.

Developer: Redis.

Original author: Salvatore Sanfilippo.

Latest Redis release: Redis 6.2.6.

Redis license: BSD 3-clause.

IBM DB2

IBM DB2 is a database management product developed by IBM, formerly known as DB2 for Linux, UNIX and Windows.

Developer: IBM.

Latest IBM DB2 release: IBM DB2 11.5.7.

IBM DB2 license: proprietary license.

Elasticsearch

Elasticsearch is a distributed, RESTful search and analytics engine. It is based on the Lucene library. Elasticsearch is the successor to a previous search engine called Compass, also designed by Shay Banon.

Developer: Elastic NV.

Original author: Shay Banon.

Latest Elasticsearch release: Elasticsearch 8.0.1.

Elasticsearch license: dual-licensed Elastic license and Server Side Public License.

SQLite

SQLite is a public domain database engine that belongs to the embedded, relational database management systems family. It has bindings to many programming languages.

Developer: Dwayne Richard Hipp.

Latest SQLite release: SQLite 3.38.0.

SQLite license: Public domain.

Comparing database management systems

DBMSTypeOperating systemsLicenseWritten in
MySQLRDBMSCanonical, FreeBSD, Linux, MacOS, Solaris and WindowsGNU GPL v2 and proprietaryC and C++
MariaDBRDBMSLinux, MacOS and WindowsGNU GPL v2Bash, C, C++, and Perl
Microsoft SQL ServerRDBMSLinux and WindowsProprietaryC and C++
Oracle DBMSMulti-model database management systemAIX, BS2000, HP-UX, Linux, MacOS and WindowsProprietaryAssembly language, C and C++
PostgreSQLRDBMSFreeBSD, Linux, MacOS, OpenBSD and WindowsPostgreSQL licenseC
MongoDBDocument-oriented databaseFreeBSD, Linux, MacOS and WindowsServer Side Public LicenseC++, JavaScript and Python
RedisKey-value databaseUnix-likeBSD 3-clauseC
IBM DB2RDBMSLinux, Unix-like and WindowsProprietaryAssembly, C, C++ and Java
ElasticsearchSearch and indexLinux, MacOS and WindowsDual-licensed Elastic license and Server Side Public LicenseJava
SQLiteRDBMSAndroid, BSD, iOS, Linux, MacOS, Solaris, VxWorks and WindowsPublic domainC

Top 10 database management systems

Finally, according to DB-Engines ranking, as of March 2022*, these are the top 10 database management systems:

  1. Oracle
  2. MySQL
  3. Microsoft SQL Server
  4. PostgreSQL
  5. MongoDB
  6. Redis
  7. IBM DB2
  8. Elasticsearch
  9. Microsoft Access
  10. SQLite

*DB-Engines ranking is updated on a monthly basis.

Share it on Social Media!