filmov
tv
Vertica Live Aggregate Projection
Показать описание
Featuring: Nga Tran, Software Engineer at HP Vertica
Description: Live Aggregate Projections (LAPs) are a new type of projection, introduced in HP Vertica 7.1, that contain one or more columns of data that have been aggregated from a table. The data in a LAP are aggregated at load time, thus querying it is several times faster than applying the aggregation directly on the table.
Unlike other databases which do not support incremental maintenance of non-distributive aggregate functions (e.g. MIN and MAX) for updates and deletes, incremental maintenance is possible in Vertica because the data in LAPs are *partially* aggregated.
This talk focuses on the implementation of Vertica LAPs, for which the current supported aggregate functions are (distributive) SUM, COUNT and (non-distributive) MIN, MAX, and TOP-K. By aggregating data per load on each partition, Vertica allows incremental maintenance on both distributive and non-distributive aggregation while allowing data to be deleted.
Description: Live Aggregate Projections (LAPs) are a new type of projection, introduced in HP Vertica 7.1, that contain one or more columns of data that have been aggregated from a table. The data in a LAP are aggregated at load time, thus querying it is several times faster than applying the aggregation directly on the table.
Unlike other databases which do not support incremental maintenance of non-distributive aggregate functions (e.g. MIN and MAX) for updates and deletes, incremental maintenance is possible in Vertica because the data in LAPs are *partially* aggregated.
This talk focuses on the implementation of Vertica LAPs, for which the current supported aggregate functions are (distributive) SUM, COUNT and (non-distributive) MIN, MAX, and TOP-K. By aggregating data per load on each partition, Vertica allows incremental maintenance on both distributive and non-distributive aggregation while allowing data to be deleted.
0:20:14
Vertica Live Aggregate Projection
0:53:02
The Shortest Path to Vertica – Best Practices for Data Warehouse Migration and ETL
0:12:23
Vertica Overview - Eyecademy Data Training
0:49:33
Tuning vertica performance at scale
0:40:54
Vertica Demo: Getting Started with Vertica in Eon Mode
0:24:39
VERTICA Training – VERTICA Online Training – (VERTICA Certification Tips)– VERTICA Course
0:04:17
Vertica Foundation Series - Topic 5 Query Plan and Execution
0:00:47
Vertica Segmentation and Replication Examples
0:19:58
DBD: An Automated Design Tool for Vertica
0:46:52
Technical overview of Vertica architecture
0:01:17
HP2-N36 - HP Test Vertica Exam Solutions Questions
0:01:21
Databases: Vertica Export configuration
0:11:29
Vertica Accelerator Demo
0:34:09
Wayfair: Cross the streams: Blending real-time and historical datasets from Vertica and MemSQL
0:40:18
Vertica Unify 2022 - Best Practices for Optimizing Vertica Performance
0:29:12
Vertica And Spark: Connecting Computation And Data
0:50:29
Migrating to Vertica strategies and best practices
0:14:52
Vertica Admintools Overview | Vertica Unbox Series | Practical Sessions | EP - 02
0:01:16
SQL : Optimizing a Vertica SQL query to do running totals
0:52:00
Vertica in Eon mode, performance improvements for multi PB scale
0:18:15
Vertica Game Changers: 10 Features That Make Vertica Stand Out From the Pack
0:58:36
Big Data Simplified With HP Vertica
0:01:07
HP VERTICA HADOOP
0:04:25
Vertica Test Drive for Predictive Maintenance
Комментарии