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