Software // Information Management
Commentary
9/24/2008
12:54 PM
Curt Monash
Curt Monash
Commentary
Connect Directly
RSS
E-Mail
50%
50%
Repost This

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 Elite 100 - 2014
Our InformationWeek Elite 100 issue -- our 26th ranking of technology innovators -- shines a spotlight on businesses that are succeeding because of their digital strategies. We take a close at look at the top five companies in this year's ranking and the eight winners of our Business Innovation awards, and offer 20 great ideas that you can use in your company. We also provide a ranked list of our Elite 100 innovators.
Video
Slideshows
Twitter Feed
Audio Interviews
Archived Audio Interviews
GE is a leader in combining connected devices and advanced analytics in pursuit of practical goals like less downtime, lower operating costs, and higher throughput. At GIO Power & Water, CIO Jim Fowler is part of the team exploring how to apply these techniques to some of the world's essential infrastructure, from power plants to water treatment systems. Join us, and bring your questions, as we talk about what's ahead.