Patent ID: 11893027
Assignee: DATORAMA TECHNOLOGIES LTD.
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 10:
11. A computer program product comprising:
a non-transitory computer readable storage medium;
program instructions for executing, by a processor, a method for aggregate query optimization, the method 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.