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 PC World newsletter!

Error: Please check your email address.
Rocket to Success - Your 10 Tips for Smarter ERP System Selection

Tags Amazon Web ServicesManaged Servicescloud computinginternet

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

Most Popular Reviews

Latest Articles

Resources

PCW Evaluation Team

Matthew Stivala

HP OfficeJet 250 Mobile Printer

The HP OfficeJet 250 Mobile Printer is a great device that fits perfectly into my fast paced and mobile lifestyle. My first impression of the printer itself was how incredibly compact and sleek the device was.

Armand Abogado

HP OfficeJet 250 Mobile Printer

Wireless printing from my iPhone was also a handy feature, the whole experience was quick and seamless with no setup requirements - accessed through the default iOS printing menu options.

Azadeh Williams

HP OfficeJet Pro 8730

A smarter way to print for busy small business owners, combining speedy printing with scanning and copying, making it easier to produce high quality documents and images at a touch of a button.

Andrew Grant

HP OfficeJet Pro 8730

I've had a multifunction printer in the office going on 10 years now. It was a neat bit of kit back in the day -- print, copy, scan, fax -- when printing over WiFi felt a bit like magic. It’s seen better days though and an upgrade’s well overdue. This HP OfficeJet Pro 8730 looks like it ticks all the same boxes: print, copy, scan, and fax. (Really? Does anyone fax anything any more? I guess it's good to know the facility’s there, just in case.) Printing over WiFi is more-or- less standard these days.

Ed Dawson

HP OfficeJet Pro 8730

As a freelance writer who is always on the go, I like my technology to be both efficient and effective so I can do my job well. The HP OfficeJet Pro 8730 Inkjet Printer ticks all the boxes in terms of form factor, performance and user interface.

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.

Featured Content

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?