Amazon Redshift Query processing and Result caching

Amazon Redshift Query processing and Result caching

Introduction: In this document, we are going see the flow of query processing and result caching feature in Amazon Redshift. The Query Planning And Execution Workflow: The leader node receives the query and parses the SQL. The parser produces an initial query tree...
Column Compression in Amazon Redshift

Column Compression in Amazon Redshift

What Is Compression? Compression is a column-level operation that reduces the size of data when it is stored. Compression conserves storage space and reduces the size of data that is read from storage, which reduces the amount of disk I/O and therefore improves query...
Amazon Redshift Backups

Amazon Redshift Backups

Snapshots are point-in-time backups of a cluster. There are two types of Snapshots: AUTOMATED and MANUAL. Redshift stores these snapshots internally in S3 by using an encrypted SSL(Secure Socket Layer) connection. When you restore from a snapshot, Amazon Redshift...
Massive Parallel Processing (MPP)

Massive Parallel Processing (MPP)

Introduction: Massive Parallel Processing (MPP) is a type of processing where the data and processing power are split up among several different nodes (servers), with one leader node and one or many compute nodes. In MPP, the leader node would be communicating with...
AWS: S3 at a Glance

AWS: S3 at a Glance

Simple Storage Service – S3  – Object-Based Storage  – Unlimited Storage  – Not Suitable to install OS and/or Database Buckets Naming Convention Unique Name Scope Attached to Region Access By Default – Not Public – Bucket Policies. – Access Control Lists Can create...