We performed a comparison between Actian PSQL, Oracle Database In-Memory, and SAP HANA based on real PeerSpot user reviews.
Find out what your peers are saying about SAP, Oracle, Firebird and others in Embedded Database."Actian PSQL is easy to configure and the performance is affordable."
"We can integrate it with any data sources as well."
"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."
"It efficiently handles low-code data and supports read-and-write operations for clustering."
"The solution's ROI is excellent."
"Oracle Database In-Memory is a suite of features that improves performance for real-time analytics and mixed workloads."
"The solution is very fast."
"The memory is the solution's most valuable feature. It's the main feature of HANA. Others are still the regular IT databases that are on storage and are therefore much slower than HANA. The solution is quite fast."
"We can save data very easily."
"The solution offers advanced features that the company was struggling to implement."
"The solution is marvelous because it controls everything including workflow and that makes our company more productive."
"We have found that the Fiori Apps are particularly good."
"SAP HANA is vertically and horizontally scalable."
"It is very stable and very innovative. You can integrate many applications with it."
"We like that the product is both vertically and horizontally scalable, allowing us to do around 86 percent compression of documentation from 50 to seven terabytes."
"We need to improve the security options for the on-premise option."
"I would like Oracle Database In-Memory to include a data replication feature."
"The solution is quite expensive."
"It would be good if Oracle could reduce downtime when transferring from non-In-Memory to In-Memory."
"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."
"The high cost of the product is an area of concern where improvements are required."
"The pricing could be improved. It would ideal if it was more reasonable."
"Oracle should include column store or advanced query optimization so a database can be optimized by enabling analytic queries to run faster."
"There could be better management for faster updates, last year there were some changes in India to the e-invoicing feature."
"The initial setup of SAP HANA is complex. We did the implementation of one site, and a global deployment will take another three to four years."
"While new users to this solution have the benefit of the new design, existing ERP users may experience issues with migrating legacy data. We would like to see development of ready-made tools that allow for easy mapping when upgrading."
"In a future release, SAP HANA should add a module for taxation, such as income tax and withholding tax."
"The product lacks some flexibility in its settings and configurations."
"What needs improvement in SAP HANA is its automation, in particular, it needs more enhancements in that area."
"The interface is a little bit hard to customize. You almost have to consult the SAP original developer to change it."
"The solution needs to work on its performance and make it faster."
