Welcome Guest. | Log In| Register | Membership Benefits

Intelligent Enterprise

Better Insight for Business Decisions

Intelligent Enterprise - Better Insight for Business Decisions
search Intelligent Enterprise
Home
Digital Library
Events
RSS | Newsletters
Webcasts



Vertica Spells Out Compression Claims | Intelligent Enterprise Blog
Data Frontiers, by Curt Monash
Curt Monash runs Monash Research, which provides strategic, analysis-based advice to users and vendors of advanced information technology. He also writes the blogs DBMS2, Text Technologies, and Strategic Messaging.
See More by Curt Monash

E-MAIL | Follow Us on Twitter FOLLOW US
Share
Vertica Spells Out Compression Claims

Posted by Curt Monash
Wednesday, September 24, 2008
12:54 PM

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.



E-MAIL | Follow Us on Twitter FOLLOW US
Share




This is a public forum. United Business Media and its affiliates are not responsible for and do not control what is posted herein. United Business Media makes no warranties or guarantees concerning any advice dispensed by its staff members or readers.

Community standards in this comment area do not permit hate language, excessive profanity, or other patently offensive language. Please be aware that all information posted to this comment area becomes the property of United Business Media LLC and may be edited and republished in print or electronic format as outlined in United Business Media's Terms of Service.

Important Note: This comment area is NOT intended for commercial messages or solicitations of business.


 




    Subscribe to RSS feed of all blogs