We performed a comparison between IBM Db2 Database and Oracle Database In-Memory based on real PeerSpot user reviews.
Find out in this report how the two Relational Databases Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The most valuable features of this solution are security and stability."
"The stability of IBM Db2 Database is stable. We have not faced any downtime in one year. Our work is mostly during business hours and during that time, we haven't faced any downtime."
"Scales well enough for a relational database."
"The most valuable feature of the solution is its compatibility with IBM Power Systems."
"It is a scalable solution."
"The most valuable feature of the IBM Db2 Database is the ease of use, and the ability to do query writing of any SQL statement and have an output."
"Reliable, robust with great features."
"The solution has many beneficial features, such as security, support, and stability."
"The application development is very user-friendly."
"The solution is very fast."
"The scalability of the solution is very good. It's able to support large amounts of data."
"I like Oracle because it is a backward-compatible solution."
"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 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."
"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."
"Security is the most valuable feature."
"The solution could improve by providing more integration."
"We just want a bit more integration with Linux. That said, we are already seeing Linux more readily available on the mainframe environment."
"Db2 interface could be improved a bit. Comparing it to Oracle, Db2's interfaces could be improved."
"The initial setup could be improved."
"It would be helpful to have more querying tools and more development tools for us to work easily with Microsoft."
"IBM Db2 Database could improve the user-defined functions. There are some user-defined functions that are missing, such as the spring functions. I used to have Teradata for my projects and I was used to working in the environment. They had a good set of user-defined functions."
"The management of Db2 should be simplified because there are not too many specialists in this area, and the learning curve of Db2 specialists is very long. After the courses, probably it takes one and a half or two years to get to the point when you are using the product properly in the production systems. So, the complexity is very high, and the most important thing is to simplify the management of the product, including self-maintenance. They should simplify the installation, management, and monitoring to simplify the product. It takes too long for a person to be a specialist in this product."
"The technical support can be faster."
"The platform’s pricing needs improvement."
"The high cost of the product is an area of concern where improvements are required."
"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."
"Oracle should include column store or advanced query optimization so a database can be optimized by enabling analytic queries to run faster."
"Technical support is below our expectations currently. It could be improved."
"They should lower the price. My customers think that it's too expensive."
"Lacks sufficient integration with other tools."
IBM Db2 Database is ranked 6th in Relational Databases Tools with 66 reviews while Oracle Database In-Memory is ranked 8th in Relational Databases Tools with 27 reviews. IBM Db2 Database is rated 8.2, while Oracle Database In-Memory is rated 8.8. The top reviewer of IBM Db2 Database writes "Very scalable with high availability and excellent technical support". 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 Db2 Database is most compared with SQL Server, Oracle Database, SAP HANA, Teradata and IBM Netezza Performance Server, whereas Oracle Database In-Memory is most compared with SAP HANA, Progress OpenEdge RDBMS, SQL Server, Apache Derby and kdb+. See our IBM Db2 Database vs. Oracle Database In-Memory report.
See our list of best Relational Databases Tools vendors.
We monitor all Relational Databases Tools 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.