Skip to main content
TrustRadius
IBM Informix

IBM Informix

Overview

What is IBM Informix?

Informix is an embedded relational database offering from IBM.

Read more
Recent Reviews
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Return to navigation

Pricing

View all pricing
N/A
Unavailable

What is IBM Informix?

Informix is an embedded relational database offering from IBM.

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

19 people also want pricing

Alternatives Pricing

What is Db2?

DB2 is a family of relational database software solutions offered by IBM. It includes standard Db2 and Db2 Warehouse editions, either deployable on-cloud, or on-premise.

What is HCL Zen Edge Data Management?

HCL Zen Edge Data Management (formerly Actian Zen) is a NoSQL and SQL (fully ANSI compliant) embedded database that runs on Windows, Linux, Android, iOS, macOS, in VMs and Containers with AES 256-bit encryption. Version footprints range from 5MB (client only) to 50 MB (embedded client-server) to…

Return to navigation

Product Demos

Intel-IBM Informix Building Automation Demo

YouTube

IBM Informix (IDS) - High and Continuous Availability

YouTube

0 IBM Informix 12.1 Demo

YouTube
Return to navigation

Product Details

IBM Informix Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(16)

Attribute Ratings

Reviews

(1-1 of 1)
Companies can't remove reviews or game the system. Here's why
Art S. Kagel | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
I support business and government organizations that use Informix worldwide. Clients use Informix for OLTP applications as well as Data Warehouse and Decision Support analytics. Database sizes range from several GB to tens of TB. Industries include retail, wholesale, electric utilities, online gaming, online gambling, information processing, financial records management and financial transactions, court record keeping, government taxation units, etc. For most of these organizations Informix manages and secures mission-critical data.
  • Industry leading OLTP performance.
  • Excellent Data Warehouse performance from the basic engine. Outstanding Data Warehouse performance from the Informix Warehouse Accelerator module.
  • Best embedability among major RDBMS systems.
  • Scalable from the smallest Raspberry PI up to the largest monolithic systems and out to dozens of distributed nodes.
  • Hybrid data capabilities to merge relational data with time seriesv, geospacial data, JSON data and other non-traditional data types with performance comparable or better than systems dedicated to those data types.
  • Honestly, not much. IBM and HCL have excellent product feature feedback mechanisms with an online system for users to offer feature improvements and suggestions. Many are incorporated in new releases. The latest includes two such user suggested features for example.
  • Like most RDBMS servers, Informix is strong in OLTP so it is a good choice for any high volume transaction systems including retail, banking, online gambling, etc.
  • Because its memory and storage footprints are relatively small and its installation footprint can be adjusted by deselecting unneeded features during installation, and also in large part to the autonomic tuning features of Informix, it is ideal for embedded systems and is used as the embedded database engine for several mainstream products in telecommunications, environmental management, and similar systems.
  • Its ability to integrate timeseries data with relational data make it ideal for monitoring and for the analytical processing of time oriented data such as utility supply, weather tracking, logistics and warehouse management, etc.
  • Informix's support for JSON/BSON data types and for the MongoDB API and wire listener protocol, in addition to the extensions Informix adds to the MongoDB API to support relational data, generic SQL statements, and multi-step transactions make it an ideal drop in replacement for MongoDB and other document oriented databases when application requirements exceed the capabilities and performance characteristics of these NoSQL database systems.
  • The Informix Warehouse Accelerator (IWA) feature of the Informix Advanced Enterprise Edition can accelerate data warehouse queries several hundred times over the speed of the base Informix and other RDBMS servers. In addition, IWA provides this acceleration with no modifications to applications and analytical tools and without the need to create additional indexes, cubes, or pre-calculated summary tables. Further, queries accelerated with IWA do not affect the performance of simpler queries running in the base Informix engine allowing IWA to provide an analytical query engine on top of a operational data store without complex ETL/ELT data migrations/conversions.
  • Informix typically requires fewer DBAs and less time spent by DBA staff on operational and maintenance operations permitting them to concentrate on other issues and reducing ROI.
I have participated in evaluations of Informix versus most of its competing RDBMS engines. In all of those evaluations, when performance, ease of maintenance, ROI, and effort required to train staff to proficiency are the criteria of decision, Informix has always been the choice.
1
President and Principal Consultant
1
General DBA skills, Informix domain specific knowledge.
  • Data analytics
Informix is the best RDBMS on the market. Period.
No
  • Product Features
  • Product Usability
  • Product Reputation
  • Prior Experience with the Product
  • Third-party Reviews
The combination of performance and the applicability of the feature list to specific projects combined to be the deciding factor.
Might include other products in the evaluation stream.
The Informix product support team has won awards and is appreciated by the entire Informix user community.
Yes
Yes. Most reported bugs result in a patch within a few weeks at the outside with the next scheduled release containing a permanent fix for the issue.
A year or so ago I described a problem with a shortcut function that simplifies creating a virtual table that maps timeseries data to a relational table image for the use of analytical tools that do not understand timeseries data directly. In a few days I was provided with a solution involving using the underlying virtual table technology directly to accomplish the goal. The next release of the engine, available within 60 days, contained a reworked function that fixed the issue, though our problem was already solved by the work-around.
  • Schema alterations
  • Server version upgrades
  • Server monitoring
  • Performance tuning
  • Nothing. Really!
Server management is easy enough to be able to embed the engine in a device and let it run for years without maintenance.
Return to navigation