Sap Se

Abdelkader Sellami

Ivan Schreter

Thomas Willhalm

Norman May

Daniel Booss

Alexander Boehm

Peter Bumbulis

Werner Thesing

Tobias Scheuer

Frank Renkes

Oliver Rebholz

Anastasia Ailamaki

Iraklis Psaroudakis

Gunter Radestock

Techniques and solutions are provided for performing adaptive database table placement in a non-uniform memory access (NUMA) architecture. The adaptive table placement can occur in response to changing workloads on the NUMA nodes. For example, if a particular NUMA node is saturated, a database table may be moved from the memory of the saturated NUMA node to the memory of another NUMA node that is underutilized. In some cases, an entire database table is moved, while in other cases the database table is partitioned and only part of the table is moved.

Adaptive table placement in NUMA architectures

A system includes a non-volatile random access memory storing a column store main fragment of a column of a database table, and a processing unit to read the column store main fragment from the non-volatile random access memory. A volatile random access memory storing a column store delta fragment of the column of the database table may also be included, in which the processing unit is to write to the column store delta fragment. According to some systems, the stored column store main fragment is byte-addressable, and is copied from the volatile random access memory to the non-volatile random access memory without using a filesystem cache.

Column store main fragments in non-volatile RAM and the column store main fragments are merged with delta fragments, wherein the column store main fragments are not allocated to volatile random access memory and initialized from disk

Growing community of inventors

Heidelberg, Germany

Abdelkader Sellami