Amazon Athena vs. Oracle Autonomous Database

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 Database
Score 8.9 out of 10
N/A
Oracle Autonomous Database provides a self-driving, self-securing, self-repairing cloud service that eliminate the overhead and human errors associated with traditional database administration. Oracle Autonomous Database takes care of configuration, tuning, backup, patching, encryption, scaling, and more.N/A
Pricing
Amazon AthenaOracle Autonomous Database
Editions & Modules
Price per Query
$5.00
per TB of Data Scanned
No answers on this topic
Offerings
Pricing Offerings
Amazon AthenaOracle Autonomous Database
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 Database
Top Pros
Top Cons
Features
Amazon AthenaOracle Autonomous Database
Database-as-a-Service
Comparison of Database-as-a-Service features of Product A and Product B
Amazon Athena
8.5
3 Ratings
2% below category average
Oracle Autonomous Database
-
Ratings
Automatic software patching8.12 Ratings00 Ratings
Database scalability8.12 Ratings00 Ratings
Automated backups7.73 Ratings00 Ratings
Database security provisions9.12 Ratings00 Ratings
Monitoring and metrics8.73 Ratings00 Ratings
Automatic host deployment9.12 Ratings00 Ratings
Database Development
Comparison of Database Development features of Product A and Product B
Amazon Athena
-
Ratings
Oracle Autonomous Database
7.0
24 Ratings
19% below category average
Version control tools00 Ratings6.213 Ratings
Test data generation00 Ratings5.714 Ratings
Performance optimization tools00 Ratings7.824 Ratings
Schema maintenance00 Ratings8.323 Ratings
Database change management00 Ratings7.015 Ratings
Database Administration
Comparison of Database Administration features of Product A and Product B
Amazon Athena
-
Ratings
Oracle Autonomous Database
7.7
25 Ratings
11% below category average
User management00 Ratings8.024 Ratings
Database security00 Ratings8.724 Ratings
Database status reporting00 Ratings8.025 Ratings
Change management00 Ratings6.216 Ratings
Best Alternatives
Amazon AthenaOracle Autonomous Database
Small Businesses
IBM Cloudant
IBM Cloudant
Score 9.5 out of 10
DBeaver
DBeaver
Score 8.3 out of 10
Medium-sized Companies
IBM Cloudant
IBM Cloudant
Score 9.5 out of 10
DBeaver
DBeaver
Score 8.3 out of 10
Enterprises
IBM Cloudant
IBM Cloudant
Score 9.5 out of 10
DBeaver
DBeaver
Score 8.3 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Amazon AthenaOracle Autonomous Database
Likelihood to Recommend
9.4
(3 ratings)
8.6
(56 ratings)
Likelihood to Renew
-
(0 ratings)
9.0
(2 ratings)
Usability
-
(0 ratings)
8.0
(1 ratings)
User Testimonials
Amazon AthenaOracle Autonomous Database
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
Pro - Stability. Does everything anyone could need. If it's not there it will be on the next update. There is plenty of support for it. It's been around for a long time and it's reliable. The support is well documented and has a great reputation. Cons - Errors have been found in the documentation provided by Oracle with guidelines, etc. Oracles salespeople have a reputation of being obnoxious and condescending.
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
  • Robust - this product doesn't have a lot of downtime. It's less prone to errors than some other tools I've worked with.
  • Scalable - we can keep adding more things to it. We haven't hit any roadblocks when we've tried to do more with our database.
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
  • There is no access to the physical host of the DB. This is expected from a managed DB. Everything must be done through the console or via API calls. This is a new learning curve for the DBAs.
  • Due to the lack of physical host access, certain features are not supported, such as Transportable tablespaces and Oracle LogMiner.
  • Certain special data types, (such as XMLType) are not allowed; be sure the app vendor certifies their product on this platform.
Read full review
Likelihood to Renew
Amazon AWS
No answers on this topic
Oracle
Because it does exactly what we need: it enables us to manage our development and testing database environments in a quick and simple way without requiring support from a database administrators team.
Read full review
Usability
Amazon AWS
No answers on this topic
Oracle
The product is continuously evolving and new features are added frequently. Management options through the OCI (Oracle Cloud Infrastructure) console and through the command line and API are being enhanced frequently.
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
I found Oracle Autonomous Database very secure to store data and private information.I always feel secure with Oracle Autonomous Databases disaster recovery features.It is very effective to build applications for mobile and desktop devices lesser code using a low code development framework namely Oracle Application Express (ApEx).
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
  • Oracle Autonomous Database has a wide range of warehouses, which is competent and of high performance.
  • The transactional processing power that Oracle Autonomous Database outlines are completely important and digital.
  • The efficiency of Oracle Autonomous Database data encryption fosters security measures, a form that demands more threat detectors.
Read full review
ScreenShots

Oracle Autonomous Database Screenshots

Screenshot of Oracle Autonomous Database is supported on Shared or Dedicated Exadata InfrastructureScreenshot of Oracle Autonomous Database supports workload-optimized cloud services for Data Warehouse, Transaction Processing,  JSON centric applicationsScreenshot of Oracle Autonomous Database supports  both License Included and Bring Your Own Licensing (BYOL) with  Yearly and Pay As You Go subscription pricingScreenshot of Oracle Autonomous Database provides built-in development  tools such as SQL Developer web, Performance Hub, APIs for data managementScreenshot of Oracle Autonomous Database provides native shell for API driven development