Vertica Spells Out Compression Claims - InformationWeek
IoT
IoT
Software // Information Management
Commentary
9/24/2008
12:54 PM
Curt Monash
Curt Monash
Commentary
50%
50%
RELATED EVENTS
[Dark Reading Crash Course] Finding & Fixing Application Security Vulnerabilitie
Sep 14, 2017
Hear from a top applications security expert as he discusses key practices for scanning and securi ...Read More>>

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
Comments
Newest First  |  Oldest First  |  Threaded View
How Enterprises Are Attacking the IT Security Enterprise
How Enterprises Are Attacking the IT Security Enterprise
To learn more about what organizations are doing to tackle attacks and threats we surveyed a group of 300 IT and infosec professionals to find out what their biggest IT security challenges are and what they're doing to defend against today's threats. Download the report to see what they're saying.
Register for InformationWeek Newsletters
White Papers
Current Issue
2017 State of IT Report
In today's technology-driven world, "innovation" has become a basic expectation. IT leaders are tasked with making technical magic, improving customer experience, and boosting the bottom line -- yet often without any increase to the IT budget. How are organizations striking the balance between new initiatives and cost control? Download our report to learn about the biggest challenges and how savvy IT executives are overcoming them.
Video
Slideshows
Twitter Feed
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.
Flash Poll