公开(公告)号：US20250013574A1

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

申请号：US18348225

申请日：2023-07-06

Applicant: SAP SE

Inventor： Canberk Morelli ,  Paul Willems

IPC: G06F12/0888 ,  G06F12/0893 ,  G06F16/2455

Abstract: A system and/or method for spill-to-disk in projection operations includes receiving a query including a projection, receiving a plurality of rows in response to the query processed by a processing thread of a plurality of processing threads, determining whether the query specifies an order for the plurality of rows, determining whether a disk buffer associated with the processing thread contains a stored row in response to the query specifying the order, storing the plurality of rows in the disk buffer in response to determining the disk buffer contains the stored row, storing the plurality of rows in a memory buffer associated with the processing thread in response to determining the disk buffer does not contain the stored row and the memory buffer contains at least a threshold amount of memory to store the plurality of rows, and providing the stored plurality of rows in response to the query.

公开(公告)号：US12204546B2

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

申请号：US17945599

申请日：2022-09-15

Applicant: SAP SE

Inventor： Canberk Morelli ,  Till Merker

IPC: G06F16/2455 ,  G06F11/34 ,  G06F16/2453

Abstract: Described herein are systems and method for providing data transfer in a computer-implemented database from a database extension layer. A data server associated with a database receives a request to transfer data stored in a database extension layer of the database. Input data chunks are collected from the database extension layer until a configured row count limit is reached. Row positions are determined from the input data chunks. Value identifiers corresponding to the row positions are determined. Values corresponding to the value identifiers are retrieved. Output data is generated based on the values corresponding to the value identifiers.

公开(公告)号：US20240095248A1

公开(公告)日：2024-03-21

申请号：US17945599

申请日：2022-09-15

Applicant: SAP SE

Inventor： Canberk Morelli ,  Till Merker

IPC: G06F16/2455 ,  G06F11/34 ,  G06F16/2453

CPC classification number: G06F16/24561 ,  G06F11/3419 ,  G06F16/24542 ,  G06F16/24552

Abstract: Described herein are systems and method for providing data transfer in a computer-implemented database from a database extension layer. A data server associated with a database receives a request to transfer data stored in a database extension layer of the database. Input data chunks are collected from the database extension layer until a configured row count limit is reached. Row positions are determined from the input data chunks. Value identifiers corresponding to the row positions are determined. Values corresponding to the value identifiers are retrieved. Output data is generated based on the values corresponding to the value identifiers.