Skip to main content

Informix Features and Benefits

Information Management software

Informix 11.7 - The beginning of the next decade of IBM Informix

Data management that’s fast and efficient with zero downtime – all made easy!

Informix 11.7 ushers in the next decade for IBM Informix to continue as a force in helping to deliver smarter solutions as the engine that powers OLTP and decision support applications for businesses and partners of all sizes. Take a look at Informix 11.7 and discover unprecedented advantages through advanced levels of performance, availability, and efficiency, with minimal complexity and lower computing costs. And with the introduction of Informix Flexible Grid, not only is it easy to perform routine maintenance and upgrades throughout all your geographic locations from a single site, you can do it with NO downtime whatsoever.

Key enhancements

IBM® Informix® is an exceptional relational database that offers outstanding performance, reliability, scalability and manageability for businesses, ISVs and OEMs of all sizes.

Options, not hassles, for achieving continuous availability
IBM Informix offers the industry's most comprehensive set of high availability options that can take advantage of low-cost hardware, and Informix 11.7 takes that to new heights with Informix Flexible Grid. Schedule upgrades or maintenance when you want, without any downtime, and without having to use temporary hardware or clone your databases and applications. Use different hardware, operating systems, or even different versions of Informix from cluster to cluster within a grid. Scale capacity when and where needed, bring data on or off line, or change your data schema throughout your grid, all on-demand and with no downtime. Easily manage your grid environment from a single location!

Speed and efficiency let you do more and spend less
Informix is fast. Ask any Informix user. Informix was built from the ground up for performance. Higher performance means fewer servers – and less space, power, and cooling resources. Gain even higher throughput using low-cost commodity hardware. It starts with a multi-threaded architecture that optimizes the use of the hardware, together with on-going enhancements focused on keeping a performance edge. The strong performance of Informix as a single platform to address OLTP and analytical workloads presents significant value since operations can be consolidated on a single database server technology. Capabilities for multi-index scans and star join optimization make analytical workloads up to 50% faster. More demanding warehouse environments will benefit from the Informix Ultimate Warehouse Edition and its Informix Warehouse Accelerator that leverages a deep columnar approach to accelerate queries up to 100 times.

Easy administration lets you maximize DBA resources
Informix 11.7 represents continued investment in autonomics – meaning Informix software automatically senses and responds to changes without human or programmatic intervention. The self-maintaining, self-configuring, and self-healing capabilities of Informix 11.7 add powerful new features such as automated storage and memory management, a new deployment utility and automated install capable of mass deployment across multiple servers, as well as an automated task scheduler. There is also built-in support for advanced data types including spatial, geodetic, and timeseries data.

Application development enhancements increase developer productivity and options
The introduction of Informix Genero provides easy, graphical tools that increase developer productivity whether the goal is to accelerate a new generation of mobile and cloud-based applications, or to modernize existing 4GL applications. Informix 11.7 also delivers increased options and easier enablement of open source applications through increased support for industry standard SQL, new SQL syntax for easier porting of open source applications to Informix, and increased interoperability with open source software. Integration with IBM Optim Development Studio provides visual analysis of SQL statements, execution and performance for faster development and testing of SQL queries, stored procedures and Web Services.

Enhanced security speeds time to compliance
Informix 11.7 continues a tradition of protecting your valuable data with the introduction of several new features to improve auditing and user authentication. Organizations have greater control over auditing practices with selective row level auditing. With this more granular control, organizations can minimize performance impact of auditing while simplifying the management and querying of audit records. Additionally, Informix 11.7 brings trusted context to solution providers to create a trusted connection between the middle tier and the database, together with 3rd party authentication, greatly simplifying administration.