Vertica Blog

Vertica Blog

LAP

A key with a key hole and Unlock Vertica Potential in text at the bottom

How to Use UDx to Extend Vertica Live Aggregate Projections

Maurizio Felici, Field Chief Technologist
August 8, 2023

Thanks to its sophisticated optimizer and extremely efficient query engine Vertica can process data aggregations order of magnitudes faster than traditional Database Management Systems. To further boost data aggregation performance, we can use Vertica’s Live Aggregate Projections (LAP from now on). The concept is very simple: pre-aggregate data once during load operations rather than doing...
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...

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.