by S-Square | Jun 28, 2019 | Blogs
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...
by S-Square | Jun 28, 2019 | Blogs
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...
by S-Square | May 29, 2019 | Blogs
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...
by S-Square | May 28, 2019 | Blogs
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...
by S-Square | Apr 30, 2019 | Blogs
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...