To content
Department of Computer Science
Publication at VLDB 2021

Low-Latency Compilation of SQL Queries to Machine Code

Title

Low-Latency Compilation of SQL Queries to Machine Code

Authors

Henning Funke and Jens Teubner

Published

Proceedings of the VLDB Endowment, Volume 14, Issue 12, Pages 2691–2694.

Abstract

Query compilation has proven to be one of the most efficient query processing techniques. Despite its fast processing speed, the additional compilation times of the technique limit its applicability. This is because the approach is most beneficial only when the improvements in processing time clearly exceed the additional compilation time.


Recently the feasibility of query compilers with very low compilation times has been shown. This may prove query compilation as a merely universal approach. In this article and in the corresponding live demo, we show the capabilities of the ReSQL database system, which uses the intermediate representation Flounder IR to achieve very low compilation times. ReSQL reduces the compilation times from SQL to machine code compared to existing LLVM-based techniques by up to 101.1x for real-world analytic queries

Download

via VLDB