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.850379e-05
Overall Rank: 3,997 | 73.21%
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
6,003	Terabyte-Scale Analytics in the Blink of an Eye	2026	VLDB	5.9023799e-05
6,305	Declarative Sub-Operators for Universal Data Processing	2023	VLDB	5.8008469e-05
6,571	Maximus: A Modular Accelerated Query Engine for Data Analytics on Heterogeneous Systems	2025	SIGMOD	5.7278348e-05
6,765	Mitigating the Impedance Mismatch between Prediction Query Execution and Database Engine	2025	SIGMOD	5.6695399e-05
7,983	Excalibur: A Virtual Machine for Adaptive Fine-grained JIT-Compiled Query Execution based on VOILA	2023	VLDB	5.3962907e-05
8,635	The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining	2025	VLDB	5.2832224e-05
9,009	nsDB: Architecting the Next Generation Database by Integrating Neural and Symbolic Systems	2024	VLDB	5.2245336e-05
9,512	Query Compilation Without Regrets	2024	SIGMOD	5.1515819e-05
9,691	BladeDISC: Optimizing Dynamic Shape Machine Learning Workloads via Compiler Approach	2023	SIGMOD	5.1258854e-05
9,833	Raqlet: Cross-Paradigm Compilation for Recursive Queries	2026	CIDR	5.1064323e-05
10,725	InferF: Declarative Factorization of AI/ML Inferences over Joins	2026	SIGMOD	4.9605343e-05
10,794	Scalable GPU Acceleration of Scalar Functions in Analytical Databases: Compilation, Benchmarking, and Optimization	2026	VLDB	4.9605343e-05
10,993	TQP++: Bridging ML Compilers and Analytical Query Processing on GPUs	2026	VLDB	4.9605343e-05
11,002	IMLane: Composable Framework for Efficient AI Function Execution in Database Engine	2026	VLDB	4.9605343e-05
11,107	Future-Proof Data Systems	2026	VLDB	4.9605343e-05
11,222	LingoDB-CT: Understanding LingoDB's Inner Workings	2025	SIGMOD	4.9605343e-05
11,404	Towards Designing Future-Proof Data Processing Systems	2025	VLDB	4.9605343e-05
11,526	Welding Natural Language Queries to Analytics IRs with LLMs	2024	CIDR	4.9605343e-05
11,815	Asymptotically Better Query Optimization Using Indexed Algebra	2023	VLDB	4.9605343e-05
11,829	Big Data Analytic Toolkit: A general-purpose, modular, and heterogeneous acceleration toolkit for data analytical engines	2023	VLDB	4.9605343e-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.00056737487
71	DuckDB: an Embeddable Analytical Database	2019	SIGMOD	0.00037688945
215	Morsel-Driven Parallelism: A NUMA-Aware Query Evaluation Framework for the Many-Core Age	2014	SIGMOD	0.00024554257
226	Amazon Redshift and the Case for Simpler Data Warehouses	2015	SIGMOD	0.0002389883
375	Umbra: A Disk-Based System with In-Memory Performance	2020	CIDR	0.00019660459
498	Building Efficient Query Engines in a High-Level Language	2014	VLDB	0.00017323427
881	Dynamic Programming Strikes Back	2008	SIGMOD	0.0001324243
1,197	Weld: A Common Runtime for High Performance Data Analytics	2017	CIDR	0.00011548039
1,350	Relaxed Operator Fusion for In-Memory Databases: Making Compilation, Vectorization, and Prefetching Work Together At Last	2018	VLDB	0.00010934877
1,475	Voodoo - A Vector Algebra for Portable Database Performance on Modern Hardware	2016	VLDB	0.00010525713
1,756	How to Architect a Query Compiler	2016	SIGMOD	9.7053947e-05
2,199	Extending Relational Query Processing with ML Inference	2020	CIDR	8.8664379e-05
2,433	How to Architect a Query Compiler, Revisited	2018	SIGMOD	8.4614165e-05
5,787	Database Technology for the Masses: Sub-Operators as First-Class Entities	2021	VLDB	5.9768075e-05
7,887	Building Advanced SQL Analytics From Low-Level Plan Operators	2021	SIGMOD	5.4162508e-05

Semantically Similar Papers

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