MySQL is the database management system that increased greater notoriety in our DB-Engines Ranking inside the most recent year than any of the other 350 checked frameworks.
We consequently proclaim MySQL as the Database Management System (DBMS) of the Year 2019.
For deciding the DBMS of the year, we subtracted the prominence scores of January 2019 from the most recent scores of January 2020. We utilize the distinction of these numbers, as opposed to a rate, since that would support frameworks with a minor prevalence toward the start of the year.
The outcome is a rundown of DBMSs arranged by the amount they figured out how to expand their fame in 2019, or at the end of the day, what number of extra individuals began to convey about it in one of the manners in which we measure in our system, for instance employment propositions, proficient profile passages and references on the web.
At the point when Michael “Monty” Widenius and others began to create MySQL for individual utilization over 25 years back, the momentous history of one of the best open source ventures started.
As one of the first foundations of the LAMP stack for web advancement, MySQL immediately turned into the go-to DBMS answer for some designers.
Things began to look somewhat tricky when Sun obtained MySQL in 2008, as individuals were worried about the fate of this open source venture heavily influenced by a major business organization. At the point when Oracle procured Sun two years after the fact, many idea that would be the finish of MySQL. For what reason would Oracle keep on supporting the advancement of MySQL and consequently hazard to rip apart the piece of the pie of its business DBMS? Monty Widenius made MariaDB, as the eventual fate of MySQL looked excessively dubious.
In any case, Oracle made a superior showing than many had expected, making the MySQL venture release while as yet giving an aggressive open source network version. MySQL 8.0, discharged in 2018, brought among others critical speed enhancements and improved help for NoSQL record stores and JSON. The outcome is that MySQL continues picking up notoriety, regardless of the achievement of its immediate rivals MariaDB and PostgreSQL.
Second place: Oracle
Prophet had its good and bad times in our notoriety positioning over the most recent 8 years. It lost a touch of its prominence score in that time period, yet it likewise was our DBMS of the year 2015 and had again a generally excellent year in 2019. It remains our top positioned DBMS regardless of savage challenge. Prophets driving position is affirmed by a few Gartner reports, that show Oracle as the #1 DBMS in a few classes, and the accomplishment of its in-house rival MySQL didn’t change that.
Third spot: Microsoft SQL Server
Like Oracle, Microsoft SQL Server is a previous DBMS of the year champ in 2016 with a solid addition in notoriety in 2019. While SQL Server was positioned second in our positioning for a couple of months in 2013 and has lost this situation meanwhile to MySQL, it stayed an undisputed top 3 framework consistently. Microsoft additionally offers various exceptionally fruitful cloud-put together DBMSs with respect to its Azure stage, yet SQL Server remains its leader item for now.
The main 3 DBMSs in our fame positioning are likewise the ones with the greatest prominence additions, and every one of them are entrenched RDBMSs. What does that say about the DBMS advertise?
Does this sign the end of NoSQL?
We don’t think so for two reasons. To start with, there are fruitful NoSQL frameworks in the main 10 of our positioning, which are as yet picking up notoriety quite a long time after year: MongoDB, Elasticsearch and Redis, and there are more NoSQL frameworks outside the best 10 that keep on doing well indeed.
Second, the best RDBMSs have changed much throughout the years by consolidating increasingly more NoSQL highlights. The entirety of the best 3 frameworks bolster the Document Store information model as optional models, Oracle and SQL Server additionally bolster the Graph DBMS model. That implies they have broadened their degree well past the customary RDBMS highlights. On the off chance that, for instance, you need some adaptability in your information conspire, you are never again required to change to a devoted NoSQL DBMS, you can have the best of the two universes by simply utilizing some all-encompassing highlights of your RDBMS. On the off chance that you need, NoSQL isn’t vanishing, it has gone standard.
Then again, nonetheless, frameworks, for example, MongoDB, Elasticsearch Redis still give a lot of particular highlights and properties that guarantee they won’t be outdated at any point in the near future.
Past winners of the DB-Engines DBMS of the Year Award:
Microsoft SQL Server 2016
Chosen proclamations on the outcomes:
Andy Mendelsohn, EVP Oracle: “We are glad to see acknowledgment of the developing fame of Oracle Database and MySQL in the DB Engines review with Oracle Database remaining the top positioned DBMS by and large and MySQL winning the DBMS of the Year 2019 honor.
We urge engineers to utilize our Free Autonomous Database on Oracle Cloud to evaluate the most recent Oracle Database merged database advancements, for example, Blockchain tables, significantly better SQL on JSON information, improved ML and chart calculations (presently free with all Database Editions), and much better IoT support.”
We compliment MySQL, Oracle and Microsoft SQL Server on their achievement in 2019.