公开(公告)号：US11275721B2

公开(公告)日：2022-03-15

申请号：US14802580

申请日：2015-07-17

Applicant: SAP SE

Inventor： Tobias Scheuer ,  Iraklis Psaroudakis ,  Abdelkader Sellami ,  Norman May ,  Anastasia Ailamaki

IPC: G06F16/22

Abstract: 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.

公开(公告)号：US20180246809A1

公开(公告)日：2018-08-30

申请号：US15695621

申请日：2017-09-05

Applicant: SAP SE

Inventor： Oliver Rebholz ,  Ivan Schreter ,  Abdelkader Sellami ,  Daniel Booss ,  Gunter Radestock ,  Peter Bumbulis ,  Alexander Boehm ,  Frank Renkes ,  Werner Thesing ,  Thomas Willhalm

IPC: G06F12/02 ,  G06F17/30 ,  G11C11/56

Abstract: 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.

公开(公告)号：US10824673B2

公开(公告)日：2020-11-03

申请号：US15695621

申请日：2017-09-05

Applicant: SAP SE

Inventor： Oliver Rebholz ,  Ivan Schreter ,  Abdelkader Sellami ,  Daniel Booss ,  Gunter Radestock ,  Peter Bumbulis ,  Alexander Boehm ,  Frank Renkes ,  Werner Thesing ,  Thomas Willhalm

IPC: G06F16/901 ,  G06F3/06

Abstract: 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.

公开(公告)号：US20170017674A1

公开(公告)日：2017-01-19

申请号：US14802580

申请日：2015-07-17

Applicant: SAP SE

Inventor： Tobias Scheuer ,  Iraklis Psaroudakis ,  Abdelkader Sellami ,  Norman May ,  Anastasia Ailamaki

IPC: G06F17/30

CPC classification number: G06F16/2282

Abstract: 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.

Abstract translation: 提供了技术和解决方案，用于在非均匀存储器访问（NUMA）架构中执行自适应数据库表放置。 自适应表放置可以响应于NUMA节点上的工作负载变化而发生。 例如，如果特定的NUMA节点饱和，则数据库表可以从饱和NUMA节点的存储器移动到未充分利用的另一个NUMA节点的存储器。 在某些情况下，整个数据库表被移动，而在其他情况下，数据库表被分区，只有表的一部分被移动。