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 solution's stability, performance, enhanced functionality, and replication are all great features."
"IBM Informix benefits users with high availability and good integration capabilities."
"It supports multiple applications and business intelligence tools."
"Replication, all levels of replication, query charting, and the MongoDB embedded are the most valuable features of this solution."
"It supports in-house-built applications in .NET and VB6"
"The initial setup is pretty easy."
"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."
"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."
"We use the tool for real-time data transfer for risk management purposes. In a trading system, conversions happen fast. We use the product to handle fast transactions with low latency."
"It efficiently handles low-code data and supports read-and-write operations for clustering."
"Oracle Database In-Memory is a suite of features that improves performance for real-time analytics and mixed workloads."
"The scalability of the solution is very good. It's able to support large amounts of data."
"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."
"I like Oracle because it is a backward-compatible solution."
"The solution is very fast."
"I really would love to have a QT plugin."
"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."
"I would like to see backups from secondary servers."
"The support team could include local engineers to establish efficient communication. It will help us speed up the escalation process."
"This solution is in need of more current tools."
"I experienced poor input/output (IO) performance."
"The solution really doesn't add new features very often."
"There should be more intelligence surrounding discovering data to be able to automatically create indexes."
"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."
"The query optimization and backup features should be added."
"They should lower the price. My customers think that it's too expensive."
"I would like Oracle Database In-Memory to include a data replication feature."
"The platform’s pricing needs improvement."
"It would be good if Oracle could reduce downtime when transferring from non-In-Memory to In-Memory."
"The product could be more economical."
"The pricing could be improved. It would ideal if it was more reasonable."
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 MariaDB. 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.