What users are saying about
3 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.8 out of 100
10 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7 out of 100

Likelihood to Recommend

Actian Matrix

Actian matrix is not good for small data sets. If you have a limited data pool, or do not plan on having multiple users/clients accessing a data source, stick with a more traditional relational database model - Access for the truly small user base, or a DB2 or Oracle back end if your going to have multiple users, and moderate sized data. Actian is for LARGE data sets (Big Data, in the industry parlance). Millions of rows of data from multiple sources with various down stream systems accessing the database. It is for data analytics of large data groups and intense data mining.
Anonymous | TrustRadius Reviewer

SingleStore (formerly MemSQL)

SingleStore DB (formerly MemSQL) is good for a high-volume, real-time data feed, a high number of concurrent queries, and excellent for both OLAP and OLTP workloads. It's not good for unstructured data store.
Anonymous | TrustRadius Reviewer

Pros

Actian Matrix

  • Super fast. Aggregate query such as SUM(), Count() returns result within seconds from a table with more than billion records.
  • Excellent data compression.
  • Easy maintenance. We managed this database without having a full time DBA.
  • Support ANSI SQL and ODBC/JDBC. It's easy to connect to this database from other systems.
Dipankar Pradhan | TrustRadius Reviewer

SingleStore (formerly MemSQL)

  • High data volume processing.
  • Operational data enablement.
Bernard Bardawil | TrustRadius Reviewer

Cons

Actian Matrix

  • Some of the bugs were annoying and QA definitely needs improvement
  • Connectivity to Informatica and ETL providers
  • Workload management could be better like when you compare with Teradata
Anonymous | TrustRadius Reviewer

SingleStore (formerly MemSQL)

  • GUI needs to be better.
  • To scale out on the fly needs to be a little simpler.
Anonymous | TrustRadius Reviewer

Likelihood to Renew

Actian Matrix

Actian Matrix 6.0
Based on 1 answer
No answer on this topic is available.

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

Actian Matrix

Actian Matrix 6.0
Based on 1 answer
I wish to give higher rating for the speed and efficiency in handling the queries, but only 6 because of consistent bugs we encounter
Anonymous | TrustRadius Reviewer

SingleStore (formerly MemSQL)

SingleStore (formerly MemSQL) 8.6
Based on 2 answers
SingleStore DB (formerly MemSQL) covers a wide spectrum of use-cases and provides ANSI-SQL support, MySQL drop-in replacement.It supports several deployment options--cloud, Helios, on-premise bare-metal or virtualized. Has drivers for many programming languages like Java and Python, for BI tools like Zoomdata and Tableau.
Anonymous | TrustRadius Reviewer

Support Rating

Actian Matrix

Actian Matrix 8.0
Based on 1 answer
  • Faster initial response
  • Trained professionals
  • Very helpful in resolving issues
Anonymous | TrustRadius Reviewer

SingleStore (formerly MemSQL)

SingleStore (formerly MemSQL) 7.4
Based on 3 answers
The team is always available, responsive, and quite helpful. It is clear by their answers that the support reps are experts in SingleStore DB (formerly MemSQL). They can deliver proper answers and understand the client's environment. I never had an issue that took them long to figure out. They are also ready to walk us through upgrades and have meetings whenever required.
Bernard Bardawil | TrustRadius Reviewer

Implementation Rating

Actian Matrix

Actian Matrix 6.0
Based on 1 answer
Leader failover setup is the toughest and lack of proper documentation is making things tough.
Anonymous | TrustRadius Reviewer

SingleStore (formerly MemSQL)

No score
No answers yet
No answers on this topic

Alternatives Considered

Actian Matrix

Actian Matrix is our first big data analytics storage platform, and as I was not involved in the POC process to compare it to other products out on the market, unfortunately I cannot say if it is better than other Big Data storage options. I can say that it out performs products such as Oracle or UDB in regards to the volume of data it can easily index and handle.
Anonymous | TrustRadius Reviewer

SingleStore (formerly MemSQL)

  • VoltDB is more transactional.
  • Redis just a k-v as is Voldemort.
  • Elasticsearch security is an issue. Plus more of reads than writes
  • Aerospike great K-V that is great with writes and reads. But expensive. More expensive than SingleStore DB (formerly MemSQL).
  • Firebird opensource, but scalability is an issue
  • SingleStore DB (formerly MemSQL) at least supports ANSI-SQL. Between SingleStore DB (formerly MemSQL) and VoltDB, I would choose VoltDB, based on pricing.
Anonymous | TrustRadius Reviewer

Return on Investment

Actian Matrix

  • ROI is great, less spending on full time DBA and that money could be use to add additional node.
  • Negative - Not many developers are well aware of this tool, it takes some time to learn.
Dipankar Pradhan | TrustRadius Reviewer

SingleStore (formerly MemSQL)

  • It offers me solution to solve spark storage problem.
  • It adds more complexity of my application since multiple tech softwares are involved.
  • More types of bugs will be encountered when doing streamliner, including hardware connection.
Tianwen Chu | TrustRadius Reviewer

Screenshots

Pricing Details

Actian Matrix

General

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

SingleStore (formerly MemSQL)

General

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

Add comparison