Feeds

ParAccel flashes data warehouses

Thinking in columns

Internet Security Threat Report 2014

ParAccel - one of the many upstarts that is chasing the data warehousing and analytics dollars these days - has tweaked its ParAccel Analytic Database 2.0 software and its underlying homegrown Linux operating system so that the x64 nodes on which it runs can be equipped with flash-based drives. And that, the company says, will boost query performance.

The ParAccel analytics database and the data warehousing clusters that are built using it are not just glorified relational databases that organize record information in rows and then scan it to do queries, but rather use a columnar format that organizes data by field. (The Sybase IQ database, which is used in several thousand data warehouses and which is distinct from the regular Adaptive Server relational database, also organizes data in columns).

Organizing relational databases by row is key for transaction processing, where you want to locate a record among zillions, read its data, and maybe modify it. But in a data warehouse, where you want to sort data and extract answers from the tables underlying the database, this row orientation gets in the way and slows everything down. Which is why Barry Zane, one of the founders of data warehousing appliance maker Netezza, left the company and started ParAccel in 2006.

Here's a simple example: Say you have a subset of the US census data with 10 different answers to questions stored in 10 fields in a relational database. Say each one has 10 bytes of data. In the row-oriented relational data warehouse, if you want to ask a question about the state and age of citizens, you have to scan all ten fields, for a total of 1,000 bytes.

But in a columnar database, you know you only want to look at the age and state columns, and you are only scanning 200 bytes to do a query. With the ParAccel database, you run the database in a shared-nothing, massively parallel cluster of servers with a mix of local server and remote SAN storage, and you can radically speed up table scans and queries as well as loading of data onto the database because everything is parallelized.

The addition of flash to PADB 2.0, which started shipping in June, doesn't boost performance as much as you might expect, and that's because of the clever things that the database already does with local and remote storage to goose performance. According to Kim Stanick, vice president of marketing at ParAccel, customers should expect about a 15 per cent performance boost if they add some flash drives to their x64 servers, and when the reduced power consumption is taken into account, they might see a 25 per cent increase in queries per watt. That's nothing to shake a stick at, but it is not the kind of performance improvement you would expect given the very high I/O rates of flash drives.

Beginner's guide to SSL certificates

Next page: Redmondian roots

More from The Register

next story
Docker's app containers are coming to Windows Server, says Microsoft
MS chases app deployment speeds already enjoyed by Linux devs
'Hmm, why CAN'T I run a water pipe through that rack of media servers?'
Leaving Las Vegas for Armenia kludging and Dubai dune bashing
'Urika': Cray unveils new 1,500-core big data crunching monster
6TB of DRAM, 38TB of SSD flash and 120TB of disk storage
Facebook slurps 'paste sites' for STOLEN passwords, sprinkles on hash and salt
Zuck's ad empire DOESN'T see details in plain text. Phew!
SDI wars: WTF is software defined infrastructure?
This time we play for ALL the marbles
Windows 10: Forget Cloudobile, put Security and Privacy First
But - dammit - It would be insane to say 'don't collect, because NSA'
Oracle hires former SAP exec for cloudy push
'We know Larry said cloud was gibberish, and insane, and idiotic, but...'
prev story

Whitepapers

Forging a new future with identity relationship management
Learn about ForgeRock's next generation IRM platform and how it is designed to empower CEOS's and enterprises to engage with consumers.
Why cloud backup?
Combining the latest advancements in disk-based backup with secure, integrated, cloud technologies offer organizations fast and assured recovery of their critical enterprise data.
Win a year’s supply of chocolate
There is no techie angle to this competition so we're not going to pretend there is, but everyone loves chocolate so who cares.
High Performance for All
While HPC is not new, it has traditionally been seen as a specialist area – is it now geared up to meet more mainstream requirements?
Intelligent flash storage arrays
Tegile Intelligent Storage Arrays with IntelliFlash helps IT boost storage utilization and effciency while delivering unmatched storage savings and performance.