Diving Deep into Sensor Data with TimescaleDB | Episode #2: Data Processing with Hierarchical CAGGs

Published: 27 March 2024
on channel: Timescale
355
7

Timescale Community Templates is a webinar series dedicated to specific industries and designed to foster collaboration and expertise exchange. In this session, Timescale Developer Advocate, Jônatas Paganini, will take a deep dive into data processing with hierarchical continuous aggregates (Timescale’s supercharged version of Posgres materialized views). This session will explore strategies for managing and analyzing sensor data more effectively, allowing for faster insights.

📹 Other Sensor Data Sessions:
✨ Episode 1 - Creating a Sensor Data Pipeline ⇒    • Diving Deep into Sensor Data with Tim...  
✨ Episode 2 - Data processing with Hierarchical continuous aggregates ⇒ (current)
✨ Episode 3 - Query performance and Downsampling techniques ⇒ https://lu.ma/1e0fvk8z
✨ Episode 4 - Policies for Compression and Retention ⇒ https://lu.ma/dqu4zna7

🛠 𝗥𝗲𝗹𝗲𝘃𝗮𝗻𝘁 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀
📌 More on Timescale Community Templates ⇒ https://tsdb.co/templates-blog
📌 GitHub Templates ⇒ https://github.com/timescale/templates
📌 Office Hours ⇒ https://tsdb.co/officehours

🐯 𝗔𝗯𝗼𝘂𝘁 𝗧𝗶𝗺𝗲𝘀𝗰𝗮𝗹𝗲
At Timescale, we see a world made better via innovative technologies, and we are dedicated to serving software developers and businesses worldwide, enabling them to build the next wave of computing. Timescale is a remote-first company with a global workforce backed by top-tier investors with a track record of success in the industry.

💻 𝗙𝗶𝗻𝗱 𝗨𝘀 𝗢𝗻𝗹𝗶𝗻𝗲!
🔍 Website ⇒ https://tsdb.co/website
🔍 Slack ⇒ https://slack.timescale.com (#discussion-sensors)
🔍 GitHub ⇒ https://github.com/timescale
🔍 Twitter ⇒   / timescaledb  
🔍 LinkedIn ⇒   / timescaledb  
🔍 Timescale Blog ⇒ https://tsdb.co/blogs
🔍 Timescale Documentation ⇒ https://tsdb.co/doc

📚 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀
⏱ 0:00 ⇒ Introduction
⏱ 2:13 ⇒ Configuration to start
⏱ 7:57 ⇒ Hierarchical Continuous Aggregation Overview
⏱ 8:50 ⇒ Part 1: Interval & Granularity
⏱ 12:28 ⇒ Part 2: Watermarks
⏱ 18:48 ⇒ Part 3: Invalidation Logs
⏱ 22:53 ⇒ Part 4: Materialized-only strategies (Demo)
⏱ 28:45 ⇒ Part 5: Toolkit Aggregations
⏱ 33:22 ⇒ Part 5: Retention Policies
⏱ 34:26⇒ Part 6: Compression Policies
⏱ 35:25⇒ Q&A (includes Hierarchical CAGGs tip)
⏱ 38:05 ⇒ Outro


Watch video Diving Deep into Sensor Data with TimescaleDB | Episode #2: Data Processing with Hierarchical CAGGs online without registration, duration hours minute second in high quality. This video was added by user Timescale 27 March 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 35 once and liked it people.