US 11,853,283 B2
Dynamic aggregate generation and updating for high performance querying of large datasets
Sarah Gerweck, San Mateo, CA (US); and David Ross, San Francisco, CA (US)
Assigned to AtScale, Inc., San Mateo, CA (US)
Filed by Atscale, Inc., San Mateo, CA (US)
Filed on Nov. 8, 2022, as Appl. No. 17/982,729.
Application 17/982,729 is a continuation of application No. 16/732,648, filed on Jan. 2, 2020, granted, now 11,494,362.
Application 16/732,648 is a continuation of application No. 14/945,430, filed on Nov. 19, 2015, granted, now 10,528,540, issued on Jan. 7, 2020.
Claims priority of provisional application 62/159,890, filed on May 11, 2015.
Prior Publication US 2023/0185790 A1, Jun. 15, 2023
Int. Cl. G06F 16/00 (2019.01); G06F 16/22 (2019.01); G06F 16/2455 (2019.01); G06F 16/2453 (2019.01); G06F 16/242 (2019.01); G06F 16/28 (2019.01)
CPC G06F 16/2282 (2019.01) [G06F 16/2264 (2019.01); G06F 16/244 (2019.01); G06F 16/24542 (2019.01); G06F 16/24556 (2019.01); G06F 16/283 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method comprising:
receiving a set of database query statements applied to a virtual multi-dimensional data model representing a subject database, the virtual multidimensional data model comprising virtual cube attributes derived from at least a portion of subject database metadata associated with the subject database;
generating a set of aggregate performance metrics associated with a set of recommended aggregates; and
selecting an aggregate from a set of recommended aggregates based on the aggregate performance metrics, the selected aggregate representing a set of raw data in the subject database referenced by at least one of the virtual cube attributes, the selected aggregate including a first of number of objects derived from the set of raw data, the first number of objects being fewer than a second number of objects associated with the set of raw data.