An Empirical Analysis of Just-in-Time Compilation in Modern Databases

RAIDS Lab Authors

Zhengyi Yang

(corresponding author)

Director

Details

Research Area

Tags

Resources

Abstract

JIT (Just-in-Time) technology has garnered significant attention for improving the efficiency of database execution. It offers higher performance by eliminating interpretation overhead compared to traditional execution engines. LLVM serves as the primary JIT architecture, which was implemented in PostgreSQL since version 11. However, recent advancements in WASM-based databases, such as Mutable, present an alternative JIT approach. This approach minimizes the extensive engineering efforts associated with the execution engine and focuses on optimizing supported operators for lower latency and higher throughput. In this paper, we perform comprehensive experiments on the twoes representative open-source databases to gain deeper insights into the effectiveness of different JIT architectures.

Author Affiliations

@inproceedings{ma2023empirical,
  title = {An Empirical Analysis of Just-in-Time Compilation in Modern Databases},
  author = {Ma, Miao and Yang, Zhengyi and Hao, Kongzhang and Chen, Liuyi and Wang, Chunling and Jin, Yi},
  editor = {Bao, Zhifeng and Borovica-Gajic, Renata and Qiu, Ruihong and Choudhury, Farhana and Yang, Zhengyi},
  booktitle = {Databases Theory and Applications},
  year = {2024},
  publisher = {Springer Nature Switzerland},
  address = {Cham},
  pages = {227--240},
  isbn = {978-3-031-47843-7}
}