Try our new research platform with insights from 80,000+ expert users

IBM Db2 Database vs SingleStore comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

IBM Db2 Database
Average Rating
8.2
Reviews Sentiment
6.7
Number of Reviews
75
Ranking in other categories
Relational Databases Tools (6th)
SingleStore
Average Rating
8.8
Reviews Sentiment
7.4
Number of Reviews
6
Ranking in other categories
Database as a Service (DBaaS) (12th), Vector Databases (15th)
 

Mindshare comparison

While both are Databases solutions, they serve different purposes. IBM Db2 Database is designed for Relational Databases Tools and holds a mindshare of 7.5%, up 6.8% compared to last year.
SingleStore, on the other hand, focuses on Database as a Service (DBaaS), holds 2.6% mindshare, up 0.9% since last year.
Relational Databases Tools Market Share Distribution
ProductMarket Share (%)
IBM Db2 Database7.5%
SQL Server15.8%
Oracle Database12.6%
Other64.1%
Relational Databases Tools
Database as a Service (DBaaS) Market Share Distribution
ProductMarket Share (%)
SingleStore2.6%
Amazon RDS20.1%
MongoDB Atlas13.9%
Other63.4%
Database as a Service (DBaaS)
 

Featured Reviews

Michael Raz - PeerSpot reviewer
Efficient access path optimization and performance excellence with helpful support
IBM Db2 for zOS serves as the central database for all the core business applications in the two banks I work with. All applications use Db2 as a data server. We fully implement and utilize most of Db2's functionalities and capabilities for core banking business applications IBM Db2 has…
Yasin Sarı - PeerSpot reviewer
High-speed data processing, seamless scalability, and excellent high availability making it an optimal choice for those prioritizing performance and efficiency in a database solution
There's a noteworthy consideration when it comes to collecting massive amounts of data. It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks. Attempting to use it for direct extraction, for instance, might lead to memory-related challenges. While MySQL version five might lack extensive SQL capabilities, SingleStore also has its constraints, requiring simpler SQL writing. This becomes evident when seeking advanced functionalities like window functions or JSON functions, where SingleStore doesn't offer an extensive toolkit, necessitating a more straightforward approach to SQL.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"IBM Db2 Database has good performance."
"The solution helps secure the database."
"As part of your licensing with IBM, you get access to their case system, which lets you raise incidents related to software or hardware. This system is helpful for problem determination and quickly identifying issues."
"It has a good, stable performance."
"The self-management and optimization features are probably the best on the market"
"The valuable features include access path optimization, excellent performance, a robust locking mechanism, parallelism, and effective buffering in memory."
"​Scales well enough for a relational database."
"When you submit a ticket the response time is quick."
"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"It's a distributed relational database, so it does not have a single server, it has multiple servers. Its architecture itself is fast because it has multiple nodes to distribute the workload and process large amounts of data."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"The paramount advantage is the exceptional speed."
"The product can automatically reinstall and reconfigure in case of a shutdown."
 

Cons

"It might be slightly slower than other database vendors, but it works well since banks typically do not move quickly with leading-edge technology."
"The queries can be difficult for beginners because there are so many. I would like to see more use cases for flow analysis that enable us to correlate the flow with events. Adding this feature in a QI format would be good for beginners."
"IBM Db2 Database could improve in the steps it takes for upgrades. It is not an easy process. The process of upgrading the version is lengthy and requires a lot of time. To make it more efficient, I suggest implementing some automation on the solution side. This will greatly reduce the time required for the upgrade."
"End-to-end encryption specifically is something the solution needs to have in the next release."
"The solution no longer supports POWER8."
"The IBM Db2 Database needs improved support, and there are many difficulties in using it."
"The solution could improve by providing more integration."
"IBM's support isn't as strong as it used to be, especially when it comes to providing fixes."
"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."
"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."
"We don't get good discounts in Pakistan."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
"For new customers, it's very tough to start. Their documentation isn't organized, and there's no online training available. SingleStore is working on it, but that's a major drawback."
"Having the ability to migrate servers using a single command would be extremely beneficial."
 

Pricing and Cost Advice

"We don't see what the specific price of the DB2 license is because we pay for the backup license as a package."
"Compared to Oracle, it is so much cheaper."
"The solution's hardware and subscription model for support are very expensive."
"They are competitive and honest (compared to how peer firms approach licensing conversations). ​"
"Among Microsoft SQL Server, Oracle, and Db2, Microsoft SQL Server is the cheapest one, and Oracle is the most expensive one. Db2 is in the middle. As compared to SQL Server, its price could go down. It will be good for customers."
"The solution's pricing is fine."
"Clients are required to purchase a license."
"I rate the product pricing a nine out of ten."
"The product's licensing is not expensive. It is comparable."
"Using it for analytical purposes can be cost-effective in the long run, especially in terms of infrastructure."
"They have two main options: cloud installation and bare-metal installation, each with different pricing models."
"I would advise users to try the free 128GB version."
"SingleStore is a bit expensive."
report
Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
867,349 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
20%
Manufacturing Company
10%
Government
9%
Computer Software Company
9%
Financial Services Firm
32%
Computer Software Company
12%
Comms Service Provider
6%
University
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business20
Midsize Enterprise13
Large Enterprise48
By reviewers
Company SizeCount
Small Business4
Large Enterprise3
 

Questions from the Community

What do you like most about IBM Db2 Database?
Db2 database scalability and performance capabilities match our database needs. It covers pretty much everything a database administrator or engineer might need.
What is your experience regarding pricing and costs for IBM Db2 Database?
IBM Db2 is an expensive solution. While I am not heavily involved with pricing, additional companies provide capabilities or products like those from BMC, which many installations might also purchase.
What needs improvement with IBM Db2 Database?
The IBM Db2 Database is a good solution, but now there is a high maintenance charge. The IBM Db2 Database needs improved support, and there are many difficulties in using it. We tend to use the clo...
What do you like most about SingleStore DB?
The paramount advantage is the exceptional speed.
What is your experience regarding pricing and costs for SingleStore DB?
Using it for analytical purposes can be cost-effective in the long run, especially in terms of infrastructure. While building an on-premise cluster incurs an initial cost for servers with ample RAM...
What needs improvement with SingleStore DB?
There's a noteworthy consideration when it comes to collecting massive amounts of data. It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation...
 

Comparisons

 

Also Known As

DB2
No data available
 

Overview

 

Sample Customers

Knorr-Bremse, Mizuho Bank Ltd., Australian Government Department of Defence, SCHWENK Zement, Friedhelm Loh Group, YAZAKI Europe Limited, Ekornes ASA, Baldor Electric, VSN Systemen BV, Lion Brewery (Ceylon) PLC, PLANSEE Group, TE Connectivity, Hansgrohe SE, Openmatics, University of Toronto
400+ customers including: 6sense, Adobe, Akamai, Ant Money, Arcules, CARFAX, Cigna, Cisco, Comcast, DELL, DBS Bank, Dentsu, DirectlyApply, EY, Factors.AI, Fathom Analytics, FirstEnergy, GE, Goldman Sachs, Heap, Hulu, IMAX, impact.com, Kroger, LG, LiveRamp, Lumana, Nvidia, OpenDialog, Outreach, Palo Alto Networks, PicPay, RBC, Samsung, SegMetrics, Siemens, SiteImprove, SiriusXM, SK Telecom, SKAI, SONY, STC, SunRun, TATA, Thorn, ZoomInfo.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools. Updated: August 2025.
867,349 professionals have used our research since 2012.