GenDB: The Next Generation of Query Processing -- Synthesized, Not Engineered
Jiale Lao, Immanuel Trummer

TL;DR
GenDB leverages Large Language Models to synthesize customized query execution code, enabling adaptable and high-performance query processing that surpasses traditional engines in specific workloads.
Contribution
This paper introduces GenDB, a novel LLM-powered system that synthesizes query execution code dynamically, reducing engineering complexity and improving performance over existing query engines.
Findings
GenDB outperforms state-of-the-art query engines on OLAP workloads.
The system effectively tailors execution code to specific data and hardware.
Early prototype demonstrates significant performance improvements.
Abstract
Traditional query processing relies on engines that are carefully optimized and engineered by many experts. However, new techniques and user requirements evolve rapidly, and existing systems often cannot keep pace. At the same time, these systems are difficult to extend due to their internal complexity, and developing new systems requires substantial engineering effort and cost. In this paper, we argue that recent advances in Large Language Models (LLMs) are starting to shape the next generation of query processing systems. We propose using LLMs to synthesize execution code for each incoming query, instead of continuously building, extending, and maintaining complex query processing engines. As a proof of concept, we present GenDB, an LLM-powered agentic system that generates instance-optimized and customized query execution code tailored to specific data, workloads, and hardware…
Peer Reviews
No public reviews on file for this paper yet. If you reviewed it on a platform where reviews are public (OpenReview, ICLR, NeurIPS, ICML), you can paste yours below so the community can read it here.
Videos
No videos yet. Explain this paper in a talk, walkthrough, or lecture? Add one.
Taxonomy
TopicsAdvanced Database Systems and Queries · Semantic Web and Ontologies · Graph Theory and Algorithms
