What users are saying about

1010data

5 Ratings

IBM Informix

7 Ratings

1010data

5 Ratings
Score 4.7 out of 101

IBM Informix

7 Ratings
Score 9.6 out of 101

Add comparison

Likelihood to Recommend

1010data

The software is excellent for any application which is too large for Excel. The visual interface surpasses that of most SQL platforms. It is quite useful for data mining in an exploratory way but less useful in statistical and regression analysis.

IBM Informix

  • 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.

Pros

  • Crunches huge datasets
  • Has versatility in functionality and grouping capabilities
  • Native XML macro language is easy to master
  • The platform has great visualization tools
  • Informix is very stable. It has stayed up and running for years. The only downtimes we had were due to planned power outages. This is a mandatory quality required in a industrial environment.
  • Informix has a very rich and extended replication system that allows many useful functionalities:
  • High Availability
  • Tables or part of tables replication, both ways
  • Replication patterns like 1 to many servers and sharing storage between 2 servers
  • All these replication techniques can be combined together and we love the simplicity of their set up.
  • Informix has been featuring NoSQL datatype ( JSON/BSON) for almost 5 years now, including the NoSQL MongoDB style language.
  • Once you have loaded your MongoDBdata into Informix, you can run any application compatible with the MongoDB 3.0 stack
  • The biggest advantage of this solution is that you can execute joins with SQL Structured tables and NoSQL collections alltogether, either in SQL language or in NoSQL language.
  • I heard recently that Informix is available on AWS, with a very wide range of configurations from very small to very big. This is something we would like to look at
  • Informix runs on gateway devices, like for instance Raspberry PI / Arm based nano computer or Intel Quark based. This is the same product that works on bigger platforms, including the replication architecture that makes IOT applications much easier to develop and maintain.
  • Informix is also directly accessible thru the REST protocol, with is a great asset for IOT applications, based on Node JS, Python, running on nanocomputers. This makes those applications much tinier in terms of resource comsumption, as well as efficient.

Cons

  • The ten.do interface could use more detailed documentation
  • The name of Informix is almost invisible on the market, which is very frustrating. This give the feeling that IBM is not interested in Informix without providing any reasons for why IBM makes no effort to sell Informix.
  • The pricing policy is very complex

Likelihood to Renew

No score
No answers yet
No answers on this topic
IBM Informix10.0
Based on 1 answer
Informix is the best RDBMS on the market. Period.

Usability

1010data8.0
Based on 1 answer
That's votes by our team.
IBM Informix10.0
Based on 1 answer
Server management is easy enough to be able to embed the engine in a device and let it run for years without maintenance.

Support

No score
No answers yet
No answers on this topic
IBM Informix10.0
Based on 1 answer
The Informix product support team has won awards and is appreciated by the entire Informix user community.

Alternatives Considered

While we have used SQL, 1010data is really the only industry standard product available for our use.
  • Informix vs. Oracle: although both products are real enterprise-class DBMS, satisfying robustness and scalability criteria, Informix is much more easy and simple to admin. It requires much fewer resources in terms of DBA staffing for an equivalent infrastructure on Oracle. Also, we have noticed that Informix consumes noticeably less hardware resource than Oracle for an identical level of performance. This is probably due to the Informix real-multithread architecture.
  • Informix vs. MS SQL Server: we do not consider Microsoft as a reliable platform for a database server, at least for critical service
  • Informix vs. PostgreSQL: PostgreSQL is a great product: it seems to scale nicely, very rich in terms of SQL language, has a nice implementation of NoSQL too. Nonetheless, we have doubts about the ease of version upgrading, an operation that generally takes less than 2 minutes with Informix, even on production systems. Also, it seems that the replication architecture is not as clear nor complete as Informix' replication, probably due to the fact of not having a unique software architect. We like to have a unique contact for the product maintenance and not a community.
Those criteria [helped] us to keep Informix as the preferred DBMS, despite many people around totally ignore it. What a waste!

Return on Investment

  • This has sped up the process of analysis.
  • We can now automate process which were performed manually.
  • Analysis can be performed more frequently.
  • Although I do not own nor have visibility on my company's figures:
  • Informix generates consistent savings on DBA staffing, no need for many DBAs as other DBMS require.
  • The replication architecture allowed consistent savings in the infrastructure as well as developments and maintenance, the job is already done, no need to develop complex and costly solutions, it's just a matter of configuring it.
  • The advantages of hybrid development (i.e mixing SQL and NoSQL in the same database) is not just a marketing hype: it allowed us to solve with a brilliant solution, in one afternoon of coding, a functional problem we have been having for more than 10 years!
  • The biggest drawback is that IBM pricing may be constraining, it has too important gaps between the mid range and highrange in terms of pricing

Pricing Details

1010data

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

IBM Informix

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details