Actian/Matrix, please do not shut down your shop
April 14, 2017
Actian/Matrix, please do not shut down your shop
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Actian Matrix
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