TrustRadius
ParAccel is an data warehouse appliance (DWA) option now offered by Actian, since the acquisition of ParAccel (April, 2013).Actian/Matrix, please do not shut down your shopActian Matrix is being used as analytical tool to answer analytical questions business might have. Business inteligence group uses this database. It is not used across organization. Business has to run aggregate query on top of billion of rows - they use Matrix. BI team has to create internal reports (KPI), and Matrix is being used to do all the processing, [as well as] joins between multiple tables to generate aggregated report. Also, this is the source of a data virtualization layer.,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.,Dashboard for Admin instead of a linux console. Admin with ability to kill inactive sessions when sessions reaches to more than allowed sessions. We ended up restarting the database. Ability to easily scale up database by adding extra node. Better support from Actian.,9,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.,,Toad Data Point, Informatica Application ILM, SnapLogicAn Integrators view on Actian Matrix DB Platform, or Big Data Storage made simple.Actian Matrix is leveraged by multiple teams and organizations to solve the issues related to data mining and big data crunching. It is a tool used to aggregate data from multiple internal and external sources and perform detailed analysis in a shared repository. It is often used in conjunction with ETL programs to transform and load the data, and then sourced from this repository by multiple analytics platforms, both in house and off the shelf software packages.,Handles Various data types from multiple sources. Indexing speed - using the Actian platform as a back end database greatly improved processing time.,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.,7,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.,oracle,PowerCenter, Rapid SQL, CollabNet TeamForge,Yes,Price Product Usability Analyst Reports,I would include more of the middleware support groups in the process of selecting tools.ParAccel - Great software, but deal with its shortcomingsI used it in MicroStrategy Cloud. It is used as one of the big data solutions provider for all the performance tier customers. Apart from MicroStrategy Cloud, it was also used with MicroStrategy wisdom and MicroStrategy Social softwares. It definitely solved the slower queries that were pestering in SQL Server and Oracle. It is the best in loading the data into the database.,Data loading is excellent ParAccel support is the best I have seen so far.,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,6,Faster reports Faster ETL Bugs were annoying and [it was] tough to get the resolution sooner,Vertica, Teradata Database and IBM Netezza Data Warehouse Appliances,PostgreSQL, Amazon Elastic Compute Cloud (EC2), MongoDB, Docker, Nagios,100,4,Speed Columnar structure Compression,Columnar storage Compression to 10:1 ratio Backup and restore,Workload management,6,Yes,Price Product Features Product Usability Prior Experience with the Product,I would have reviewed workload management more, especially managing the number of concurrent heavy and lighter queries.,Implemented in-house Professional services company,Yes,Getting OS configuration right Less documentation made the setup tough,6,Yes,8,Yes,For the leader failover setup, a particular version of Corosync was giving an issue. Support directly jumped in and solved it for me.,Table creation Understanding columnar nature of storage Backup,Incremental restore Data Compression Workload management,No,6
Unspecified
Actian Matrix
3 Ratings
Score 8.7 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>TRScore

Actian Matrix Reviews

Actian Matrix
3 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.7 out of 101
Show Filters 
Hide Filters 
Filter 3 vetted Actian Matrix reviews and ratings
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role
Reviews (1-3 of 3)
  Vendors can't alter or remove reviews. Here's why.
Dipankar Pradhan profile photo
April 14, 2017

Actian Matrix Review: "Actian/Matrix, please do not shut down your shop"

Score 9 out of 10
Vetted Review
Verified User
Review Source
Actian Matrix is being used as analytical tool to answer analytical questions business might have. Business inteligence group uses this database. It is not used across organization. Business has to run aggregate query on top of billion of rows - they use Matrix. BI team has to create internal reports (KPI), and Matrix is being used to do all the processing, [as well as] joins between multiple tables to generate aggregated report. Also, this is the source of a data virtualization layer.
  • 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.
  • Dashboard for Admin instead of a linux console.
  • Admin with ability to kill inactive sessions when sessions reaches to more than allowed sessions. We ended up restarting the database.
  • Ability to easily scale up database by adding extra node.
  • Better support from Actian.
[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.
Read Dipankar Pradhan's full review
No photo available
July 26, 2016

Review: "An Integrators view on Actian Matrix DB Platform, or Big Data Storage made simple."

Score 7 out of 10
Vetted Review
Verified User
Review Source
Actian Matrix is leveraged by multiple teams and organizations to solve the issues related to data mining and big data crunching. It is a tool used to aggregate data from multiple internal and external sources and perform detailed analysis in a shared repository. It is often used in conjunction with ETL programs to transform and load the data, and then sourced from this repository by multiple analytics platforms, both in house and off the shelf software packages.
  • Handles Various data types from multiple sources.
  • Indexing speed - using the Actian platform as a back end database greatly improved processing time.
  • 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.
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.
Read this authenticated review
No photo available
July 19, 2016

Actian Matrix Review: "ParAccel - Great software, but deal with its shortcomings"

Score 6 out of 10
Vetted Review
Verified User
Review Source
I used it in MicroStrategy Cloud. It is used as one of the big data solutions provider for all the performance tier customers. Apart from MicroStrategy Cloud, it was also used with MicroStrategy wisdom and MicroStrategy Social softwares. It definitely solved the slower queries that were pestering in SQL Server and Oracle. It is the best in loading the data into the database.
  • Data loading is excellent
  • ParAccel support is the best I have seen so far.
  • 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
It is one of the best fit for data analytics, but if the database is smaller than 500GB then it is less appropriate.
Read this authenticated review

About Actian Matrix

ParAccel is an data warehouse appliance (DWA) option now offered by Actian, since the acquisition of ParAccel (April, 2013).
Categories:  Data Warehouse

Actian Matrix Technical Details

Operating Systems: Unspecified
Mobile Application:No