Architecture and Implementation of Relational Operators in Distributed SQL Engines

on YouTube ↗46m

" summary

Covers architecture and implementation of relational operators (like joins, aggregations, filters) inside distributed SQL engines, focusing on how these operators are designed and realized across nodes. Discusses engineering challenges and practical techniques used in distributed query execution and operator placement within big-data SQL systems.

AI-written summary · about

" chapters (13)

1. 0:00Introduction
2. 2:09Talk goals
3. 8:05Intermediate query representation
4. 15:31Query optimization in distributed systems
5. 17:18Data distribution and SQL operators
6. 20:09Data scan optimization
7. 24:25Aggregation in distributed systems
8. 27:58Window functions and sorting
9. 30:49JOIN execution strategies
10. 34:40Data sorting and physical properties
11. 38:32Physical-property-based optimization
12. 40:57Summary
13. 41:59Q&A

" related talks

• 50mThe hell of SQL DBs on Kubernetes versus the promise of operatorsD. Donchez, A. Buisine · Kubernetes Community Days France 2023
• 26mNewSQL: concepts, realities and when you should embrace itGargi Ahluwalia · XConf Australia 2022
• 46mDistributed SQL engine in Picodata DBMS: how it works and architectural decisionsEmir Vildanov · HighLoad++ 2024
• 44mNonrelational SQLAndrey Nikolaenko · HighLoad++ 2017
• 27mScaling for Intelligence: Distributed SQL Databases in the Age of AIWei Hu · DevWorld 2026
• 29mModern Database Architecture: From SQL to NoSQL & Distributed SQLAndrei Manakov · Site Reliability Engineering (SRE) 2025
• 01h 20mProblems with Relational Databases in 2020P. Zaytsev, A. Milovidov, A.Borodin, E. Lysenko · Highload fwdays'20
• 48mHow Well Do Relational Database Engines Support JSON?Christian Antognini · Voxxed Days Ticino 2018