Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Amazon Redshift Deep Dive: Tuning and Best Practices

DZone's Guide to

Amazon Redshift Deep Dive: Tuning and Best Practices

Redshift is Amazon's managed columnar (NoSQL) store. If you're looking to learn more about it or learn how to become a power user from the developers at TripAdvisor, watch this.

· Database Zone
Free Resource

Learn how to create flexible schemas in a relational database using SQL for JSON.

TripAdvisor uses Amazon's Redshift hosted data store, and they've come up with some killer best practices that everyone considering or using Redshift ought to know.


Get a look under the covers: Learn tuning best practices for taking advantage of Amazon Redshift's columnar technology and parallel processing capabilities to improve your delivery of queries and improve overall database performance. This session explains how to migrate from existing data warehouses, create an optimized schema, efficiently load data, use work load management, tune your queries, and use Amazon Redshift's interleaved sorting features. Finally, learn how TripAdvisor uses these best practices to give their entire organization access to analytic insights at scale.

Create flexible schemas using dynamic columns for semi-structured data. Learn how.

Topics:
amazon redshift ,nosql ,database ,cloud ,performance

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}