Overview
What is IBM Informix?
Informix is an embedded relational database offering from IBM.
IBM Informix is an Effective Cloud Platform for the Multiple Services Automation.
A point of view on Informix IDS and tools
IBM Informix, the unknown wonderful database
Informix, still the RDBMS of choice among those who have used it.
The Basal Stone.
Best of breed for critical production environments, and IOT infras from top to bottom
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
Pricing
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…
Product Demos
Intel-IBM Informix Building Automation Demo
IBM Informix (IDS) - High and Continuous Availability
0 IBM Informix 12.1 Demo
Product Details
- About
- Tech Details
What is IBM Informix?
IBM Informix Technical Details
Operating Systems | Unspecified |
---|---|
Mobile Application | No |
Comparisons
Compare with
Reviews and Ratings
(16)Attribute Ratings
Reviews
(1-7 of 7)Reliable Database Management
A point of view on Informix IDS and tools
IBM Informix, the unknown wonderful database
- Transactional operations.
- Embedded database, like in IoT.
- Full end to end IoT integration.
- Solutions requiring database extensibility.
- Support for hybrid data structures (relational and NoSQL).
- Storing text data, even if the text datablade is a great product, now integrated, it is not designed for this.
- 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.
The Basal Stone.
This is why Informix is able to adapt to almost any sort of environment and satisfy almost any sort of requirement, even if the requirement is to be embedded in hardware! This last is possible because it it requires zero support and maintenance, as it can be self tuned and self healed. One of the main scenarios which is nowadays getting promoted for is the IoT one. Starting from mid 90's Informix incorporated the extensibility concept through the datablades it had brought from Illustra. This is why it is pioneer in the TimeSeries and GeoSpatial (tracking moving objects) technology, with the fastest and best storing TimeSeries techniques and GeoSpatial functionalities. The Wire Listener is one of the best features Informix has introduced to its suit of functionalities, can work in three different scenarios API types: MQTT, REST and MONGO, supporting IoT, MongoDB (an application using MongoDB can be redirected as it is to Informix-Mongo without changes) and able to understand HTTP functions (POST, GET, PUT, etc).
- demanding industrial automation processing
- infrastructures required complex replication schemas, with servers located on different places/regions/countries
- Applications intensively using timestamp and or geospatial
- Simplifying DBMS by using at the same time SQL and NoSQL, needless to use separately RDBMS and NoSQL DBMS
- Amazingly low requirements for DBA staff, in general, Informix is good for companies who like simplicity and efficiency
- Informix being a pay-for solution, it may not be recommended for companies who do not want to spend money for a DBMS,
- Also Informix is not good for companies who refuse to consider anything than the top 5