Amazon improves performance and cuts cost of data warehouse service

Amazon Web Services has introduced a new node type with SSD storage and faster processors

Amazon Web Services has improved the performance of its Redshift data warehouse with new SSD-based nodes, which can also lower the cost of the service as long as storage capacity needs are also low.

Just like with many of its other hosted services, Amazon contends that Redshift lowers the bar for implementing and managing, in this case, a data warehouse. IT takes care of the work needed to set up and operate a data warehouse, including provisioning the infrastructure and automating tasks such as backups and patching.

Redshift data warehouses are made up of clusters of Dense Storage nodes or the new SSD-based Dense Compute nodes. The storage nodes allow enterprises to create very large data warehouses using hard disk drives for a low price per gigabyte, while the compute nodes allow enterprises to build high-performance data warehouses using faster CPUs, large amounts of RAM and SSD storage.

The compute nodes are ideal for enterprises which have less than 500GB of data in their warehouse or whose primary focus is performance. The storage nodes are a better fit when performance isn't as critical and storage demands are high but the budget isn't.

On-demand prices for a single Large Dense Compute node start at US$0.25 per hour. For that users get 160GB of SSD storage, two Intel Xeon E5-2670v2 virtual cores (based on Ivy Bridge) and 15GB of RAM. A single Extra Large Dense Storage node may cost from $0.85 per hour, but it has 2TB of storage. It also has two Intel Xeon E5-2650 virtual cores (based on Sandy Bridge) and 15GB of RAM.

For users that want better performance and more storage per node, Amazon also offers Eight Extra Large nodes in both Compute and Storage variants. Warehouses based on those two can contain up to 100 nodes, while ones based on the smaller nodes can contain up to 32 nodes.

Scaling a cluster up and down or switching between node types is done using API calls or the AWS Management Console.

Since its launch in February last year, Redshift -- which still is in beta -- has been adopted by companies such as Fender, Financial Times, Nasdaq OMX, Nokia, and Pinterest, Amazon said.

Join the Good Gear Guide newsletter!

Error: Please check your email address.

Tags Amazon Web ServicesManaged Servicescloud computinginternet

Our Back to Business guide highlights the best products for you to boost your productivity at home, on the road, at the office, or in the classroom.

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Mikael Ricknäs

IDG News Service
Show Comments

Essentials

Lexar® JumpDrive® S57 USB 3.0 flash drive

Learn more >

Microsoft L5V-00027 Sculpt Ergonomic Keyboard Desktop

Learn more >

Mobile

Lexar® JumpDrive® S45 USB 3.0 flash drive 

Learn more >

Exec

Lexar® JumpDrive® C20c USB Type-C flash drive 

Learn more >

Lexar® Professional 1800x microSDHC™/microSDXC™ UHS-II cards 

Learn more >

HD Pan/Tilt Wi-Fi Camera with Night Vision NC450

Learn more >

Audio-Technica ATH-ANC70 Noise Cancelling Headphones

Learn more >

Budget

Back To Business Guide

Click for more ›

Most Popular Reviews

Latest News Articles

Resources

PCW Evaluation Team

Michael Hargreaves

Windows 10 for Business / Dell XPS 13

I’d happily recommend this touchscreen laptop and Windows 10 as a great way to get serious work done at a desk or on the road.

Aysha Strobbe

Windows 10 / HP Spectre x360

Ultimately, I think the Windows 10 environment is excellent for me as it caters for so many different uses. The inclusion of the Xbox app is also great for when you need some downtime too!

Mark Escubio

Windows 10 / Lenovo Yoga 910

For me, the Xbox Play Anywhere is a great new feature as it allows you to play your current Xbox games with higher resolutions and better graphics without forking out extra cash for another copy. Although available titles are still scarce, but I’m sure it will grow in time.

Kathy Cassidy

STYLISTIC Q702

First impression on unpacking the Q702 test unit was the solid feel and clean, minimalist styling.

Anthony Grifoni

STYLISTIC Q572

For work use, Microsoft Word and Excel programs pre-installed on the device are adequate for preparing short documents.

Featured Content

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?