IBM Db2 Database vs SingleStore comparison

Read 6 SingleStore reviews

204 Views
169 Comparison Views

100% willing to recommend

IBM Db2 Database

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between IBM Db2 Database and SingleStore based on real PeerSpot user reviews.

Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools.

To learn more, read our detailed Relational Databases Tools Report (Updated: March 2025).

Relational Databases Tools

March 2025

Download the complete report

Helped 849,963 peers since 2012

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.8

Number of Reviews

Ranking in other categories

Relational Databases Tools (6th)

SingleStore

Average Rating

8.8

Reviews Sentiment

7.4

Number of Reviews

Ranking in other categories

Database as a Service (DBaaS) (7th), Vector Databases (13th)

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.1%, up 6.5% compared to last year.
SingleStore, on the other hand, focuses on Database as a Service (DBaaS), holds 1.7% mindshare, up 0.7% since last year.

Relational Databases Tools

Database as a Service (DBaaS)

Featured Reviews

SimonHiggins

Mainframe Technical Manager/Service Integration Lead at Saudi Business Machines

Very scalable with high availability and excellent technical support

The good thing is that there are improvements coming with later function levels for the z/OS Db2. I'd like it if, with the operating system that we've got, z/OS, on the mainframe, it would allow us to refresh the hardware to run Linux dockers on the mainframe. This means this might give us opportunities for different ways of coming into the Db2 environment in the future. We just want a bit more integration with Linux. That said, we are already seeing Linux more readily available on the mainframe environment. Not only have we got the premium operating systems on OS. We can run LPARs on the same mainframe footprint that is also supporting Linux. This is what has improved and made the mainframe environment more competitive. We're also looking at AI for Db2 as well, and machine learning for the future. We know that AI has come out, that we're going to get that, and we're going to evaluate that product next year for Db2. That said, I haven't got any real complaints about Db2 on the mainframe. For the most part, a lot of the problems we have nowadays are to do with communication between the various teams that you would class as stakeholders.

Read full review

Yasin Sarı

Senior Data Analyst at a comms service provider with 1,001-5,000 employees

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.

Read full review

Quotes from Members

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

Pros

"The solution is very stable, in both hardware and database."

"The most valuable features of this solution are security and stability."

"The most valuable feature of the IBM Db2 Database is security."

"It has a good feature called pureScale, which is just for scalability. It is a perfect solution for environments where scalability is going to be an issue."

"Your iOS, your throughputs, your performance cycles, you cannot touch it with Microsoft or with Oracle scalability-wise. That is far and away the most scalable systems and the highest performing systems of the set of them."

"It's easy to search and extract data from the warehouse using queries."

"It's the best solution in terms of security, performance, and availability because the system is available 24/7."

"It has a good, stable performance."

More IBM Db2 Database pros

"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."

"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."

"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."

"The paramount advantage is the exceptional speed."

"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."

"The product can automatically reinstall and reconfigure in case of a shutdown."

Cons

"The ease of use, or ease of management, could be improved."

"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."

"The solution's data retrieval speed could be improved, especially for heavy queries. Better optimization or indexing might also be involved."

"Their view of it is they're maintaining it, they're continuing to upgrade it, they're continuing to grow it, however, they don't go out and try and sell that as an architectural solution the way they do Linux and Unix."

"The backup solution lacks flexibility."

"Performance is something that can be improved with DB2."

"Db2 interface could be improved a bit. Comparing it to Oracle, Db2's interfaces could be improved."

"IBM Db2 Database is not ACID compliant, which would improve it. Db2 lacks Isolation, so when two people are trying to update the same field at the same time it can become stuck. Other newer databases do not have this issue, such as Microsoft SQL, Oracle DB, PostgreSQL, and SAP HANA."

More IBM Db2 Database cons

"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."

"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."

"We don't get good discounts in Pakistan."

"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."

"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."

Pricing and Cost Advice

"I rate the product pricing a nine out of ten."

"If I consider the price of IBM Db2 Database, I would say there are cheaper products in the market."

"There is a license for this solution and we pay every three years."

"It is expensive. The price depends on the size of the machine on which you are installing the Db2 and the features you are using. It also depends on the country. IBM has different policies and different options for payment for this product."

"Compared to other databases, Db2 is relatively cheaper."

"I rate the price of the IBM Db2 Database an eight out of ten."

"Licensing fees are on a yearly basis."

"It is expensive when compared to other products."

More IBM Db2 Database pricing and cost advice

"Using it for analytical purposes can be cost-effective in the long run, especially in terms of infrastructure."

"SingleStore is a bit expensive."

"I would advise users to try the free 128GB version."

"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."

See which vendors are best for you

Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.

See recommendations

849,963 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Educational Organization

59%

Financial Services Firm

Computer Software Company

Government

Financial Services Firm

32%

Computer Software Company

12%

Manufacturing Company

University

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

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 user interface is old and needs to be improved. It doesn't match the responsive and suggestion-rich UI of cloud solutions. New functions don't come to mind.

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?

SQL Server vs IBM Db2 Database

Comparisons

Compared 32% of the time

Oracle Database vs IBM Db2 Database

Compared 18% of the time

SAP HANA vs IBM Db2 Database

Compared 16% of the time

Teradata vs IBM Db2 Database

Compared 12% of the time

SAP IQ vs IBM Db2 Database

Compared 1% of the time

More IBM Db2 Database Competitors

ClickHouse vs SingleStore

Compared 14% of the time

SQL Server vs SingleStore

Compared 7% of the time

Chroma vs SingleStore

Compared 6% of the time

CockroachDB vs SingleStore

Compared 6% of the time

Teradata vs SingleStore

Compared 6% of the time

More SingleStore Competitors

Product Reports

Download IBM Db2 Database product report

IBM Db2 Database

April 2025

Download SingleStore product report

April 2025

Also Known As

DB2

No data available

Overview

DB2 Enterprise for Linux, UNIX, and Windows is the ideal data server for the most demanding workloads. New XML support is designed to help firms minimize the time and effort it takes to persist and use their XML data reducing development costs and improving business agility.

IBM

SingleStore enables organizations to scale from one to one million customers, handling SQL, JSON, full text and vector workloads — all in one unified platform.

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

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.