公开(公告)号：US11693876B2

公开(公告)日：2023-07-04

申请号：US16739352

申请日：2020-01-10

Applicant: SAP SE

Inventor： Stefan Noll ,  Jens Teubner ,  Norman May ,  Alexander Boehm

IPC: G06F16/25 ,  G06F16/23

CPC classification number: G06F16/254 ,  G06F16/2365 ,  G06F16/258

Abstract: The present disclosure involves systems, software, and computer implemented methods for efficient shared bulk loading into optimized storage. One example method includes identifying a data set on a client to load to a server. Load steps that can be performed either on the client or the server are identified. Values for load factors are determined. Load rules are determined that are based on load factors and are for determining processing locations for the load steps. A processing location of either the client or the server is determined for each load step, based on the load rules. Load steps that have a processing location of the client are executed on the data set, on the client. The data set is transferred from the client to the server, over a network. Load steps that have a processing location of the server are executed on the data set, at the server.

公开(公告)号：US20240220475A1

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

申请号：US18435230

申请日：2024-02-07

Applicant: SAP SE

Inventor： Stefan Noll ,  Paul Willems

IPC: G06F16/22 ,  G06F16/23 ,  G06F16/2453 ,  G06F16/2455 ,  G06F16/28

CPC classification number: G06F16/2282 ,  G06F16/2322 ,  G06F16/2329 ,  G06F16/24532 ,  G06F16/24564 ,  G06F16/285 ,  G06F16/288

Abstract: A method for processing non-standardized data in a relational database may include identifying, within a sequence of operations forming a query pipeline for executing a query, a first operation ingesting a non-standardized data. In response to identifying the first operation ingesting the non-standardized data, a second operation may be inserted before the first operation. The non-standardized data may be output by a third operation preceding the first operation or a source external to the query pipeline. The second operation may serialize the non-standardized data for ingestion by the first operation, for example, by generating a relational table populated by the non-standardized data. The query may be executed by performing the sequence of operations included in the query pipeline. Related systems and computer program products are also provided.

公开(公告)号：US20190310943A1

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

申请号：US15945244

申请日：2018-04-04

Applicant: SAP SE

Inventor： Stefan Noll ,  Norman May ,  Alexander Martin Böhm ,  Jens Thilo Teubner

IPC: G06F12/0891 ,  G06F12/0897 ,  G06F17/30

Abstract: Disclosed herein are system, method, and computer program product embodiments for cache partitioning to accelerate concurrent workload performance of in-memory databases. An embodiment operates by storing a first bitmask, associating the first bitmask with a first processor core, setting a subset of the bits of the first bitmask, wherein the subset of the bits of the first bitmask represents a first portion of shared last-level cache, and wherein any part of the first bitmask excluding the subset of the bits of the first bitmask represents a second portion of the lowest-level cache, and disallowing eviction of any cache line in the second portion of the lowest-level cache by the first processor core.

公开(公告)号：US20230350867A1

公开(公告)日：2023-11-02

申请号：US17733507

申请日：2022-04-29

Applicant: SAP SE

Inventor： Stefan Noll ,  Paul Willems

IPC: G06F16/22 ,  G06F16/28 ,  G06F16/2455 ,  G06F16/2453 ,  G06F16/23

CPC classification number: G06F16/2282 ,  G06F16/285 ,  G06F16/288 ,  G06F16/24564 ,  G06F16/24532 ,  G06F16/2322 ,  G06F16/2329

Abstract: A method for processing non-standardized data in a relational database may include identifying, within a sequence of operations forming a query pipeline for executing a query, a first operation ingesting a non-standardized data. In response to identifying the first operation ingesting the non-standardized data, a second operation may be inserted before the first operation. The non-standardized data may be output by a third operation preceding the first operation or a source external to the query pipeline. The second operation may serialize the non-standardized data for ingestion by the first operation, for example, by generating a relational table populated by the non-standardized data. The query may be executed by performing the sequence of operations included in the query pipeline. Related systems and computer program products are also provided.

