DB-Engines, the world-renowned database popularity leaderboard site, announced that MySQL has been more popular in the DB-Engines rankings over the past year than any of the other 350 monitored database management systems. As a result, MySQL is the dbMS of the year for 2019.
The results are based on the current most recent score (January 2020) and the score difference for January 2019. The final result represents the popularity of a product in 2019. DB-Engines indicates that scores, rather than percentages, are used as dimensions for evaluation to take care of systems that are less popular at the beginning.
DBMS of the Year: MySQL
Twenty-five years ago, when Michael “Monty” Widenius and others began working together to develop MySQL for personal use, one of the most successful open source projects began to write its history. As the original foundation member of the LAMP technology stack for Web development, MySQL quickly became the DBMS solution of choice for many developers.
However, things changed when Sun acquired MySQL in 2008 amid concerns about the future of an open source project controlled by a large commercial company. Two years later, when Oracle acquired Sun again, many even thought it was the decline of MySQL. They see why Oracle is risking being eaten up by MySQL’s commercial DBMS market share to continue to support MySQL’s development. To do this, MySQL founder Monty Widenius created MariaDB, a branch of MySQL. Yes, he also doesn’t seem certain about the future of MySQL.
However, Oracle’s move surprised many people and even did better than expected. Oracle not only created MySQL Enterprise, but still offers a very competitive open source community version. MySQL 8.0 was released in 2018, bringing significant speed improvements and support for NoSQL document storage and JSON. Although the end result was the success of MySQL’s immediate competitors MariaDB and PostgreSQL, it was still popular.
Over the past 8 years, Oracle’s popularity rankings have ups and downs. Also during that time, although its popularity score declined, it was still the 2015 DBMS of the year. By 2019, it’s doing well again. Despite the intense competition, Oracle remains the highest-ranked DBMS in the DB-Engines rankings. Several Gartner reports also confirm Oracle’s leadership, which shows that Oracle is the number one DBMS in multiple categories, and the success of its internal rival MySQL has not changed that.
Runner-up: Microsoft SQL Server
Similar to Oracle, Microsoft SQL Server has been named DBMS of the Year, which is DBMS of the Year in 2016 and has a very high popularity in 2019. SQL Server was second in the 2013 months, while MySQL lost that position. Microsoft SQL Server has also been the undisputed TOP 3 DBMS for many years. Even though Microsoft offers many very successful cloud-based DBMS on its Azure platform, SQL Server remains its flagship product for the time being.
DB-Engines also gives their understanding and analysis for this year’s data. The following represents the views of DB-Engines.
The TOP 3 databases are also the most popular, and they also happen to be very mature relational databases (RDBMS). What does this tell the DBMS market? Does it mark the decline of the NoSQL database?
DB-Engines disagrees with this for two reasons. First, there are very successful NoSQL database systems in the DB-Engines rankings, and they are still popular every year: MongoDB, Elasticsearch, and Redis. And there are many NoSQL database systems outside the top 10 that are doing well.
Second, over the years, the most successful relational databases have changed considerably by merging more and more NoSQL features. For example, TOP 3 databases support the Document Store data model as a secondary model, and Oracle and SQL Server support graph database (Graph DBMS) models. This means that their boundaries are well beyond traditional relational databases. For example, if we need some flexibility in our database system and no longer need to switch to dedicated NoSQL DBMS, you can do both with some of the extensions of RDBMS. As long as there is demand, NoSQL will not disappear, because it has become mainstream.
But on the other hand, systems such as MongoDB, Elasticsearch, and Redis still offer a number of dedicated features and features to ensure that they don’t go out of date any time soon.
DB-Engines DBMS Winner of the Year:
MySQL 2019 PostgreSQL 2018 PostgreSQL 2017 Microsoft SQL Server 2016 Oracle 2015 MongoDB 2014 MongoDB 2013
Finally, let’s look at the January data for the DB-Engines database popularity leaderboard, and the top 20 are:
The trend changes in the TOP 10 database as follows:
Other changes, as well as the full ranking, are available for https://db-engines.com/en/ranking.
Each type of database is ranked as follows:
Top 10 relational databases
Key-Value Database Top 10
Top 10 document databases
Top 10 graph databases
Top 10 in the time series database
DB-Engines ranks database management systems based on popularity, and the rankings are updated once a month. The ranking data is based on 5 different metrics:
Number of keyword searches for Google and Bing search engines
Number of searches for Google Trends
Job searches on the Indeed website
Number of profiles mentioned in keywords on LinkedIn
Number of issues and followers on Stackoverflow
This list analysis is intended to provide a reference to the technical direction of database-related practitioners, which involves ranking sits not based on factors such as the product’s technological sophissande or market share. Regardless of the ranking, choosing the technology that is suitable for the business needs is the most important.