September 7, 2011

Vertica projections — an overview

Partially at my suggestion, Vertica has blogged a three-part series explaining the “projections” that are central to a Vertica database. This is important, because in Vertica projections play the roles that in many analytic DBMS might be filled by base tables, indexes, AND materialized views. Highlights include:

The blog posts contain a lot more than that, of course, both rah-rah and technical detail, including reminders of other Vertica advantages (compression, no logging, etc.). If you’re interested in analytic DBMS, they’re worth a look.

Comments

5 Responses to “Vertica projections — an overview”

  1. anonymous on September 18th, 2011 1:43 am

    Is Vertica a client of yours? If so, it may be ethical to state in the article.

  2. Curt Monash on September 18th, 2011 4:26 am

    See the About link at the top of the blog. It links to my latest disclosures.

    Many of the companies I write about are clients, including Vertica.

  3. A data distribution idea at Vertica and Clustrix | DBMS 2 : DataBase Management System Services on July 19th, 2012 5:44 pm

    […] Vertica projections explained at length (September, 2011) Categories: Clustering, Clustrix, Columnar database management, Vertica Systems  Subscribe to our complete feed! […]

  4. Golan on July 21st, 2012 11:48 am

    From my experience with Vertica
    In must cases you need 4-8 projections to run all
    Your queries very fast on a 10-100 columns table
    Don’t listen to others – test it

  5. Curt Monash on July 22nd, 2012 8:53 pm

    Is that 4-8 projections per column? Or is it that some columns need to be duplicated a number of times?

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:

Login

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.