公开(公告)号：US20210373893A1

公开(公告)日：2021-12-02

申请号：US16883241

申请日：2020-05-26

Applicant: SAP SE

Inventor： Dirk Thomsen ,  Thorsten Glebe ,  Tobias Scheuer ,  Werner Thesing ,  Johannes Gloeckle

IPC: G06F9/30 ,  G06F16/28 ,  G06F9/38 ,  G06F9/54

Abstract: Aspects of the current subject matter are directed to an approach in which a parallel load operation of file ID mapping containers is accomplished at start and/or restart of a database system. Parallel load operation of file ID mapping and/or large binary object (LOB) file ID mapping is done among a plurality of scanning engines into a plurality of data buffers that are associated with each of the plurality of scanning engines. Each scanning engine operates on a certain path of a page chain of a page structure including the mapping, causing the page chain to be split among scanning engines to process maps. Contents of the data buffers are pushed to mapping engines via a queue. The mapping engines load the file ID mapping and the LOB file ID mapping into maps for in-system access.

公开(公告)号：US11042527B2

公开(公告)日：2021-06-22

申请号：US15980525

申请日：2018-05-15

Applicant: SAP SE

Inventor： Tobias Scheuer ,  Dirk Thomsen

IPC: G06F16/23 ,  G06F9/46 ,  G06F16/27

Abstract: Systems and methods are described herein for system critical phase lock job inhibitors. Acquisition of a consistent change exclusive lock is initiated. A job request having a scope object is received. Execution of the job request and generation of a replacement job associated with the job request is prohibited based on the scope object indicating that the job requires consistent change access during the consistent change exclusive lock.

公开(公告)号：US10810116B2

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

申请号：US15638189

申请日：2017-06-29

Applicant: SAP SE

Inventor： Dirk Thomsen ,  Thorsten Glebe

IPC: G06F12/00 ,  G06F12/02 ,  G06F16/21 ,  G06F16/28

Abstract: Loading of a page into memory of an in-memory database system is initiated. Thereafter, a new page size for the page in memory is allocated corresponding to a greater of a current page size and an intended page size. Later, the page is loaded into the allocated memory so that a consistent change can be opened. Content within the page is reorganized according to the new page size followed by the consistent change being closed.

公开(公告)号：US20200242160A1

公开(公告)日：2020-07-30

申请号：US16261361

申请日：2019-01-29

Applicant: SAP SE

Inventor： Dirk Thomsen

IPC: G06F16/901

Abstract: A database system receives a mass insert operation command specifying a plurality of entries. Thereafter, the entries are iteratively inserted into a plurality of preliminary pages associated with a container provided by a persistence layer of the database system. Thereafter, the preliminary pages are registered to the container once they are full.

公开(公告)号：US20200241976A1

公开(公告)日：2020-07-30

申请号：US16261172

申请日：2019-01-29

Applicant: SAP SE

Inventor： Dirk Thomsen

IPC: G06F11/14 ,  G06F16/908 ,  H04L9/08 ,  G06F3/06

Abstract: Recovery of an in-memory database is initiated. Thereafter, pages for recovery having a size equal to or below a pre-defined threshold are copied to a superblock. For each copied page, encryption information is added to a superblock control block for the superblock. The copied pages are encrypted within the superblock using the corresponding encryption information added to the super block control block. The superblock is then flushed from memory (e.g., main memory, etc.) of the database to physical persistence.

公开(公告)号：US20200241791A1

公开(公告)日：2020-07-30

申请号：US16261299

申请日：2019-01-29

Applicant: SAP SE

Inventor： Dirk Thomsen

IPC: G06F3/06 ,  G06F9/50 ,  G06F9/48

Abstract: Physical block numbers are assigned to pages loaded into memory of an in-memory database. Thereafter, pages having a same size are distributed to one of a plurality of helper threads executing in parallel for processing if such pages having consecutive physical block numbers. Each of these helper threads can have a corresponding small page buffer. Contents of the respective small page buffers are later flushed to physical disk persistence when such small page buffers are full.

公开(公告)号：US20190340276A1

公开(公告)日：2019-11-07

申请号：US15970739

申请日：2018-05-03

Applicant: SAP SE

Inventor： Dirk Thomsen ,  Thorsten Glebe

IPC: G06F17/30

Abstract: A request is received for a first non-exclusive lock to read a page in a database. Thereafter, execution of the at least one non-exclusive lock is initiated. Later, a request for an exclusive lock to modify the page in the database is received. Subsequently, a request is received for a second non-exclusive lock. In response, an amount of time to finish the first request and the second request is estimated. The second non-exclusive lock is allowed to execute in parallel to the first non-exclusive if the determined amount of time to finish the second non-exclusive lock is less than an estimated amount of time needed by the first non-exclusive lock. Alternatively, execution of the second non-exclusive lock is delayed to after the execution of the exclusive lock if the determined amount of time to finish the second non-exclusive lock is greater than an amount of time needed by the first non-exclusive lock.

公开(公告)号：US20190340017A1

公开(公告)日：2019-11-07

申请号：US15970730

申请日：2018-05-03

Applicant: SAP SE

Inventor： Tobias Scheuer ,  Dirk Thomsen

IPC: G06F9/48 ,  G06F17/30

Abstract: Systems and methods are described herein for job execution using system critical threads. An in-memory database system having pages loaded into a memory and having associated physical disk storage generates a safety critical thread pool. The safety critical thread pool has one or more safety critical threads associated with flushing the pages to the physical disk storage. Execution of the one or more safety critical threads is initiated within the safety critical thread pool. A job request to access data stored within the physical disk storage is received. Utilization levels of the one or more safety critical threads are monitored. Execution of the job request is permitted based on the utilization levels associated with the one or more safety critical threads.

公开(公告)号：US20190018742A1

公开(公告)日：2019-01-17

申请号：US15647045

申请日：2017-07-11

Applicant: SAP SE

Inventor： Dirk Thomsen ,  Christoph Roterring ,  Thorsten Glebe

IPC: G06F11/14 ,  G06F17/30 ,  G06F12/02

Abstract: Recovery of a database system by taking the database system offline is initiated. Thereafter, recovery operations specified by a redo log of the database system are replayed. A cleanup log is generated that identifies cleanup operations occurring during the replay of the recovery operations for garbage collection. Concurrent with the startup of the database, garbage collection of the cleanup operations as specified in the database savepoint is initiated. In addition, concurrent with the replay of the recovery operations, garbage collection of the cleanup operations specified by the cleanup log is initiated. The amount of parallelization of the garbage collection can be varied based on utilized processor resources. The database system is later brought online after all of the recovery operations are replayed.

公开(公告)号：US20180335949A1

公开(公告)日：2018-11-22

申请号：US15600633

申请日：2017-05-19

Applicant: SAP SE

Inventor： Dirk Thomsen

IPC: G06F3/06 ,  G06F12/123

Abstract: Allocation of an entry in a variable size entry container is initiated in an in-memory database system. The variable size entry container includes a plurality of pages forming a chain. Thereafter, it is determined whether free space is found within the pre-existing pages. If free space is found, the entry is allocated in the free space. Otherwise, a new page is created and appended to the chain so that the entry can be allocated on such new page.