Amazon Redshift: The Definitive Guide

Chapter 9. Migrating to Amazon Redshift

Organizations have been running on-premises data warehouses for years, and these have served them well for the workloads of yesterday. But today’s volume, variety, and velocity of data requires customers to modernize their data warehouses to ensure optimal performance. Here are some of the major limitations or shortcomings of the traditional data warehouse:

Slow to obtain

Procuring your own servers and sizing them takes much longer compared to provisioning infrastructure in the cloud.

Costly to maintain

They are so rigid in the structure that any modifications means a drastic increase in costs and project timelines.

Resiliency

Hardware components are bound to fail sooner or later. Designing redundancy around failures and having multiple data centers with standby servers gets expensive really fast.

Inflexible architecture

The foremost requirement of every business is agility and scalability. The inflexible architecture of the traditional data warehouses makes it next to impossible to bring in changes rapidly.

Technology advances

Advancements in technology are made every day. The traditional data warehouse you set up for your business was probably done a couple of years back. So, you are already behind.

To address these limitations, one option is to adopt Amazon Redshift for your analytical needs because it is a fully managed, fast, scalable, and cost-effective service that enables you to derive insights from all your data.

However, ...