We performed a comparison between Oracle Database In-Memory and SAP HANA 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."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."
"The scalability of the solution is very good. It's able to support large amounts of data."
"The scalability is very good."
"Security is the most valuable feature."
"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."
"We can integrate it with any data sources as well."
"Oracle Database In-Memory is a suite of features that improves performance for real-time analytics and mixed workloads."
"The most valuable aspects of this solution are the fast caching and improved performance to the database"
"What's most valuable in SAP HANA is that it covers the business process systems of my company. The solution also helps because it makes almost everything automated. Another valuable feature of SAP HANA is that it can be integrated with third parties and other enhancements needed by the company."
"Eases management of databases."
"The in-memory database is excellent."
"It is difficult for me to narrow down what the best features are in SAP HANA because they work together to provide the overall functionality of the solution. However, the Fiori application is very good."
"The solution is easy to manage enterprise resources and the reporting and analytics are including. It is good for company growth and all module are managed well."
"We have found the solution to be customizable and it is beneficial it comes as a bundled package. Additionally, it is user-friendly."
"Provides us with predictive capabilities for asset maintenance, and real-time forecasts."
"All features are valuable."
"The product could be more economical."
"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."
"The high cost of the product is an area of concern where improvements are required."
"The query optimization and backup features should be added."
"The platform’s pricing needs improvement."
"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 bid process needs to be improved."
"I think that the pricing is high and it needs improvement."
"The releases need to be more stable. It's surprising to still encounter significant bugs after ten years of the product being available."
"The solution's development platform should be more flexible and scalable to adapt to other solutions."
"When you do a report on a non-SAP platform, you face some compatibility problems."
"SAP HANA is not strong like Oracle when it comes to finance. They are only strong with the logistic business project."
"Uses a large amount of RAM and is costly."
"The product is very demanding on memory requirements."
Oracle Database In-Memory is ranked 8th in Relational Databases Tools with 27 reviews while SAP HANA is ranked 3rd in Relational Databases Tools with 81 reviews. Oracle Database In-Memory is rated 8.8, while SAP HANA is rated 8.4. The top reviewer of Oracle Database In-Memory writes "User friendly with great scalability but needs to move toward intelligent AI". On the other hand, the top reviewer of SAP HANA writes "Excellent compatibility between modules and the control". Oracle Database In-Memory is most compared with IBM Db2 Database, Progress OpenEdge RDBMS, SQL Server, Apache Derby and kdb+, whereas SAP HANA is most compared with Oracle Database, SQL Server, MySQL, IBM Db2 Database and Teradata. See our Oracle Database In-Memory vs. SAP HANA report.
See our list of best Relational Databases Tools vendors and best Embedded Database 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.