By using AWS re:Post, you agree to the Terms of Use
/incorrect grouping/

incorrect grouping

0

Athena and redshift are incorrectly grouped under analytics. quicksight is the correct tool in that category. But redshift should be under database. https://i.stack.imgur.com/8O65F.png

2 Answers
0

Hi,

while it is correct that Athena is an SQL engine, and Refshift it is a DataBase, they are mostly used in Analytics workloads (ad-hoc queries and analysis) and Data Warehousing and ML (Redshift ML), hence the current classification.

you can also check external sources which define Analytics databases as this one. And you will notice the classification of Presto and Amazon Redshift in this category as well.

hope this helps clarifying.

EXPERT
answered 5 months ago
0

Amazon Redshift is a fully managed data warehousing service, specifically designed for online analytic processing (OLAP) and business intelligence (BI) applications. This is different from most relational databases that are focussed on row-based transactions (OLTP). The analytics use case means it is grouped with the analytics services.

Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena does not manage the data, or the S3 objects the data is stored in, so is not classed as a database service.

The key differences between Amazon Redshift and Postgres are described in this doc https://docs.aws.amazon.com/redshift/latest/dg/c_redshift-and-postgres-sql.html

This doc goes into more detail on why columnar storage is important for analytic query performance https://docs.aws.amazon.com/redshift/latest/dg/c_columnar_storage_disk_mem_mgmnt.html

answered 5 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions