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."Db2's best features are that it's self-maintaining and self-monitoring, which means I have to view and monitor the database far less often."
"We are dealing with millions of transactions a month and the performance is very good."
"The solution's initial setup is straightforward."
"Reliable, robust with great features."
"The most valuable aspect of this solution is its stability. We have never had any problems and have never had to contact technical support."
"It is a scalable solution."
"It's easy to search and extract data from the warehouse using queries."
"Its functionality and availability are valuable. Its availability is great. It is available 99.99% of the time."
"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"The product can automatically reinstall and reconfigure in case of a shutdown."
"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 product's initial setup phase was pretty straightforward, with no complex processes."
"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 solution could improve by providing more integration."
"In terms of improvements, IBM Db2 can improve its interface and its functionality. Also, the embedded functions should be much richer than the current ones - the functions which are embedded in the engine itself."
"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."
"The only drawback that we see in Db2 Database is the crash recovery. When there is a crash and somebody has to do the recovery, Db2 Database first stops, and then it does any crash recovery. In Oracle Database, crash recovery happens within the database. The database is not shut down."
"I would say that the tool has to be made more cloud-friendly and should have agreements with AWS, Microsoft, or Google to run things on hyperscalers."
"Some of the internal rearrangement in the administration is not as straightforward as it is in competing products."
"The licensing fees can be reduced."
"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."
"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."
"The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings."
"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."
"Having the ability to migrate servers using a single command would be extremely beneficial."
IBM Db2 Database is ranked 6th in Relational Databases Tools with 66 reviews while SingleStore is ranked 6th in Database as a Service with 7 reviews. IBM Db2 Database is rated 8.2, while SingleStore is rated 8.8. The top reviewer of IBM Db2 Database writes "Very scalable with high availability and excellent technical support". On the other hand, the top reviewer of SingleStore writes "A reasonably priced product that offers good speed and seamless support". IBM Db2 Database is most compared with SQL Server, Oracle Database, SAP HANA, Teradata and Oracle Multitenant, whereas SingleStore is most compared with SQL Server, MySQL, Teradata, Oracle Database and Imply Polaris.
We monitor all Relational Databases Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.