What users are saying about

Actian Matrix

3 Ratings

MemSQL

7 Ratings

Actian Matrix

3 Ratings
Score 8.6 out of 101

MemSQL

7 Ratings
Score 8.8 out of 101

Add comparison

Likelihood to Recommend

Actian Matrix

[Actian Matrix is well suited for:]1. Power user who wants to derive aggregate metrics by joining huge dataset.2. Batch load where you have to load billion of records very fast (copy command).3. Scenario where you want to do ELT because your ETL tool cannot handle huge volume of data.
Dipankar Pradhan profile photo

MemSQL

MemSQL is especially useful to serve as a back-end storage for spark streaming, and also small update problems. The streamliner technology is very helpful to process daily streaming data and consequent data analysis. Same SQL syntax is also very handy for people to learn and use.
Sachin Aggarwal profile photo

Pros

  • 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 profile photo
  • Faster query speed than traditional SQL database.
  • It con server in the pipeline to deal with streaming data with Kafka, spark streaming and MemSQL
  • It is very scalable.
Sachin Aggarwal profile photo

Cons

  • Its a new product, there are plenty of bugs to work out with regards to converting special reserve characters that might crop up in data.
  • The Matrix 2 Matrix database port tool needs some ironing out.
No photo available
  • Provide faster python API for invoking MemSQL
  • MemSQL connection between spark failed when more than around 48 partitions data processing
  • Better tuning of MemSQL performance on Scale-up server
Sachin Aggarwal profile photo

Likelihood to Renew

Actian Matrix6.0
Based on 1 answer
No answer on this topic is available.
MemSQL5.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 profile photo

Usability

Actian Matrix6.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
No photo available
No score
No answers yet
No answers on this topic

Support

Actian Matrix8.0
Based on 1 answer
  • Faster initial response
  • Trained professionals
  • Very helpful in resolving issues
No photo available
No score
No answers yet
No answers on this topic

Implementation

Actian Matrix6.0
Based on 1 answer
Leader failover setup is the toughest and lack of proper documentation is making things tough.
No photo available
No score
No answers yet
No answers on this topic

Alternatives Considered

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.
No photo available
I have tried using CSV as a back-end storage, yet I/O is very heavy, direct transit from spark to MemSQL in memory really beats.
Sachin Aggarwal profile photo

Return on Investment

  • I cannot comment on the specific numbers, all I can say is that switching to the backend greatly improved our processing speed. The more we process through our systems, the more clients we can serve. Which should bump ROI.
No photo available
  • 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.
Sachin Aggarwal profile photo

Pricing Details

Actian Matrix

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

MemSQL

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