TrustRadius: an HG Insights company

Amazon Athena vs. Amazon Relational Database Service (RDS)

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Amazon Athena

    Score9.9 out of 10
    N/AAmazon 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 RDS

    Score8.7 out of 10
    N/AAmazon Relational Database Service (Amazon RDS) is a database-as-a-service (DBaaS) from Amazon Web Services.N/A
    Pricing
    Amazon AthenaAmazon RDS
    Editions & Modules
    Price per Query
    $5.00
    per TB of Data Scanned
    Amazon RDS for PostgreSQL
    $0.24 ($0.48)
    per hour, R5 Large (R5 Extra Large)
    Amazon RDS for MariaDB
    $0.25 ($0.50)
    per hour, R5 Large (R5 Extra Large)
    Amazon RDS for MySQL
    $0.29 ($0.58)
    per hour, R5 Large (R5 Extra Large)
    Amazon RDS for Oracle
    $0.482 ($0.964)
    per hour, R5 Large (R5 Extra Large)
    Amazon RDS for SQL Server
    $1.02 ($1.52)
    per hour, R5 Large (R5 Extra Large)
    Offerings
    Pricing Offerings
    Amazon AthenaAmazon RDS
    Free Trial
    NoNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeOptional
    Additional Details——
    More Pricing Information
    Community Pulse
    Amazon AthenaAmazon RDS
    Considered Both Products
    Amazon AWS
    No answer on this topic
    Amazon AWS
    Chose Amazon RDS
    AWS RDS provides multiple Engines as compared to Google SQL AWS RDS provides more than 5 read replicas which a Google SQL does not AWS RDS is a cheaper option than Redshift for smaller datasets. Redshift is a Dataware house and must be used for super large datasets only …
    Incentivized
    Key User Insights
    Would buy again
    No answers on this topic
    99%
    Would buy again
    102 Answers
    Delivers good value for the price
    No answers on this topic
    98%
    Delivers good value for the price
    98 Answers
    Happy with the feature set
    No answers on this topic
    99%
    Happy with the feature set
    102 Answers
    Lived up to sales and marketing promises
    No answers on this topic
    99%
    Lived up to sales and marketing promises
    83 Answers
    Implementation went as expected
    No answers on this topic
    96%
    Implementation went as expected
    96 Answers
    Features
    Amazon AthenaAmazon RDS
    Database-as-a-Service
    Comparison of Database-as-a-Service features of Amazon Athena and Amazon Relational Database Service (RDS)
    Feature
    Amazon Athena
    8.6
    4 Ratings
    1% below category average
    Amazon Relational Database Service (RDS)
    -
    Ratings
    Automatic software patching8.22 Ratings00 Ratings
    Database scalability9.03 Ratings00 Ratings
    Automated backups7.73 Ratings00 Ratings
    Database security provisions9.22 Ratings00 Ratings
    Monitoring and metrics8.04 Ratings00 Ratings
    Automatic host deployment9.22 Ratings00 Ratings
    Best Alternatives
    Amazon AthenaAmazon RDS
    Small Businesses
    MongoDB Atlas
    Score8.2 out of 10
    SingleStore
    Score7.5 out of 10
    Medium-sized Companies
    Azure Database
    Score9.8 out of 10
    SAP HANA Cloud
    Score8.9 out of 10
    Enterprises
    Google BigQuery
    Score8.4 out of 10
    SAP IQ
    Score10 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Amazon AthenaAmazon RDS
    Likelihood to Recommend
    10.0
    (4 ratings)
    8.8
    (130 ratings)
    Likelihood to Renew
    -
    (0 ratings)
    8.4
    (5 ratings)
    Usability
    10.0
    (1 ratings)
    8.0
    (7 ratings)
    Availability
    -
    (0 ratings)
    9.0
    (1 ratings)
    Performance
    -
    (0 ratings)
    7.0
    (1 ratings)
    Support Rating
    -
    (0 ratings)
    9.6
    (13 ratings)
    Online Training
    -
    (0 ratings)
    10.0
    (1 ratings)
    Product Scalability
    -
    (0 ratings)
    9.0
    (1 ratings)
    User Testimonials
    Amazon AthenaAmazon RDS
    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
    Read full review
    Amazon AWS
    If your application needs a relational data store and uses other AWS services, AWS RDS is a no-brainer. It offers all the traditional database features, makes it a snap to set up, creates cross-region replication, has advanced security, built-in monitoring, and much more at a very good price. You can also set up streaming to a data lake using various other AWS services on your RDS.
    Incentivized
    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
    Read full review
    Amazon AWS
    • Automated Database Management: We use it for streamlining routine tasks like software patching and database backups.
    • Scalability on Demand: we use it to handle traffic spikes, scaling both vertically and horizontally.
    • Database Engine Compatibility: It works amazingly with multiple database engines used by different departments within our organization including MySQL, PostgreSQL, SQL Server, and Oracle.
    • Monitoring: It covers our extensive monitoring and logging, and also has great compatibility with Amazon CloudWatch
    Incentivized
    Read full review
    Cons
    Amazon AWS
    • Response caching can be improved.
    • Data Partitioning is tricky and understanding of the same could be improved.
    Incentivized
    Read full review
    Amazon AWS
    • It is a little difficult to configure and connect to an RDS instance. The integration with ECS can be made more seamless.
    • Exploring features within RDS is not very easy and intuitive. Either a human friendly documentation should be added or the User Interface be made intuitive so that people can explore and find features on their own.
    • There should be tools to analyze cost and minimize it according to the usage.
    Incentivized
    Read full review
    Likelihood to Renew
    Amazon AWS
    No answers on this topic
    Amazon AWS
    We do renew our use of Amazon Relational Database Service. We don't have any problems faced with RDS in place. RDS has taken away lot of overhead of hosting database, managing the database and keeping a team just to manage database. Even the backup, security and recovery another overhead that has been taken away by RDS. So, we will keep on using RDS.
    Incentivized
    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
    Read full review
    Amazon AWS
    I've been using AWS Relational Database Services in several projects in different environments and from the AWS products, maybe this one together to EC2 are my favourite. They deliver what they promise. Reliable, fast, easy and with a fair price (in comparison to commercial products which have obscure license agreements).
    Incentivized
    Read full review
    Support Rating
    Amazon AWS
    No answers on this topic
    Amazon AWS
    I have only had good experiences in working with AWS support. I will admit that my experience comes from the benefit of having a premium tier of support but even working with free-tier accounts I have not had problems getting help with AWS products when needed. And most often, the docs do a pretty good job of explaining how to operate a service so a quick spin through the docs has been useful in solving problems.
    Incentivized
    Read full review
    Online Training
    Amazon AWS
    No answers on this topic
    Amazon AWS
    the online training & digital content available on the web from AWS was having sufficient information to deploy and run the service
    Incentivized
    Read full review
    Alternatives Considered
    Amazon AWS
    Incentivized
    Read full review
    Amazon AWS
    Amazon Relational Database Service (RDS) stands out among similar products due to its seamless integration with other AWS services, automated backups, and multi-AZ deployments for high availability. Its support for various database engines, such as MySQL, PostgreSQL, and Oracle, provides flexibility. Additionally, RDS offers managed security features, including encryption and IAM integration, enhancing data protection. The pay-as-you-go pricing model makes it cost-effective. Overall, Amazon RDS excels in ease of use, scalability, and a comprehensive feature set, making it a top choice for organizations seeking a reliable and scalable managed relational database service in the cloud.
    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
    Read full review
    Amazon AWS
    • The overall cost increases, but we spect this and we can mitigate other risks.
    • Is easy to work from the cloud. Is reliable, but we keep our local solution as well where RDS works quite good.
    • RDS allow us to focurs on owr objetives instead of the other matters regarding databases.
    Incentivized
    Read full review
    ScreenShots

    Amazon RDS Screenshots

    Screenshot of A look inside the RDS console.