MotherDuck Research

Advancing the future of data + AI.

Declarative Caching in MotherDuck
Declarative Caching in MotherDuck
Data AppsDuckDBHybrid Query ProcessingQuery Optimization

Declarative Caching in MotherDuck

This thesis introduces Accelerated Approximate Views — a new SQL-level caching mechanism for MotherDuck’s hybrid execution model. By partially materializing query results on the client, AAVs reduce latency for interactive data exploration in both native and WebAssembly environments.