Feeds

Teradata adds flash, denser packaging for BI appliances

More data chewing per square foot

Providing a secure and efficient Helpdesk

Teradata wants to keep its dominant position in data warehousing and analytics, so it is picking up the technology pace to take on Oracle with its Exadata appliances and IBM with its Netezza and Smart Analytic System appliances. The company is rolling out an improved Enterprise Data Warehouse product line and a separate product that mixes disk drives and flash memory to shoot the gap between its disk-based and flash-based appliances.

As El Reg previously reported, Teradata rolled out its first fully flash-based data warehouse box, the Extreme Performance Appliance 4600, last October. This machine pairs up solid state disk drives and two-socket Xeon X5670 server nodes from Dell to create a data warehousing box that delivers around 18X the improvement in decision support query rates compared to the basic Active Enterprise Data Warehouse cluster running the Teradata 13.10 database. Average query times on the fully flashed EPA 4600 cluster are about one-quarter of the disk-based Active EDW appliance.

But not everybody needs that kind of performance, or can live with the 17 TB of data space upper limit that the 24-node EPA 4600 has. So Teradata is creating a new box that sits somewhere between the Active EDW and the EPA 4600 in its product line, offering a balanced mix of 3.5-inch 15K RPM Fibre Channel disks and SSDs.

To build this hybrid box, Teradata first went back to the drawing board and rejiggered the all-disk Active EDW design with the 6650 appliance, an upgrade to last year's Active EDW 5650. Scott Gnau, chief development officer at Teradata, tells El Reg that the 6650 appliance consumes about 25 per cent less energy and has about a 25 per cent lower footprint than the 5650 appliance. To accomplish this, 3.5-inch Fibre Channel disk storage used for the server nodes is packed more tightly in the server nodes.

The Active EDW comes in two flavors. The 6650C appliance only has one of the two processor sockets in the server nodes populated with a six-core 2.93GHz Xeon X5670 processor and 48GB of main memory on the nodes. Each node can have up to four disk drives and uses 8Gb/sec Fibre Channel adapters to link out to additional storage. The Active EDW 6650C uses Teradata's BYNET V4 system interconnect to link cluster nodes together and scales up to 4,096 nodes; it is designed to co-exist with prior EDW boxes and offers up to 22.8TB per node of user data space with 42 to 124 disks per node.

The new Active EDW 6650H plugs in a second processor for a total of a dozen cores per node, doubles up main memory to 96GB on the server node, and allows for between 84 and 232 disks to be attached per node for up to 29.6GB of user space per node. This box also scales up to 4,096 nodes across that BYNET 4 network to scale the data warehousing workloads, for a total capacity of 92PB.

Teradata Active EDW 6650

Teradata's Active EDW 6650 and 6680

The Active EDW 6680 gets the flash drives and there is a significant performance boost on the I/O front and even denser packaging. This box is based on a two-socket Xeon X5670 configuration (that's the six-core chips running at 2.93GHz) with 96GB of main memory. Teradata is using 300GB SSDs from Pliant, with a total of a dozen SSDs per tray and three trays per cabinet. Gnau says that Teradata has tuned up four different SSD-disk node configurations, which vary depending on how much of the data customers are using is hot or cold, with the percentage ranging from a low of 15 per cent to a high of 34 per cent of total customer data space. Teradata is using disk and SSD enclosures from LSI this time around. Using the BYNET 4 interconnect, the 6680 can scale up to 4,096 nodes; depending on the disk and SSD configuration, each node can have between 3.8TB and 7.3TB of combined disk capacity, which works out to between 15.6PB and 29.9PB of customer data space max.

Security for virtualized datacentres

More from The Register

next story
Wanna keep your data for 1,000 YEARS? No? Hard luck, HDS wants you to anyway
Combine Blu-ray and M-DISC and you get this monster
US boffins demo 'twisted radio' mux
OAM takes wireless signals to 32 Gbps
Apple flops out 2FA for iCloud in bid to stop future nude selfie leaks
Millions of 4chan users howl with laughter as Cupertino slams stable door
No biggie: EMC's XtremIO firmware upgrade 'will wipe data'
But it'll have no impact and will be seamless, we're told
Students playing with impressive racks? Yes, it's cluster comp time
The most comprehensive coverage the world has ever seen. Ever
prev story

Whitepapers

Providing a secure and efficient Helpdesk
A single remote control platform for user support is be key to providing an efficient helpdesk. Retain full control over the way in which screen and keystroke data is transmitted.
WIN a very cool portable ZX Spectrum
Win a one-off portable Spectrum built by legendary hardware hacker Ben Heck
Saudi Petroleum chooses Tegile storage solution
A storage solution that addresses company growth and performance for business-critical applications of caseware archive and search along with other key operational systems.
Protecting users from Firesheep and other Sidejacking attacks with SSL
Discussing the vulnerabilities inherent in Wi-Fi networks, and how using TLS/SSL for your entire site will assure security.
Security for virtualized datacentres
Legacy security solutions are inefficient due to the architectural differences between physical and virtual environments.