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 scalability is very good."
"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."
"Security is the most valuable feature."
"The scalability of the solution is very good. It's able to support large amounts of data."
"It accelerates query processing, which in turn speeds up operations and streamlines workflow, and ultimately enhancing productivity."
"The application development is very user-friendly."
"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 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."
"The initial setup is straightforward."
"We need to improve the security options for the on-premise option."
"The solution should move to the new way of writing software code with AI that is intelligent and learns."
"The high cost of the product is an area of concern where improvements are required."
"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."
"We often have to find solutions on our own through the support site, so there's room for improvement in this regard."
"They should improve the solution's scalability for large databases."
"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."
"Advanced security would be a good additional feature."
"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."
Earn 20 points