US 12,265,532 B2
Accelerating query execution by optimizing data transfer between storage nodes and database nodes
Kamaljit Shergill, Maidenhead (GB); Ken Kumar, Karnataka (IN); Aurosish Mishra, Foster City, CA (US); and Shasank Kisan Chavan, Menlo Park, CA (US)
Assigned to Oracle International Corporation, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Nov. 30, 2022, as Appl. No. 18/072,222.
Claims priority of provisional application 63/416,462, filed on Oct. 14, 2022.
Prior Publication US 2024/0126750 A1, Apr. 18, 2024
Int. Cl. G06F 16/24 (2019.01); G06F 16/22 (2019.01); G06F 16/2453 (2019.01)
CPC G06F 16/2453 (2019.01) [G06F 16/2246 (2019.01)] 28 Claims
OG exemplary drawing
 
1. A method comprising:
receiving a database statement at a compute node;
transmitting, by the compute node, to a storage node, a set of one or more selection criteria that are associated with the database statement;
based on the database statement, retrieving, by the storage node, a set of data blocks from storage, wherein each data block of the set of data blocks comprises a plurality of rows of a database object;
applying, by the storage node, the set of one or more selection criteria to a data block in the set of data blocks, wherein applying the set of one or more selection criteria comprises generating a modified data block;
generating, by the storage node, for the modified data block, modified header data that is different than original header data of the data block;
after including the modified header data in the modified data block, transmitting the modified data block from the storage node to the compute node;
wherein the method is performed by one or more computing devices.