Informix Ultimate Edition

Informix Flexible Grid

• Schedule maintenance and upgrades to give users continuous access to data without any downtime.
• Use different hardware or operating systems, or different versions of Informix from cluster to cluster.
• Manage your environment and automatically update database schemas throughout the grid from a single location.
• Enable web-based services and cloud computing with a profile and feature set that is well-suited to virtualization.

Storage enhancements

• Build a cluster of Informix instances around a single set of shared storage devices using the Continuous Availability Feature.
• Get load-balancing or continuously available data services, even if one or more servers fail.
• Deliver up to 80 percent savings on disk space and a 20 percent improvement on input/output with the optional Storage Optimization Feature.
• Reduce data volumes for shorter backup and restore operations, faster search times and more efficient use of memory.

Security features

• High-availability data replication supports disaster recovery and continuous log restore, point-time instance-wide restore, and table-level backup and recovery.
• Advanced access control enables cell-, column- and row-level label-based access control.
• Capabilities let you control data access down to an individual cell of information.

Spatial data warehouses

• The IBM Informix SQL Warehousing Tool, a graphical environment that works with the Design Studio, enables you to build in-database data movements and transformations into your warehouse.
• The IBM Informix Spatial DataBlade® provides SQL-based spatial data types and functions that can be used directly through standard SQL queries or with client-side geographic information systems software.
• You can generate units of code that are organized inside execution plans, and use a metadata system and an integrated development environment to create, edit and manage these flows. A code-generation system translates the flow models into optimized SQL code to test-run, schedule and execute.