Just-in-time compilation for SQL query processing
Summary: Examines JIT compilation of SQL queries into native code as a competitive alternative to interpretation across the full query processing stack. Frames the approach with compiler-tech analogies, surveys the design space, and outlines open data-management research questions for runtime code generation. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Stratis D. Viglas (University of Edinburgh)
BibTeX Citation
@article{viglas_vldb13,
title = {{Just-in-time compilation for SQL query processing}},
author = {Viglas, Stratis D.},
journal = {PVLDB},
series = {{VLDB} '13},
volume = {6},
number = {11},
pages = {1190--1193},
doi = {10.14778/2536222.2536225},
url = {https://doi.org/10.14778/2536222.2536225},
year = {2013}
}Incoming Citations (Sorted by Pagerank)
Showing 6 of 6 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,379 | Relaxed Operator Fusion for In-Memory Databases: Making Compilation, Vectorization, and Prefetching Work Together At Last | 2018 | VLDB | 0.00010970894 |
| 1,892 | Procedural Extensions of SQL: Understanding their usage in the wild | 2021 | VLDB | 9.5277793e-05 |
| 5,000 | Permutable Compiled Queries: Dynamically Adapting Compiled Queries without Recompiling | 2021 | VLDB | 6.4069917e-05 |
| 6,714 | Towards Unified Ad-hoc Data Processing | 2014 | SIGMOD | 5.7959651e-05 |
| 8,072 | Operational Analytics Data Management Systems | 2016 | VLDB | 5.4933919e-05 |
| 8,967 | One Loop Does Not Fit All | 2015 | SIGMOD | 5.3429745e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 9 of 9 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 |
| 153 | Common Expression Analysis in Database Applications | 1982 | SIGMOD | 0.00029032276 |
| 943 | DynaMat: A Dynamic View Management System for Data Warehouses | 1999 | SIGMOD | 0.00013068595 |
| 1,197 | Daytona And The Fourth-Generation Language Cymbal | 1999 | SIGMOD | 0.00011712263 |
| 1,517 | Building a Scalable Geo-Spatial DBMS: Technology, Implementation, and Evaluation | 1997 | SIGMOD | 0.00010520118 |
| 2,151 | An Architecture for Recycling Intermediates in a Column-store | 2009 | SIGMOD | 9.0784444e-05 |
| 4,137 | Optimizing I/O for Big Array Analytics | 2012 | VLDB | 6.8783832e-05 |
| 4,574 | Translating Aggregate Queries into Iterative Programs | 1986 | VLDB | 6.6223845e-05 |
| 8,625 | QPPT: Query Processing on Prefix Trees | 2013 | CIDR | 5.3979222e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 10,072 | Query Compilation Without Regrets | 2024 | SIGMOD |
| 2 | 2,488 | How to Architect a Query Compiler, Revisited | 2018 | SIGMOD |
| 3 | 11,708 | Low-Latency Compilation of SQL Queries to Machine Code | 2021 | VLDB |
| 4 | 8,636 | Adaptive Code Generation for Data-Intensive Analytics | 2021 | VLDB |
| 5 | 11,361 | Predicting Query Execution time for JIT Compiled Database Engines | 2023 | CIDR |
| 6 | 10,040 | SQL Engines Excel at the Execution of Imperative Programs | 2024 | VLDB |
| 7 | 10,008 | Towards Unifying Query Interpretation and Compilation | 2023 | CIDR |
| 8 | 5,000 | Permutable Compiled Queries: Dynamically Adapting Compiled Queries without Recompiling | 2021 | VLDB |
| 9 | 5,376 | Evolution of a Compiling Query Engine | 2021 | VLDB |
| 10 | 1,797 | How to Architect a Query Compiler | 2016 | SIGMOD |