What users are saying about
7 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
28 Ratings
7 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.8 out of 100

SingleStore (formerly MemSQL)

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
28 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 7.7 out of 100

Likelihood to Recommend

Db2 on Cloud

A great product - would not shy away at all. It has some great features that makes it easy to read and write. Their on-memory technology for on-prem is good and overall it's user friendly with its approach. I even like the IBM product support team on helping out on our issues. There is massive community support over online bugs and seems like one of my best go to tools for Data Science.
Jay Padhya | TrustRadius Reviewer

SingleStore (formerly MemSQL)

Migrating existing databases to one instance, accelerate and scale-out existing data warehouses/analytics platforms. Replace HIVE for SingleStore, which will boost your overall performance and support your data management. Get ready for the cloud by using it on-premise, your own cloud/data center, or as a SAAS. The functionality is the same and migrating will be smooth.
Anonymous | TrustRadius Reviewer

Feature Rating Comparison

Database-as-a-Service

Db2 on Cloud
8.2
SingleStore (formerly MemSQL)
Automatic software patching
Db2 on Cloud
8.7
SingleStore (formerly MemSQL)
Database scalability
Db2 on Cloud
9.5
SingleStore (formerly MemSQL)
Automated backups
Db2 on Cloud
7.6
SingleStore (formerly MemSQL)
Database security provisions
Db2 on Cloud
7.7
SingleStore (formerly MemSQL)
Monitoring and metrics
Db2 on Cloud
6.8
SingleStore (formerly MemSQL)
Automatic host deployment
Db2 on Cloud
8.7
SingleStore (formerly MemSQL)

Pros

Db2 on Cloud

  • Easy to manage.
  • Auto backups are available.
  • Always Availablity feature.
  • No downtime.
Rizwan Ali Joo | TrustRadius Reviewer

SingleStore (formerly MemSQL)

  • We use it as a replacement for having a separate in-memory cache and a traditional disk-based database because SingleStore does both in a single package.
  • We also use the row store for storing transactional state and the column store for storing time series data. Having both in the same product is nice.
  • We get 7x compression for the time series data, which is really good for scaling.
Anonymous | TrustRadius Reviewer

Cons

Db2 on Cloud

  • UI : the UI can be improved to a great extent. Ideally we would want to see the UI/UX to match with latest trends.
  • Limitation to a 15TB database size for any edition below than ES for on-prem. I am sure Cloud solves it, but falls in the same range as others (sometimes higher), making it maybe not the first one to go to.
Jay Padhya | TrustRadius Reviewer

SingleStore (formerly MemSQL)

  • Features related on [SingleStore (formerly MemSQL)] studio UI for monitoring needed some improvement when we used. The SingleStore studio support team helped us in resolving the issues with relation on running the different sets of indexing queries. Challenges here being the detailed logs were not available and we needed to connect with DBA for more detail drill down.
  • SingleStore can have some more improvement in setting up more examples on help documentation for the beginners and early learners.
Anonymous | TrustRadius Reviewer

Likelihood to Renew

Db2 on Cloud

No score
No answers yet
No answers on this topic

SingleStore (formerly MemSQL)

SingleStore (formerly MemSQL) 5.0
Based on 1 answer
I still want to see the performance about using latest version of spark and memsql. About renewal, if there is a new and better version of spark-memsql connector, then maybe.
Tianwen Chu | TrustRadius Reviewer

Usability

Db2 on Cloud

No score
No answers yet
No answers on this topic

SingleStore (formerly MemSQL)

SingleStore (formerly MemSQL) 7.7
Based on 6 answers
[Until it is] supported on AWS ECS containers, I will reserve a higher rating for SingleStore. Right now it works well on EC2 and serves our current purpose, [but] would look forward to seeing SingleStore respond to our urge of feature in a shorter time period with high quality and security.
Anonymous | TrustRadius Reviewer

Support Rating

Db2 on Cloud

Db2 on Cloud 9.0
Based on 2 answers
Easily the best product support team. :) Whenever we have questions, they have answered those in a timely manner and we like how they go above and beyond to help.
Jay Padhya | TrustRadius Reviewer

SingleStore (formerly MemSQL)

SingleStore (formerly MemSQL) 7.7
Based on 6 answers
Very responsive to trouble tickets - Often, I think, the SingleStore's monitoring systems have already alerted the engineers by the time I get around to writing a ticket (about 10 - 20 mins after we see a problem). I feel like things are escalated nicely and SingleStore takes resolving trouble tickets seriously. Also SingleStore follows up after incidents to with a post mortem and actionable takaways to improve the product. Very satisfied here.
John Barry | TrustRadius Reviewer

Alternatives Considered

Db2 on Cloud

IBM Db2 is cheap, easy to use, and less human intervention is required.
Rizwan Ali Joo | TrustRadius Reviewer

SingleStore (formerly MemSQL)

I guess the main difference is how the memory is used for stacking and storing data until it reaches the final destination, the performance is awesome compared with others and when you have a real time business with a certain complexity. The development team would be more familiarized with the SQL environment and there’s practically a zero learning curve, when you compare this with other data bases you’re going to find that there’s a huge saving in time and money.
Jacob Ortega | TrustRadius Reviewer

Return on Investment

Db2 on Cloud

  • Not as much business as in Pakistan.
  • It has yet to get developed in the market.
  • Rather new for many customers.
Rizwan Ali Joo | TrustRadius Reviewer

SingleStore (formerly MemSQL)

  • It can save thousands of dollars in licensing. However you still have to provision big clusters, which sometimes it's more expensive than having traditional technologies and it's difficult to create business cases for our customers
  • Time. Differently SS is key to save time, and time is money.
  • Enhanced user experience (for the IT/BI teams)
Diego Montúfar | TrustRadius Reviewer

Screenshots

Pricing Details

Db2 on Cloud

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Db2 on Cloud Editions & Modules

Additional Pricing Details

SingleStore (formerly MemSQL)

General

Free Trial
Yes
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
Optional

SingleStore (formerly MemSQL) Editions & Modules

Edition
OnDemand0.691
  1. per hour
Additional Pricing Details

Rating Summary

Likelihood to Recommend

Db2 on Cloud
8.7
SingleStore (formerly MemSQL)
7.8

Likelihood to Renew

Db2 on Cloud
SingleStore (formerly MemSQL)
5.0

Usability

Db2 on Cloud
SingleStore (formerly MemSQL)
7.7

Support Rating

Db2 on Cloud
9.0
SingleStore (formerly MemSQL)
7.7

Add comparison