Feeds

ParAccel flashes data warehouses

Thinking in columns

Boost IT visibility and business value

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.

Boost IT visibility and business value

Next page: Redmondian roots

More from The Register

next story
Pay to play: The hidden cost of software defined everything
Enter credit card details if you want that system you bought to actually be useful
HP busts out new ProLiant Gen9 servers
Think those are cool? Wait till you get a load of our racks
Shoot-em-up: Sony Online Entertainment hit by 'large scale DDoS attack'
Games disrupted as firm struggles to control network
Community chest: Storage firms need to pay open-source debts
Samba implementation? Time to get some devs on the job
Like condoms, data now comes in big and HUGE sizes
Linux Foundation lights a fire under storage devs with new conference
Silicon Valley jolted by magnitude 6.1 quake – its biggest in 25 years
Did the earth move for you at VMworld – oh, OK. It just did. A lot
prev story

Whitepapers

Gartner critical capabilities for enterprise endpoint backup
Learn why inSync received the highest overall rating from Druva and is the top choice for the mobile workforce.
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.
Rethinking backup and recovery in the modern data center
Combining intelligence, operational analytics, and automation to enable efficient, data-driven IT organizations using the HP ABR approach.
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.
Next gen security for virtualised datacentres
Legacy security solutions are inefficient due to the architectural differences between physical and virtual environments.