Vertica Blog

Vertica Blog

Projections

Programmer

Improving COUNT DISTINCT Performance with Live Aggregate Projections

HPBigData_BP
February 17, 2016

Today?s organizations need to be able to measure the effectiveness of online ads and marketing campaigns. In your particular organization, you may want to measure how effectively your ads drive unique visitors to your website. Or you may want to see if your ads drive repeat visits from the same user over a specific period...

Best Practices for Refreshing Large Projections

Sarah Lemaire, Manager, Vertica Documentation
May 27, 2015

More than once I have worked with customers who need to update a superprojection or create a new projection for a large fact table. It seems like a simple and easy process: just create a projection and perform a refresh. However, refreshing projections for large fact tables can produce unwanted complications. In this blog, we?ll...

Tech Support Series: Optimizing Projections

Sarah Lemaire, Manager, Vertica Documentation
December 10, 2014

Welcome to another installment of our Top Tech Support Questions Answered blog series. In our first

Live Aggregate Projections with Vertica

Steve Sarsfield, Vertica Senior Product Marketing Manager – Partner Ecosystem
July 1, 2014

The Dragline release of Vertica offers an exciting new feature that is unique in the world of big data analytics platforms. We now offer Live Aggregate projections as part of the platform. The impact is that you can really fly through certain types of big data analytics that typically grind down any analytics system.