Coming October 25: PeerSpot Awards will be announced! Learn more

Actian Ingres OverviewUNIXBusinessApplication

Actian Ingres is #8 ranked solution in top Data Visualization tools and #10 ranked solution in top Data Warehouse tools. PeerSpot users give Actian Ingres an average rating of 9.0 out of 10. Actian Ingres is most commonly compared to Oracle Database Appliance: Actian Ingres vs Oracle Database Appliance. Actian Ingres is popular among the large enterprise segment, accounting for 63% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a computer software company, accounting for 21% of all views.
Buyer's Guide

Download the Data Warehouse Buyer's Guide including reviews and more. Updated: September 2022

What is Actian Ingres?

Actian’s Ingres is a leading, enterprise-grade database management system designed to reduce IT costs and time-to-value, while delivering the strength and features expected from an enterprise-class database. Ingres 10.2 is the latest version of the database, containing enhancements that will make it easier to internationalize customer applications. Along with improved performance and reduced configuration overhead, users can take their first steps into big data analytics with the new Window functions.

Actian Ingres was previously known as Ingres, Ingres 2006.

Actian Ingres Customers

Groupe Adeo, IsCool Entertainment

Actian Ingres Reviews

Filter by:
Filter Reviews
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Showingreviews based on the current filters. Reset all filters
reviewer1501218 - PeerSpot reviewer
Managing Director at Jet iT Ltd.
Real User
Top 20
Good multi-platform SQL compatibility, as well as performance and data integrity
Pros and Cons
  • "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."
  • "The ability to reset the log file without stopping the DBMS would be helpful for us."

What is our primary use case?

We currently run Web server solutions (CMS, CRM business solutions).

Our CMS solution is obviously very text-oriented, and our CRM Business Solution was built for a finance and asset management business, which is capable of handling millions of transactions.

Performance, access control, data integrity are fundamental to any application but we have been able to more than satisfy our clients with the solutions we have delivered.

We have Ingres running on an AWS Linux server. We have Windows Server running front end solutions using Ingres OpenRoad and Linux Servers serving Web Applications through Apache and PHP.

How has it helped my organization?

Ingres is the only database solution that has maintained a level of consistency and integrity about the way users interact with it. As a database administrator, there is a level of transparency and control at all levels.

Over the last few years, we have migrated all of our business functional logic into database procedures, which improves performance significantly and allows us to alter our development tools/programming languages easily.

Our products CK5 and JS5 are offered as SaaS solutions through jetpac.co.nz

What is most valuable?

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. The User is never exposed to any configurations or logins other than their own initial identification.

The SQL capability is consistent across all platforms. This means that we can code into our PHP functions to manage the database so that the users can be generally self-sufficient and requiring DB support only rarely.

What needs improvement?

Whilst our server up-time is in the > 99%, we still have to reboot the DBMS periodically to allow us to archive the log file. The ability to reset the log file without stopping the DBMS would be helpful for us.

We have created our own error management/reporting process within our database procedures. Unfortunately, if there is a database error, such as a duplicate key, the default action is to abort. This means that our information is generally lost. An option to not abort on failure would be great. Of course, this only really occurs in testing.

Buyer's Guide
Data Warehouse
September 2022
Find out what your peers are saying about Actian, Oracle, Snowflake Computing and others in Data Warehouse. Updated: September 2022.
633,952 professionals have used our research since 2012.

For how long have I used the solution?

I first came across Actian Ingres in 1992 and have been using it in all of my solutions since then.

What do I think about the scalability of the solution?

It is completely scalable, as the Query Execution Process is completely dynamic based on the current number of rows and efficiency of the index structures.

Which solution did I use previously and why did I switch?

We did not use another solution, as this was a greenfield opportunity

Which other solutions did I evaluate?

We evaluated Oracle and DB2.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user