[ IBM Inf... Reviews ](https://www.g2.com/products/ibm-informix/reviews) [ IBM Inf... Reviews ](https://www.g2.com/products/ibm-informix/reviews) # IBM Informix Features ##### ## Database Features (7) Storage Availability Stability Scalability Security Data Manipulation Query Language Show More ##### ## Management (4) Real-Time Analytics Track data and system backups, replication, and failover events. Solution Integration Integrate with other management, resilience, or backup solutions Infrastructure Compatibility Be compatible with a variety of cloud and/or virtual infrastructure. Monitoring Monitor replication environment via GUI Show More ##### ## Solution Provision (3) System Failover Provide as-before failover capabilities for cloud environments. Pay by Usage Services are offered under a pay-as-you-go or utilization-based purchase model. Service Provision Offer disaster recovery capabilities as a third-party provider. Show More ##### ## Support (4) Text Search Provides support for international character sets and full text search. Data Types Supports multiple data types like primitive, structured, document etc. Languages Supports multiple procedural programming languages like PL/PGSQL, Perl, Python etc. Operating Systems Available on multiple operating systems like Linux, Windows, MacOS etc. Show More ##### ## Security (4) Database Locking Prevents other users and applications from accessing data while it is being updated to avoid data loss or update. Access Control Allows permissions to be granted or revoked in the database, schema or table levels. Encryption Built-in native encryption with enterprise key management. Authentication Provides multi-factor authentication with certificates. Show More ##### ## Performance (5) Disaster Recovery Provides data recovery functionality to protect and restore data in a database. Data Concurrency Allows multi-version concurrency control. Workload Management Handles workloads, from single machines to data warehouses or web services with many concurrent users. Advanced Indexing Allows users to quickly retrieve data through various types of indexing like B-tree, hash table etc. Query Optimizer Helps interpret SQL queries and determine the fastest method of execution. Show More ##### ## Management (4) Data Schema Data is organized as a set of tables with columns and rows like a table structure. Query Language Allows users to create, update and retrieve data in a database. ACID - Complaint Adheres to ACID (atomicity, consistency, isolation, durability), a set of database transaction properties. Data Replication Provides log-based or/and trigger-based replication. Show More ## Top-Rated Alternatives [ ![Microsoft SQL Server](https://images.g2crowd.com/uploads/product/hd_favicon/a8a99a96fda235658139f710592f8a53/microsoft-sql-server.svg "Microsoft SQL Server") Microsoft SQL Server 4.4/5(2,286) ](https://www.g2.com/products/microsoft-sql-server/reviews) [ ![MySQL](https://images.g2crowd.com/uploads/product/image/large_detail/large_detail_240340edca859994ec71e4490aa20022/mysql.png "MySQL") MySQL 4.4/5(1,682) ](https://www.g2.com/products/mysql/reviews) [ ![Oracle Database](https://images.g2crowd.com/uploads/product/image/large_detail/large_detail_82f55e945509bff7b8009e8024cfe73c/oracle-database.jpg "Oracle Database") Oracle Database 4.3/5(1,019) ](https://www.g2.com/products/oracle-database/reviews) [ View All Alternatives ](https://www.g2.com/products/ibm-informix/competitors/alternatives) IBM Informix Comparisons ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/small_square/small_square_82f55e945509bff7b8009e8024cfe73c/oracle-database.jpg "Product Avatar Image") Oracle Database 4.3/5(1,019) [ Compare Now ](https://www.g2.com/compare/ibm-informix-vs-oracle-database) ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/small_square/small_square_240340edca859994ec71e4490aa20022/mysql.png "Product Avatar Image") MySQL 4.4/5(1,682) [ Compare Now ](https://www.g2.com/compare/ibm-informix-vs-mysql) ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/small_square/small_square_0d3b67827912f22174857de9475977c9/microsoft-sql-server.jpg "Product Avatar Image") MS SQL 4.4/5(2,286) [ Compare Now ](https://www.g2.com/compare/ibm-informix-vs-microsoft-sql-server) ##### Categories on G2 [ Relational Databases ](https://www.g2.com/categories/relational-databases)[ Data Replication ](https://www.g2.com/categories/data-replication) ##### Explore More [ Which bot platforms work well for ecommerce websites that need to handle product questions, cart recovery and order tracking automatically? ](https://www.g2.com/discussions/which-bot-platforms-work-well-for-ecommerce-websites-that-need-to-handle-product-questions-cart-recovery-and-order-tracking-automatically)[ Best container monitoring solutions for hybrid cloud deployments ](https://www.g2.com/discussions/best-container-monitoring-solutions-for-hybrid-cloud-deployments)[ Which media targeting tool offers the most accurate journalist database? ](https://www.g2.com/discussions/which-media-targeting-tool-offers-the-most-accurate-journalist-database) [ Best digital sales enablement tools for large enterprises ](https://www.g2.com/discussions/best-digital-sales-enablement-tools-for-large-enterprises)[ Most recommended demo automation tool for SaaS companies ](https://www.g2.com/discussions/most-recommended-demo-automation-tool-for-saas-companies)[ Top-rated network monitoring service for startups ](https://www.g2.com/discussions/top-rated-network-monitoring-service-for-startups) Show More [ Which bot platforms work well for ecommerce websites that need to handle product questions, cart recovery and order tracking automatically? ](https://www.g2.com/discussions/which-bot-platforms-work-well-for-ecommerce-websites-that-need-to-handle-product-questions-cart-recovery-and-order-tracking-automatically)[ Best container monitoring solutions for hybrid cloud deployments ](https://www.g2.com/discussions/best-container-monitoring-solutions-for-hybrid-cloud-deployments)[ Which media targeting tool offers the most accurate journalist database? ](https://www.g2.com/discussions/which-media-targeting-tool-offers-the-most-accurate-journalist-database) [ Best digital sales enablement tools for large enterprises ](https://www.g2.com/discussions/best-digital-sales-enablement-tools-for-large-enterprises)[ Most recommended demo automation tool for SaaS companies ](https://www.g2.com/discussions/most-recommended-demo-automation-tool-for-saas-companies)[ Top-rated network monitoring service for startups ](https://www.g2.com/discussions/top-rated-network-monitoring-service-for-startups)