We performed a comparison between Actian PSQL, Oracle Database In-Memory, and Progress OpenEdge RDBMS 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 most valuable feature is that Database-In-Memory is more consistent and faster than traditional databases as it requires fewer CPUs to process instructions."
"The solution is very fast."
"The application development is very user-friendly."
"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."
"The solution's ROI is excellent."
"Security is the most valuable feature."
"It accelerates query processing, which in turn speeds up operations and streamlines workflow, and ultimately enhancing productivity."
"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 initial setup is straightforward."
"The product can be scaled in any direction and a very nice feature is that you can logically split the database by the value of the data, which is great."
"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."
"The high cost of the product is an area of concern where improvements are required."
"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 solution should move to the new way of writing software code with AI that is intelligent and learns."
"The platform’s pricing needs improvement."
"They should improve the solution's scalability for large databases."
"We often have to find solutions on our own through the support site, so there's room for improvement in this regard."
"The only big hurdle for us is that most customers aren't familiar with it, so it's scary. If you're in commercial environments, everybody knows SQL, everybody knows Oracle, or whatever."
"Advanced security would be a good additional feature."
Earn 20 points
