Feeds

Teradata adds flash, denser packaging for BI appliances

More data chewing per square foot

The Essential Guide to IT Transformation

In general, the 80-20 rule applies, says Gnau, with about 20 per cent of the data using up about 80 per cent of the aggregate I/O. "You are always looking at last week's data, which is hot, and then comparing it to the year-ago data, which was cold, then gets hot for a while, and then gets cold again."

Because moving this data manually from disk to SSD and back again would be a nightmare, Teradata has cooked up a little something it calls Virtual Storage, which tracks the hotness and coldness of the data at a block level and automatically moves it back and forth between the media based on the demand from the queries smacking against it. This software was first released in the Teradata clustered database two years ago, according to Gnau. "This is not some vaporware," Gnau says emphatically. "It is out there in the field and it works."

Rack for rack, the Active EDW 6680 flash-enhanced appliances have about four times the throughput of the new Active EDW 6650 appliances; the 6680s have less capacity and user space, of course, but significantly higher I/O for a portion of their data.

Gnau says that a few customers have already installed the Active EDW 6680 flashy appliances, and that is is aimed at the belly of the market where flash will help on some queries – not at the Extreme Performance Appliance 4600, where the "all the customer's data is hot, all the time". Teradata is also using the 6680 appliances on the systems that track its quality metrics and manage its supply chain for its manufacturing operations.

While you can mix the Active EDW 5650 and 6650 nodes in a single Teradata cluster, it is not advisable to mix the 6680 flash-enhanced nodes with node that don't have flash because, as Gnau put it, in a shared-nothing cluster, the cluster only performance as fast as its slowest node, so the 6680 nodes would be tapping their feet about three quarters of the time.

While Teradata did not release pricing information for the two new appliances, Gnau did give some guidance. The Active EDW 6650 costs less than the 5650 appliance announced last fall. The flash-enhanced Active EDW 6680 costs about the same as last year's 5650 appliance, but because it can do more work, it yields a much better cost per query than the 5650 did. The Active EDW 6680 has about a 75 per cent reduction in data center footprint and power consumption compared to a 5650 appliance yielding the same performance. ®

The Essential Guide to IT Transformation

More from The Register

next story
Sysadmin Day 2014: Quick, there's still time to get the beers in
He walked over the broken glass, killed the thugs... and er... reconnected the cables*
VMware builds product executables on 50 Mac Minis
And goes to the Genius Bar for support
Auntie remains MYSTIFIED by that weekend BBC iPlayer and website outage
Still doing 'forensics' on the caching layer – Beeb digi wonk
Multipath TCP speeds up the internet so much that security breaks
Black Hat research says proposed protocol will bork network probes, flummox firewalls
Microsoft says 'weird things' can happen during Windows Server 2003 migrations
Fix coming for bug that makes Kerberos croak when you run two domain controllers
Cisco says network virtualisation won't pay off everywhere
Another sign of strain in the Borg/VMware relationship?
Forrester says Australia, not China, is next boom market for cloud
It's cloudy but fine down under, analyst says
prev story

Whitepapers

Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
Boost IT visibility and business value
How building a great service catalog relieves pressure points and demonstrates the value of IT service management.
Why and how to choose the right cloud vendor
The benefits of cloud-based storage in your processes. Eliminate onsite, disk-based backup and archiving in favor of cloud-based data protection.
The Essential Guide to IT Transformation
ServiceNow discusses three IT transformations that can help CIO's automate IT services to transform IT and the enterprise.
Maximize storage efficiency across the enterprise
The HP StoreOnce backup solution offers highly flexible, centrally managed, and highly efficient data protection for any enterprise.