Bringing BLINK Closer to the Full Power of SQL

: BLINK is a prototype of an in-memory based query processor that exploits heavily the underlying CPU infrastructure. It is very sensitive to the processor’s caches and instruction set. In this paper, we describe how to close two major functional gaps in BLINK, which arise from real-world workloads. The manipulation of the data maintained by BLINK require specialized data structures. Another aspect being discussed are NULLs and how to avoid the three-valued logic during query processing.

• Type: Conference
• Year: 2009
• Where: BTW
• Authors: Knut Stolze, Vijayshankar Raman, Richard Sidle, O. Draese
• Keywords: BLINK, BTW 2009, Database, In-memory Based Query, Major Functional Gaps