公开(公告)号：US11880371B2

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

申请号：US18065187

申请日：2022-12-13

Applicant: SAP SE

Inventor： Franz Faerber ,  Juchang Lee ,  Ivan Schreter

IPC: G06F16/2455 ,  G06F16/24 ,  G06F16/21 ,  G06F16/22

CPC classification number: G06F16/24561 ,  G06F16/213 ,  G06F16/221 ,  G06F16/24 ,  G06F16/2455 ,  G06F16/2456

Abstract: A system and method of query processing in a multi-level storage system having a unified table architecture. A query is received by a common query execution engine connected with the unified table architecture, the query specifying a data record. The common query execution engine performs a look-up for the data record based on the query at the first level storage structure. If the data record is not present at the first level storage structure, the common query execution engine performs separate look-ups in each of the second level storage structure and the main store.

公开(公告)号：US20220221897A1

公开(公告)日：2022-07-14

申请号：US17710181

申请日：2022-03-31

Applicant: SAP SE

Inventor： Ivan Schreter ,  Sergey Yurenev

IPC: G06F1/12 ,  G06F1/08 ,  G06F16/23

Abstract: A thread executing a task at a node in a multi-socket computing system may access a first data structure to obtain a first calibration dataset for the node. The first thread may generate a timestamp based on the first calibration dataset and a first quantity of time measured by a clock at the first node. The real-time duration of the task may be determined based on the timestamp. The first thread may recalibrate the first clock by at least generating, based on the first quantity of time measured by the clock and a second quantity of time measured by a wall clock of an operating system of the multi-socket computing system, a second calibration dataset. The first thread may update the first data structure to include the second calibration dataset while a second thread accesses a second data structure to obtain calibration data.

公开(公告)号：US11320854B2

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

申请号：US16837508

申请日：2020-04-01

Applicant: SAP SE

Inventor： Ivan Schreter ,  Sergey Yurenev

IPC: G06F1/12 ,  G06F1/08 ,  G06F16/23

Abstract: A thread executing a task at a node in a multi-socket computing system may access a first data structure to obtain a first calibration dataset for the node. The first thread may generate a timestamp based on the first calibration dataset and a first quantity of time measured by a clock at the first node. The real-time duration of the task may be determined based on the timestamp. The first thread may recalibrate the first clock by at least generating, based on the first quantity of time measured by the clock and a second quantity of time measured by a wall clock of an operating system of the multi-socket computing system, a second calibration dataset. The first thread may update the first data structure to include the second calibration dataset while a second thread accesses a second data structure to obtain calibration data.

公开(公告)号：US11086832B2

公开(公告)日：2021-08-10

申请号：US14885752

申请日：2015-10-16

Applicant: SAP SE

Inventor： Panfeng Zhou ,  Colin Florendo ,  Ivan Schreter ,  Thorsten Glebe ,  David Wein

IPC: G06F16/22 ,  G06F12/00

Abstract: The subject matter disclosed herein relates to out of memory error handling in a database system. A database operation can be received by an in-memory database. The database operation can be for a database object stored in a database table that can be represented as a plurality of pages that can be persisted in a page chain. The in-memory database can reserve out of memory space sufficient to load a predetermined number of pages in the page chain into memory. The in-memory database can iteratively process each page in the page chain until completion of the database operation. The iterative process can include loading the page from persistence into memory of the in-memory database, performing at least a portion of the database operation using the loaded page, and unloading the page from the memory of the in-memory database. Related apparatus, systems, techniques, and articles are also described.

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

公开(公告)号：US10817196B2

公开(公告)日：2020-10-27

申请号：US16029460

申请日：2018-07-06

Applicant: SAP SE

Inventor： Ivan Schreter

