DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Informationen zu relationalen und NoSQL DatenbankmanagementsystemenEin Service von solid IT

Blog > Post

The struggle for the hegemony in Oracle's database empire

von Paul Andlinger, 2. Mai 2017
Tags: Microsoft SQL Server, MySQL, Oracle

Oracle's flagship RDBMS and its open source competitor MySQL fight for being the most popular database management system. But the DB-Engines ranking indicates that other systems may benefit from this race.

Since the beginning of the DB-Engines popularity ranking, we list the Oracle RDBMS as the most popular of currently 327 monitored database management systems.

Oracle MySQL Trend

However, since January 2016, we measure a negative trend for the Oracle RDBMS, while we see a popularity gain in the same period for MySQL (the leading open source DBMS) and it seems to be only a question of time, when MySQL will pass Oracle and become the leader in the DB-Engines ranking. That comes despite the fact, that also MySQL’s popularity decreased during the last quarter, allowing Microsoft SQL Server (the number 3 of the ranking) to reduce the gap to both Oracle-owned systems.

 

Monthly popularity gains/drops

The above diagram shows the gains/drops for Oracle and MySQL for each month since January 2016. We see that in these 17 months Oracle could improve its popularity score in only 2 months (decreasing in 15) and MySQL exhibits a rather inconclusive trend (8 gains vs 9 drops). It is interesting to note, that 11 months show Oracle and MySQL having an opposite trend - one system winning, the other losing. This statistical peculiarity could lead to the a bit farfetched conclusion that Oracle and MySQL are somehow cannibalizing each others popularity.

A short parenthesis to SQL:

Given that you have a simple table with 2 columns, a timestamp and a score, how would you write a SQL statement to calculate the differences of the score between consecutive timestamps, as required for the diagram above? A fixed interval of the timestamps should not be assumed.

The not very familiar SQL window functions, introduced with standard ANSI/ISO SQL 2003 and 2008 (ANSI/ISO SQL documention) are extremely helpful for that type of queries. In MySQL, which does not support these functions, you need to code a workaround.





Teilen sie diese Seite mit ihrem Netzwerk

Featured Products

SingleStore logo

Build AI apps with Vectors on SQL and JSON with milliseconds response times.
Try it today.

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Ontotext logo

GraphDB allows you to link diverse data, index it for semantic search and enrich it via text analysis to build big knowledge graphs. Get it free.

Präsentieren Sie hier Ihr Produkt