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

Built by the engineers behind Netezza and the technology behind Amazon Redshift, AnzoGraph is a native, Massively Parallel Processing (MPP) distributed Graph OLAP (GOLAP) database that executes queries more than 100x faster than other vendors.  

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.

Download AnzoGraph now and find out for yourself why it is acknowledged as the most complete all-in-one data warehouse for BI style and graph analytics.  

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 }}