Feeds

Teradata adds flash, denser packaging for BI appliances

More data chewing per square foot

Intelligent flash storage arrays

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.

Secure remote control for conventional and virtual desktops

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
NSA SOURCE CODE LEAK: Information slurp tools to appear online
Now you can run your own intelligence agency
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

Choosing cloud Backup services
Demystify how you can address your data protection needs in your small- to medium-sized business and select the best online backup service to meet your needs.
Getting started with customer-focused identity management
Learn why identity is a fundamental requirement to digital growth, and how without it there is no way to identify and engage customers in a meaningful way.
Driving business with continuous operational intelligence
Introducing an innovative approach offered by ExtraHop for producing continuous operational intelligence.
Why CIOs should rethink endpoint data protection in the age of mobility
Assessing trends in data protection, specifically with respect to mobile devices, BYOD, and remote employees.
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.