We performed a comparison between Actian Ingres and Amazon Redshift based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."The deployment of our solution across a number of servers using Ingres .NET has meant that we can protect the database server behind a highly secure firewall and deploy the front end solutions on a normal web server."
"It allows for the storage of huge amounts of data."
"I find the most valuable features to be the MPP style of processing, which mostly all of the data warehouses provide. The ability to integrate all other AWS services, such as NSS and S3, with little effort is very helpful. The service is well maintained, there are update patches frequently."
"The tool's most valuable feature is its parallel processing capability. It can handle massive amounts of data, even when pushing hundreds of terabytes, and its scaling capabilities are good."
"The feature that we find most useful is the ability to do analytics on the fly."
"I found the Amazon Redshift computing services easy. I found the computing instances the most incredible in the solution."
"The processing of data is very fast."
"The most valuable feature is the scalability, as it grows according to our needs."
"It allows you write complex queries and perform row by row processes."
"The ability to reset the log file without stopping the DBMS would be helpful for us."
"What would make Amazon Redshift better is improvising on the pricing structure. For example, Acronis provides backups in cybersecurity, yet the pricing is a bit lesser than Amazon Redshift."
"I would like to improve the pricing and the simplicity of using this solution."
"In the next release, a pivot function would be a big help. It could save a lot of time creating a query or process to handle operations."
"In our experiments, the handling of unstructured data was not very smooth."
"Pricing is one of the things that it could improve. It should be more competitive."
"Amazon Redshift does not have the capability to dynamically increase the VM file."
"It lacks a few features which can be very useful, such as stored procedures"
"The explain panel in the Redshift database could be better."
Earn 20 points
Actian Ingres is ranked 22nd in Data Warehouse while Amazon Redshift is ranked 4th in Cloud Data Warehouse with 58 reviews. Actian Ingres is rated 9.0, while Amazon Redshift is rated 7.8. The top reviewer of Actian Ingres writes "Good multi-platform SQL compatibility, as well as performance and data integrity". On the other hand, the top reviewer of Amazon Redshift writes "Provides one place where we can store data, and allows us to easily connect to other services with AWS". Actian Ingres is most compared with Snowflake, Oracle Database Appliance, Databricks and Teradata, whereas Amazon Redshift is most compared with AWS Lake Formation, Snowflake, Teradata, Vertica and Microsoft Azure Synapse Analytics.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.