Informix Growth Edition

Enhances security

• A high-availability data replication feature supports disaster recovery and continuous log restore, point-time instance-wide restore and table-level backup and recovery.
• An advanced access control feature enables cell-, column- and row-level label-based access control.
• Data access can be controlled down to an individual cell of information, providing greater security for your critical data and sensitive customer information.

Improves performance

• Direct input/output (I/O) support delivers performance nearly equal to that of raw devices.
• American National Standards Institute (ANSI) SQL extensions for derived tables and optimizer directives enhance your queries.
• Multithreaded architecture for SMPs is provided. This includes asynchronous I/O, non-blocking checkpoints, cascading deletes and direct I/O support.

Makes development easier

• Allows customized deployment and application control of the server through the administration API, making it easier to develop and deploy integrated applications.
• Includes a Web Feature Service API, which supports use of location-based data in a service-oriented architecture environment.
• Supports application development with smart large objects, user-defined data types, aggregates and routines, and also supports spatial and temporal data with R-tree indexing technology.
• Allows multiple triggers on tables and views for application flexibility and compatibility.

Implements spatial data warehouses

• The Informix SQL Warehousing Tool and Informix Spatial DataBlade module help you implement spatial data warehouses.
• The Informix SQL Warehousing Tool enables you to build in-database data movements and transformations into your warehouse.
• The Informix SQL Warehousing Tool lets you model logical flows of high-level operations, create, edit and manage these flows, and translate the flow models into optimized SQL code to test-run, schedule and execute.
• 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.