Comparing Vertica, ParAccel and Exasol - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

IoT
IoT
Software // Information Management
Commentary
8/19/2008
09:00 AM
Curt Monash
Curt Monash
Commentary
50%
50%

Comparing Vertica, ParAccel and Exasol

I talked with executives at Nuremberg, Germany-based Exasol last week - at 5:00 am ET! - and of course want to blog about it. For clarity, I'd like to start by comparing/contrasting the fundamental data structures at Vertica, ParAccel, and Exasol. And it feels like that should be a separate post. So here goes.

I talked with executives at Nuremberg, Germany-based Exasol last week - at 5:00 am ET! - and of course want to blog about it. For clarity, I'd like to start by comparing/contrasting the fundamental data structures at Vertica, ParAccel, and Exasol. And it feels like that should be a separate post. So here goes.• Exasol, Vertica, and ParAccel all store data in columnar formats.

• Exasol, Vertica, and ParAccel all compress data heavily.

• Exasol, Vertica, and ParAccel all - perhaps to varying extents - operate on in-memory data in compressed formats.

ParAccel and Exasol write data to what amounts to the in-memory part of their basic data structures; the data then gets persisted to disk. Vertica, however, has a separate in-memory data structure to accept data and write it to disk.

Vertica is a disk-centric system that doesn't rely on there being a lot of RAM.

• ParAccel can be described that way too; however, in some cases (including on the TPC-H benchmarks), ParAccel recommends loading all your data into RAM for maximum performance.

• Exasol is totally optimized for the assumption that queries will be run against data that had already been previously loaded into RAM.

Beyond the above, I discuss in this separate post how Exasol does MPP shared-nothing, software-only columnar data warehouse database management differently than Vertica and ParAccel.I talked with executives at Nuremberg, Germany-based Exasol last week - at 5:00 am ET! - and of course want to blog about it. For clarity, I'd like to start by comparing/contrasting the fundamental data structures at Vertica, ParAccel, and Exasol. And it feels like that should be a separate post. So here goes.

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
Commentary
Gartner Forecast Sees 7.3% Shrinkage in IT Spending for 2020
Joao-Pierre S. Ruth, Senior Writer,  7/15/2020
Slideshows
10 Ways AI Is Transforming Enterprise Software
Cynthia Harvey, Freelance Journalist, InformationWeek,  7/13/2020
Commentary
IT Career Paths You May Not Have Considered
Lisa Morgan, Freelance Writer,  6/30/2020
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
Key to Cloud Success: The Right Management
This IT Trend highlights some of the steps IT teams can take to keep their cloud environments running in a safe, efficient manner.
Slideshows
Flash Poll