Amazon RDS vs Oracle Autonomous Transaction Processing

Likelihood to Recommend

If you're operating within the Amazon universe of cloud computing, it's almost a no-brainer to utilize [Amazon Relational Database Service (RDS)]. RDS is well suited for probably a majority of applications that are candidates to host on a cloud computing platform as it reduces overall management and complexity of your system.However, if you're doing a lot of data exporting/importing using tools that write to/read from the disk on the server, you may have challenges integrating RDS, as you have no access to the underlying host.

Read full review

Verified User

Engineer in Engineering

Marketing and Advertising Company, 11-50 employees

View all 40 answers on this topic

If your company's value is not increased by maintaining databases, you should use the ATP.

Read full review

Peter Merkert

CTO (Chief Technical Officer)

retraced GmbHInformation Technology & Services, 1-10 employees

View all 2 answers on this topic

Feature Rating Comparison

Amazon RDS

Oracle Autonomous Transaction Processing

Automatic software patching

Database scalability

Automated backups

Database security provisions

Monitoring and metrics

Automatic host deployment

Pros

For engineers with experience managing databases, setup is simple. And for the uninitiated, the RDS console interface becomes intuitive with some practice.
Not having the maintain the underlying infrastructure is a great benefit of using RDS. Patching and backups can be scheduled from the console and from then on are pretty much automated.
Right-sizing the DB instance to perform optimally with an application can be a very simple procedure. If a DB instance is not struggling to keep up, the instance size can be scaled up with just a few clicks.
Baseline configurations are generally sane for most RDS instances. This allows novice developers and engineers to get the most out of the service without being a complete database administrator.

Read full review

Michael Jenkins

Senior Systems Reliability Engineer

The Walt Disney CompanyEntertainment, 10,001+ employees

View all 40 answers on this topic

Quick and simple to deploy (less than 5 steps to create a new instance)
No administrative tasks (backup, re-sizing) required

Read full review

Lisandro Fernigrini

Sr. Software Developer / DBA

Personal UseInformation Technology and Services, 1-10 employees

View all 2 answers on this topic

Cons

There should be a proper listing of all parameter groups alongside the instances that they are attached to. This would help to see which instances would be affected if a parameter group is changed.
RDS should allow SUPER privilege to the master user. A few advanced tasks(like getting a physical backup using MySQL Enterprise Backup) fail because SUPER privilege is not available for the master user.
A few parameters are not modifiable in the parameter groups and the access to the server filesystem is not given. This should not be the case because as an advanced user, you might want to understand things a little deeper.

Read full review

Alok Patwal

Software Developer

ezDIHealth, Wellness and Fitness, 201-500 employees

View all 40 answers on this topic

Connectivity between ATP and Oracle Kuberentes Engine cluster seems to drop randomly
The ATP could come in an even smaller shape as the smallest shape is already quite big . But if must be more than always free, as that version does have connectivity limitations about 20 connections

Read full review

Peter Merkert

CTO (Chief Technical Officer)

retraced GmbHInformation Technology & Services, 1-10 employees

View all 2 answers on this topic

Usability

Amazon RDS 8.8

Based on 5 answers

The vast majority of things you'd want to do in Amazon Relational Database Service are simple to accomplish and remarkably consistent across database engines. Pricing, scalability and monitoring are easy to configure. If I had one complaint, it's that database engine specific features are not well documented in AWS, requiring reading external documentation in order to use some database systems to the fullest. But for most use cases, the defaults available in AWS are simple, easy to use, and good enough.

Read full review

Verified User

Professional in Information Technology

Human Resources Company, 51-200 employees

View all 5 answers on this topic

Oracle Autonomous Transaction Processing 7.3

Based on 1 answer

You get almost all the features of Oracle Database, including the ability to deploy APEX applications, without having to worry about system, storage or database configuration and maintenance, backups, etc. Also, you can start for free and move up adding resources as you need.

Read full review

Lisandro Fernigrini

Sr. Software Developer / DBA

Personal UseInformation Technology and Services, 1-10 employees

View all 1 answers on this topic

Support Rating

Amazon RDS 8.9

Based on 25 answers

