US 11,914,593 B2
Generate digital signature of a query execution plan using similarity hashing
Sweta Singh, Bangalore (IN); Vaibhav Murlidhar Kulkarni, Bangalore (IN); Mario Dominic Savio Briggs, Bangalore (IN); Deepak Anil Mahajan, Jamner (IN); and Eitan Daniel Farchi, Haifa (IL)
Assigned to INTERNATIONAL BUSINESS MACHINES CORPORATION, Armonk, NY (US)
Filed by INTERNATIONAL BUSINESS MACHINES CORPORATION, Armonk, NY (US)
Filed on Apr. 22, 2022, as Appl. No. 17/726,795.
Prior Publication US 2023/0342356 A1, Oct. 26, 2023
Int. Cl. G06F 16/2453 (2019.01)
CPC G06F 16/24542 (2019.01) [G06F 16/24539 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method comprising:
generating a node digital signature for nodes in a query;
generating an edge digital signature for edges in the query, the edges connecting the nodes;
selecting at least one previously executed query based on the node digital signature and the edge digital signature for the query; and
causing the query to be processed according to an assignment associated with the at least one previously executed query, wherein the at least one previously executed query has another node digital signature and another edge digital signature, the selecting further comprising determining that the assignment of the at least one previously executed query is to be utilized for processing the query based, at least in part, on the another node digital signature.