TrustRadius

Alibaba Cloud ApsaraDB vs. Amazon Athena

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
ApsaraDB
Score 7.0 out of 10
N/A
Alibaba Cloud offers ApsaraDB, a range of scalable online database services that provide operation and maintenance of more than 90% of the mainstream open source and commercial databases (such as MySQL, SQL Server, and Redis). Also, ApsaraDB provides POLARDB performant databases. In addition, ApsaraDB offers HybridDB with 100TB of real-time data computational capabilities. ApsaraDB delivers a comprehensive solution that includes disaster recovery, backups, restoration, monitoring, and migration.N/A
Amazon Athena
Score 9.9 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
Pricing
Alibaba Cloud ApsaraDBAmazon Athena
Editions & Modules
No answers on this topic
Price per Query
$5.00
per TB of Data Scanned
Offerings
Pricing Offerings
ApsaraDBAmazon Athena
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
Alibaba Cloud ApsaraDBAmazon Athena
Features
Alibaba Cloud ApsaraDBAmazon Athena
Database-as-a-Service
Comparison of Database-as-a-Service features of Product A and Product B
Alibaba Cloud ApsaraDB
-
Ratings
Amazon Athena
8.6
Ratings
1% below category average
Automatic software patching00 Ratings8.20 Ratings
Database scalability00 Ratings9.00 Ratings
Automated backups00 Ratings7.70 Ratings
Database security provisions00 Ratings9.20 Ratings
Monitoring and metrics00 Ratings8.00 Ratings
Automatic host deployment00 Ratings9.20 Ratings
User Ratings
Alibaba Cloud ApsaraDBAmazon Athena
Likelihood to Recommend
-
(0 ratings)
10.0
(0 ratings)
Usability
-
(0 ratings)
10.0
(0 ratings)
User Testimonials
Alibaba Cloud ApsaraDBAmazon Athena
Likelihood to Recommend
No answers on this topic
Best suited for analyzing huge amounts of data by just querying on Amazon Athena. Amazon Athena is also best to integrate with Amazon Quickight for visualization and reporting of data. Easy to work with CSV, JSON, and columnar data formats like Parquet, and ORC. Less appropriate to work with AVRO data format and also stored procedures are not supported in Amazon Athena. The size of a single row is also limited to 32 MB.
RK
Riyaz Khan
Data Engineer
Read full review
Pros
No answers on this topic
  • Load Balance traffic analysis
  • Big data report generation
  • Micro services pattern query analysis
Verified User
Anonymous
Read full review
Cons
No answers on this topic
  • Every dialect of SQL has some missing functions. I wish there was automated GROUP BY options here.
  • There are connection problems back to Power BI occasionally.
  • If you don't watch certain queries, it's possible that it takes a long time to run and charges you a lot of money.
Scott Kennedy | TrustRadius Reviewer
Scott Kennedy
Sr Director, BI
Read full review
Usability
No answers on this topic
Easy to use. Scalable. Gets the job of data warehousing setup done. Using the datalake on S3 has become super convenient.
Alok Pabalkar | TrustRadius Reviewer
Alok Pabalkar
Co-Founder & CTO
Read full review
Alternatives Considered
No answers on this topic
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.
Scott Kennedy | TrustRadius Reviewer
Scott Kennedy
Sr Director, BI
Read full review
Return on Investment
No answers on this topic
  • It's easy to store and query data on S3. Multiple teams can query the same data to generate their reports. It removes the need for a full-fledged data warehouse for a startup. Saves costs.
  • Improved team efficiency on monitoring user activities by easy logging and reporting.
  • As the dataset gets heavier on S3, one needs to understand partitioning and that leads to the requirement of expertise.
Alok Pabalkar | TrustRadius Reviewer
Alok Pabalkar
Co-Founder & CTO
Read full review
ScreenShots