Actian Matrix Reviews

[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.

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.

It is one of the best fit for data analytics, but if the database is smaller than 500GB then it is less appropriate.