Feeds

ParAccel flashes data warehouses

Thinking in columns

Next gen security for virtualised datacentres

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.

5 things you didn’t know about cloud backup

Next page: Redmondian roots

More from The Register

next story
The Return of BSOD: Does ANYONE trust Microsoft patches?
Sysadmins, you're either fighting fires or seen as incompetents now
Microsoft: Azure isn't ready for biz-critical apps … yet
Microsoft will move its own IT to the cloud to avoid $200m server bill
Oracle reveals 32-core, 10 BEEELLION-transistor SPARC M7
New chip scales to 1024 cores, 8192 threads 64 TB RAM, at speeds over 3.6GHz
Docker kicks KVM's butt in IBM tests
Big Blue finds containers are speedy, but may not have much room to improve
US regulators OK sale of IBM's x86 server biz to Lenovo
Now all that remains is for gov't offices to ban the boxes
Gartner's Special Report: Should you believe the hype?
Enough hot air to carry a balloon to the Moon
Flash could be CHEAPER than SAS DISK? Come off it, NetApp
Stats analysis reckons we'll hit that point in just three years
Dell The Man shrieks: 'We've got a Bitcoin order, we've got a Bitcoin order'
$50k of PowerEdge servers? That'll be 85 coins in digi-dosh
prev story

Whitepapers

Endpoint data privacy in the cloud is easier than you think
Innovations in encryption and storage resolve issues of data privacy and key requirements for companies to look for in a solution.
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.
Top 8 considerations to enable and simplify mobility
In this whitepaper learn how to successfully add mobile capabilities simply and cost effectively.
Solving today's distributed Big Data backup challenges
Enable IT efficiency and allow a firm to access and reuse corporate information for competitive advantage, ultimately changing business outcomes.
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.