MotherDuck Research
Advancing the future of data + AI.
Cost-Based Hybrid Query Optimization in MotherDuck
Cost-Based OptimizationDuckDBHybrid Query ProcessingQuery Optimization
Cost-Based Hybrid Query Optimization in MotherDuck
This thesis tackles a core challenge in MotherDuck's hybrid execution model: deciding which parts of a query should run locally vs. in the cloud. The result is a cost-based optimizer that delivers up to 17x speedups on long-running analytical queries.
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.
