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 performance of the solution is valuable."
"The solution is easy to install and simple to maintain. The most valuable aspect of the solution is its general user-friendliness for users of all kinds."
"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."
"I like that its true active-active. For example, if there are two instances within a cluster, we can take one of them down and there's no failover or switch over. There's no primary and secondary, it's true active-active. We can take one side down and we can upgrade that with new maintenance or a new version, obviously testing coexistence beforehand, without impacting the business."
"The most valuable features are the simplicity of the database and the access to Db2 and Db2 information."
"It's easy to search and extract data from the warehouse using queries."
"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 solution is stable."
"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"The paramount advantage is the exceptional speed."
"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 GUI interface is not particularly friendly for those who do not have experience with the product."
"The application development requires a Java developer and not every company has these resources."
"Db2 interface could be improved a bit. Comparing it to Oracle, Db2's interfaces could be improved."
"The product needs to improve its configuration and storage."
"There could be more user-friendly tools with features such as drag-and-drop functionality, visual basics, and low-code capabilities."
"Some of the internal rearrangement in the administration is not as straightforward as it is in competing products."
"They should develop its containerized version."
"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."
"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."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
"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."
"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."
"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.