J

J

Database

Stencil-Based Just-In-Time Compilation for SQL Expression Evaluation: A Copy-and-Patch Approach

Abstract Just-in-time compilation offers significant performance improvements for database query execution by eliminating interpreter overhead. However, traditional JIT frameworks such as LLVM introduce compilation latencies measured in milliseconds, which fail to amortize for typical OLTP workloads. This article presents a practical implementation of stencil-based JIT compilation for SQL expression evaluation,

By J

Compiler

Compiler Optimization Techniques: Loop Invariant Code Motion and Static Single Assignment Form

Abstract This report presents a comprehensive analysis of two fundamental compiler optimization techniques: Loop Invariant Code Motion (LICM) and Static Single Assignment (SSA) Form. We explore the theoretical foundations, implementation algorithms, and practical applications of these techniques in modern optimizing compilers. The report demonstrates how SSA form provides an elegant

By J

Computer Architecture

Memory Locality in the Age of Virtualization: Optimizing Database Performance in Hidden NUMA Topologies

1. Introduction Modern cloud infrastructure presents a fascinating paradox: as we advance toward more sophisticated hardware architectures, virtualization increasingly obscures these same architectures from the software running within virtual machines. This phenomenon is particularly evident in Non-Uniform Memory Access (NUMA) systems, where memory access times depend on the memory location

By J