Vertica Spells Out Compression Claims - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

IoT
IoT
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.

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
Slideshows
10 RPA Vendors to Watch
Jessica Davis, Senior Editor, Enterprise Apps,  8/20/2019
Commentary
Enterprise Guide to Digital Transformation
Cathleen Gagne, Managing Editor, InformationWeek,  8/13/2019
Slideshows
IT Careers: How to Get a Job as a Site Reliability Engineer
Cynthia Harvey, Freelance Journalist, InformationWeek,  7/31/2019
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
Data Science and AI in the Fast Lane
This IT Trend Report will help you gain insight into how quickly and dramatically data science is influencing how enterprises are managed and where they will derive business success. Read the report today!
Slideshows
Flash Poll