Amazon Redshift

Amazon RDS logoAmazon Redshift is a data warehouse product built by Amazon. Available on Amazon Web Services, Redshift is able to handle analytics workloads on large scale datasets and is searchable using traditional BI applications and SQL methods.

The product manages setting up, operating, and scaling data warehouses. It automatically monitors notes and drives to help recover from failures, provision the infrastructure capacity, and operate administrative tasks, such as back-ups and patching.

Amazon Redshift’s performance can reach at least ten times higher than other databases for data warehousing and analytics workloads. A few of its features include:

  • Columnar data storage: Unlike other databases which use a series of rows, this feature is ideal for data warehousing and analytics because the system requires fewer I/Os, leading to an improved query performance.
  • Advanced compression: With its columnar-based data storage, Amazon Redshift automatically samples data and selects the most appropriate compression scheme when loading data into an empty table.
  • Massively Parallel Processing (MPP): Amazon Redshift automatically distributes data and query across nodes, which allows for faster query performance as the data warehouse grows.

Advantages of Amazon Redshift:

  • The ability to access large databases in a low-cost and timely manner
  • The ability to handle databases larger than a petabyte
  • The ability to quickly return results with a variety of resources
  • The low cost can save a lot of money, compared to the cost of using your own hardware and software
RETURN TO THE BI ENCYCLOPEDIA