公开(公告)号：US10769075B2

公开(公告)日：2020-09-08

申请号：US16197851

申请日：2018-11-21

Applicant: SAP SE

Inventor： Carsten Thiel ,  Guenter Radestock ,  Martin Richtarsky ,  Bernhard Scheirle

IPC: G06F12/10 ,  G06F12/02 ,  G06F16/22 ,  G06F12/06 ,  G06F3/06

Abstract: A system includes storage, in a volatile random access memory, of a first data block comprising an array of distinct values of a database table column, and first header data comprising a first pointer to the first data block, determination of a memory size associated with the first header data and the first data block, allocation of a first memory block of the non-volatile random access memory based on the determined memory size, determination of an address of the non-volatile random access memory associated with the allocated first memory block, and writing of an indicator of the number of distinct values of the array and a binary copy of the first data block at the address of the non-volatile random access memory.

公开(公告)号：US12282494B1

公开(公告)日：2025-04-22

申请号：US18529218

申请日：2023-12-05

Applicant: SAP SE

Inventor： Janardhan Hungund ,  Neha Shikha Kachhap ,  Jagadeesha Kanihal ,  Sebastian Seifert ,  Bernhard Scheirle ,  Amit Pathak ,  Werner Thesing ,  Thomas Peh

IPC: G06F16/27 ,  G06F16/25

Abstract: A primary database system loads database objects into a primary in-memory store according to a given format. The primary database captures, in replay logs, the loading of the database objects according to the given format. The primary database sends the replay logs to a secondary database system. In response to receiving a replay log, the secondary database checks the value of a log replay configuration parameter. If the configuration parameter is a first value, the secondary database replays the replay log to load the corresponding database objects into a secondary in-memory store according to a first format. If the configuration parameter is a second value, the secondary database replays the log to load the objects according to a second format, and if the configuration parameter is a third value, the secondary database replays the log to load the objects in a same format which was used by the primary database.

公开(公告)号：US12072888B1

公开(公告)日：2024-08-27

申请号：US18316624

申请日：2023-05-12

Applicant: SAP SE

Inventor： Robert Lasch ,  Thomas Legler ,  Norman May ,  Kai-Uwe Sattler ,  Bernhard Scheirle

IPC: G06F16/00 ,  G06F16/22 ,  G06F16/2455 ,  G06F16/25

CPC classification number: G06F16/2456 ,  G06F16/2282 ,  G06F16/252

Abstract: Embodiments of the present disclosure include techniques for cooperative memory management. In one embodiment, a database management system includes a memory manager for managing a memory buffer. The memory buffer is configured to allocate memory to table data and temporary data dynamically. In some embodiments, table data memory allocations are reduced and temporary data memory allocations are increased to process queries. Temporary data memory allocations may be increased to store temporary data associated with one or more portions of a query. The memory buffer reallocates table data memory allocations and temporary data memory allocations as needed to more efficiently use available memory.

公开(公告)号：US20240111757A1

公开(公告)日：2024-04-04

申请号：US18530819

申请日：2023-12-06

Applicant: SAP SE

Inventor： Bernhard Scheirle ,  Andreas Tonder ,  Carsten Thiel ,  Guenter Radestock ,  Thomas Legler ,  Martin Heidel ,  Robert Schulze ,  Joern Schmidt ,  Rolando Blanco

IPC: G06F16/23

CPC classification number: G06F16/2379

Abstract: A method may include receiving a first transaction inserting a record into a database and a second transaction deleting the record from the database. A validity period for the record may be determined based on a first commit time at which the first transaction is committed and a second commit time at which the second transaction is committed. A current table and/or a history table of a system versioned table may be updated to include the record based on the validity period of the record. One or more temporal operations may be performed based on the system versioned table. For example, a time travel operation may be performed to retrieve, based on the system versioned table, one or more records that are valid at a given point in time. Related systems and computer program products are also provided.

公开(公告)号：US11886424B2

公开(公告)日：2024-01-30

申请号：US17481644

申请日：2021-09-22

Applicant: SAP SE

Inventor： Bernhard Scheirle ,  Andreas Tonder ,  Carsten Thiel ,  Guenter Radestock ,  Thomas Legler ,  Martin Heidel ,  Robert Schulze ,  Joern Schmidt ,  Rolando Blanco

IPC: G06F16/20 ,  G06F16/23

CPC classification number: G06F16/2379

Abstract: A method may include receiving a first transaction inserting a record into a database and a second transaction deleting the record from the database. A validity period for the record may be determined based on a first commit time at which the first transaction is committed and a second commit time at which the second transaction is committed. A current table and/or a history table of a system versioned table may be updated to include the record based on the validity period of the record. One or more temporal operations may be performed based on the system versioned table. For example, a time travel operation may be performed to retrieve, based on the system versioned table, one or more records that are valid at a given point in time. Related systems and computer program products are also provided.

公开(公告)号：US20230086162A1

公开(公告)日：2023-03-23

申请号：US17481644

申请日：2021-09-22

Applicant: SAP SE

Inventor： Bernhard Scheirle ,  Andreas Tonder ,  Carsten Thiel ,  Guenter Radestock ,  Thomas Legler ,  Martin Heidel ,  Robert Schulze ,  Joern Schmidt ,  Rolando Blanco

IPC: G06F16/23

Abstract: A method may include receiving a first transaction inserting a record into a database and a second transaction deleting the record from the database. A validity period for the record may be determined based on a first commit time at which the first transaction is committed and a second commit time at which the second transaction is committed. A current table and/or a history table of a system versioned table may be updated to include the record based on the validity period of the record. One or more temporal operations may be performed based on the system versioned table. For example, a time travel operation may be performed to retrieve, based on the system versioned table, one or more records that are valid at a given point in time. Related systems and computer program products are also provided.