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."IBM DB2 pureScale Feature is valuable."
"It's easy to search and extract data from the warehouse using queries."
"The solution's initial setup is straightforward."
"The self-management and optimization features are probably the best on the market"
"The solution's security is very tough and impenetrable."
"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."
"Db2 database scalability and performance capabilities match our database needs. It covers pretty much everything a database administrator or engineer might need."
"The stability of IBM Db2 Database is stable. We have not faced any downtime in one year. Our work is mostly during business hours and during that time, we haven't faced any downtime."
"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 most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"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 product can automatically reinstall and reconfigure in case of a shutdown."
"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"The product needs to improve its configuration and storage."
"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."
"Its process of building up queries could be more accessible."
"End-to-end encryption specifically is something the solution needs to have in the next release."
"The initial setup could be improved."
"We just want a bit more integration with Linux. That said, we are already seeing Linux more readily available on the mainframe environment."
"It would be helpful to have a hybrid data storage facility that includes NoSQL technologies."
"Do not use support. Freely available documentation is a bit weak."
"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."
"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."
"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."
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 CockroachDB, whereas SingleStore is most compared with SQL Server, MySQL, Teradata, CockroachDB and Amazon RDS.
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.