IBM Informix
Features
Benefits
High-performance technology
- Cleaner indexes and improved memory management for more-efficient use of memory and processors
- Enhanced buffer priority management for more-efficient use of large amounts of memory for today’s 64-bit operating systems
- Smarter query optimization including user-defined type costing with new spatial data types
- Shortened instruction sets for common tasks
- Reduced contention between concurrent users
Scalability
-
Previous limitations are eliminated in IDS 9.40:
- Data capacity of a single instance increased from 4TB to 128PB
- Maximum chunk size increased from 2GB to 4 TB
- Maximum number of chunks increased from 2,048 to 32K
- Maximum LVARCHAR size increased from 2KB to 32KB
- DBMS utility file size limit increased from 2GB to 17 billion GB
Security
- Secure over-the-wire encryption using the industry-standard OpenSSL encryption libraries
- Configurable user authentication mechanisms using Pluggable Authentication Modules
System management
- Informix Storage Manager support in the browser-based ISA
- Automated backup and restore functions
- Increased media efficiency by tape-handling utilities
- More flexible restore options
Application development
- SQL language enhancements
- Expanded Unicode support
- Multiple collation support
- Silent installation
- Continued support of IBM Informix 4GL, SQL, ODBC, JDBC, OLE DB, SQLJ
- .NET Driver