Feeds

Teradata adds flash, denser packaging for BI appliances

More data chewing per square foot

Internet Security Threat Report 2014

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.

Intelligent flash storage arrays

More from The Register

next story
Azure TITSUP caused by INFINITE LOOP
Fat fingered geo-block kept Aussies in the dark
NASA launches new climate model at SC14
75 days of supercomputing later ...
Yahoo! blames! MONSTER! email! OUTAGE! on! CUT! CABLE! bungle!
Weekend woe for BT as telco struggles to restore service
Cloud unicorns are extinct so DiData cloud mess was YOUR fault
Applications need to be built to handle TITSUP incidents
BOFH: WHERE did this 'fax-enabled' printer UPGRADE come from?
Don't worry about that cable, it's part of the config
Stop the IoT revolution! We need to figure out packet sizes first
Researchers test 802.15.4 and find we know nuh-think! about large scale sensor network ops
DEATH by COMMENTS: WordPress XSS vuln is BIGGEST for YEARS
Trio of XSS turns attackers into admins
SanDisk vows: We'll have a 16TB SSD WHOPPER by 2016
Flash WORM has a serious use for archived photos and videos
prev story

Whitepapers

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.
A strategic approach to identity relationship management
ForgeRock commissioned Forrester to evaluate companies’ IAM practices and requirements when it comes to customer-facing scenarios versus employee-facing ones.
Go beyond APM with real-time IT operations analytics
How IT operations teams can harness the wealth of wire data already flowing through their environment for real-time operational intelligence.
The total economic impact of Druva inSync
Examining the ROI enterprises may realize by implementing inSync, as they look to improve backup and recovery of endpoint data in a cost-effective manner.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.