IPC: G06F3/06 ,  G06F17/30 ,  G06F16/11 ,  H04L29/14 ,  G06F11/14 ,  H04L29/08 ,  G06F16/2455 ,  G06F12/0802 ,  G06F16/16 ,  G06F16/182 ,  G06F16/176 ,  G06F16/13 ,  G06F12/1009 ,  G06F16/951 ,  G06F16/27 ,  G06F16/23 ,  G06F11/16 ,  G06F16/245 ,  G06F16/215

Abstract: A method for generating a data directory can include allocating a first page for storing a first segment of a log recording changes applied to data subsequent to a checkpoint. When the first page reaches maximum capacity, a second page can be allocated for storing a second segment of the log. A third page can be allocated for storing a first page list that includes a first page reference to the second data page. A fourth page serving as a restart page can be updated. The fourth page can store a second page list of data pages storing the data directory. The fourth page can be updated to add, to the second page list, a second page reference to the data page. Crash recovery at the computing node can be performed based on the data directory. Related systems and articles of manufacture are also provided.

公开(公告)号：US10810124B2

公开(公告)日：2020-10-20

申请号：US15810442

申请日：2017-11-13

Applicant: SAP SE

Inventor： Ivan Schreter

IPC: G06F9/46 ,  G06F12/0846 ,  G06F9/52 ,  G06F9/54 ,  G06F12/0895

Abstract: A central processing unit (CPU) forming part of a computing device, initiates execution of code associated with each of a plurality of objects used by a worker thread. The CPU has an associated cache that is split into a plurality of slices. It is determined, by a cache slice allocation algorithm for each object, whether any of the slices will be exclusive to or shared by the object. Thereafter, for each object, any slices determined to be exclusive to the object are activated such that the object exclusively uses such slices and any slices determined to be shared by the object are activated such that the object shares or is configured to share such slices.

公开(公告)号：US20200319928A1

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

申请号：US16373278

申请日：2019-04-02

Applicant: SAP SE

Inventor： Ivan Schreter

IPC: G06F9/50 ,  G06F3/06

Abstract: A system and method of allocating memory to a thread of a multi-threaded program are disclosed. A method includes determining one or more thread-local blocks of memory that are available for the thread, and generating a count of the available one or more thread-local blocks for a thread-local freelist. If a thread-local block is available, allocating one block of the one or more thread-local blocks to the thread and decrementing the count in the thread-local freelist. When the count is zero, accessing a global freelist of available blocks of memory to determine a set of available blocks represented by the global freelist. Then, the set of available blocks are allocated from the global freelist to the thread-local freelist by copying one or more free block pointers of the global freelist to a thread-local state of the thread. Blocks can also be deallocated.

公开(公告)号：US10740036B2

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

申请号：US15632110

申请日：2017-06-23

Applicant: SAP SE

Inventor： Ivan Schreter ,  Dirk Thomsen ,  Colin Florendo ,  Blaine French

IPC: G06F16/22 ,  G06F3/06 ,  G06F16/23 ,  G06F16/174 ,  G06F16/2455

Abstract: Data records of a data set can be stored in multiple main part fragments retained in on-disk storage. Each fragment can include a number of data records that is equal to or less than a defined maximum fragment size. Using a compression that is optimized for each fragment, each fragment can be compressed. After reading at least one of the fragments into main system memory from the on-disk storage, an operation can be performed on the fragment or fragments while the in the main system memory.

公开(公告)号：US10409864B2

公开(公告)日：2019-09-10

申请号：US14552808

申请日：2014-11-25

Applicant: SAP SE

Inventor： Ivan Schreter ,  Chang-Gyoo Park

IPC: G06F17/30 ,  G06F16/9038 ,  G06F16/18 ,  G06F16/23

Abstract: Disclosed herein are system, method, and computer program product embodiments for utilizing a transaction control block for providing reader-writer access to transaction commit status. An embodiment operates by receiving a row read request and determining that the row is versioned. The system determines that a first timestamp information for a row destroy transaction associated with the row exists in a transaction control block and retrieves the first timestamp information from the transaction control block.