The advent of cloud computing has provided the means to develop a wide range of new products and services. We can build and run applications and perform analytics in the cloud without installing local software. This article will look at two examples of modern systems that can seamlessly integrate with SingleStoreDB for in-cloud analytics: Apache Spark™️ and MindsDB.
The notebook file used in this article is available on GitHub.» more
What is and what isn’t a hard real-time database system?
by Steve Graves, McObject (guest author), 29 May 2022
Hard real-time does not mean real fast. Database and software vendors have been using the term real-time synonymously with instant or live for years, but for mission- and safety-critical systems it means something else entirely.» more
We show how the most popular DMBS in the DB-Engines Ranking evolved in the last 10 years in form of a bar chart race.» more
SingleStore: The Increasing Momentum of Multi-Model Database Systems
by Akmal Chaudhri, SingleStore (sponsor) , 14 February 2022
Despite predictions of the imminent demise of relational technology over the past few decades, relational technology is as strong today as it has ever been. Savvy relational vendors have added new capabilities, extending their products to meet new requirements. Enter the era of multi-model database systems that provide business and technical benefits. SingleStore is in the vanguard of multi-model, distributed relational database systems. We'll discuss some of its capabilities in this article.» more
Extending database applications with a smart proxy
by Max Tardiveau (guest author), 7 February 2022
Using the connection between database clients and database servers as a leverage point.» more
Snowflake is the database management system that gained more popularity in our DB-Engines Ranking within the last year than any of the other 383 monitored systems.
We thus declare Snowflake as the DBMS of the Year 2021.
Data processing speed and reliability: in-memory synchronous replication
by Vladimir Perepelytsya, Tarantool (sponsor) , 9 November 2021
Despite the current difficult economic climate, large companies continue digitalizing their businesses. Mobile apps and personal dashboards have become indispensable service and communication channels, significantly increasing the load on IT infrastructure. There are many ways to deal with this load by improving system performance. One of the options is to use in-memory technology. But can it guarantee sufficient reliability?» more
Percona's Matt Yonkovit shares his view on why PostgreSQL is currently the hottest database in town, how liberal licensing has led to mass adoption, and why you should consider a switch to PostgreSQL.» more
Cloudera's HBase PaaS offering now supports Complex Transactions
by Krishna Maheshwari (sponsor) , 11 August 2021
Cloudera announced the general availability of the CDP Operational Database Experience (COD) on both AWS & Azure in February and recently announced support of full ACID capabilities within the relational mode of the Operational Database.» more
We have added Spatial DBMSs as a new DBMS category.» more
How the vector search engine Weaviate overcomes the limitations of popular Approximate Nearest Neighbor (ANN) libraries.» more
If we add up all the popularity scores of the 185 open source DBMSs in the DB-Engines ranking, then we get, for the first time, a higher score than the commercial counterparts.» more
PostgreSQL is the database management system that gained more popularity in our DB-Engines Ranking within the last year than any of the other 360 monitored systems.
We thus declare PostgreSQL as the DBMS of the Year 2020.
Evaluating Hbase and Aerospike Solutions for Real-time System of Record
by Srini Srinivasan, Aerospike (sponsor) , 17 March 2020
Legacy platforms often cannot meet real-time demands needed for innovation: slower response times cost the business and its customers which leads to bad user experiences. Plus, about a third of companies have failed on big data initiatives because they were too complex, required a large budget, demanded more skills and were not agile enough.» more
MySQL is the database management system that gained more popularity in our DB-Engines Ranking within the last year than any of the other 350 monitored systems.
We thus declare MySQL as the DBMS of the Year 2019.
Cloud-based DBMS's popularity grows at high rates
by Paul Andlinger, 12 December 2019
Cloud-based database management systems are continuously increasing in popularity. We analyze the trends and show the big players.» more
In this post, we review how organizations are integrating graph transactions and analytic processing and then dive deeper into graph algorithms. We’ll provide examples of using graph algorithms on Game of Thrones data to illustrate how to get started. Note that portions of this content have been taken from our O’Reilly book, Graph Algorithms: Practical Examples in Apache Spark & Neo4j, which you can download for free.» more
We recently changed the way we treat the multi-model aspect of database management systems and introduced a new option in the popularity rankings. This article explains the ideas behind.» more
PostgreSQL is the database management system that gained more popularity in our DB-Engines Ranking within the last year than any of the other 343 monitored systems.
We thus declare PostgreSQL as the DBMS of the Year 2018.
GQL - initiating an industry standard property graph query language
by Alastair Green (guest author), 30 May 2018
GQL stands for “Graph Query Language”. GQL doesn’t exist yet: it’s a proposal to create a standard declarative language - designed to live alongside and fit well with SQL - that is specifically designed for the property graph data model.» more
MariaDB has reached a new all-time high in the DB-Engines Ranking, climbing to rank 14, up from rank 18 one year ago and from rank 25 three years ago. That is roughly a tripling of its popularity score in the last three years.» more
PostgreSQL is the database management system that gained more popularity in our DB-Engines Ranking within the last year than any of the other 341 monitored systems.
We thus declare PostgreSQL as the DBMS of the Year 2017.
Azure SQL Data Warehouse, the hub for a trusted and performance optimized cloud data warehouse
by Arnaud Comet, Microsoft (sponsor) , 1 November 2017
Today, with the proliferation of data sources and the need to be data-driven, it is hard for companies to avoid siloed sources of information. Siloed data marts can represent an important increase in cost and potentially business opportunities. Centralizing data to provide more complete datasets to your internal departments, suppliers or customers can become a competitive advantage. In the context of Hub & Spokes, Azure SQL Data Warehouse is optimized to provide the greatest experience as a hub thanks to its native integration with Azure SQL Database and Analysis Services (the spokes).» more
We launched DB-Engines five years ago. This is a little summary of how it started and what we have achieved.» more
The Weight of Relational Databases: Time for Multi-Model?
by Luca Olivari (guest author), 29 August 2017
While computers and software have changed greatly in the past 47 years -- since the start of epic time -- there has been little innovation related to databases. Software requirements have changed dramatically over the past five decades; computing needs are vastly different.
In the 1970s, Intel introduced the first 4004 microprocessor that accessed only 640 bytes of memory. In the same period, the first relational database system was designed. RDBMS was invented from the paramount need to optimize storage and to utilize memory, efficiently. The world was an extremely different place. Almost everything in the computer hardware and software world has changed since then, except for relational databases. Are they still the best solution?» more
In the middle of the big data hype cycle, before IoT was on the top of everyone’s buzz list, before Cloud Native was common lingo and before large enterprises were starting the work to de-silo their infrastructure monitoring and metrics data, Paul Dix, Founder of InfluxData, began building a purpose-built Time Series Platform. Flash forward to today, time series is now the fastest growing database segment, and the market is clearly moving beyond the re-purposed Cassandra and Hbase implementations that defined the segment at that time. The following post is a firsthand account from Paul Dix outlining the problems he witnessed and why he built a modern Time Series Platform.» more
Elasticsearch saw a steady growth of popularity in the last years. It is now not only the most popular enterprise search engine, it is also one of the 10 most popular database management systems.» more
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.» more
The popularity of cloud-based DBMSs has increased tenfold in four years
by Matthias Gelbmann, 7 February 2017
Cloud-based database management systems are still relatively exotic data storage solutions, adding up to only 1.6% of the popularity of the entire DBMS market. This is, however, a tenfold increase in the last four years.» more
Microsoft SQL Server is the database management system that gained more popularity in our DB-Engines Ranking within the last year than any of the other 315 monitored systems.
We thus declare Microsoft SQL Server as the DBMS of the Year 2016.
Find out how to avoid downtime on Black Friday, find the best database design for your site, learn how to leverage Database Load Balancing to get your desired results.» more
The popularity of open source DBMSs, as measured by the DB-Engines Ranking, has reached a new record. We analyze the underlying details.» more
Articles on database technologies are jammed with buzzwords and prophecies of new trends, just like any other technology. We use the collected data of our DB-Engines Ranking to have a look at some of these trends.» more
PostgreSQL passed MongoDB and ranks 4th, only behind the big three DBMS Oracle, MySQL and SQL Server.» more
In a world that is collecting more and more data every day, Time Series DBMS seem to be perceived as particularly useful to deal with the data streams in an increasing number of application scenarios.» more
Enriching Property Graphs with Relationship Objects
by Jans Aasman (guest author), 21 June 2016
In many graph database applications we find that a link between two nodes is quite complex. Conventional property graph databases try to manage the complexity by putting properties on the edges between nodes, but this technique has significant limitations. To overcome the limitations, this article introduces the relationship objects pattern.» more
With the general availability of its new SQL Server 2016 in these days, Microsoft gets a lot of attention and pushes SQL Server’s popularity into a region where it has not been for a long time.» more
Cassandra moves up to rank #7 in the DB-Engines Ranking, overtaking Microsoft Access. Part of its success lies in the fact that it is different.» more
By adding another 4 tools to our DBMS popularity ranking, we now cover 303 tools.» more
MySQL, PostgreSQL and Redis are the winners of the March ranking
by Paul Andlinger, 2 March 2016
While the open-source DBMS show a very good performance in this months ranking, we monitor some popularity drops for the large commercial systems.» more
Big gains for Relational Database Management Systems in DB-Engines Ranking
by Matthias Gelbmann, 2 February 2016
All of the 5 DBMSs that saw the biggest gains last month are relational systems. This confirms a trend we noticed since a half year.» more
Oracle is the database management system that gained more popularity in our DB-Engines Ranking within the last year than any of the other 290 monitored systems.
We thus declare Oracle as the DBMS of the Year 2015.
Learn how you can get involved with the graph database community’s newest collaboration: the openCypher project, an open source query language for graphs.» more
Data Modeling in Document Databases for the RDBMS-Minded
by Cihan Biyikoglu (guest author), 7 December 2015
Data modeling for relational databases uses entity relationship diagrams and normalization, techniques which have evolved to perfection over the years. However data naturally does not exist in this full normalized form in real world applications. Document databases provide flexible primitives like JSON documents for storing entities but this does not mean data modeling is a lost art!» more
The recent DB-Engines Ranking of December 2015 produced some surprises. Several systems, which continuosly showed a very positive trend (e.g. MongoDB, Cassandra, Redis, Neo4j) in the past, lost points in the recent ranking. Other major players, with a rather stuttering trend in the ranking so far, heavily increased their score (e.g. Oracle, MySQL, Microsoft SQL Server). Why did that come?» more
Master Data Management Remains Siloed Without Semantics
by Jans Aasman (guest author), 16 November 2015
As Big Data continues to grow, companies are increasing their commitments to extract every last drop of value from the information they gather. Since siloed data has limited value, organizations are also embracing a more comprehensive strategy of managing data across multiple data domains. But this requires a shift away from traditional Master Data Management (MDM) to broader and more flexible data governance environments that enable enterprises to quickly synthesize diverse data sources that can result in transformative business decisions.» more
Oracle, MongoDB, MySQL, ElasticSearch, Cassandra and MariaDB are the winners in the current ranking.
IBM's DB2 and IBM dashDB show converse performances.» more
Increased popularity for consuming DBMS services out of the cloud
by Paul Andlinger, 2 October 2015
According to the recent DB-Engines ranking, the popularity of Database as a Service offerings almost doubled in the last 12 months.» more
While Amazon as DBMS provider cannot compete in popularity with Oracle, Microsoft or IBM, nor with the leading open source solutions such as MySQL, PostgreSQL or MongoDB, they are a significant market force when it comes to hosted DBMS solutions.» more
MongoDB regained the 4th rank from PostgreSQL this month and is one of the three systems within the top 10 which could improve their score.» more
With the current ranking, we introduced the new category Time Series DBMS and added 15 systems of that kind to our ranking.» more
MySQL is the clear winner of the April ranking, but the various forks do not show a uniform performance.» more
Graph DBMS show an extraordinary momentum and are making their way into enterprises.» more
We have added another 16 systems to our ranking, rounding it up to 256.» more
MongoDB is the database management system that gained more popularity in our DB-Engines Ranking within the last year than any of the other 240 monitored systems.
We thus declare MongoDB as the DBMS of the year 2014.
New DB-Engines Ranking: newcomers, winners & losers
by Paul Andlinger, 3 November 2014
The November ranking presents some interesting newcomers together with winners and losers, which one might not have expected.» more
Nowadays, everything seems to be delivered out of the cloud. We analysed whether that holds true for database systems.» more
Notable DBMS presentation: Yao Yu on how Redis is used at Twitter
by Matthias Gelbmann, 25 September 2014
Building the caching layer at Twitter is not an everyday challenge. Yao Yu presents why and how they are using Redis for that task.» more
The September ranking shows the open source systems MySQL and PostgreSQL as the clear winners of the relational category. But a deeper look into the ranking sources reveals, that jobs are rather offered for the commercial tools Oracle, Microsoft SQL Server and DB2.» more
Some of the systems in our long list of database management systems are not yet that popular, but show a strong upward trend.» more
Enterprise Search Engines are gaining popularity in the database market. Two systems, Solr and Elasticsearch are leading that very special category of DBMS tools.» more
Couchbase has seen a steady growth of its popularity ever since we started our ranking. This month it has advanced to rank #26 out of 221 systems, and it doesn't look like it will stop there.» more
If we split up the popularity scores of the DB-Engines Ranking into open source vs. commercial database systems, the commercial systems are still leading by 59:41. However, that ratio is down from 64:36 at the beginning of last year.» more
While Cassandra achieves its best position ever, other trends are stabilizing in this months ranking.» more
According to the trend to multi-model database systems, we made some changes to our categorization methodology and reclassified a couple of systems.» more
Despite very fierce competition, Redis remains the most popular key-value store and they keep getting stronger.» more
When we look at how much various categories of database management systems increased their popularity last year, Graph DBMSs are the clear winner with more than 250% increase.» more
Based on the popularity ranking, DB-Engines presents new statistics, which show that relational systems currently totally dominate the database market, but NoSQL systems have a strong upcoming trend.» more
By adding another 10 tools to our DBMS popularity ranking, we now cover 204 tools.» more
DB-Engines.com went online exactly one year ago. Time for a little review.» more
Cassandra advances into the top 10 most popular database engines
by Paul Andlinger, 3 September 2013
The top 10 database engines now include two NoSQL systems, after Cassandra gained one rank.» more
MongoDB, the most popular NoSQL database in our ranking, continues to increase its score and rank.» more
We added another 15 DBMS to our ranking.» more
We are often asked why we do not list Hadoop in the DB-Engines ranking. So we provide the way we see it.» more
In the new edition of the DB-Engines Ranking MS Access loses a rank to DB2 and falls back to rank #6.» more
In order to make it easier for you to stay informed about our site, we provide now RSS feeds for our blog and for the DB-Engines Ranking.» more
Sometimes, the changes of popularity over time is more interesting than the absolute values. Therefore, we start presenting historical data of our DB-Engines ranking.» more
We have added several database management systems specialized in data warehousing to our ranking, and Teradata comes out as most popular amongst them.» more
Starting with the February data, we include search engines as new category in our DB-Engines ranking.» more
Our DB-Engines ranking identifies the most popular DBMS systems in various database model categories
by Paul Andlinger, Matthias Gelbmann, 22 January 2013
We have introduced sub-rankings by spliting up the DBMS systems per database models.» more
Among the top 10 DB engines, only Oracle and Cassandra could increase their popularity score, while MySQL regained rank 2 from SQL Server.» more
After it slipped last month to rank 3 behind MySQL, SQL Server is back to position 2 in our December ranking with a very small difference in the scores.» more
In the new November ranking we have added more than 50 additional database management systems.» more
New DB-Engines Ranking shows the popularity of database management systems
by Matthias Gelbmann, Paul Andlinger, 3 October 2012
Oracle is the most popular DBMS, MongoDB is the most popular NoSQL system.» more