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.8697828e-05
Overall Rank: 3,986 | 73.22%
DOI: 10.14778/3551793.3551801
PDF: Download (CC BY-NC-ND 4.0)

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.9219616e-05
6,301	Declarative Sub-Operators for Universal Data Processing	2023	VLDB	5.8167709e-05
6,589	Maximus: A Modular Accelerated Query Engine for Data Analytics on Heterogeneous Systems	2025	SIGMOD	5.7401837e-05
6,747	Mitigating the Impedance Mismatch between Prediction Query Execution and Database Engine	2025	SIGMOD	5.6883491e-05
7,966	Excalibur: A Virtual Machine for Adaptive Fine-grained JIT-Compiled Query Execution based on VOILA	2023	VLDB	5.4141361e-05
8,990	nsDB: Architecting the Next Generation Database by Integrating Neural and Symbolic Systems	2024	VLDB	5.2418665e-05
9,483	Query Compilation Without Regrets	2024	SIGMOD	5.1686727e-05
9,596	The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining	2025	VLDB	5.1543679e-05
9,663	BladeDISC: Optimizing Dynamic Shape Machine Learning Workloads via Compiler Approach	2023	SIGMOD	5.142891e-05
9,800	Raqlet: Cross-Paradigm Compilation for Recursive Queries	2026	CIDR	5.1233734e-05
10,664	InferF: Declarative Factorization of AI/ML Inferences over Joins	2026	SIGMOD	4.9769913e-05
10,733	Scalable GPU Acceleration of Scalar Functions in Analytical Databases: Compilation, Benchmarking, and Optimization	2026	VLDB	4.9769913e-05
10,932	TQP++: Bridging ML Compilers and Analytical Query Processing on GPUs	2026	VLDB	4.9769913e-05
10,941	IMLane: Composable Framework for Efficient AI Function Execution in Database Engine	2026	VLDB	4.9769913e-05
11,046	Future-Proof Data Systems	2026	VLDB	4.9769913e-05
11,163	LingoDB-CT: Understanding LingoDB's Inner Workings	2025	SIGMOD	4.9769913e-05
11,351	Towards Designing Future-Proof Data Processing Systems	2025	VLDB	4.9769913e-05
11,474	Welding Natural Language Queries to Analytics IRs with LLMs	2024	CIDR	4.9769913e-05
11,771	Asymptotically Better Query Optimization Using Indexed Algebra	2023	VLDB	4.9769913e-05
11,785	Big Data Analytic Toolkit: A general-purpose, modular, and heterogeneous acceleration toolkit for data analytical engines	2023	VLDB	4.9769913e-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.00056835296
71	DuckDB: an Embeddable Analytical Database	2019	SIGMOD	0.00037724477
215	Morsel-Driven Parallelism: A NUMA-Aware Query Evaluation Framework for the Many-Core Age	2014	SIGMOD	0.00024589307
233	Amazon Redshift and the Case for Simpler Data Warehouses	2015	SIGMOD	0.00023774958
373	Umbra: A Disk-Based System with In-Memory Performance	2020	CIDR	0.00019705706
495	Building Efficient Query Engines in a High-Level Language	2014	VLDB	0.00017363171
883	Dynamic Programming Strikes Back	2008	SIGMOD	0.00013263866
1,193	Weld: A Common Runtime for High Performance Data Analytics	2017	CIDR	0.00011582619
1,341	Relaxed Operator Fusion for In-Memory Databases: Making Compilation, Vectorization, and Prefetching Work Together At Last	2018	VLDB	0.00010963427
1,473	Voodoo - A Vector Algebra for Portable Database Performance on Modern Hardware	2016	VLDB	0.00010552993
1,744	How to Architect a Query Compiler	2016	SIGMOD	9.7332903e-05
2,184	Extending Relational Query Processing with ML Inference	2020	CIDR	8.8953085e-05
2,420	How to Architect a Query Compiler, Revisited	2018	SIGMOD	8.4883426e-05
5,772	Database Technology for the Masses: Sub-Operators as First-Class Entities	2021	VLDB	5.9964298e-05
7,871	Building Advanced SQL Analytics From Low-Level Plan Operators	2021	SIGMOD	5.434014e-05

Semantically Similar Papers

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