Nov. 26, 2023, 8:36 p.m. | عبدالله عياد | Abdullah Ayad

DEV Community dev.to

Amazon Redshift is a database, but also an analytics engine.

So Redshift is based on the PostgreSQL technology, but instead of PostgreSQL, it's not used for online transaction processing.

It's actually an all-app type of database which means online analytical processing (OLAP)and it's used for analytics and data warehousing.


So it has a 10X better performance than any other data warehouses out there and it scales to petabytes and petabytes of data.


So the idea is that you …

amazon amazon redshift analytics analytics engine app aws cloud data database datascience data warehousing olap online transaction processing overview postgresql processing redshift serverless technology type

Data Architect

@ University of Texas at Austin | Austin, TX

Data ETL Engineer

@ University of Texas at Austin | Austin, TX

Lead GNSS Data Scientist

@ Lurra Systems | Melbourne

Senior Machine Learning Engineer (MLOps)

@ Promaton | Remote, Europe

AIML - Sr Machine Learning Engineer, Data and ML Innovation

@ Apple | Seattle, WA, United States

Senior Data Engineer

@ Palta | Palta Cyprus, Palta Warsaw, Palta remote