Feeds

Meet Datallegro's database crushing appliance

Where $1.1m equals a cheap box

Build a business case: developing custom apps

It appears that companies must have unusual names in the data warehousing game. The kind vendors like Datallegro and Teradata at least stick a 'data' right in there to let you know the issue at hand. Tricker players like HP (NeoView) and Netezza do us no such favors. We assume the flashy names are meant to reflect the importance of the task at hand - gathering, processing and sorting large volumes of data at the fastest possible speed.

Like the well-regarded Netezza, Datallegro has tackled the data warehousing job via an appliance. It packages up Dell servers, EMC Clariion storage, Cisco switches and the Ingres database into a large, albeit digestible package. The start-up, birthed in 2003, then layers some homegrown software on top of that package to do the dirtiest data warehousing work.

While Netezza uses custom ASICs and FPGAs to boost performance, Datallegro believes it can meet the performance needs of most customers by running with Xeon-based servers and arranging the hardware to form a MPP (Massive Parallel Processing) computer.

"Netezza, in particular, does a very good job of scanning very large amounts of data," said Jesse Fountain, a marketing VP. "Nobody touches them on overall scan speed."

Fountain, however, argues that Netezza's specialized hardware only excels at a limited number of jobs, leaving the vast majority of data analytics work in Datallegro's wheelhouse.

The basic Datallegro appliance starts with a pair of dual-socket servers (with six disks each) connected to an EMC storage system with room for six mirrored drives in a RAID 1 configuration. Filling out a rack, you end up with 8 servers and 4 storage boxes. The servers all talk to each other via Ifiniband - a big win according to Fountain since Infinband's speed helps avoid data grinding on the network. The Dell hardware taps into the storage units with Fibre Channel connections.

You'll also find an extra Dell server in the rack as a safety against system failures.

Outside of this core set-up, Datallegro does require another Dell PowerEdge 2950 server working as a management system. It also offers up a Landing Zone system, which can manage data loads, pumping the appliance with more than 1TB per hour of information. And then there's a backup system for, well, backup.

A beefy racked-up appliance will run about $1.1m for a 15TB unit with a control server. You can, however, jump into the Datallegro adventure with a smaller configuration that starts at $500,000. The prices include all of the software and backup tools.

Datallegro has an encryption option, if you're into that.

It can also build out a grid model for large customers where a number of appliances that run query jobs turn to a central rack for major data crunching.

You'll find more on the systems here. ®

Boost IT visibility and business value

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*
Auntie remains MYSTIFIED by that weekend BBC iPlayer and website outage
Still doing 'forensics' on the caching layer – Beeb digi wonk
SHOCK and AWS: The fall of Amazon's deflationary cloud
Just as Jeff Bezos did to books and CDs, Amazon's rivals are now doing to it
VVOL update: Are any vendors NOT leaping into bed with VMware?
It's not yet been released but everyone thinks it's the dog's danglies
BlackBerry: Toss the server, mate... BES is in the CLOUD now
BlackBerry Enterprise Services takes aim at SMEs - but there's a catch
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.
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.
Consolidation: The Foundation for IT Business Transformation
In this whitepaper learn how effective consolidation of IT and business resources can enable multiple, meaningful business benefits.
How modern custom applications can spur business growth
Learn how to create, deploy and manage custom applications without consuming or expanding the need for scarce, expensive IT resources.
Build a business case: developing custom apps
Learn how to maximize the value of custom applications by accelerating and simplifying their development.