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.
"The solution's ROI is excellent."
"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."
"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 scalability is very good."
"I like Oracle because it is a backward-compatible solution."
"The solution can easily be modeled."
"The solution is very stable."
"The in-memory database is excellent."
"The feature I found most valuable in SAP HANA is modeling. I also like that the solution has good integration and you can integrate it with any system, even third-party systems."
"The solution is marvelous because it controls everything including workflow and that makes our company more productive."
"The UX experience is very good."
"It's stable and reliable."
"A very feature-rich solution with excellent performance."
"They should improve the solution's scalability for large databases."
"The solution should move to the new way of writing software code with AI that is intelligent and learns."
"Lacks sufficient integration with other tools."
"The query optimization and backup features should be added."
"I would like Oracle Database In-Memory to include a data replication feature."
"Oracle should include column store or advanced query optimization so a database can be optimized by enabling analytic queries to run faster."
"It would be good if Oracle could reduce downtime when transferring from non-In-Memory to In-Memory."
"Per SAP, you can do both transactional and analytical processes in SAP HANA. Though that's true, the speed is slower when you combine the two functions, so this is what I'd like SAP to improve in SAP HANA. In the next release, I want to see better diagrams in SAP HANA and a more user-friendly interface."
"I would like to see improvement on the feedback from the road-map; it is currently extremely hard to get insight in this area."
"The only downside of the product is that it is an expensive solution that needs to consider lowering its prices to improve the product."
"Ease of use could be improved in SAP HANA. I like SAP because SAP solutions can be used by anyone, which means even laymen can start working on SAP tools, but in SAP HANA modeling, you'll need to know some other technologies and sequel scripting, and you need a separate skillset, so if you don't have the skillset, you won't be able to work on SAP HANA. Making SAP HANA low-code would make it even better."
"The initial setup was very, very complex, tedious, and costly and required someone with great expertise to complete it."
"More standards would help in the future."
"You cannot apply mulit-join inside the calculation views, for example, when you are joining tables."
"The pricing is expensive."
Oracle Database In-Memory transparently accelerates analytics by orders of magnitude while simultaneously speeding up mixed-workload OLTP. With Oracle Database In-Memory, users get immediate answers to business questions that previously took hours.
Oracle Database In-Memory delivers leading-edge in-memory performance without the need to restrict functionality, or accept compromises, complexity and risk. Deploying Oracle Database In-Memory with any existing Oracle Database compatible application is as easy as flipping a switch - no application changes are required. Oracle Database In-Memory is fully integrated with the Oracle Database’s renowned scale-up, scale-out, storage tiering, availability, and security technologies making it the most industrialstrength offering on the market.
The ability to easily perform real-time data analysis together with real-time transaction processing on all existing applications enables organizations to transform into Real-Time Enterprises that quickly make data-driven decisions, respond instantly to customer demands, and continuously optimize all key processes.
For more information on Oracle Database In-Memory, visit Oracle.com
SAP HANA, also known as SAP High-performance Analytics Appliance, is a multi-model database that stores data in its memory, allowing users to avoid disk storage. The product combines its robust database with services for creating applications. SAP HANA is faster than other database management systems (DBMS) because it stores data in column-based tables in main memory and brings online analytical processing (OLAP) and online transaction processing (OLTP) together.
The column-oriented in-memory database design allows users to run high-speed transactions alongside advanced analytics, all in a single system. This provides companies with the ability to process very large amounts of data with low latency and query data in an instant. By combining multiple data management capabilities, the solution simplifies IT, helps businesses with innovations, and facilitates digital transformation.
The solution is structured into five groups of capabilities, categorized as:
There are three more SAP products that work alongside SAP HANA and complete the experience for users together. SAP S/4HANA Cloud is a ready-to-run cloud enterprise resource planning (ERP). SAP BW/4HANA is a packaged data warehouse, based on SAP HANA, which allows users to consolidate data across the enterprise to get a consistent view of their data. Finally, SAP Cloud is a single database as a service (DBaaS) foundation for modern applications and analytics across all enterprise data. All three products can combine with SAP HANA to deliver to users an optimized experience regarding their data.
SAP HANA Features
Each architectural group of capabilities of SAP HANA has various features that users can benefit from. These include:
SAP HANA Benefits
SAP HANA provides many benefits for its users. These include:
Reviews from Real Users
According to a database consultant at a pharma/biotech company, SAP HANA is a very robust solution with good data access.
Bruno V., owner at LAVORO AUTOM INF E COM LTDA, likes SAP HANA because the product offers advanced features, helps reduce hours, and makes it easy to find what you need.
Oracle Database In-Memory is ranked 9th in Relational Databases Tools with 7 reviews while SAP HANA is ranked 3rd in Relational Databases Tools with 45 reviews. Oracle Database In-Memory is rated 8.8, while SAP HANA is rated 8.6. The top reviewer of Oracle Database In-Memory writes "A highly-compatible solution that sped up analytical processes ". On the other hand, the top reviewer of SAP HANA writes "Good integration capabilities, easy to implement, and reliable". Oracle Database In-Memory is most compared with Progress OpenEdge RDBMS, SQL Server, IBM Db2 Database, MySQL and MariaDB, whereas SAP HANA is most compared with Oracle Database, SQL Server, IBM Db2 Database, MySQL and Teradata. See our Oracle Database In-Memory vs. SAP HANA report.
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.