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,341 | Relaxed Operator Fusion for In-Memory Databases: Making Compilation, Vectorization, and Prefetching Work Together At Last | 2018 | VLDB | 0.00010968512 |
| 1,786 | Procedural Extensions of SQL: Understanding their usage in the wild | 2021 | VLDB | 9.6326265e-05 |
| 4,793 | Permutable Compiled Queries: Dynamically Adapting Compiled Queries without Recompiling | 2021 | VLDB | 6.4127583e-05 |
| 6,840 | Towards Unified Ad-hoc Data Processing | 2014 | SIGMOD | 5.6669233e-05 |
| 8,228 | Operational Analytics Data Management Systems | 2016 | VLDB | 5.3736562e-05 |
| 9,063 | One Loop Does Not Fit All | 2015 | SIGMOD | 5.2286328e-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 |
|---|---|---|---|---|
| 21 | Efficiently Compiling Efficient Query Plans for Modern Hardware | 2011 | VLDB | 0.00056855599 |
| 155 | Common Expression Analysis in Database Applications | 1982 | SIGMOD | 0.00028527932 |
| 949 | DynaMat: A Dynamic View Management System for Data Warehouses | 1999 | SIGMOD | 0.00012902181 |
| 1,196 | Daytona And The Fourth-Generation Language Cymbal | 1999 | SIGMOD | 0.00011572943 |
| 1,546 | Building a Scalable Geo-Spatial DBMS: Technology, Implementation, and Evaluation | 1997 | SIGMOD | 0.00010294163 |
| 2,084 | An Architecture for Recycling Intermediates in a Column-store | 2009 | SIGMOD | 9.0716512e-05 |
| 4,212 | Optimizing I/O for Big Array Analytics | 2012 | VLDB | 6.7298655e-05 |
| 4,653 | Translating Aggregate Queries into Iterative Programs | 1986 | VLDB | 6.4850138e-05 |
| 8,780 | QPPT: Query Processing on Prefix Trees | 2013 | CIDR | 5.2776055e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 9,472 | Query Compilation Without Regrets | 2024 | SIGMOD |
| 2 | 2,419 | How to Architect a Query Compiler, Revisited | 2018 | SIGMOD |
| 3 | 12,012 | Low-Latency Compilation of SQL Queries to Machine Code | 2021 | VLDB |
| 4 | 8,673 | Adaptive Code Generation for Data-Intensive Analytics | 2021 | VLDB |
| 5 | 11,677 | Predicting Query Execution time for JIT Compiled Database Engines | 2023 | CIDR |
| 6 | 10,223 | SQL Engines Excel at the Execution of Imperative Programs | 2024 | VLDB |
| 7 | 10,193 | Towards Unifying Query Interpretation and Compilation | 2023 | CIDR |
| 8 | 4,793 | Permutable Compiled Queries: Dynamically Adapting Compiled Queries without Recompiling | 2021 | VLDB |
| 9 | 5,455 | Evolution of a Compiling Query Engine | 2021 | VLDB |
| 10 | 1,742 | How to Architect a Query Compiler | 2016 | SIGMOD |