Distributed SQL engine in Picodata DBMS: how it works and architectural decisions

on YouTube ↗46m

" summary

An overview of Picodata’s distributed SQL query engine: it explains how the engine executes SQL queries across large distributed data volumes, describes its architectural decisions and components, and discusses the technologies used to implement distributed query planning and execution in the Picodata DBMS.

AI-written summary · about

" chapters (10)

1. 0:00Picodata intro
2. 1:07SQL in cluster
3. 3:38Query stages
4. 8:21Data buckets
5. 12:12Complex joins
6. 15:08Query planning
7. 20:49Global tables & Raft
8. 26:10Other solutions
9. 31:30When to use Picodata
10. 32:33Q&A

" related talks

• 47mDistributed high-load BI engine for Google Data Studio and Microsoft Power BIA.Serbul · Saint HighLoad++ 2022
• 27mScaling for Intelligence: Distributed SQL Databases in the Age of AIWei Hu · DevWorld 2026
• 24mPinterest’s Exploration of Distributed SQLLianghong Xu · Distributed SQL Summit 2020
• 46mArchitecture and Implementation of Relational Operators in Distributed SQL EnginesVladimir Ozerov · Big Data Days 2021
• 29mModern Database Architecture: From SQL to NoSQL & Distributed SQLAndrei Manakov · Site Reliability Engineering (SRE) 2025
• 26mNewSQL: concepts, realities and when you should embrace itGargi Ahluwalia · XConf Australia 2022
• 47mAnatomy of a Distributed SQL Database - YugabyteDBFranck Pachot · Devoxx France 2022
• 24mTech Roundtable: Distributed SQL Around the WorldTim Faulkes, David Walker, Dai Clegg, Vish Phaneendra · Distributed SQL Summit 2022