US 12,380,078 B1
Calculated dictionary column readers
Nico Bohnsack, Ingersleben (DE); Andreas Amler, Heidelberg (DE); Paul Willems, Heidelberg (DE); and Manuel Mayr, Walldorf (DE)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Jun. 3, 2024, as Appl. No. 18/732,160.
Int. Cl. G06F 16/22 (2019.01); G06F 16/21 (2019.01); G06F 16/2455 (2019.01)
CPC G06F 16/221 (2019.01) [G06F 16/212 (2019.01); G06F 16/2456 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A system, comprising:
at least one processor; and
at least one memory storing instructions, which when executed by the at least one processor, result in operations comprising:
generating a virtual column by applying a structured query language operation on distinct values in a column of data in a table;
populating the virtual column with corresponding precalculated values based on applying the structured query language operation;
compressing the virtual column with dictionary-based compression, the compressing comprising generating a column of value identifiers, each of the value identifiers representing a distinct value in the column of data;
receiving a database query against the compressed virtual column; and
returning a result of the database query by retrieving one or more of the precalculated values from the compressed virtual column.