Amazon Redshift Ready For Data
Written by Kay Ewbank   
Friday, 15 February 2013

Amazon’s cloud-based petabyte-scale data warehouse service is now available.

When Amazon Redshift was announced  in November it was restricted to a limited preview. The full version, which is still in beta, is now available, at costs of less than $1,000 per terabyte per year, which Amazon says is a tenth of the cost of most traditional data warehousing solutions.

Redshift data can be analyzed using ‘normal’ SQL-based tools and business intelligence applications, and the clusters can be set up using a few clicks in the AWS Management Console. Queries can be distributed and parallelized across multiple nodes, and Amazon has automated most of the common administrative tasks associated with provisioning, configuring, monitoring, backing up, and securing a data warehouse to make Redshift easier to administer.

 

redshift

 

Redshift supports Amazon VPC out of the box and encrypting and backing up data are simple operations. There’s an automated snapshot feature that continuously backs up new data on the cluster to Amazon S3. Snapshots are automated, incremental, and continuous, and you can also take your own snapshots at any time.

The lower costs will be a major reason for considering Redshift. It is based on a pay as you go model, and you’re charged an hourly rate based on the node type and the number of nodes in your cluster. Amazon Redshift supports two types of data warehouse nodes, a High Storage Extra Large (XL) with 2TB of storage and a High Storage Eight Extra Large (8XL) with 16TB of storage. You can start with a single XL node, 2TB data warehouse for $0.85 per hour and prices scale linearly up. If you use reserved instance pricing, the cost drops to under $1,000 per TB per year.

This promotional video is both watchable and informative. The presenter talks very quickly so it’s short!

 

 

More Information

Amazon Redshift

Related Articles

Amazon Redshifts Big Data

New AWS Managed Services

Amazon RDS Adds Replication Feature

 

To be informed about new articles on I Programmer, install the I Programmer Toolbar, subscribe to the RSS feed, follow us on, Twitter, Facebook, Google+ or Linkedin,  or sign up for our weekly newsletter.

 

espbook

 

Comments




or email your comment to: comments@i-programmer.info

 

Banner


Gender Differences In Coding Style
13/11/2024

A novel investigation into the gender gap between men and women regarding coding ability was undertaken by Dr Siân Brooke. Her conclusion? There is a difference in the Python code [ ... ]



Data Wrangler Gets Copilot Integration
11/11/2024

Microsoft has announced that Copilot is being integrated into Data Wrangler. The move will give data scientists the ability to use natural language to clean and transform data, and to get help with fi [ ... ]


More News

Last Updated ( Friday, 15 February 2013 )