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."The solution is a very stable relational database and has integration with legacy systems. It is a great product."
"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."
"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."
"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."
"The setup process has become much easier recently."
"IBM Db2 Database has good performance."
"The solution has very good data compression of up to 50%. For example, if you have 50 terabytes of data, it can be reduced to 25 terabytes."
"Scalability-wise, I rate the solution a nine out of ten."
"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 most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"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."
"The product's initial setup phase was pretty straightforward, with no complex processes."
"The paramount advantage is the exceptional speed."
"Do not use support. Freely available documentation is a bit weak."
"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."
"IBM Db2 Database could improve in the steps it takes for upgrades. It is not an easy process. The process of upgrading the version is lengthy and requires a lot of time. To make it more efficient, I suggest implementing some automation on the solution side. This will greatly reduce the time required for the upgrade."
"The technical support team is not very good when compared to the efficiency of Oracle's support."
"Its process of building up queries could be more accessible."
"Not very solid compared to its competitors' products."
"It would be helpful to have a hybrid data storage facility that includes NoSQL technologies."
"IBM Db2 Database could improve the user-defined functions. There are some user-defined functions that are missing, such as the spring functions. I used to have Teradata for my projects and I was used to working in the environment. They had a good set of user-defined functions."
"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."
"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."
"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."
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 Neo4j Graph Database.
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.