MotherDuck Research

Discover key research materials on MotherDuck's innovations.

Cost-Based Hybrid Query Optimization in MotherDuck
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.

MotherDuck: DuckDB in the Cloud and in the Client
MotherDuck: DuckDB in the Cloud and in the Client
DuckDBHybrid Query ProcessingServerless Analytics

MotherDuck: DuckDB in the Cloud and in the Client

We describe and demo MotherDuck: a new service that connects DuckDB to the cloud. MotherDuck provides the concept of hybrid query processing: the ability to execute queries partly on the client and partly in the cloud.