IBM Db2 Database vs SingleStore comparison

"We had a crash of the backup system and the IBM DB2 was always up and consistent. It's robust, and for us, it was always up and running."

"The most valuable feature of the IBM Db2 Database is the ease of use, and the ability to do query writing of any SQL statement and have an output."

"The setup process has become much easier recently."

"it is very stable and runs smoothly once it is deployed and it is almost maintenance-free."

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

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

"Db2 Database has given us good results since we have started to use it. We predominantly use IBM hardware, and this is one of the reasons why we started to use Db2 Database. Db2 Database has a very good HADR capability. High availability resilience is also good in this solution. It also has pureScale, which allows you to upgrade one node to get very good and high-level resilience. If you are using a database on five nodes, you can take one node down, upgrade that, and let that node up. You can then bring the second node down, upgrade that, and so on."

"Some of the most valuable features are the scaling from a small very cheap installation to a very large enterprise installation. In addition, the backups and assistance are good."

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

"The paramount advantage is the exceptional speed."

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

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

"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 initial set up was complex."

"The user interface is not user-friendly."

"The solution's UI hasn't been upgraded. The solution’s UI is an area to improve because the solution was developed long ago."

"There are some issues with Db2's database file system not being readable. The storage could also be increased, and the monitoring could be improved."

"It would be ideal if the solution offered backup functionality. Many similar tools already do, which means Db2 is somewhat behind the curve in terms of what a customer might expect from it."

"It might be slightly slower than other database vendors, but it works well since banks typically do not move quickly with leading-edge technology."

"It would be helpful to have more querying tools and more development tools for us to work easily with Microsoft."

"The solution no longer supports POWER8."

"Having the ability to migrate servers using a single command would be extremely beneficial."

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

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

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

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

"It is expensive."

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

"The total cost of the solution depends upon the PVU licensing"

"Compared to Oracle, it is so much cheaper."

"I would rate the pricing a five out of ten. It's not super expensive, but also not cheap."

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

"Clients are required to purchase a license."

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

"SingleStore is a bit expensive."

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

"The product's licensing is not expensive. It is comparable."