Actian/Matrix, please do not shut down your shop
Actian Matrix is being used as analytical tool to answer analytical questions business might have. Business inteligence group uses this …
Actian Matrix (discontinued)
Actian Matrix (discontinued)
Actian Matrix (discontinued)
Overview
What is Actian Matrix (discontinued)?
ParAccel was a data warehouse appliance (DWA) option now offered by Actian, since the acquisition of ParAccel (April, 2013). It was offered for some time as Actian Matrix, but has since been discontinued, and is superseded by Actian Avalanche.
Read moreRecent Reviews
Pricing
View all pricingN/A
Unavailable
What is Actian Matrix (discontinued)?
ParAccel was a data warehouse appliance (DWA) option now offered by Actian, since the acquisition of ParAccel (April, 2013). It was offered for some time as Actian Matrix, but has since been discontinued, and is superseded by
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting / Integration Services
Would you like us to let the vendor know that you want pricing?
Alternatives Pricing
What is Amazon Redshift?
Amazon Redshift is a hosted data warehouse solution, from Amazon Web Services.
What is Db2?
DB2 is a family of relational database software solutions offered by IBM. It includes standard Db2 and Db2 Warehouse editions, either deployable on-cloud, or on-premise.
Product Details
- About
- Tech Details
What is Actian Matrix (discontinued)?
ParAccel was a data warehouse appliance (DWA) option now offered by Actian, since the acquisition of ParAccel (April, 2013). It was offered for some time as Actian Matrix, but has since been discontinued, and is superseded by Actian Avalanche.
Actian Matrix (discontinued) Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Comparisons
View all alternativesCompare with
Reviews and Ratings
 (3)
Attribute Ratings
Reviews
(1-3 of 3)- Popular Filters
Companies can't remove reviews or game the system. Here's why
April 14, 2017
Actian/Matrix, please do not shut down your shop
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.
- 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.
Redshift, Greenplum
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.
- 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
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.
Yes
For the specific applications that now run on Actian Matrix, we replaced back end source databases that ran on Oracle and DB2 Databases. They were replaced because Actian Matrix is a big data analytics database, a columnar database, as opposed to the more traditional relational database. This kind of platform can better process and index large quantities of data, which is what we were looking for. Process - and processing - improvement.
- Price
- Product Usability
- Analyst Reports
Unfortunately, I was not involved in the selection process. I came in on the pilot programs that leveraged the tool ,and its success lead to our company adopting it across a few other application platforms. My team helped both my company, and the vendor (Actian) iron out various conversion issues the tool had - but I was not involved in the decision to go with the platform.
I would include more of the middleware support groups in the process of selecting tools.
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
- Faster reports
- Faster ETL
- Bugs were annoying and [it was] tough to get the resolution sooner
My comparison with Vertica: ParAccel stays at top because we do not know the projections ahead of time (which is a major performance tuning technique in Vertica)
My comparison with Netezza/Teradata: Definitely, ParAccel is economical, but if you can afford it, go for other providers as they are stable.
My comparison with Netezza/Teradata: Definitely, ParAccel is economical, but if you can afford it, go for other providers as they are stable.
100
4
- Speed
- Columnar structure
- Compression
- Columnar storage
- Compression to 10:1 ratio
- Backup and restore
- Workload management
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
Yes
Yes
Yes, a hot fix was deployed very fast just to address my bug. Very impressive!!!
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