The product is fairly straight forward to use, and staff as well as knowledge base is pretty good for getting answers you may need. The product is a great, flexible alternative to adding to one's own in-house infrastructure. It's especially useful for environments that you aren't sure about the overall long term need. Amazon Relational Database Service is great for environments that once you determine the long term need, can be maintained by Amazon.

Read full review

Mike Narumiya

President, Principal

Klaxon IT SolutionsHospital & Health Care, 11-50 employees

View all 25 answers on this topic

No score

No answers yet

No answers on this topic

Alternatives Considered

Amazon Relational Database Service will probably give you everything you need from a traditional manual DB setup, except everything is managed for you. The only downside is having to pay the premium for the service; however, the trade-off of not having to deal with the intricacies involved with database administration, make it well worth it for most.

Read full review

Gabriel Samaroo

Senior Software Engineer

RocketripComputer Software, 11-50 employees

View all 40 answers on this topic

Both Azure SQL Database and Oracle Autonomous Transaction Processing offer a powerful and robust database platform. The advantage of Autonomous Transaction Processing is the ability to host APEX applications for free and without any special/complicated deployment or configuration process. Having a rapid development environment embedded for free was the main advantage for choosing Oracle as my cloud database provider.

Read full review

Lisandro Fernigrini

Sr. Software Developer / DBA

Personal UseInformation Technology and Services, 1-10 employees

View all 2 answers on this topic

Return on Investment

Switching back to RDS from Redshift has made my BI Dashboards much more performant (though again, we're not dealing with data in the magnitudes that justify the Redshift toolset).
It has decreased our tech debt. Engineering has been much more straight forward.
Our uptime has been improved by removing unnecessary data migration processes.

Read full review

Kyle Reichelt

Senior Project Manager

OnMetricInternet, 11-50 employees

View all 40 answers on this topic

Approx 100 times faster spin up than manual setup of an Oracle DB
3h annual maintenance for big version releases (18c to 19c) compared to est. 500h annual maintenance with manual database updates

Read full review

Peter Merkert

CTO (Chief Technical Officer)

retraced GmbHInformation Technology & Services, 1-10 employees

View all 2 answers on this topic

Pricing Details

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

Optional

Free to try. Pay only for what you use with no minimum fee.

Amazon RDS Editions & Modules

Edition

Amazon RDS for MySQL	$0.29 ($0.58)¹
Amazon RDS for PostgreSQL	$0.24 ($0.48)¹
Amazon RDS for MariaDB	$0.25 ($0.50)¹
Amazon RDS for Oracle	$0.482 ($0.964)¹
Amazon RDS for SQL Server	$1.02 ($1.52)¹

per hour, R5 Large (R5 Extra Large)

Additional Pricing Details

—

General

Free Trial

Yes

Free/Freemium Version

Yes

Premium Consulting/Integration Services

Yes

Entry-level set up fee?

Optional

Oracle Autonomous Transaction Processing Editions & Modules

Edition

Transaction Processing	$1.34¹
Exadata Storage	$118.40²

OCPU Per Hour
Per Terabyte Per month

Additional Pricing Details

https://www.oracle.com/cloud/cost-estimator.html

Rating Summary

Amazon RDS

Oracle Autonomous Transaction Processing

Amazon RDS

Oracle Autonomous Transaction Processing

Amazon RDS

Oracle Autonomous Transaction Processing

Amazon RDS vs Oracle Autonomous Transaction Processing

Amazon RDS

Oracle Autonomous Transaction Processing

Feature Rating Comparison

Database-as-a-Service

Automatic software patching

Database scalability

Automated backups

Database security provisions

Monitoring and metrics

Automatic host deployment

Pros

Cons

Usability

Support Rating

Alternatives Considered

Return on Investment

Screenshots

Pricing Details

General

Free Trial

Free/Freemium Version

Premium Consulting/Integration Services

Entry-level set up fee?

Amazon RDS Editions & Modules

Edition

Additional Pricing Details

General

Free Trial

Free/Freemium Version

Premium Consulting/Integration Services

Entry-level set up fee?

Oracle Autonomous Transaction Processing Editions & Modules

Edition

Additional Pricing Details

Rating Summary

Likelihood to Recommend

Usability

Support Rating

Add comparison