Ingres 10S is the all-in-one database for collecting, analyzing and sharing spatial and business data. Ingres 10S includes comprehensive spatial support, allowing you to extend location-based data through spatial-aware applications.

Ingres 10S comes complete with spatial functionality which means no more complex add-ons and integrations with other databases, and no need to pay extra to access Ingres 10S geospatial features. Enjoy industry-leading, 24x7 mission-critical support for managing spatial and business data with and geographic-aware applications.

This release contains enhancements that will enable internationalization of customer applications allowing customers and partners to address new markets. With improved performance and reduced configuration overheads application development has never been easier. Users can also take their first steps into Big Data Analytics by applying the new Windowing functions to their existing transactional data.

New features include 2-D, 3-D and 4-D Spatial Data Types, Remote GCA, UTF-8 Transliteration, DBMS Level Authentication, IPV4 and IPV6 Data Types and Functions and Per-query Parallelism Level.

The Actian Ingres 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 offer improved isolation and support for using Python, and JavaScript languages in working with data


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


• Up to 20% faster analytical queries using the X100 engine


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

The Actian X Hybrid Database 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 X contains many new management, development and security features. Actian X 11.2 introduces Workload Management Phase 1, JSON Support in X100 tables and Encryption Initialization Vectors among other changes.

Actian X 11.2 also contains a development release of UDFs with development-only support for SQL, Java Script and Python UDFs.

The Actian X Hybrid Database 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 X also includes two significant additions for application integration and monitoring. DataConnect for Actian X provides an end-to-end solution for designing, deploying and managing data integration, and the Actian Enterprise Monitoring Appliance (EMA) can use Nagios compatible plug-ins now in Actian X to monitor Ingres environments.

Actian X also contains many new geospatial, performance, ease-of-use and security features. Actian X 11.1 introduces Hybrid Join Support, JSON support, data masking for sensitive data, partition management, pivot tables and support for listagg() among other changes.

The Actian X Hybrid Database 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 X also includes two significant additions for application integration and monitoring. DataConnect for Actian X provides an end-to-end solution for designing, deploying and managing data integration, and the Actian Enterprise Monitoring Appliance (EMA) can use Nagios compatible plug-ins now in Actian X to monitor Ingres environments.

Actian X also contains many new geospatial, performance, ease-of-use and security features. A few of the highlights are: ArcGIS plug-in, query optimizer reuse heuristics, automatic log file rotation, IANA timezones, Y2K38 fix, blob encryption and AES password encryption.