Everything about Amazon Redshift
Cloud-based data warehouse service
Amazon Redshift is a data warehouse product which forms part of the larger cloud-computing platform Amazon Web Services. It is built on top of technology from the massive parallel processing (MPP) data warehouse company ParAccel, to handle large scale data sets and database migrations. Redshift differs from Amazon's other hosted database offering, Amazon RDS, in its ability to handle analytic workloads on big data data sets stored by a column-oriented DBMS principle. Redshift allows up to 16 petabytes of data on a cluster. Redshift uses parallel processing and compression to decrease command execution time. Wikipedia →
🧭 Start here: a 6-step reading path
- Read the overview: Amazon RedshiftA 5-minute orientation
- Pick up a classic book: Amazon Redshift CookbookThe most-reprinted book on the subject
- Read the landmark paper: Why TPC is Not Enough: An Analysis of the Amazon Redshift FleetCited 45 times
- Go sideways: List of column-oriented DBMSesA closely related topic
- Go sideways: ParAccelA closely related topic
📖 Definitions
No dictionary entry for this exact phrase.
🗂️ The subject at a glance
No outline available.
🏆 Landmark papers (most cited)
Why TPC is Not Enough: An Analysis of the Amazon Redshift Fleet
Fast and effective distribution-key recommendation for amazon redshift
The evolution of Amazon redshift
Amazon Redshift: Performance Tuning and Optimization
Amazon Redshift Performance Tuning for Large-Scale Analytics
An overview of cloud data warehouses: Amazon Redshift (AWS), Azure Synapse (Azure), and Google BigQuery (GCP)
Incremental Query Optimizer Statistics in Amazon Redshift
Data Modeler’s Guide to Implement Kimball Dimensional modeling on Amazon Redshift
📚 Books worth reading
- 📕Amazon Redshift CookbookShruti Worlikar, Thiyagarajan Arumugam · 2021
Getting Started with Amazon RedshiftStefan Bauer · 2013- 📕Mastering Amazon RedshiftRobert Johnson · 2025
- 📕Amazon Redshift : The Definitive GuideRajesh Francis, Rajiv Gupta · 2023
- 📕Serverless Machine Learning with Amazon Redshift MLDebu Panda, Phil Bates · 2023
- 📕AMAZON WEB SERVICES : a Comprehensive Hands-On Introduction, Volume 2K. Strong · 2019
Ranked by number of editions on Open Library, a rough measure of how lasting a book is.
🔗 Related topics
- List of column-oriented DBMSes This article is a list of column-oriented database management system software. Amazon Redshift Basekick Labs – Arc Cloud, managed hosting for the Arc columnar…
- ParAccel ParAccel, Inc. was a California-based software company. It provided a database management system designed to provide advanced analytics for business intelligenc…
- Actian Actian is an American software company headquartered in Santa Clara, California and the data and AI division of HCLSoftware. Actian develops technologies…
- DB-Engines ranking The DB-Engines Ranking ranks database management systems by popularity, covering over 410 systems. The ranking criteria include number of search engine…
- Amazon Relational Database Service Amazon Relational Database Service (or Amazon RDS) is a distributed relational database service by Amazon Web Services (AWS). It is a web service running…
- Cloud database A cloud database is a database that typically runs on a cloud computing platform, with access provided as a service. There are two common deployment models:…
- Yellowbrick Data Yellowbrick Data is a US-based database company delivering massively parallel processing (MPP) data warehouse and SQL analytics products. The company is…
- Greenplum Greenplum is a big data technology based on MPP architecture and the Postgres open source database technology. The technology was created by a company…