US 11,860,906 B2
Partition-local partition value identifier grouping
Andreas Amler, Heidelberg (DE); Jonathan Dees, Heidelberg (DE); and Till Merker, Sandhausen (DE)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on May 16, 2022, as Appl. No. 17/745,741.
Prior Publication US 2023/0367791 A1, Nov. 16, 2023
Int. Cl. G06F 16/00 (2019.01); G06F 16/28 (2019.01); G06F 16/27 (2019.01)
CPC G06F 16/285 (2019.01) [G06F 16/278 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A system, comprising:
at least one data processor; and
at least one memory storing instructions which, when executed by the at least one data processor, result in operations comprising:
generating a partition value identifier for a partitioned table comprising: a main fragment including a main dictionary storing a first mapping between a first value and a main value identifier corresponding to the first value; and a delta fragment including a delta dictionary storing a second mapping between a second value and a delta value identifier corresponding to the second value, wherein the delta value identifier is different from the main value identifier; wherein generating the partition value identifier comprises: setting the partition value identifier based at least in part on the first value and the second value;
maintaining a mapping between the generated partition value identifier and a corresponding one of the main value identifier and the delta value identifier;
receiving a query including a request to group data stored in the partitioned table across the main fragment and the delta fragment; and
executing the query by at least using the mapping.