Most Popular Databases In The World
March 26, 2020
Do you wonder which database is the most popular database in the world? Is it MySQL or SQL Server or Oracle? The following table Lists world's most popular databases with their rankings. Higher score means higher ranking.
The most popular database in the world is Oracle according to DB-Engine ranking. Oracle is followed by MySQL, SQL Server, PostgreSQL, and MongoDB in the ranking.
The following table lists world’s most popular databases and their rankings.
The following table lists world’s most popular databases and their rankings.
| Database | Rank | |
| 1 | Oracle | 1268.84 |
| 2 | MySQL | 1154.27 |
| 3 | Microsoft SQL Server | 1040.26 |
| 4 | PostgreSQL | 466.11 |
| 5 | MongoDB | 387.18 |
| 6 | IBM Db2 | 179.85 |
| 7 | Redis | 149.01 |
| 8 | Elasticsearch | 143.44 |
| 9 | Microsoft Access | 141.62 |
| 10 | SQLite | 126.8 |
| 11 | Cassandra | 122.98 |
| 12 | Splunk | 81.43 |
| 13 | MariaDB | 78.82 |
| 14 | Teradata | 76.19 |
| 15 | Hive | 69.91 |
| 16 | Solr | 61.48 |
| 17 | HBase | 60.39 |
| 18 | FileMaker | 57.15 |
| 19 | SAP HANA | 56.64 |
| 20 | Amazon DynamoDB | 55.09 |
| 21 | SAP Adaptive Server | 55.04 |
| 22 | Neo4j | 46.8 |
| 23 | Couchbase | 34.59 |
| 24 | Memcached | 29.54 |
| 25 | Microsoft Azure SQL Database | 27.2 |
The DB Engines score is calculated based on the following factors,
- Number of results in Google, Bing, and Yandex search engines
- Frequency of searches in Google Trends
- Frequency of technical discussions on the well-known IT-related Q&A sites Stack Overflow and DBA Stack Exchange
- The number of job offers on Indeed and Simply Hired.
- Number of profiles in professional networks including LinkedIn and Upwork.
- Mentions in Twitter tweets.
#1. Oracle
Oracle developed by Oracle Corporation is the most popular relational database system (RDBMS). Not only Oracle is a RDBMS, but also provides functionality for Cloud, Document Store, Graph DBMS, Key-value storage, BLOG, and PDF Storages. Recently. Oracle just announced autonomous feature that allows database to be intelligent and self-managed.
The current version of Oracle Database is 18c.
Oracle database is a relational database (RDBMS). Relational databases store data in a tabular form of rows and columns. Column of a database table represents the attributes of an entity and rows of a table stores records. An RDBMS that implements object-oriented features such as user-defined types, inheritance, and polymorphism is called an object-relational database management system (ORDBMS). Oracle Database has extended the relational model to an object-relational model, making it possible to store complex business models in a relational database.
One characteristic of an RDBMS is the independence of physical data storage from logical data structures.
In Oracle Database, a database schema is a collection of logical data structures, or schema objects. A database user owns a database schema, which has the same name as the user name.
Schema objects are user-created structures that directly refer to the data in the database. The database supports many types of schema objects, the most important of which are tables and indexes.
A schema object is one type of database object. Some database objects, such as profiles and roles, do not reside in schemas.
#2. MySQL
MySQL is world’s most popular database that is open source and free. MySQL was acquired by Oracle as a part of Sun Microsystems acquisition in 2009.
In MySQL, the SQL part of “MySQL” stands for “Structured Query Language”. SQL is the most common standardized language used to access databases. Depending on your programming environment, you might enter SQL directly (for example, to generate reports), embed SQL statements into code written in another language, or use a language-specific API that hides the SQL syntax.
Key properties of MySQL:
- MySQL is a database management system.
- MySQL databases are relational.
- MySQL software is Open Source.
- The MySQL Database Server is very fast, reliable, scalable, and easy to use.
- MySQL Server works in client/server or embedded systems.
#3. SQL Server
SQL Server database developed by Microsoft is one of the most popular databases in the world. Initially launched in 1989 and written in C, C++, SQL Server is now widely used among major companies. SQL Server is also a part of Microsoft’s Azure cloud as Azure SQL Server. The current version of SQL Server is SQL Server 2019.
Similar to Oracle and MySQL, SQL Server is also a relational database management system (RDBMS).
Some popular SQL Server editions are:
Azure SQL Database is the cloud-based version of Microsoft SQL Server, presented as a platform as a service offering on Microsoft Azure.
Compact (SQL CE), the compact edition is an embedded database engine. Unlike the other editions of SQL Server, the SQL CE engine is based on SQL Mobile (initially designed for use with hand-held devices) and does not share the same binaries. Due to its small size (1 MB DLL footprint), it has a markedly reduced feature set compared to the other editions. For example, it supports a subset of the standard data types, does not support stored procedures or Views or multiple-statement batches (among other limitations). It is limited to 4 GB maximum database size and cannot be run as a Windows service, Compact Edition must be hosted by the application using it. The 3.5 version includes support for ADO.NET Synchronization Services. SQL CE does not support ODBC connectivity, unlike SQL Server proper.
SQL Server Enterprise Edition is the main database most companies buy that comes with every product feature.
SQL Server Developer Edition includes the same features as SQL Server Enterprise Edition, but is limited to one license only that is used for development purposes by software developers.