Fast Compilation and Execution of SQL Queries with WebAssembly
Immanuel Haffner, Jens Dittrich

TL;DR
This paper presents a WebAssembly-based approach for fast SQL query compilation and execution that achieves low latency and high throughput, enabling adaptive query processing with minimal development effort.
Contribution
It introduces a method to compile complex SQL queries to WebAssembly in under a millisecond, facilitating adaptive execution without extensive compiler development.
Findings
Compilation time under 1 millisecond for complex queries
Seamless transition from rapid to optimized code during execution
Competitive or superior performance compared to existing systems
Abstract
Interpreted execution of queries, as in the vectorized model, suffers from interpretation overheads. By compiling queries this interpretation overhead is eliminated at the cost of a compilation phase that delays execution, sacrificing latency for throughput. For short-lived queries, minimizing latency is important, while for long-running queries throughput outweighs latency. Because neither a purely interpretive model nor a purely compiling model can provide low latency and high throughput, adaptive solutions emerged. Adaptive systems seamlessly transition from interpreted to compiled execution, achieving low latency for short-lived queries and high throughput for long-running queries. However, these adaptive systems pose an immense development effort and require expert knowledge in both interpreter and compiler design. In this work, we investigate query execution by compilation to…
Peer Reviews
No public reviews on file for this paper yet. If you reviewed it on a platform where reviews are public (OpenReview, ICLR, NeurIPS, ICML), you can paste yours below so the community can read it here.
Videos
No videos yet. Explain this paper in a talk, walkthrough, or lecture? Add one.
Taxonomy
TopicsParallel Computing and Optimization Techniques · Advanced Database Systems and Queries · Scientific Computing and Data Management
