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."
"The solution's ROI is excellent."
"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 solution is very fast."
"It accelerates query processing, which in turn speeds up operations and streamlines workflow, and ultimately enhancing productivity."
"We can integrate it with any data sources as well."
"The scalability of the solution is very good. It's able to support large amounts of data."
"Security is the most valuable feature."
"The application development is very user-friendly."
"The functionality is of the solution is very good."
"In comparison with other DMS solutions, it offers good performance."
"SAP HANA is one of the best databases known for its performance...The new version of the solution is stable."
"Technically it resembles Oracle, but as a somewhat lighter version."
"What I like best about SAP HANA is that it's faster than Microsoft SQL Server."
"The speed at which it gets the data is great."
"As I only worked part-time on SAP HANA, I did not have the opportunity to explore the advanced features of the solution. However, I did work with basic features, such as user administration and access controls for the accounting department. The feature that stood out to me the most was the Single Sign-On and user administration, backup, and server management. My experience with SAP HANA was mainly focused on basic server improvements."
"The in-memory computing and the efficient response time are very good features."
"We need to improve the security options for the on-premise option."
"Oracle should include column store or advanced query optimization so a database can be optimized by enabling analytic queries to run faster."
"The product could be more economical."
"Lacks sufficient integration with other tools."
"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."
"Technical support is below our expectations currently. It could be improved."
"The high cost of the product is an area of concern where improvements are required."
"It would be good if Oracle could reduce downtime when transferring from non-In-Memory to In-Memory."
"What needs improvement in SAP HANA is its automation, in particular, it needs more enhancements in that area."
"The user experience should be better. Its user interface is not good. I also don't like the transition concept."
"The pricing is expensive."
"The pricing could be better."
"The solution's development platform should be more flexible and scalable to adapt to other solutions."
"The solution could improve by having better migration flexibility. For example, it would be helpful if there was a way for customers could check their nonproduction and production deployments."
"SAP HANA is not strong like Oracle when it comes to finance. They are only strong with the logistic business project."
"SAP HANA is not perfect and they could improve by having more options and more integration."