February 7, 2008

Vertica update

I chatted with Andy Ellicott and Mike Stonebraker of Vertica today. Some of the content is embargoed until February 19 (for TDWI), but here are some highlights of the rest.

We also addressed the subject of Vertica’s schema assumptions, but I’ll leave that to another post.


6 Responses to “Vertica update”

  1. Larry Dooley on February 8th, 2008 4:09 pm

    I’m very familiar with hedge funds have worked at one for almost 7 years (a top 25 fund).
    10 tb is a lot of data for a hedge fund even if you’ve got both position by strategy/hedge by security
    by tax lot by day and also keep it by prime brokerage account strategy security tax lot by day that’s
    a lot of data but for the big guys for 5 years data I don’t see it close to 10 TD (and I’ve had my
    nose buried in this for a good bit of the past seven years) The first by strategy by security is going
    to be both wide and deep. The second at prime brokerage location is going to narrow and deep. It’s
    extremely difficult if not impossible to do P&L at prime brokerage locations Margin is a different matter
    and very important because managing that means managing your leverage.

    If you’ve got anyone else doing DW/BI at hedge funds I’d be interestend in corresponding

  2. Curt Monash on February 8th, 2008 10:38 pm

    As I understand it, this isn’t primarily for the hedge funds’ own transactions (although I’m sure those are stored too). Rather, it’s for historical market data, trade-by-trade. I.e., it’s for the algorithm-development part of algorithmic trading.


  3. Column Oriented Storage lawsuits? « Technophilia on April 6th, 2008 5:40 pm

    […] vertica update 2 the author […]

  4. Amrith on April 6th, 2008 9:08 pm

    You make a mention of the Sybase vs. Vertica lawsuit in your post. The lawsuit currently is against Vertica but may affect column store databases in general.


  5. DBMS2 — DataBase Management System Services » Blog Archive » Vertica update on May 13th, 2008 7:48 am

    […] outsourced data marts. But I also had the opportunity to follow up on a couple of points from February’s briefing, […]

  6. Vertica a column database | Think… hack! on August 13th, 2010 2:24 am

    […] First of; Vertica is expensive! I found one post claiming typical initial selling price is $250K, ouch! Not really a product for startup or smaller […]

Leave a Reply

Feed: DBMS (database management system), DW (data warehousing), BI (business intelligence), and analytics technology Subscribe to the Monash Research feed via RSS or email:


Search our blogs and white papers

Monash Research blogs

User consulting

Building a short list? Refining your strategic plan? We can help.

Vendor advisory

We tell vendors what's happening -- and, more important, what they should do about it.

Monash Research highlights

Learn about white papers, webcasts, and blog highlights, by RSS or email.