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."The scalability is very good."
"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."
"It supports in-house-built applications in .NET and VB6"
"The solution's stability, performance, enhanced functionality, and replication are all great features."
"IBM Informix benefits users with high availability and good integration capabilities."
"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."
"So far, we do not have a lot of issues. It's pretty problem-free."
"The initial setup is pretty easy."
"The product offers high scalability."
"The scalability is very good."
"The solution's ROI is excellent."
"It efficiently handles low-code data and supports read-and-write operations for clustering."
"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."
"Security is the most valuable feature."
"The most valuable feature is that Database-In-Memory is more consistent and faster than traditional databases as it requires fewer CPUs to process instructions."
"The technical support services need substantial improvement."
"This solution is in need of more current tools."
"There should be more intelligence surrounding discovering data to be able to automatically create indexes."
"The solution lacks some functionality."
"I really would love to have a QT plugin."
"It would be helpful to have IBM salespeople know that Informix exists, and sell it. Currently, it is completely ignored by IBM."
"I would like to see backups from secondary servers."
"This product could be made easier to use for beginners."
"The solution should move to the new way of writing software code with AI that is intelligent and learns."
"I would like Oracle Database In-Memory to include a data replication feature."
"We use some partitions in In-Memory. We have a very large table and a low dose. It is very expensive in data to load all of them into In-Memory. It takes up more memory slots in the server, as well as a lot of RAM. We use last partitions on the table. We always need to create a script and make a schedule that can load a last partition in In-Memory. Oracle doesn't have features to do this automatically. I would like them to allow us to load last partitions, as well as other table partitions, in In-Memory. I think a good feature would do that automatically, letting you see a table, load a large partition, and monitor loading memory. It's quite a good feature."
"Technical support is below our expectations currently. It could be improved."
"Oracle should include column store or advanced query optimization so a database can be optimized by enabling analytic queries to run faster."
"They should lower the price. My customers think that it's too expensive."
"They should improve the solution's scalability for large databases."
"It would be good if Oracle could reduce downtime when transferring from non-In-Memory to In-Memory."
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, MySQL and MariaDB, whereas Oracle Database In-Memory is most compared with SAP HANA, IBM Db2 Database, Progress OpenEdge RDBMS, SQL Server and Apache Derby. 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.
