IBM Informix vs Oracle Multitenant comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

IBM Informix
Ranking in Relational Databases Tools
15th
Average Rating
8.6
Number of Reviews
16
Ranking in other categories
Embedded Database (6th)
Oracle Multitenant
Ranking in Relational Databases Tools
16th
Average Rating
8.4
Number of Reviews
15
Ranking in other categories
No ranking in other categories
 

Market share comparison

As of June 2024, in the Relational Databases Tools category, the market share of IBM Informix is 2.3% and it increased by 28.3% compared to the previous year. The market share of Oracle Multitenant is 0.3% and it decreased by 56.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Relational Databases Tools
Unique Categories:
Embedded Database
16.7%
No other categories found
 

Featured Reviews

BT
Apr 8, 2021
Quite stable and flexible but not very innovative
We are using the latest version of the solution in our organization. I was in the company for almost 20 years. Initially, we had quite a lot of databases. Basically, most of our big database was using Informix. And then, 10 years ago, we started the first migration to Oracle due to the licensing costs. On the first attempt, we changed to Oracle due to the fact that we got a very good deal from Oracle. Then, we moved one of the applications to Oracle. This year, the company direction is to go completely over to Oracle. That said, we still have one application, which until today we still use Informix for. That's why there's the intent to also migrate to Oracle, so that our company will focus on Oracle only, instead of multiple kinds of application databases. I look at the current market trends. It seems like IBM Informix is a little bit behind compared to other big vendors like Oracle. Competitors invest a lot in new features, such as in-memory and those kinds of things. We don't see a lot from Informix. In general, I would rate the solution at a six out of ten. It's an okay solution, however, if a company is looking for something more innovative, there are other options on the market.
François Dernoncourt - PeerSpot reviewer
May 31, 2022
Databases are automatically upgraded and cloning of pluggable databases requires just one command
We are currently migrating to Oracle's multitenant architecture and are in the process of moving databases over from the old architecture to use this as a multitenant database. We are customers of Oracle and integrators of this solution This is a cost-effective solution because we're using the…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"Replication is a valuable feature and easy to use."
"It supports in-house-built applications in .NET and VB6"
"The initial setup is pretty easy."
"IBM Informix benefits users with high availability and good integration capabilities."
"Every version is faster than the previous."
"The most valuable feature is concurrency and locking because my customers usually use databases in OLTP mode. So, for a large number of competitive users. Other features that are well valued are quick large-scale data types. It is better than Oracle."
"For IoT business cases, having Informix Enterprise Edition work on edge computers, like Raspberry Pi and using Informix replication, makes complex situations simple to build and maintain."
"Replication, all levels of replication, query charting, and the MongoDB embedded are the most valuable features of this solution."
"You can scale the solution as needed."
"The most valuable features are the speed and ease of use."
"The database becomes pluggable. Inside this container is called a pluggable database and each application contains this pluggable database inside Multitenant. We can then share resources like control files, memory, etc. This lets you stop and start each application without impacting the others. This resource sharing is the most valuable feature"
"The feature that I like on Multitenant is the ease - it is very easy for my team to run the database."
"It's easy to use and works great."
"Maintaining databases is a valuable feature for us."
"Multitenant has a container database with many pluggable databases."
"The best thing about Oracle Multitenant is its ability to consolidate multiple databases into one engine."
 

Cons

"This solution is in need of more current tools."
"In my opinion, the packages could be improved. The version I use doesn't allow for packages. I can do some general procedures, but no packages like in Oracle. So, develop separate modules in SQL language. This would be most beneficial for me."
"This product could be made easier to use for beginners."
"The support team could include local engineers to establish efficient communication. It will help us speed up the escalation process."
"I would like to see backups from secondary servers."
"The solution lacks some functionality."
"The technical support services need substantial improvement."
"It would be helpful to have IBM salespeople know that Informix exists, and sell it. Currently, it is completely ignored by IBM."
"While the product is overall excellent, it is quite expensive."
"That said, Oracle in general doesn't invest in their UI for any of their applications. If we're talking about the dashboard or other user experience, there is room for improvement. I'm talking about on premises. The cloud version has started to improve."
"The solution lacks a GUI for commands."
"It can be complicated to scale up the solution, but it's scalable."
"This solution is a bit complicated when collecting from containers - that feature should be a bit better."
"The user interface for this solution can be made better."
"It would be beneficial to include this solution with Oracle Enterprise, but Oracle charges additional fees for it."
"Technical support could be faster."
 

Pricing and Cost Advice

"The product has reasonable pricing. We purchase its yearly license."
"I am not aware of the licensing costs or terms."
"For me, it's always too expensive."
"The free edition can be enough to handle moderate-size implementations, but you may want a pay for edition to benefit from more functionality, such as replication."
"For me, I will go with it if I have the budget. Some features are nicer than before, but at the end of the day, you always have a limited budget. I prefer to upgrade and get a specific hardware when possible. At the end, you will have to make a compromise. You will not get everything you would have liked to have."
"This solution is a little bit pricey."
report
Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
787,226 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
54%
Financial Services Firm
5%
Retailer
5%
Computer Software Company
5%
Financial Services Firm
19%
Computer Software Company
11%
Manufacturing Company
8%
Government
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about IBM Informix?
It supports multiple applications and business intelligence tools.
What is your experience regarding pricing and costs for IBM Informix?
The product has reasonable pricing. We purchase its yearly license.
What needs improvement with IBM Informix?
The key areas for improvement revolve around understanding the current customer trends and demands, particularly in software and database requirements. The product's performance could be better com...
What do you like most about Oracle Multitenant?
The best thing about Oracle Multitenant is its ability to consolidate multiple databases into one engine.
What is your experience regarding pricing and costs for Oracle Multitenant?
Oracle Multitenant is suitable mainly for large enterprises due to its high cost and resource demands. There are additional fees beyond standard licensing, which makes it expensive.
What needs improvement with Oracle Multitenant?
While the product is overall excellent, it is quite expensive.
 

Comparisons

 

Also Known As

Informix
Oracle Pluggable Database
 

Learn More

Video not available
 

Overview

 

Sample Customers

Shaspa, Hildebrand, Kaifa, Ranhill Powertron, Federaci‹ Farmacutica (FedeFarma), Camden Council, The German Aerospace Center (DLR), Myers, Votorantim Group, Doosan Infracore, GreenIvory
An Post, National Oilwell Varco, SAS Institute, Sportmaster, Y-Telecom
Find out what your peers are saying about IBM Informix vs. Oracle Multitenant and other solutions. Updated: May 2024.
787,226 professionals have used our research since 2012.