CPC G06F 16/24561 (2019.01) [G06F 16/244 (2019.01); G06F 16/2423 (2019.01); G06F 16/2453 (2019.01)] | 20 Claims |
1. A method for aggregate query optimization, comprising:
receiving a dataset comprising a plurality of values divided into a plurality of dimensions and a plurality of measurements;
for a plurality of iterations respective of a plurality of combinations of values of the plurality of dimensions, calculating and storing for at least one aggregate measurement of interest and a respective one of the plurality of combinations a pre-calculated value obtained by calculating at least one aggregate of respective values of a measurement of the plurality of measurements;
in response to receiving an input comprising a first set of one or more of the plurality of dimensions and a second set of one or more of the at least one aggregate measurement of interest, calculating and outputting for a respective member of the second set a respective aggregate result value by retrieving for the respective member of the second set the pre-calculated value respective of members of the first set.
|