US 12,105,707 B2
Transformation of property-value table to facilitate search
Dietmar Henkes, Schwetzingen (DE)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Oct. 29, 2021, as Appl. No. 17/452,814.
Prior Publication US 2023/0138283 A1, May 4, 2023
Int. Cl. G06F 16/24 (2019.01); G06F 16/22 (2019.01); G06F 16/2453 (2019.01)
CPC G06F 16/24544 (2019.01) [G06F 16/221 (2019.01); G06F 16/2282 (2019.01)] 18 Claims
OG exemplary drawing
 
1. A system comprising:
a memory storing processor-executable program code; and
a processing unit to execute the processor-executable program code in order to cause the system to:
identify first distinct values of a key column of a property-value table;
create a new table including a new key column, the new key column populated with only one of each of the identified first distinct values;
identify second distinct values of a property column of the property-value table;
create only one property column of the new table for each of the identified second distinct values;
populate each cell of the property columns with a value of the property-value table associated with the first distinct value of the row of the cell and the second distinct value of the property column of the cell in the property-value table; and
after population of each cell of the property columns:
receive a search query including the property-value table from a requestor computing system;
identify the new table as a search table of the property-value table;
execute the search query on the new table; and
return a result of the executed search query to the requestor computing system via one or more computing networks.