US 12,242,476 B2
Text searching using partial score expressions
Oliver Horn, Nussloch (DE); Wolfgang Stephan, Heidelberg (DE); Joerg Fellmann, Nussloch (DE); and Till Merker, Sandhausen (DE)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Jul. 24, 2023, as Appl. No. 18/357,920.
Prior Publication US 2025/0036619 A1, Jan. 30, 2025
Int. Cl. G06F 16/2453 (2019.01); G06F 16/2457 (2019.01)
CPC G06F 16/24537 (2019.01) [G06F 16/24542 (2019.01); G06F 16/24578 (2019.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 to search for a search term in at least a first column of a first table and a second column of a second table;
scanning the first column and the second column for at least a portion of the search term;
generating a first partial score table including a first identifier and a first partial score determined for each row in the first column containing at least the portion of the search term;
generating a second partial score table including a second identifier and a second partial score for each row in the second column containing at least the portion of the search term;
determining a combined score for each row in the first column and/or the second column containing at least the portion of the search term based at least on a join of the first partial score table and the second partial score table; and
providing, in response to the query and based at least on the combined score, a row of the first column and/or the second column including at least the portion of the search term.