IBM Informix

HomeSoftware SystemsInformixFeatures & Benefits

IBM Informix Features and Benefits

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


Back to top