Amazon Athena vs. Oracle Database Cloud Service

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Amazon Athena
Score 8.5 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 Database Cloud Service
Score 8.5 out of 10
N/A
Oracle offers their DBaaS, the Oracle Database Cloud Service, touting high availability, scalability, available managed or under enterprise control.N/A
Pricing
Amazon AthenaOracle Database Cloud Service
Editions & Modules
Price per Query
$5.00
per TB of Data Scanned
No answers on this topic
Offerings
Pricing Offerings
Amazon AthenaOracle Database Cloud Service
Free Trial
NoNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
Amazon AthenaOracle Database Cloud Service
Top Pros
Top Cons
Features
Amazon AthenaOracle Database Cloud Service
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 Database Cloud Service
9.7
4 Ratings
11% above category average
Automatic software patching8.22 Ratings9.04 Ratings
Database scalability8.22 Ratings10.04 Ratings
Automated backups7.73 Ratings10.04 Ratings
Database security provisions9.22 Ratings10.04 Ratings
Monitoring and metrics8.83 Ratings9.04 Ratings
Automatic host deployment9.22 Ratings10.04 Ratings
Best Alternatives
Amazon AthenaOracle Database Cloud Service
Small Businesses
IBM Cloudant
IBM Cloudant
Score 8.1 out of 10
IBM Cloudant
IBM Cloudant
Score 8.1 out of 10
Medium-sized Companies
IBM Cloudant
IBM Cloudant
Score 8.1 out of 10
IBM Cloudant
IBM Cloudant
Score 8.1 out of 10
Enterprises
IBM Cloudant
IBM Cloudant
Score 8.1 out of 10
IBM Cloudant
IBM Cloudant
Score 8.1 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Amazon AthenaOracle Database Cloud Service
Likelihood to Recommend
9.5
(3 ratings)
9.0
(4 ratings)
User Testimonials
Amazon AthenaOracle Database Cloud Service
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
  • Cost Effective & Flexible: Customers can start as low as a single OCPU VM up to 24 OCPUs. Customers pay only for OCPUs and Storage used.
  • Ease Of Getting Started: Customers can easily create Oracle Certified, full-featured, fully supported 11g, 12c (both 12.1 & 12.2) databases with choice of any database edition.
  • Built-in High Availability Constructs: Customers can easily deploy 2-node RAC configurations with all the VM shapes. For example: Easily deploy a 2-node RAC configuration with 2 core Virtual Machines and shared block storage of up to 40 TB.
  • Durable & Scalable Storage: Customers can use remote storage starting at 256GB up to 40 TB. Storage can be scale up with no downtime.
  • Secure: Customers still get all the advantages of our Oracle IAM for management control and VCN Security lists for securing their database environments.
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
  • Eliminates the requirement of hardware and installation.
  • Minimizes the cost of operation and maintenance.
  • Scalable to meet the increase in requirements.
  • Enhances integrity, connectivity and performance of our applications.
  • Reliable in terms of data security.
  • Improved speed of querying and searching.
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
  • When we restart the DBaaS instance, it seems like we had to add the NIC network back again. I'm not sure if it's specific to our instance configuration!
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 would prefer the oracle database as service where my complete implementation is on Oracle Cloud Platform and as BI Implementation where datawarehouse is built on oracle database.
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
  • Billing on Hosted Environment per hour, OCPU per hour, block volumes, object storage, etc.
  • Costing & maintenance, patching.
  • Security & TDE cycles.
  • Backups & recovery.
  • The features are complemented by database lifecycle management features, like configuration management, performance management, patch automation, etc. which make the solution complete from a DBaaS administrator’s perspective as well.
  • Manager 12c covers all the major use cases for DBaaS, which yield significant business benefits and high ROI.
Read full review
ScreenShots