Comparing Vertica, ParAccel and Exasol - InformationWeek
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
AI as a Human Right
Guest Commentary, Guest Commentary,  3/8/2019
News
How to Become a Master Scrum Master
John Edwards, Technology Journalist & Author,  2/28/2019
News
TaylorMade IT Spin-Off Taps Cloud Database
Jessica Davis, Senior Editor, Enterprise Apps,  2/15/2019
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
Security and Privacy vs. Innovation: The Great Balancing Act
This InformationWeek IT Trend Report will help you better understand and address the growing challenge of balancing the need for innovation with the real-world threats and regulations.
Slideshows
Flash Poll