JavaRush /Java Blog /Random EN /PYPL index: Oracle is the most popular DBMS, while Fireba...

PYPL index: Oracle is the most popular DBMS, while Firebase is growing alarmingly fast

Published in the Random EN group
If you are planning to participate in any serious development, knowing databases is vital. They are everywhere, even if you don't know it. The PYPL ranking , which calculates the popularity of programming languages , IDEs and databases, identifies 14 database management systems used by at least 1% of users. PYPL indexes popularity based on the number of queries in Google search. As of October 2017, Oracle remains the most popular database, with a score of 32.26%, according to the processing of the collective intelligence results. PYPL index: Oracle is the most popular DBMS, and Firebase is growing alarmingly fast - 1This cross-platform DBMS is the elder of the database world. It's hard to believe, but the first version, which for reasons unknown to us is called Oracle v2, was released back in 1979. The newest to date - Oracle 12.2 - in September 2016. The Oracle database is most commonly used by large companies, but there is also a free version if you want to practice and then find a job related to the "adult" version. It's called Oracle Database Express Edition and can be downloaded from the Oracle website . Of course, it has a large number of limitations (it uses up to 1 GB of RAM, only 1 processor, only one DB up to 11 GB).
PYPL index: the most popular DBMS is Oracle, and Firebase is growing alarmingly fast - 2
Second place went to MySQL . Those who studied databases at university or tried to master them on their own, most likely used this free database. This is an interesting solution for medium and small applications, now also owned by Oracle. By the way, MySQL passed into the possession of this company along with our favorite language Java, in the process of acquiring Sun Microsystems. According to PYPL, MySQL is of interest to 21.15% of the total number of users or programmers.
PYPL index: the most popular DBMS is Oracle, and Firebase is growing alarmingly fast - 3
In third place with comfort and 16.78% is Microsoft's SQL Server. This DBMS is great for managing databases of various sizes, from personal to Enterprise. It has also been on the market for a very long time, albeit a decade less than Oracle: April 24, 1989 is considered to be its date of birth. Like the vast majority of Microsoft products, SQL Server is paid(in the case of the Enterprise version, even very paid), but there are also free options. The simplest of these is SQL Server Express, which is well suited for educational purposes and can be deployed on small servers or ordinary computers. The database size is up to 10 GB. There is also a free version for programmers. It is intended for creating, testing and demonstrating an application based on a "real" SQL Server. The Microsoft product is followed by PostgreSQL by a wide margin . This open-source development of the University of California at Berkeley has long been in the shadow of its competitors, but in recent years its share has been slowly but surely growing. And all thanks to its free, easy extensibility and a system of built-in programming languages.
PYPL index: the most popular DBMS is Oracle, and Firebase is growing alarmingly fast - 4
Fifth and sixth places went to non-relational databases MongoDB and a very young Firebase. Interest in both is clearly growing, especially in Firebase: compared to October last year, interest in it grew by 1.4% and now its result is 2.19%. Rounding out the top ten are SQLite, elasticsearch, Apache Hive and DB2.

PYPL rating of DBMS popularity, October 2017 and growth compared to October 2016

Rank change database share trend
1 Oracle 32.26% -2.7%
2 MySQL 21.15% -0.7%
3 SQL Server 16.78% -0.7%
4 PostgreSQL 3.65% +0.4%
5 MongoDB 3.34% +0.4%
6 ↑↑↑↑↑↑ firebase 2.6% +1.4%
7 SQLite 2.19% -0.0%
8 elasticsearch 2.1% +0.5%
9 Apache Hive 1.99% +0.2%
10 ↓↓↓ DB2 1.89% -0.0%
Have you already worked with DBMS? If yes, with what?
Comments
TO VIEW ALL COMMENTS OR TO MAKE A COMMENT,
GO TO FULL VERSION