Improving Dashboard Performance, Achieving Fine-Grained Analytics with Vertica

Logo
Presented by

Yuanzhe Bei and Jie Guo, Vertica

About this talk

There are two popular ways that organizations mine growing volumes of data for insight: short-term dashboard reporting and long-term analytics. Every organization would like their dashboards on recent data to be faster in addition to keeping data longer so that data analytics can derive more insightful, granular results. Join us for this Webcast to understand how Vertica can help you achieve both of these goals with these powerful features – Hierarchical Partitioning, Flattened Tables, and Live Aggregate Projections. Discover how Hierarchical Partitioning combines old data partitions into larger files, allowing you to retain more data without bloating the catalog or forcing partitions to be less fine-grained. The former benefits data analytics, while the latter helps with dashboard reporting, as more fine-grained partitions help with pruning data more aggressively, resulting in faster query performance and less resource usage. You’ll also learn how Flattened Tables provides convenient and faster data denormalization for your dashboard queries and optimizes resources more efficiently by avoiding joins. The unique column-wise refresh mechanism can defer denormalization operation after your ETL process without introducing much overhead. Finally, learn how Live Aggregate Projections materializes partially aggregated results to speed up those aggregation-type analytical queries.

Related topics:

More from this channel

Upcoming talks (2)
On-demand talks (158)
Subscribers (36597)
The Vertica Unified Analytics Platform is built to handle the most demanding analytic use cases and is trusted by thousands of leading data-driven enterprises around the world, including Etsy, Bank of America, Uber, and more. Based on a massively scalable architecture with a broad set of analytical functions spanning event and time series, pattern matching, geospatial, and built-in machine learning capability, Vertica enables data analytics teams to easily apply these powerful functions to large and demanding analytical workloads. Vertica unites the major public clouds and on-premises data centers, as needed, and integrates data in cloud object storage and HDFS without forcing any data movement. Available as a SaaS option, or as a customer-managed system, Vertica helps teams combine growing data siloes for a more complete view of available data. Vertica features separation of compute and storage, so teams can spin up storage and compute resources as needed, then spin down afterwards to reduce costs.