Informix Developer Edition

Availability

• The Informix Flexible Grid lets you distribute workloads to maximize hardware investments while keeping data synchronized at all times—regardless of server location. You can manage your grid environment from a single location.
• In case of system failure, another server takes over with minimal impact to your business.
• Upgrades and maintenance can be scheduled as needed, without interrupting business operations. Keep data available during planned outages without the need for temporary hardware, or cloning of databases or applications.
• You can scale capacity as needed, bring data online or offline, or change your data schema throughout your grid—on demand and with no downtime.

Speed and efficiency

• Make analytical workloads up to 50 percent faster by using multi-index scans and star optimization.
• Gain higher throughput using low-cost commodity hardware. A multithreaded architecture optimizes the use of the hardware, and ongoing enhancements continually improve performance.
• Use Informix as a single platform to address online transaction processing and analytical workloads. This helps you reduce costs by consolidating operations on a single database server technology.

Easy administration

• Senses and responds to changes without human or programmatic intervention.
• Includes self-monitoring and self-configuring capabilities such as automated storage and memory management, a deployment utility, an automated install capable of mass deployment across multiple servers, and an automated task scheduler.
• Allows you to program the software to proactively track and react to business thresholds—so you can resolve them before they become an issue.
• Supports advanced data types such as spatial, geodetic and time series data.

Increased developer productivity

• Integrates with IBM Informix Genero, an application development environment for accelerating new mobile and cloud-based applications.
• Delivers increased support for SQL, new SQL syntax for easier porting of open-source applications to Informix and increased interoperability with open-source software.
• Integrates with IBM Optim™ Development Studio, providing visual analysis of SQL statements, execution and performance. This enables faster development and testing of SQL queries, stored procedures and web services.
• Integrates with other tools such as OpenAdmin Tool for Informix to enhance results.

Faster time to compliance

• Protect valuable data with new features that improve auditing and user authentication.
• Gain greater control over auditing practices with selective row-level auditing. Minimize the performance impact of auditing, while simplifying the management and querying of audit records.
• Take advantage of trusted context. Informix simplifies administration by creating a trusted connection between the middle tier and the database.