Amazon Athena vs. Oracle Autonomous Transaction Processing

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Amazon Athena
Score 8.4 out of 10
N/A
Amazon Athena is an interactive query service that makes it easy to analyze data directly in Amazon S3 using standard SQL. With a few clicks in the AWS Management Console, customers can point Athena at their data stored in S3 and begin using standard SQL to run ad-hoc queries and get results in seconds. Athena is serverless, so there is no infrastructure to setup or manage, and customers pay only for the queries they run. You can use Athena to process logs, perform ad-hoc analysis, and run…
$5
per TB of Data Scanned
Oracle Autonomous Transaction Processing
Score 9.0 out of 10
N/A
Oracle offers the Autonomous Transaction Processing, supporting database self-repair and maintenance with machine learning to eliminate human labor, human error, and manual tuning.
$1.34
OCPU Per Hour
Pricing
Amazon AthenaOracle Autonomous Transaction Processing
Editions & Modules
Price per Query
$5.00
per TB of Data Scanned
Transaction Processing
$1.34
OCPU Per Hour
Exadata Storage
$118.40
Per Terabyte Per month
Offerings
Pricing Offerings
Amazon AthenaOracle Autonomous Transaction Processing
Free Trial
NoYes
Free/Freemium Version
NoYes
Premium Consulting/Integration Services
NoYes
Entry-level Setup FeeNo setup feeOptional
Additional Details
More Pricing Information
Community Pulse
Amazon AthenaOracle Autonomous Transaction Processing
Top Pros
Top Cons

No answers on this topic

Features
Amazon AthenaOracle Autonomous Transaction Processing
Database-as-a-Service
Comparison of Database-as-a-Service features of Product A and Product B
Amazon Athena
8.5
3 Ratings
3% below category average
Oracle Autonomous Transaction Processing
-
Ratings
Automatic software patching8.22 Ratings00 Ratings
Database scalability8.22 Ratings00 Ratings
Automated backups7.73 Ratings00 Ratings
Database security provisions9.22 Ratings00 Ratings
Monitoring and metrics8.83 Ratings00 Ratings
Automatic host deployment9.22 Ratings00 Ratings
Best Alternatives
Amazon AthenaOracle Autonomous Transaction Processing
Small Businesses
IBM Cloudant
IBM Cloudant
Score 8.2 out of 10
IBM Cloudant
IBM Cloudant
Score 8.2 out of 10
Medium-sized Companies
IBM Cloudant
IBM Cloudant
Score 8.2 out of 10
IBM Cloudant
IBM Cloudant
Score 8.2 out of 10
Enterprises
IBM Cloudant
IBM Cloudant
Score 8.2 out of 10
IBM Cloudant
IBM Cloudant
Score 8.2 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Amazon AthenaOracle Autonomous Transaction Processing
Likelihood to Recommend
9.5
(3 ratings)
9.1
(2 ratings)
Usability
-
(0 ratings)
7.3
(1 ratings)
User Testimonials
Amazon AthenaOracle Autonomous Transaction Processing
Likelihood to Recommend
Amazon AWS
If you are looking to take a lot of the traditional "database administration" work off someone's plate, going with Amazon Athena certainly has "no code" options to optimize lots of database tasks. I would say this option is less appropriate if you have other Microsoft things at play, such as Power BI.
Read full review
Oracle
If your company's value is not increased by maintaining databases, you should use the ATP.
Read full review
Pros
Amazon AWS
  • Nested Schemas like JSON data structure
  • Ability to adapt the data model to fit your queries better
  • Performance Improvement
Read full review
Oracle
  • Quick and simple to deploy (less than 5 steps to create a new instance)
  • No administrative tasks (backup, re-sizing) required
Read full review
Cons
Amazon AWS
  • Query manager can incoperate GUI based query designer
  • Auto-completion engine sometimes overwrite the query
  • Time range selection should be implicit
Read full review
Oracle
  • 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
Usability
Amazon AWS
No answers on this topic
Oracle
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
Alternatives Considered
Amazon AWS
Amazon Athena, a product from Amazon, competes with offerings from Google and Microsoft. Overall, I think your database choice depends on some of the other applications you are running at your company. For example, if you are using Microsoft Power BI for reporting needs, you might want to consider going the Azure route.
Read full review
Oracle
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
Return on Investment
Amazon AWS
  • Easy to query terabytes of data with faster response
  • Pricing model is also cheap
  • No indexing and partitioning
Read full review
Oracle
  • 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
ScreenShots

Oracle Autonomous Transaction Processing Screenshots

Screenshot of Autonomous Transaction Processing Database takes automatic backupsScreenshot of Provisioning a new Autonomous Transaction Processing is simpleScreenshot of Autonomous Transaction Processing Database  ConsoleScreenshot of Auto scaling and manual scaling options of the database