Panoply vs. ParAccel

Panoply is well suited for companies with large amounts of data that do not want all users of the company to see or view. It is appropriate for companies that have to store data for several years in case clients need the data. It is not made to constantly be downloading or looking at the documents.

Incentivized

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.

Incentivized

• Ease of data integrations. Importing data into the data warehouse is a point-and-click effort.
• Automated data modeling. The data is modeled in a way that facilitates analysis without having to look into it myself.
• Query speed. Automated query optimization has really sped up our dashboards.

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

Incentivized

• The user interface could use some improvement for analytical tools. Apart from that, it’s great.

• 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

Incentivized

It’s a good choice for building a quick, multipurpose data stack for a variety of businesses needs.

I wish to give higher rating for the speed and efficiency in handling the queries, but only 6 because of consistent bugs we encounter

Incentivized

• Faster initial response
• Trained professionals
• Very helpful in resolving issues

Incentivized

Leader failover setup is the toughest and lack of proper documentation is making things tough.

Incentivized

Panoply has much more storage and better organization tools for searching. There are better folders and tools for keeping documents secure and stored for a long period of time. It is better to offload data in mass than singular or Zip drive documents like you would do in Google Drive.

Incentivized

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.

Incentivized

• Saved time on Redshift setup
• Saved support costs (monetary and temporal) by not having to set up on-premise
• Widens the BI tool use in organization; lowers the barrier to entry and makes organization more productive in analytical terms

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

Incentivized