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

IBM Db2 on Cloud vs SingleStore comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Aug 12, 2024

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 on Cloud
Ranking in Database as a Service (DBaaS)
11th
Average Rating
8.6
Reviews Sentiment
7.3
Number of Reviews
2
Ranking in other categories
No ranking in other categories
SingleStore
Ranking in Database as a Service (DBaaS)
7th
Average Rating
8.8
Reviews Sentiment
7.4
Number of Reviews
6
Ranking in other categories
Vector Databases (13th)
 

Mindshare comparison

As of April 2025, in the Database as a Service (DBaaS) category, the mindshare of IBM Db2 on Cloud is 1.0%, up from 0.8% compared to the previous year. The mindshare of SingleStore is 1.7%, up from 0.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Database as a Service (DBaaS)
 

Featured Reviews

FM
Multi-node architecture and it is good from a security point of view
I would rate the stability a seven out of ten. Most of the issues we faced during troubleshooting were due to specific bugs in the environment, and the only solution was to upgrade the database environment or services. But it is not easy to upgrade the database level when third-party applications are involved, as they are not always comfortable with upgrading. There should be some cumulative solution provided by IBM for their customers, just like other vendors. Upgrading to a certain version doesn't always resolve the issue. It might get resolved at the database level, but what about the other applications integrated with that database that are only compatible with older versions?
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

"Multiple business departments rely on reports and predictive analysis to make decisions for future business based on their data warehouse and Db2 network analytics tool. It helps our business department make decisions."
"The reliability is the most valuable feature. It is also user-friendly."
"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 product can automatically reinstall and reconfigure in case of a shutdown."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"The paramount advantage is the exceptional speed."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
 

Cons

"In other environments like Oracle or Teradata, they provide their own solutions for troubleshooting issues. They provide built-in AI services or autonomous databases, which I don't see in the Db2 environment."
"I would give their support a ten if they had more tutorials available."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."
"Having the ability to migrate servers using a single command would be extremely beneficial."
"We don't get good discounts in Pakistan."
"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."
"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."
 

Pricing and Cost Advice

Information not available
"Using it for analytical purposes can be cost-effective in the long run, especially in terms of infrastructure."
"The product's licensing is not expensive. It is comparable."
"They have two main options: cloud installation and bare-metal installation, each with different pricing models."
"SingleStore is a bit expensive."
"I would advise users to try the free 128GB version."
report
Use our free recommendation engine to learn which Database as a Service (DBaaS) solutions are best for your needs.
846,617 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
No data available
Financial Services Firm
33%
Computer Software Company
13%
Manufacturing Company
5%
Healthcare Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What needs improvement with IBM Db2 on Cloud?
In other environments like Oracle or Teradata, they provide their own solutions for troubleshooting issues. They provide built-in AI services or autonomous databases, which I don't see in the Db2 e...
What advice do you have for others considering IBM Db2 on Cloud?
Since I have worked with almost every product, including IBM, Teradata is far better than any other data warehouse product. It's a separate database with its own features, architecture, and working...
What is your primary use case for IBM Db2 on Cloud?
It's a multi-node logical database clustered in three physical nodes. We use a lot of services already provided in our private cloud environment. It's a multi-node architecture.
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

 

Overview

 

Sample Customers

Owens-Illinois, KONE Corp., Cambridgeshire Fire and Rescue, Canon Europe, Delhaize America, Wimbledon
6Sense, ADNOC, Adobe, Akamai, CARFAX, Cigna, Cisco, Comcast, DBS Bank, Dell, Dentsu, EY, FirstEnergy, GE, Goldman Sachs, Heap, Hulu, IMAX, Kakao, Kroger, LG, LiveRamp, Lumana, NBC, OpenDialog, Outreach, Palo Alto Networks, PicPay, RBC, Samsung, Siemens, SiriusXM, SK Telecom, SKAI, Sony, State Street Financial, STC, SunRun, TATA, Thorn, and ZoomInfo.
Find out what your peers are saying about IBM Db2 on Cloud vs. SingleStore and other solutions. Updated: April 2025.
846,617 professionals have used our research since 2012.