What Is Amazon Redshift?

Amazon Redshift Defined

Amazon Redshift is an Internet hosting service and a petabyte-scale data warehouse cloud product, which is a  part of Amazon’s Web Services platform. This service is a relational database system, which is built on PostgreSQL data warehouse technology. 

This data warehouse is a collection of computing resources called nodes, which are organized to clusters. Each cluster runs an Amazon Redshift engine, containing one or more databases. 

There are two types of nodes within Amazon Redshift:

  • Dense Storage (DS) – These nodes allow you to create large data warehouses using Hard Disk Drives (HDDs) for a low price point.
  • Dense Compute (DC) – These nodes allow you to create high-performance data warehouses using Solid-State Drives (SSDs).

Amazon Redshift integrates with various data loading and ETL tools and business intelligence reporting, data mining and analytic tools. Allowing for storage and query performance through a combination of parallel processing, columnar data storage and target data compression encoding schemes. 

At Indicative, we pride ourselves on our data warehouse integration. We can integrate with Amazon Redshift, connecting to your event data for customer analysis. Contact us to learn more.

In Data Defined, we help make the complex world of data more accessible by explaining some of the most complex aspects of the field.

Click Here for more Data Defined.