Software // Information Management
Commentary
9/24/2008
12:54 PM
Curt Monash
Curt Monash
Commentary
50%
50%

Vertica Spells Out Compression Claims

Omer Trajman of column-store DBMS vendor Vertica put up a must-read blog spelling out detailed compression numbers, based on actual field experience... Omer goes on to claim that Vertica's compression is typically severalfold better than that of competitive row-based systems.

Omer Trajman of column-store DBMS vendor Vertica put up a must-read blog spelling out detailed compression numbers, based on actual field experience (which I'd guess is from a combination of production systems and POCs):• CDR - 8:1 (87%) • Consumer Data - 30:1 (96%) • Marketing Analytics - 20:1 (95%) • Network logging - 60:1 (98%) • Switch Level SNMP - 20:1 (95%) • Trade and Quote Exchange - 5:1 (80%) • Trade Execution Auditing Trails - 10:1 (90%) • Weblog and Click-stream - 10:1 (90%)

It's clear what Omer means by most of those categories from reading the post, but I'm a little fuzzy on what "Consumer Data" or "Marketing Analytics" comprise in his taxonomy. Anyhow, Omer's post is a huge improvement over my recent one - based on a conversation with Omer - which featured far less accurate and complete compression numbers.

Omer goes on to claim that trickle-feed data is harder for rival systems to compress than it is for Vertica, and generally to claim that Vertica's compression is typically severalfold better than that of competitive row-based systems.Omer Trajman of column-store DBMS vendor Vertica put up a must-read blog spelling out detailed compression numbers, based on actual field experience... Omer goes on to claim that Vertica's compression is typically severalfold better than that of competitive row-based systems.

Comment  | 
Print  | 
More Insights
The Agile Archive
The Agile Archive
When it comes to managing data, donít look at backup and archiving systems as burdens and cost centers. A well-designed archive can enhance data protection and restores, ease search and e-discovery efforts, and save money by intelligently moving data from expensive primary storage systems.
Register for InformationWeek Newsletters
White Papers
Current Issue
InformationWeek Tech Digest, Nov. 10, 2014
Just 30% of respondents to our new survey say their companies are very or extremely effective at identifying critical data and analyzing it to make decisions, down from 42% in 2013. What gives?
Video
Slideshows
Twitter Feed
InformationWeek Radio
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.