We performed a comparison between IBM Informix and Oracle Database In-Memory based on real PeerSpot user reviews.
Find out in this report how the two Embedded Database solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."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."
"This solution has made financial reporting possible by allowing financial people the opportunity to set Informix to "Auto Pilot" so that they can attend other duties."
"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."
"The initial setup is pretty easy."
"The scalability is very good."
"So far, we do not have a lot of issues. It's pretty problem-free."
"The solution's stability, performance, enhanced functionality, and replication are all great features."
"Replication, all levels of replication, query charting, and the MongoDB embedded are the most valuable features of this solution."
"The on-premise version is stable. We have different teams and resources for the server side, for admin, and for development. We can easily take care of all the services and applications."
"The product offers high scalability."
"The solution's ROI is excellent."
"The most valuable aspects of this solution are the fast caching and improved performance to the database"
"Oracle Database In-Memory is a suite of features that improves performance for real-time analytics and mixed workloads."
"The scalability is very good."
"Normally, every database server uses hard disks. In-Memory has a feature, apart from their database, which is very good. When we start our server, all your data needs loading memory. We can use that. It's a very good feature. I think they added this feature in 2019. We can mount memory in the partition, create partitions in there, and create table space from that spot to share. It's a really good feature. We use it a lot."
"We can integrate it with any data sources as well."
"I would like to see backups from secondary servers."
"Continue extending the SQL language for compatibility with the competition's language, including Stored Procedure Language."
"It would be helpful to have IBM salespeople know that Informix exists, and sell it. Currently, it is completely ignored by IBM."
"The pricing is a bit expensive."
"The support team could include local engineers to establish efficient communication. It will help us speed up the escalation process."
"There should be more intelligence surrounding discovering data to be able to automatically create indexes."
"This solution is in need of more current tools."
"The solution really doesn't add new features very often."
"Technical support is below our expectations currently. It could be improved."
"They should improve the solution's scalability for large databases."
"The query optimization and backup features should be added."
"The pricing could be improved. It would ideal if it was more reasonable."
"Oracle should include column store or advanced query optimization so a database can be optimized by enabling analytic queries to run faster."
"Oracle Database In-Memory appliance-based solutions can be restrictive for some applications, as they may require more flexibility in the database design to be tuned and sized to the customer's needs."
"The high cost of the product is an area of concern where improvements are required."
"Lacks sufficient integration with other tools."
IBM Informix is ranked 6th in Embedded Database with 16 reviews while Oracle Database In-Memory is ranked 2nd in Embedded Database with 27 reviews. IBM Informix is rated 8.6, while Oracle Database In-Memory is rated 8.8. The top reviewer of IBM Informix writes "Quite stable and flexible but not very innovative". On the other hand, the top reviewer of Oracle Database In-Memory writes "User friendly with great scalability but needs to move toward intelligent AI". IBM Informix is most compared with Oracle Database, SQL Server, IBM Db2 Database and MySQL, whereas Oracle Database In-Memory is most compared with SAP HANA, Progress OpenEdge RDBMS, IBM Db2 Database and SQL Server. See our IBM Informix vs. Oracle Database In-Memory report.
See our list of best Embedded Database vendors and best Relational Databases Tools vendors.
We monitor all Embedded Database reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.