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.

Towards Efficient Data Wrangling with LLMs using Code Generation
Towards Efficient Data Wrangling with LLMs using Code Generation
Code GenerationData TransformationData WranglingEntity MatchingLLMMotherDuck

Towards Efficient Data Wrangling with LLMs using Code Generation

Instead of applying LLMs to every row, generate code once and run it on millions of rows. Up to 37-point F1 improvement on data transformations at a fraction of the cost.

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.