Sign inSign in
ConceptSystems & CS

Semi joins

A join operation where the result only contains columns from the left table, used in distributed DBMSs to minimize the amount of data sent over the network.
as Andy Pavlo defines itCarnegie Mellon University
Watch it explained

Know first

Named as a prerequisite by the lectures that define this. The number is how many say so. A grey one has no page yet.

Database joins1Join1Projection pushdown1SQL queries1

Lecturers

2

Each in their own terms, from the easiest level.

  • Tyler Cloutier

    Carnegie Mellon University · Graduate

    Filtering on a table where you are always querying a table.
    • 41:07SpacetimeDB: Inverting the Backend - Why We Built Our MMORPG Inside a Database

Connections

4

The lectures that define it or assume it, and the concepts next to it.

2 lecturers. Definitions are written by AI from each lecture’s transcript. A time with a play mark starts the lecture at the moment the lecturer says it.