Amazon Redshift

Amazon Redshift is a data warehouse product which forms part of the larger cloud-computing platform Amazon Web Services. It is built on top of technology from the massive parallel processing data warehouse company ParAccel, to handle large scale data sets and database migrations. Amazon Redshift uses SQL to analyze structured and semi-structured data across data warehouses, operational databases, and data lakes, using AWS-designed hardware and machine learning to deliver the best price performance at any scale. Red shift' is a key concept for astronomers. The term can be understood literally - the wavelength of the light is stretched, so the light is seen as 'shifted' towards the red part of the spectrum. Something similar happens to sound waves when a source of sound moves relative to an observer.

Amazon Redshift materialized views allow you to achieve significantly faster query performance for iterative or predictable analytical workloads such as dashboarding and queries from Business Intelligence (BI) tools, and extract, transform and load ELT data processing jobs. Finely detailed measurements of redshifts are used in helioseismology to determine the precise movements of the photosphere of the Sun.

There are three known types:

1.Doppler shifts ( due to motion through space away from the observer)

2. Gravitational redshifts ( due to light leaving a strong gravitational field)

3. Cosmological expansion ( where space itself stretches as light travels through it).

Amazon Redshift is ideal for online analytical processing (OLAP) using your existing business intelligence tools. Organizations are using Amazon Redshift to: Analyze global sales data for multiple products. Store historical stock trade data.

Pros & Cons of Amazon Redshift :

Pros Cons

Widely Adopted Not a multi-cloud solution

Ease of administration Not 100% managed

Ideal for data lakes Concurrent execution

Ease of querying Choice of keys impacts performance and price

Columnar storage Master node

Performance Not a serverless architecture

Scalability

Security

Strong AWS ecosystem

Pricing

Conclusion

The choice of a data warehouse depends on your use case, your budget, the current state of the business, and your plans to use the data warehouse. We do not believe there is an absolute right or wrong choice about technology selection. Feel free to contact us if you have questions about what data warehouse is a good fit for your business. Our data architects can guide you in making the right decision for your business.