Redshift Architecture

 An Amazon Redshift data warehouse is an enterprise-class relational database query and management system.Amazon Redshift is a fully managed highly scalable data warehouse service in AWS.

Here is the list of features covered

	list of features components	Amazon Redshit top features list:
	Leader Node	Optimizing the Data Warehousing
	Compute Node	Petabyte Scale
	Node Slices	Automated Backups
	Massively Parallel Processing	Restore the data fast
	Columnar Data Storage	Network Isolation
	Data Compression
	Query Optimizer RedShift Spectrum

Leader Node  Communication with data apps  Distribution of workloads  Caching of query results  Maintenance of catalog tables

Compute Node

·       Handle all query processing, in parallel execution (MPP)

·       Dense compute nodes (“SDD”) and are best for performance intensive workloads.        

      ·       Dense storage nodes (“HDD”) and are best for large data workloads

Node Slices

·       Compute node is partitioned into number of slices per node.

·       The number of slices per node might change if the cluster is resized using elastic resize.

Massively parallel processing (MPP) Multiple compute nodes execute the same query code on portions of data to maximize parallel processing.

Columnar Data Storage Data in Amazon Redshift data warehouse is stored in a columnar fashion which drastically reduces the I/O on disks. Columnar storage reduces the number of disk I/O requests and minimizes the amount of data loaded into the memory to execute a query.