What users are saying about
54 Ratings
7 Ratings
54 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9.1 out of 101
7 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9.5 out of 101

Likelihood to Recommend

Amazon Aurora

For workloads that already use, or plan on using, MySQL or PostgreSQL, Aurora is our new go-to favorite deployment option for projects on AWS. The best use cases for Aurora will be substantial workloads that are well-suited to the simple scaling controls (both from an instance type perspective, as well as storage perspective), and will benefit from Aurora's simple, very low latency read replicas. Aurora is extremely fault tolerant and has improved self-healing ability.
No photo available

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

Amazon Aurora

  • Aurora is a relational database as a service on AWS which is MySQL and Postgres compatible. So if you are looking for a serverless option which going through need to host and manage a database then Aurora as a service is great.
  • It is a simple and cost-effective open source database which is much cheaper than a normal database cost. Hence very efficient for microservices database where you do not need one very large centralized database but many small databases that are available and low latency.
  • Aurora provides high performance and low latency. Last year they also announced multi-master in the same region and read replicas in multiple regions. This is very convenient if you are trying to design and build a highly reliable application.
No photo available

IBM Informix

  • 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

Amazon Aurora

  • Without direct access to the instances it isn't possible to do a few things you'd be able to do if you were running your own database server, but this is rarely an issue
Andrew Raines profile photo

IBM Informix

  • 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
Eric Vercelletto profile photo

Likelihood to Renew

Amazon Aurora

No score
No answers yet
No answers on this topic

IBM Informix

IBM Informix 10.0
Based on 1 answer
Informix is the best RDBMS on the market. Period.
Art S. Kagel profile photo

Usability

Amazon Aurora

No score
No answers yet
No answers on this topic

IBM Informix

IBM Informix 10.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

Amazon Aurora

No score
No answers yet
No answers on this topic

IBM Informix

IBM Informix 10.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

Amazon Aurora

In the end, we went with Amazon Aurora due to the decent performance and cost. Cost was determined in two ways for us: 1) no additional license is required (such as using SQL Server or Oracle) and 2) the ability to cut down on needed resources to maintain the system from the maintenance perspective due to the built-in maintenance capabilities. Amazon Aurora is also based on MySQL (soon to include PostgreSQL ) which allowed my team to quickly and easily move our existing MySQL servers to a faster system.
No photo available

IBM Informix

  • 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!
Eric Vercelletto profile photo

Return on Investment

Amazon Aurora

  • The main positive for my team is the time that has been freed up from the tasks of managing updates and fixing replication issues.
  • A negative for myself as a database administrator is removal of features that were available in Mysql. Examples include 1) the use of the storage engines other than InnoDB (such as the Federated Storage Engine), 2) certain administrative privileges such as ability to export to csv file and easy ability to kill processes. I seem to also forget they removed the built-in kill ability and you must use their own provided kill functionality.
No photo available

IBM Informix

  • 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
Eric Vercelletto profile photo

Pricing Details

Amazon Aurora

General

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

IBM Informix

General

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

Add comparison