IBM Informix is a widely used and scalable relational database management system designed to handle large amounts of data and high transaction volumes. It is known to provide exceptional performance, thanks to its Parallel Data Query Engine (PDQ) that enables parallel processing of queries and operations, significantly reducing response times for complex queries and large data sets. Additionally, Informix supports online operations like backup, restore, index maintenance, and table reorganization, minimizing downtime and ensuring continuous availability.
Product | Market Share (%) |
---|---|
IBM Informix | 1.4% |
SQLite | 29.5% |
Firebird SQL | 22.7% |
Other | 46.400000000000006% |
Type | Title | Date | |
---|---|---|---|
Category | Embedded Database | Aug 28, 2025 | Download |
Product | Reviews, tips, and advice from real users | Aug 28, 2025 | Download |
Comparison | IBM Informix vs SQLite | Aug 28, 2025 | Download |
Comparison | IBM Informix vs Firebird SQL | Aug 28, 2025 | Download |
Comparison | IBM Informix vs Oracle Database In-Memory | Aug 28, 2025 | Download |
Title | Rating | Mindshare | Recommending | |
---|---|---|---|---|
SQL Server | 4.2 | N/A | 93% | 269 interviewsAdd to research |
Teradata | 4.1 | N/A | 87% | 76 interviewsAdd to research |
Company Size | Count |
---|---|
Small Business | 6 |
Midsize Enterprise | 2 |
Large Enterprise | 5 |
Company Size | Count |
---|---|
Small Business | 51 |
Midsize Enterprise | 34 |
Large Enterprise | 87 |
Informix provides robust high availability and replication features, including shared-disk clustering, remote data replication, and high-availability data replication (HDR). These features ensure data redundancy, failover protection, and disaster recovery capabilities, making it a reliable choice for mission-critical applications. Furthermore, Informix offers specialized features for data warehousing and analytics, such as in-database analytics, data compression, and parallel load capabilities, making it suitable for business intelligence (BI) and data analysis applications.
Informix can be deployed as an embedded database, allowing it to be tightly integrated with applications and systems, reducing overhead and simplifying deployment. It includes workload management capabilities, enabling organizations to prioritize and manage different types of workloads, such as online transaction processing (OLTP) and analytical queries, ensuring efficient resource utilization and meeting service-level agreements (SLAs). Informix also provides robust security features, including role-based access control, data encryption, auditing, and compliance with industry standards like FIPS 140-2 and Common Criteria.
IBM Informix was previously known as Informix.
Shaspa, Hildebrand, Kaifa, Ranhill Powertron, Federaci‹ Farmacutica (FedeFarma), Camden Council, The German Aerospace Center (DLR), Myers, Votorantim Group, Doosan Infracore, GreenIvory
Author info | Rating | Review Summary |
---|---|---|
Senior Oracle Database and Systems Administrator at Dedagroup | 3.0 | I use IBM Informix as a central database solution for various applications and business intelligence tools. While it supports multiple environments, it could improve in performance and aligning with current software trends, especially when compared to Oracle. |
General Manager and Architect - Informix Expertise at Begooden-IT Consulting | 4.5 | No summary available |
Head of Department at a transportation company with 10,001+ employees | 3.0 | No summary available |
ING ( technical developer) at Centrum | 5.0 | I use IBM Informix primarily for educational purposes, focusing on testing concurrency and locking capabilities. It excels in handling large-scale data types and OLTP mode. However, it lacks package support, unlike Oracle. Previously, I used Oracle and Microsoft SQL Server. |
Acting Snr Manager: Enterprise Architecture & Process Management at Road Accident Fund | 1.0 | I primarily use IBM Informix for case applications. However, I've encountered performance issues and difficulty finding skilled workers. There's room for improvement in terms of performance and ease of use, as I'm unsure if the problem lies with the database. |
Executive Director at Dynamic Tomorrow | 5.0 | No summary available |
Database Administrator at a energy/utilities company with 5,001-10,000 employees | 4.0 | No summary available |
General Manager and Architect - Informix Expertise at Begooden-IT Consulting | 5.0 | No summary available |