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

公开(公告)号：US11681676B2

公开(公告)日：2023-06-20

申请号：US17357097

申请日：2021-06-24

Applicant: SAP SE

Inventor： Frederic Junker ,  Christian Lemke ,  Sebastian Seifert

IPC: G06F16/22 ,  H03M7/30

CPC classification number: G06F16/221 ,  G06F16/2282 ,  H03M7/6064

Abstract: A system includes application of respective compression types to first data associated with each of a plurality of columns to generate compressed column data, determination of a first compression ratio for each of the plurality of columns based on the compressed column data, storage of the determined first compression ratios, application, for each of the plurality of columns, of the determined compression type to second data associated with the column to generate second compressed column data, determination of a second compression ratio for each of the plurality of columns based on the second compressed column data, determination of a value for each column based on the stored first compression ratio and the second compression ratio determined for the column, determination of a representative value of the determined values, and determination, based on the representative value, whether to re-determine a compression type for each of the plurality of columns.

公开(公告)号：US10452693B2

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

申请号：US15482518

申请日：2017-04-07

Applicant: SAP SE

Inventor： Frederik Transier ,  Christian Lemke ,  Sebastian Seifert

IPC: G06F7/00 ,  G06F16/31 ,  G06F16/41 ,  G06F16/955 ,  G06F16/22

Abstract: A method can include: reordering an enriched inverted index associated with a database, the enriched inverted index including a first inverted list having a first plurality of current document identifiers of records that contain a first data value, the enriched inverted index further including a first data structure storing enrichment data, the reordering of the enriched inverted index comprising: generating an ordinal sequence corresponding to an order of a first plurality of current document identifiers that include a change of at least one of the first plurality of current document identifiers to a new document identifier; determining a reordered ordinal sequence corresponding to a sorted order of the second plurality of document identifiers; separately reordering, based at least on the reordered ordinal sequence, the first plurality of current document identifiers in the first inverted list and the enrichment data in the first data structure.

公开(公告)号：US20250165453A1

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

申请号：US18515731

申请日：2023-11-21

Applicant: SAP SE

Inventor： Janardhan Hungund ,  Amit Pathak ,  Amit Saonerker ,  Deepak Shrivastava ,  Souvik Pal ,  Sebastian Seifert ,  Robert Schulze ,  Mihnea Andrei

IPC: G06F16/22 ,  G06F16/23

Abstract: A database system detects an operation to move a first database object from an in-memory store to a persistence store, wherein the first database object is in either a page-loadable or column-loadable format in the in-memory store, and wherein the first database object comprises a plurality of subcomponents. Each subcomponent of the first database object is examined separately from other subcomponents of the plurality of subcomponents. In response to determining that a first subcomponent of the plurality of subcomponents has a datatype and a compression type supported by a unified persistence format, the first subcomponent is stored in a unified persistence format in the persistence store. In response to determining that a second subcomponent of the plurality of subcomponents has either a datatype or a compression type which is not supported by the unified persistence format, the second subcomponent is stored in a serial persistence format in the persistence store.

公开(公告)号：US20250139015A1

公开(公告)日：2025-05-01

申请号：US18495478

申请日：2023-10-26

Applicant: SAP SE

Inventor： Nishant Vijayvergiya ,  Amit Pathak ,  Sebastian Seifert ,  Thomas Peh ,  Sergej Hardock

IPC: G06F12/1009 ,  G06F12/123

Abstract: In some implementations, there is provided a method that includes configuring a first threshold for page-loadable data at a buffer cache associated with a database; checking the buffer cache to determine usage of the buffer cache by the page-loadable data; in response to the usage of the buffer cache being more than the first threshold, causing a background job to release one or more buffers in the buffer cache; checking, after releasing at least one buffer of the buffer cache, the buffer cache to determine whether usage by the page-loadable data is below the first threshold; in response to the usage being below the first threshold, stopping the release of additional one or more buffers in the buffer cache; and in response to the usage being above the first threshold, continuing the release of the additional one or more buffers in the buffer cache.

公开(公告)号：US11151126B2

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

申请号：US16866766

申请日：2020-05-05

Applicant: SAP SE

Inventor： Colin Florendo ,  Mihnea Andrei ,  Amit Pathak ,  Robert Schulze ,  Adrian Dragusanu ,  Reza Sherkat ,  Sebastian Seifert ,  Christian Lemke

