The 12.0 release introduces several enhancements, including performance optimization, workload automation, database management improvements, and cloud-enabled capabilities that drive business continuity. The 12.0 release has new capabilities designed to support mission-critical business and modernization efforts, such as:

• Workload Manager 2.0 provides better queue management and allocation of resources by user, role, and group.


• Containerized UDFs (Linux, Windows) offer improved isolation and support for using Python, and Javascript languages in working with data.


• Up to 20% faster analytical queries (Linux, Windows) using the X100 engine.


• Backup to Cloud and Disaster Recovery (Linux, Windows) for on-premises and cloud deployments using Virtual Machines(VMs) or Docker containers in Kubernetes.


• Improvements that harden security against brute force and Denial of Service (DoS) attacks from malicious actors

The Actian Ingres Database (Linux, Windows) includes the record breaking analytic engine from Actian’s Vector to enable a new class of applications that can mix OLTP and analytic queries, with each query being directed to the appropriate execution engine.

Actian Ingres 11.2 contains many new management, development and security features. Actian Ingres 11.2 introduces Workload Management Phase 1, JSON Support, Data Masking for sensitive data, Partition Management, Pivot Tables, and Encryption Initialization Vectors among other changes.

Actian Ingres 11.2 also contains a development release of UDFs with development-only support for SQL, Java Script (Linux, Windows) and Python UDFs (Linux, Windows).