Amazon Athena vs. Oracle Autonomous Transaction Processing

Amazon Athena

Oracle Autonomous Transaction Processing

Overview
Product	Rating	Most Used By	Product Summary	Starting Price
Amazon Athena	Score 8.0 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 Athena

Oracle 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 Athena	Oracle Autonomous Transaction Processing
Free Trial
No	Yes
Free/Freemium Version
No	Yes
Premium Consulting/Integration Services
No	Yes

Entry-level Setup Fee

No setup fee

Optional

Additional Details

—

More Pricing Information

Community Pulse
	Amazon Athena	Oracle Autonomous Transaction Processing

Features

Amazon Athena

Oracle Autonomous Transaction Processing

Database-as-a-Service

Comparison of Database-as-a-Service features of Product A and Product B
	Amazon Athena 8.6 4 Ratings 1% above category average	Oracle Autonomous Transaction Processing - Ratings
Automatic software patching	8.22 Ratings	00 Ratings
Database scalability	9.03 Ratings	00 Ratings
Automated backups	7.73 Ratings	00 Ratings
Database security provisions	9.22 Ratings	00 Ratings
Monitoring and metrics	8.04 Ratings	00 Ratings
Automatic host deployment	9.22 Ratings	00 Ratings

Best Alternatives
	Amazon Athena	Oracle Autonomous Transaction Processing
Small Businesses	IBM Cloudant Score 7.4 out of 10	IBM Cloudant Score 7.4 out of 10
Medium-sized Companies	IBM Cloudant Score 7.4 out of 10	IBM Cloudant Score 7.4 out of 10
Enterprises	IBM Cloudant Score 7.4 out of 10	IBM Cloudant Score 7.4 out of 10
All Alternatives	View all alternatives	View all alternatives

User Ratings
	Amazon Athena	Oracle Autonomous Transaction Processing
Likelihood to Recommend	10.0 (4 ratings)	9.1 (2 ratings)
Usability	10.0 (1 ratings)	7.3 (1 ratings)

User Testimonials
	Amazon Athena	Oracle 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. Incentivized Scott Kennedy Sr Director, BI Read full review	Oracle If your company's value is not increased by maintaining databases, you should use the ATP. Peter Merkert CTO (Chief Technical Officer) 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 Incentivized RK Riyaz Khan Data Engineer 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 Incentivized Lisandro Fernigrini Sr. Software Developer / DBA Read full review
Cons	Amazon AWS Response caching can be improved. Data Partitioning is tricky and understanding of the same could be improved. Incentivized Alok Pabalkar Co-Founder & CTO 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 Peter Merkert CTO (Chief Technical Officer) Read full review
Usability	Amazon AWS Easy to use. Scalable. Gets the job of data warehousing setup done. Using the datalake on S3 has become super convenient. Incentivized Alok Pabalkar Co-Founder & CTO Read full review	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. Incentivized Lisandro Fernigrini Sr. Software Developer / DBA Read full review
Alternatives Considered	Amazon AWS Incentivized Verified User Anonymous 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. Incentivized Lisandro Fernigrini Sr. Software Developer / DBA Read full review
Return on Investment	Amazon AWS The query speeds help us make more decisions in a day (speed). If you need more horsepower for specific times in the day this option helps scale. The security of your environment is well protected too. Incentivized Scott Kennedy Sr Director, BI 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 Peter Merkert CTO (Chief Technical Officer) Read full review
ScreenShots		Oracle Autonomous Transaction Processing Screenshots