Amazon Athena vs. Amazon SimpleDB

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
Amazon SimpleDB
Score 8.0 out of 10
N/A
Amazon SimpleDB is a non-relational data store and service.
$0
per GB allowance
Pricing
Amazon AthenaAmazon SimpleDB
Editions & Modules
Price per Query
$5.00
per TB of Data Scanned
Machine Utilization
$0.00 for first 25 hours $0.14 per machine hour over 25 hours
per GB allowance
Structured Data Storage
$0.00 for first GB-month $0.25 per GB-month thereafter
per GB allowance
Free Tier
25 SimpleDB Machine Hours and 1 GB of Storage for free each month
per GB allowance
Data Transfer
All data transfer in is $0.00 per GB
per GB allowance
Offerings
Pricing Offerings
Amazon AthenaAmazon SimpleDB
Free Trial
NoNo
Free/Freemium Version
NoYes
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
Amazon AthenaAmazon SimpleDB
Top Pros
Top Cons
Features
Amazon AthenaAmazon SimpleDB
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
Amazon SimpleDB
-
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 AthenaAmazon SimpleDB
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 AthenaAmazon SimpleDB
Likelihood to Recommend
9.5
(3 ratings)
9.0
(1 ratings)
User Testimonials
Amazon AthenaAmazon SimpleDB
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
Amazon AWS
Well suited for: Games, Chat rooms, real time software like corporate events, marathons and so. Anytime and anywhere you could use a NoSQL DB you should think of SimpleDB.
As an arduous AWS user, Amazon SimpleDB easily integrates with EC2 and other AWS module; and if you are not an AWS user, you also have a fantastic tool that will solve the problem for which you are focused.
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
Amazon AWS
  • Flexibility
  • Easy to learn and use
  • AWS integration
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
Amazon AWS
  • Non AWS environments
  • Strict storage limit (but well we have DynamoDB for storage issues)
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
Amazon AWS
It integrates beautifully with AWS. In some projects we use SimpleDB while we use DynamoDB for others, according to the characteristics of the project. If the infrastructure is AWS, we always think of one of them.
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
Amazon AWS
  • Reduced database administration time
  • Reduced data model analysis time
  • Lower cost of resources in projects in general
Read full review
ScreenShots