What users are saying about

1010data

5 Ratings

IBM Informix

7 Ratings

1010data

5 Ratings
Score 4.3 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.
Marc Gilbert profile photo

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.
Art S. Kagel profile photo

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
Marc Gilbert profile photo
  • 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.
Art S. Kagel profile photo

Cons

  • The ten.do interface could use more detailed documentation
Marc Gilbert profile photo
  • 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.
Art S. Kagel profile photo

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.
Art S. Kagel profile photo

Usability

1010data8.0
Based on 1 answer
That's votes by our team.
Henry PAN profile photo
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.
Art S. Kagel profile photo

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.
Art S. Kagel profile photo

Alternatives Considered

While we have used SQL, 1010data is really the only industry standard product available for our use.
Marc Gilbert profile photo
As a DB Team Leader I have been looking after other platforms (SQLSvr, MySQL, Oracle and PostgreSQL), supporting application changes, and driving their platforms enhancements through lots of projects over many years. The more I have learnt from other platforms, the more I found Informix as the easiest and most convenient platform to administer and implement.I never had the chance to decide over the DB platform, but if I had to, no doubt I would seriously consider it. After all I have explained about its characteristics, I can definitely say that Informix has the lowest cost ownership, and it is the best one suited and prepared for the current and future challenges.
Andrés Repossi profile photo

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.
Marc Gilbert profile photo
  • As I have explained earlier, Informix has had along the past 15 years, the lowest number of vulnerability defects reported in NVD. Informix allows you to disregard the vulnerability defects, and spend your time building and growing your business instead of wasting it in patching and fixing every quarter! This to me is the best example I can empirically prove that Informix is definitely one of the best return of investment and so that any CDO or CIO should pay attention at the time to consider what platform to chose, to build on top!
  • The other return of investment any CDO or CIO should pay attention to, is the number of DBAs a DB platform should be required to support it! Informix with the SELF-everything, is getting chosen by companies as the best suited engine given its low footprint and little maintenance to get it embedded in their hardware.
  • Given its uptime and minimum planned outages Informix allows you to have, it is yet another reason Informix is not means an investment and not a money waste!
Andrés Repossi profile photo

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