公开(公告)号：US10891234B2

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

申请号：US15945244

申请日：2018-04-04

Applicant: SAP SE

Inventor： Stefan Noll ,  Norman May ,  Alexander Martin Böhm ,  Jens Thilo Teubner

IPC: G06F12/0891 ,  G06F16/22 ,  G06F16/2455 ,  G06F12/0897 ,  G06F12/084 ,  G06F12/0864 ,  G06F12/126

Abstract: Disclosed herein are system, method, and computer program product embodiments for cache partitioning to accelerate concurrent workload performance of in-memory databases. An embodiment operates by storing a first bitmask, associating the first bitmask with a first processor core, setting a subset of the bits of the first bitmask, wherein the subset of the bits of the first bitmask represents a first portion of shared last-level cache, and wherein any part of the first bitmask excluding the subset of the bits of the first bitmask represents a second portion of the lowest-level cache, and disallowing eviction of any cache line in the second portion of the lowest-level cache by the first processor core.

公开(公告)号：US20240419660A1

公开(公告)日：2024-12-19

申请号：US18355679

申请日：2023-07-20

Applicant: SAP SE

Inventor： Stefan Noll ,  Paul Willems

IPC: G06F16/2452 ,  G06F16/2453 ,  G06F16/2455 ,  G06F16/2458

Abstract: In some implementations, there is provided a method that includes detecting in a query plan a pipeline that includes a last restart query operator that can cause a retry of the query plan during execution of the query plan; configuring the pipeline to execute the pipeline using an open call configuration, configuring at least one subsequent pipeline to execute in a fetch call configuration; executing the query plan including the pipeline in the open call configuration; sending, by the send operator, a message indicating the last restart query operator cannot cause a retry of the execution of the query plan; and causing execution of at least one operator in the subsequent pipeline to execute in the fetch call configuration, in which result streaming of partial results is allowed for the at least one operator.

公开(公告)号：US11947514B2

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

申请号：US17733507

申请日：2022-04-29

Applicant: SAP SE

Inventor： Stefan Noll ,  Paul Willems

IPC: G06F16/22 ,  G06F16/23 ,  G06F16/2453 ,  G06F16/2455 ,  G06F16/28

CPC classification number: G06F16/2282 ,  G06F16/2322 ,  G06F16/2329 ,  G06F16/24532 ,  G06F16/24564 ,  G06F16/285 ,  G06F16/288

Abstract: A method for processing non-standardized data in a relational database may include identifying, within a sequence of operations forming a query pipeline for executing a query, a first operation ingesting a non-standardized data. In response to identifying the first operation ingesting the non-standardized data, a second operation may be inserted before the first operation. The non-standardized data may be output by a third operation preceding the first operation or a source external to the query pipeline. The second operation may serialize the non-standardized data for ingestion by the first operation, for example, by generating a relational table populated by the non-standardized data. The query may be executed by performing the sequence of operations included in the query pipeline. Related systems and computer program products are also provided.

公开(公告)号：US20210216564A1

公开(公告)日：2021-07-15

申请号：US16739352

申请日：2020-01-10

Applicant: SAP SE

Inventor： Stefan Noll ,  Jens Teubner ,  Norman May ,  Alexander Boehm

IPC: G06F16/25 ,  G06F16/23

Abstract: The present disclosure involves systems, software, and computer implemented methods for efficient shared bulk loading into optimized storage. One example method includes identifying a data set on a client to load to a server. Load steps that can be performed either on the client or the server are identified. Values for load factors are determined. Load rules are determined that are based on load factors and are for determining processing locations for the load steps. A processing location of either the client or the server is determined for each load step, based on the load rules. Load steps that have a processing location of the client are executed on the data set, on the client. The data set is transferred from the client to the server, over a network. Load steps that have a processing location of the server are executed on the data set, at the server.