We performed a comparison between Amazon Aurora and Oracle Database In-Memory 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 most valuable feature is that the maintainability is offloaded to the service provider. I don't have to maintain a database or do any administrative tasks, which comes in handy."
"We had better control over the parameters that we could tweak in terms of intermediate storage and better indexing capabilities."
"The solution’s scalability is good since we don’t need to take a maintenance window during unpredictable workloads. I like the solution’s behind-the-scenes happenings. It is a great feature."
"Aurora's compatibility with MySQL or PostgreSQL benefited our database management. The migration from on-premise MySQL to Aurora was similar, so we didn't need to change our source code."
"The most valuable feature of Amazon Aurora is SQL standardization, it doesn't have its own syntax which is good. It has a lot of hands-off self-management type of activities, such as log rolling and auto-scaling."
"The provision of custom read and write endpoints eliminates the need for managing a separate proxy load balancer."
"The most valuable feature is the ability to do multiple-read and single-write. These are the kinds of features that we were interested in, and Aurora takes care of that natively."
"The scalability of the solution is very good. It's able to support large amounts of data."
"Security is the most valuable feature."
"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 product offers high scalability."
"The scalability is very good."
"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 most valuable aspects of this solution are the fast caching and improved performance to the database"
"I would like to see more AI-related features in future releases."
"The pricing could improve. It should be reduced."
"It would have been helpful if they had provided some benchmarking numbers."
"There is improvement needed to have more developer focus. Additionally, it would be helpful to have a stand-alone solution outside of Amazon. Amazon has a tendency to favor developing web-based clients, which may not always provide the fastest or most responsive solution as desired."
"I would like to see performance insights on the database based on the queries. Currently, we use SolarWinds as the monitoring tool. I would like to leverage SolarWinds’ performance insights in AWS services. SolarWinds gives larger insights when we run performance issues."
"The product's distributed query process for MySQL needs improvement."
"It is a bit costly. The features are quite good, and I wouldn't say it requires any technical improvements. But from a cost perspective, some clients wouldn't go for Aurora because of that."
"They should lower the price. My customers think that it's too expensive."
"The product could be more economical."
"Oracle should include column store or advanced query optimization so a database can be optimized by enabling analytic queries to run faster."
"I would like Oracle Database In-Memory to include a data replication feature."
"Oracle Database In-Memory appliance-based solutions can be restrictive for some applications, as they may require more flexibility in the database design to be tuned and sized to the customer's needs."
"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 platform’s pricing needs improvement."
Amazon Aurora is ranked 11th in Relational Databases Tools with 7 reviews while Oracle Database In-Memory is ranked 8th in Relational Databases Tools with 27 reviews. Amazon Aurora is rated 7.8, while Oracle Database In-Memory is rated 8.8. The top reviewer of Amazon Aurora writes "Easy-to-manage platform with a valuable auto-scaling feature ". On the other hand, the top reviewer of Oracle Database In-Memory writes "User friendly with great scalability but needs to move toward intelligent AI". Amazon Aurora is most compared with SQL Server, Oracle Database, MariaDB, CockroachDB and MySQL, whereas Oracle Database In-Memory is most compared with SAP HANA, IBM Db2 Database, Progress OpenEdge RDBMS, SQL Server and Apache Derby. See our Amazon Aurora vs. Oracle Database In-Memory report.
See our list of best Relational Databases Tools vendors.
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.