Concurrency Control

Data Model

Hardware Acceleration

Indexes

Joins[07]

Yellowbrick supports hash, sort-merge, and nested loop joins.

Query Compilation[06]

Yellowbrick partitions query plans into segments and converts them into C++ code. Segments are then compiled into machine code in parallel using a modified version of LLVM which is memory-resident with its ASTs pre-loaded. Compiled object files are cached and reused.

Query Execution

Query Interface

Storage Architecture

Storage Model

Stored Procedures[08]

Yellowbrick supports PL/pgSQL stored procedures (CREATE PROCEDURE) but not user-defined functions (CREATE FUNCTION). Unlike in PostgreSQL, stored procedures in Yellowbrick can return values and be called from SELECT statements, but only when there is no table-referencing FROM clause.

Triggers are not supported.

System Architecture