[Berkeley Seminar] Michael Arntzenius (Topos Institute) | A perfect join algorithm? @ToposInstitute
[Berkeley Seminar] Michael Arntzenius (Topos Institute) | A perfect join algorithm?  @ToposInstitute
Uploaded September 2026 | Updated September 2026, 2 weeks ago
Title: A perfect join algorithm? Answering queries in optimal time: Yannakakis’ algorithm
Abstract: If we have a query over some database, how fast can we find all answers for it? If we don’t assume any additional structure (such as indexes on the database), the best possible time is O(IN + OUT): that is, the size of the input (the database) plus the size of the output (the matches for the query). Since we didn’t assume anything about the structure the database is in, any part of it could be relevant, so we have to read the entire database; and by definition we have to write the entire output. Is this achievable? It is, for a particular class of queries: the α-acyclic queries. In this talk I’ll explain how to view queries (and databases) as labelled hypergraphs, define α-acyclicity, and show why and how it allows us to answer queries in linear time using Yannakakis’ algorithm (YA). If I have time, I may: - explain more practical variants on YA such as TreeTrackerJoin - explain the fractional edge cover bound on a query/hypergraph, and how to achieve it using worst-case optimal joins, which handle cyclic queries. - (unlikely) explain further generalizations such as hypertree decompositions of queries.
Date: Aug 4, 2026
[Berkeley Seminar] Michael Arntzenius (Topos Institute) | A perfect join algorithm?Paul-Andre Mellies: The rabbit calculus[Berkeley Seminar] Kevin Carlson | Does it matter whether there are infinite sets?[Berkeley Seminar] Dennis Chen | Cartesian polynomial monads in HoTT[Oxford Seminar] David Corfield | Charles Peirce, inference, and category theory[Berkeley Seminar] Gabriel Goren-Roig | Arboreal coreflections[Oxford Seminar] Virginie Debauche | The Path-Complete Formalism for Switched SystemsFosco Loregian: A double category of transducers[Oxford Seminar] Owen Lynch | An introduction to the geolog projectFabio Gadducci: From gs-monoidal to cartesian categories: a structural analysisJoe Moeller: A categorical approach to Lyapunov stability[2-torial] Categorical algebraic geometry, Part 2
Topos Institute |

[Berkeley Seminar] Michael Arntzenius (Topos Institute) | A perfect join algorithm?

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER