AWS Redshift
AWS Tutorial: Amazon Redshift
Welcome to the Amazon Redshift lesson. RDS and DynamoDB are designed for fast, real-time application interactions. But what happens when business analysts need to run massive historical reports across petabytes of data?
Why Learn Amazon Redshift?
If you run a complex historical analytics query on your main RDS database, it will consume all the CPU and crash your live application! Data Warehousing solves this by separating analytics from daily operations.
Tutorial Overview
In this tutorial, you will learn:
- What a Data Warehouse is.
- OLTP vs OLAP processing.
What is Amazon Redshift?
Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud. You can analyze all your data using standard SQL and your existing Business Intelligence (BI) tools (like Tableau or Amazon QuickSight).
OLTP vs. OLAP
- OLTP (Online Transaction Processing): Databases like RDS and DynamoDB. They are designed to process thousands of small, rapid transactions per second (e.g., adding a single item to a shopping cart).
- OLAP (Online Analytical Processing): Databases like Redshift. They are designed to process complex analytical queries across massive datasets (e.g., "What were the total sales of blue shirts in Europe over the last 5 years?").
By moving your reporting and analytics to Redshift, you keep your OLTP application databases running fast and securely.
Exercise
?Which AWS service is a petabyte-scale data warehouse designed for OLAP analytical processing?