Designing an Open Framework for Query Optimization and Compilation

Summary: Proposes an open, MLIR-based layered query compilation stack with interoperable IRs, enabling flexible, cross-layer optimization for data-centric code generation. LingoDB demonstrates reduced implementation effort, high performance, and low compilation latency by moving optimization into the compiler and supporting cross-domain optimization. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 12919
Venue: VLDB
Year: 2022
Pagerank: 6.8275676e-05
Overall Rank: 4,215 | 71.09%
DOI: 10.14778/3551793.3551801

Incoming Non-self Citations Over Time

Authors

1. Michael Jungmair (Technical University of Munich)
2. André Kohn (Technical University of Munich)
3. Jana Giceva (Technical University of Munich)

BibTeX Citation

@article{jungmair_vldb22,
        title = {{Designing an Open Framework for Query Optimization and Compilation}},
        author = {Jungmair, Michael and Kohn, André and Giceva, Jana},
        journal = {PVLDB},
        series = {{VLDB} '22},
        volume = {15},
        number = {11},
        pages = {2389--2401},
        doi = {10.14778/3551793.3551801},
        url = {https://doi.org/10.14778/3551793.3551801},
        year = {2022}
}

Incoming Citations (Sorted by Pagerank)

Showing 17 of 17 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
6,253	Declarative Sub-Operators for Universal Data Processing	2023	VLDB	5.940599e-05
6,614	Mitigating the Impedance Mismatch between Prediction Query Execution and Database Engine	2025	SIGMOD	5.8216658e-05
7,959	Terabyte-Scale Analytics in the Blink of an Eye	2026	VLDB	5.5181056e-05
8,053	Maximus: A Modular Accelerated Query Engine for Data Analytics on Heterogeneous Systems	2025	SIGMOD	5.4990605e-05
8,368	Excalibur: A Virtual Machine for Adaptive Fine-grained JIT-Compiled Query Execution based on VOILA	2023	VLDB	5.4419148e-05
8,716	nsDB: Architecting the Next Generation Database by Integrating Neural and Symbolic Systems	2024	VLDB	5.3776746e-05
9,415	The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining	2025	VLDB	5.2742285e-05
9,475	BladeDISC: Optimizing Dynamic Shape Machine Learning Workloads via Compiler Approach	2023	SIGMOD	5.2634238e-05
10,072	Query Compilation Without Regrets	2024	SIGMOD	5.1624689e-05
10,143	Raqlet: Cross-Paradigm Compilation for Recursive Queries	2026	CIDR	5.093636e-05
10,466	InferF: Declarative Factorization of AI/ML Inferences over Joins	2026	SIGMOD	5.093636e-05
10,541	Scalable GPU Acceleration of Scalar Functions in Analytical Databases: Compilation, Benchmarking, and Optimization	2026	VLDB	5.093636e-05
10,723	LingoDB-CT: Understanding LingoDB's Inner Workings	2025	SIGMOD	5.093636e-05
10,957	Towards Designing Future-Proof Data Processing Systems	2025	VLDB	5.093636e-05
11,120	Welding Natural Language Queries to Analytics IRs with LLMs	2024	CIDR	5.093636e-05
11,453	Asymptotically Better Query Optimization Using Indexed Algebra	2023	VLDB	5.093636e-05
11,468	Big Data Analytic Toolkit: A general-purpose, modular, and heterogeneous acceleration toolkit for data analytical engines	2023	VLDB	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 15 of 15 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
23	Efficiently Compiling Efficient Query Plans for Modern Hardware	2011	VLDB	0.00054886415
103	DuckDB: an Embeddable Analytical Database	2019	SIGMOD	0.00034161428
237	Amazon Redshift and the Case for Simpler Data Warehouses	2015	SIGMOD	0.0002369895
241	Morsel-Driven Parallelism: A NUMA-Aware Query Evaluation Framework for the Many-Core Age	2014	SIGMOD	0.00023654664
422	Umbra: A Disk-Based System with In-Memory Performance	2020	CIDR	0.00018732744
534	Building Efficient Query Engines in a High-Level Language	2014	VLDB	0.00017046514
1,013	Dynamic Programming Strikes Back	2008	SIGMOD	0.00012652549
1,229	Weld: A Common Runtime for High Performance Data Analytics	2017	CIDR	0.00011578425
1,379	Relaxed Operator Fusion for In-Memory Databases: Making Compilation, Vectorization, and Prefetching Work Together At Last	2018	VLDB	0.00010970894
1,469	Voodoo - A Vector Algebra for Portable Database Performance on Modern Hardware	2016	VLDB	0.00010678751
1,797	How to Architect a Query Compiler	2016	SIGMOD	9.7368925e-05
2,293	Extending Relational Query Processing with ML Inference	2020	CIDR	8.7949378e-05
2,488	How to Architect a Query Compiler, Revisited	2018	SIGMOD	8.5091578e-05
6,263	Database Technology for the Masses: Sub-Operators as First-Class Entities	2021	VLDB	5.936052e-05
7,774	Building Advanced SQL Analytics From Low-Level Plan Operators	2021	SIGMOD	5.5468469e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	13,040	Investigation of Algebraic Query Optimisation for Database Programming Languages	1994	VLDB
2	4,452	Just-in-time compilation for SQL query processing	2013	VLDB
3	5,376	Evolution of a Compiling Query Engine	2021	VLDB
4	23	Efficiently Compiling Efficient Query Plans for Modern Hardware	2011	VLDB
5	8,057	Architecting a Query Compiler for Spatial Workloads	2020	SIGMOD
6	2,488	How to Architect a Query Compiler, Revisited	2018	SIGMOD
7	10,723	LingoDB-CT: Understanding LingoDB's Inner Workings	2025	SIGMOD
8	8,636	Adaptive Code Generation for Data-Intensive Analytics	2021	VLDB
9	534	Building Efficient Query Engines in a High-Level Language	2014	VLDB
10	1,797	How to Architect a Query Compiler	2016	SIGMOD