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: h9657cfd09a3c842b
Venue: VLDB
Year: 2022
Pagerank: 6.8730085e-05
Overall Rank: 3,985 | 73.21%
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 20 of 20 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
5,991	Terabyte-Scale Analytics in the Blink of an Eye	2026	VLDB	5.9247663e-05
6,296	Declarative Sub-Operators for Universal Data Processing	2023	VLDB	5.8195258e-05
6,587	Maximus: A Modular Accelerated Query Engine for Data Analytics on Heterogeneous Systems	2025	SIGMOD	5.7429023e-05
6,742	Mitigating the Impedance Mismatch between Prediction Query Execution and Database Engine	2025	SIGMOD	5.6910432e-05
7,962	Excalibur: A Virtual Machine for Adaptive Fine-grained JIT-Compiled Query Execution based on VOILA	2023	VLDB	5.4167003e-05
8,984	nsDB: Architecting the Next Generation Database by Integrating Neural and Symbolic Systems	2024	VLDB	5.2433452e-05
9,472	Query Compilation Without Regrets	2024	SIGMOD	5.1711207e-05
9,588	The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining	2025	VLDB	5.156809e-05
9,656	BladeDISC: Optimizing Dynamic Shape Machine Learning Workloads via Compiler Approach	2023	SIGMOD	5.1453267e-05
9,794	Raqlet: Cross-Paradigm Compilation for Recursive Queries	2026	CIDR	5.1257999e-05
10,653	InferF: Declarative Factorization of AI/ML Inferences over Joins	2026	SIGMOD	4.9793485e-05
10,723	Scalable GPU Acceleration of Scalar Functions in Analytical Databases: Compilation, Benchmarking, and Optimization	2026	VLDB	4.9793485e-05
10,923	TQP++: Bridging ML Compilers and Analytical Query Processing on GPUs	2026	VLDB	4.9793485e-05
10,932	IMLane: Composable Framework for Efficient AI Function Execution in Database Engine	2026	VLDB	4.9793485e-05
11,037	Future-Proof Data Systems	2026	VLDB	4.9793485e-05
11,154	LingoDB-CT: Understanding LingoDB's Inner Workings	2025	SIGMOD	4.9793485e-05
11,344	Towards Designing Future-Proof Data Processing Systems	2025	VLDB	4.9793485e-05
11,468	Welding Natural Language Queries to Analytics IRs with LLMs	2024	CIDR	4.9793485e-05
11,765	Asymptotically Better Query Optimization Using Indexed Algebra	2023	VLDB	4.9793485e-05
11,779	Big Data Analytic Toolkit: A general-purpose, modular, and heterogeneous acceleration toolkit for data analytical engines	2023	VLDB	4.9793485e-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
21	Efficiently Compiling Efficient Query Plans for Modern Hardware	2011	VLDB	0.00056855599
71	DuckDB: an Embeddable Analytical Database	2019	SIGMOD	0.00037720227
215	Morsel-Driven Parallelism: A NUMA-Aware Query Evaluation Framework for the Many-Core Age	2014	SIGMOD	0.00024598661
233	Amazon Redshift and the Case for Simpler Data Warehouses	2015	SIGMOD	0.00023783585
373	Umbra: A Disk-Based System with In-Memory Performance	2020	CIDR	0.00019711632
495	Building Efficient Query Engines in a High-Level Language	2014	VLDB	0.00017370758
884	Dynamic Programming Strikes Back	2008	SIGMOD	0.00013267935
1,193	Weld: A Common Runtime for High Performance Data Analytics	2017	CIDR	0.0001158809
1,341	Relaxed Operator Fusion for In-Memory Databases: Making Compilation, Vectorization, and Prefetching Work Together At Last	2018	VLDB	0.00010968512
1,473	Voodoo - A Vector Algebra for Portable Database Performance on Modern Hardware	2016	VLDB	0.00010557973
1,742	How to Architect a Query Compiler	2016	SIGMOD	9.7378418e-05
2,182	Extending Relational Query Processing with ML Inference	2020	CIDR	8.8982998e-05
2,419	How to Architect a Query Compiler, Revisited	2018	SIGMOD	8.4923505e-05
5,771	Database Technology for the Masses: Sub-Operators as First-Class Entities	2021	VLDB	5.9992698e-05
7,866	Building Advanced SQL Analytics From Low-Level Plan Operators	2021	SIGMOD	5.4365876e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	4,525	Just-in-time compilation for SQL query processing	2013	VLDB
2	11,037	Future-Proof Data Systems	2026	VLDB
3	5,455	Evolution of a Compiling Query Engine	2021	VLDB
4	21	Efficiently Compiling Efficient Query Plans for Modern Hardware	2011	VLDB
5	8,207	Architecting a Query Compiler for Spatial Workloads	2020	SIGMOD
6	2,419	How to Architect a Query Compiler, Revisited	2018	SIGMOD
7	11,154	LingoDB-CT: Understanding LingoDB's Inner Workings	2025	SIGMOD
8	8,673	Adaptive Code Generation for Data-Intensive Analytics	2021	VLDB
9	495	Building Efficient Query Engines in a High-Level Language	2014	VLDB
10	1,742	How to Architect a Query Compiler	2016	SIGMOD