公开(公告)号：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.

公开(公告)号：US09720774B2

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

申请号：US14753521

申请日：2015-06-29

Applicant: SAP SE

Inventor： Ismail Oukid ,  Anisoara Nica ,  Peter Bumbulis ,  Wolfgang Lehner ,  Thomas Willhalm

IPC: G06F11/00 ,  G06F11/14 ,  G06F3/06

CPC classification number: G06F11/142 ,  G06F3/0619 ,  G06F3/0644 ,  G06F3/068 ,  G06F11/00 ,  G06F2201/80

Abstract: A system includes determination of a plurality of secondary data structures of a database to be rebuilt, determination, for each of the plurality of secondary data structures, of a current ranking based on a pre-crash workload, a crash-time workload, the post-crash workload, and a rebuild time of the secondary data structure, determination to rebuild one of the plurality of secondary data structures based on the determined rankings, and rebuilding of the one of the plurality of secondary data structures in a dynamic random access memory based on primary data of a database stored in non-volatile random access memory.

公开(公告)号：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.

公开(公告)号：US20160378601A1

公开(公告)日：2016-12-29

申请号：US14753521

申请日：2015-06-29

Applicant: SAP SE

Inventor： Ismail Oukid ,  Anisoara Nica ,  Peter Bumbulis ,  Wolfgang Lehner ,  Thomas Willhalm

IPC: G06F11/14 ,  G06F3/06

CPC classification number: G06F11/142 ,  G06F3/0619 ,  G06F3/0644 ,  G06F3/068 ,  G06F11/00 ,  G06F2201/80

Abstract: A system includes determination of a plurality of secondary data structures of a database to be rebuilt, determination, for each of the plurality of secondary data structures, of a current ranking based on a pre-crash workload, a crash-time workload, the post-crash workload, and a rebuild time of the secondary data structure, determination to rebuild one of the plurality of secondary data structures based on the determined rankings, and rebuilding of the one of the plurality of secondary data structures in a dynamic random access memory based on primary data of a database stored in non-volatile random access memory.

Abstract translation: 系统包括确定要重建的数据库的多个辅助数据结构，对于多个次要数据结构中的每一个确定基于预碰撞工作负载的当前排序，崩溃时间工作负载，事件 基于所确定的排序重建所述多个辅助数据结构中的一个，以及基于动态随机存取存储器中的所述多个辅助数据结构中的一个重建所述次要数据结构的重构时间 存储在非易失性随机存取存储器中的数据库的主数据。