US 12,298,911 B2
Spill-to-disk in projection operations
Canberk Morelli, Mannheim (DE); and Paul Willems, Heidelberg (DE)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Jul. 6, 2023, as Appl. No. 18/348,225.
Prior Publication US 2025/0013574 A1, Jan. 9, 2025
Int. Cl. G06F 7/00 (2006.01); G06F 12/0888 (2016.01); G06F 12/0893 (2016.01); G06F 16/2455 (2019.01)
CPC G06F 12/0888 (2013.01) [G06F 12/0893 (2013.01); G06F 16/24554 (2019.01); G06F 2212/163 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A system, comprising:
at least one data processor; and
at least one memory result in operations comprising:
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;
in response to the query specifying the order, determining whether a disk buffer associated with the processing thread contains a stored row;
in response to determining the disk buffer contains the stored row, storing the plurality of rows in the disk buffer;
in response to determining the disk buffer does not contain the stored row and a memory buffer contains at least a threshold amount of memory to store the plurality of rows, storing the plurality of rows in the memory buffer associated with the processing thread; and
providing the stored plurality of rows in response to the query.