A JIT Compilation-Based Unified SQL Query Optimization System

In-memory databases are gaining attention as a solution to efficiently support SQL queries on large volume of data, as main memories are becoming cheaper and grow in size. However, their query performance is not well improved on modern hardware with faster CPUs, registers and caches due to the limitation of the classical iterator style query processing model. We propose a unified SQL query optimization system using JIT compilation of OLTP, OLAP, and Stored Procedure workloads for enhanced performance on modern hardware.