IPC: G06F16/22 ,  G06F16/23 ,  G06F12/02 ,  G06F3/06 ,  G06F12/0882 ,  G06F16/2455 ,  G06F12/0875 ,  G06F9/48

Abstract: Disclosed herein are system, method, and computer-program product embodiments for generating a paged and in-memory representation of a database object. An embodiment operates by maintaining in-memory and paged form primitives unique to the database object or a substructure thereof in a database such that the in-memory and paged form primitives are capable of providing the in-memory and paged representations of the database objects, respectively. Thereafter, a load configuration for the database object is determined. Based on the load configuration, the in-memory and/or paged representations of the database object are generated using the in-memory form primitive or the paged form primitive unique to the database object, respectively. Subsequently, the in-memory and/or paged representations of the database object are stored in the database.

公开(公告)号：US20170154061A1

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

申请号：US14954736

申请日：2015-11-30

Applicant: SAP SE

Inventor： Reza SHERKAT ,  Ivan Schreter ,  Robert Schulze ,  Mihnea Andrei ,  Colin Florendo ,  Christian Lemke ,  Sebastian Seifert

IPC: G06F17/30 ,  H03M7/30

CPC classification number: G06F17/30339 ,  G06F17/30336 ,  G06F17/30424 ,  G06F17/30622 ,  H03M7/60

Abstract: Disclosed herein are system and method embodiments for generating a paged inverted index. An embodiment is generated by storing a first data structure and the second data structure in a plurality of pages, where the plurality of pages are stored in the one or more memories. The first data structure is stored in the plurality of pages and includes a plurality of value identifiers, where a value identifier corresponds to an offset. The second data structure stored in the plurality of pages includes a plurality of row positions, wherein a row position is at a location that corresponds to the offset in the first data structure and identifies a position of row in a table that stores data associated with the value ID.

公开(公告)号：US12242497B1

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

申请号：US18504435

申请日：2023-11-08

Applicant: SAP SE

Inventor： Anish Maniyar ,  Santhosh T Kumar ,  Guo Gang Ye ,  Amit Pathak ,  Sebastian Seifert ,  Souvik Pal

IPC: G06F16/25

Abstract: A database system detects a query targeting a first database object stored in a unified persistence format in a persistence store. In response to detecting the query, the database system determines whether to load the first database object in column-loadable format or page-loadable format into an in-memory store. In response to determining to load the first database object in the column-loadable format, the database system determines if a first bit representation of one or more corresponding primitives in the persistence store is compatible with a second bit representation used for storing the primitives in the in-memory store. The database system performs a native copy operation to copy the primitives from the persistence store to the in-memory store if the bit representations are compatible, where the native copy operation involves copying the primitives on a page-by-page basis without decoding and encoding values of the one or more primitives.

公开(公告)号：US12197419B2

公开(公告)日：2025-01-14

申请号：US17974209

申请日：2022-10-26

Applicant: SAP SE

Inventor： Frederic Junker ,  Christian Lemke ,  Sebastian Seifert

IPC: G06F17/00 ,  G06F16/23 ,  H03M7/40

Abstract: Systems and methods include reception of an instruction to perform a consistency check on compressed column data. In response to the instruction, a compression algorithm applied to uncompressed column data to generate the compressed column data is determined, one or more consistency checks associated with the compression algorithm are determined, wherein a first one or more consistency checks associated with a first compression algorithm are different from a second one or more consistency checks associated with a second compression algorithm, the one or more consistency checks are executed on the compressed column data, and, if the one or more consistency checks are not satisfied, a notification is transmitted to a user.

公开(公告)号：US10719450B2

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

申请号：US16229313

申请日：2018-12-21

Applicant: SAP SE

Inventor： Sebastian Seifert ,  Christian Lemke

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

Abstract: A system in which a volatile random access memory stores first header data, second header data, a first logical array in a first contiguous memory block and a second logical array in a second contiguous memory block. Each array position of the first logical array stores a database column value, and each array position of the second logical array stores an indication of a number of consecutive occurrences of a database column value. The first header data includes a first pointer to the first memory block, and the second header data includes a second pointer to the second memory block. A memory size is determined associated with the first header data, the second header data, the first memory block, and the second memory block, a first memory block of the non-volatile random access memory is allocated based on the determined memory size, an address of the random access memory associated with the allocated first memory block is determined, and a portion of the first header data, a portion of the second header data, a binary copy of the first memory block and a binary copy of the second memory block are written at the address of the random access memory.