Opening SingleStore Database Overview
SingleStore Database Overview
- Length
- 1 h 16 min
- Level
- Graduate
- Recorded
- Carnegie Mellon University2023
Chapter 1 of 9: Before the lecture
Chen traces SingleStore's in-memory row store, on-disk column store and per-segment vector indexes.
SingleStore manages mixed workloads through a distributed SQL architecture that combines an in-memory row store with an on-disk column store in a shared-nothing layout. The system uses a background flusher and incremental segment merger to maintain a logarithmic number of sorted runs, supporting both operational point lookups and analytical scans. Full-query code generation compiles execution plans into machine code using LLVM, while adaptive table scans dynamically reorder filters and select access paths. Upcoming vector search capabilities integrate approximate nearest neighbor algorithms directly into the storage and indexing layers, supporting combined queries and hybrid workloads.
SingleStore manages mixed workloads through a distributed SQL architecture that combines an in-memory row store with an on-disk column store in a shared-nothing layout. The system uses a background flusher and incremental segment merger to maintain a logarithmic number of sorted runs, supporting both operational point lookups and analytical scans. Full-query code generation compiles execution plans into machine code using LLVM, while adaptive table scans dynamically reorder filters and select access paths. Upcoming vector search capabilities integrate approximate nearest neighbor algorithms directly into the storage and indexing layers, supporting combined queries and hybrid workloads.
VLDB 2022 Paper

This lecture
Lecture 24 of 24 of Intro to Database Systems.
Choose a node to see how it connects to this lecture. What comes before is on the leftat the top. What comes after is on the rightat the bottom. The ring is what it teaches. People and places are above. Other lectures and books are below.
Press a chosen node again to open it.
Your comment is kept while you sign up.Sign in