US 12,105,710 B2
Preferred storage of aggregate data items
Daryl Odnert, Los Altos, CA (US); Patrick J. Toole, Wellington, FL (US); Sarah Gerweck, San Mateo, CA (US); Joseph Barefoot, San Fransico, CA (US); and Rouzbeh Safaie, San Francisco, CA (US)
Assigned to AtScale, Inc., Boston, MA (US)
Filed by AtScale, Inc., San Mateo, CA (US)
Filed on Apr. 25, 2023, as Appl. No. 18/139,077.
Claims priority of provisional application 63/334,329, filed on Apr. 25, 2022.
Prior Publication US 2023/0342360 A1, Oct. 26, 2023
Int. Cl. G06F 16/24 (2019.01); G06F 16/2453 (2019.01); G06F 16/2455 (2019.01); G06F 16/28 (2019.01)
CPC G06F 16/24544 (2019.01) [G06F 16/24561 (2019.01); G06F 16/283 (2019.01)] 17 Claims
OG exemplary drawing
 
1. In a multidimensional database having a plurality of data sources at different network locations, each network location contributing one or more fields for satisfying a query request, a method for generating and storing aggregates, comprising:
identifying a plurality of data sources used in satisfying a query request, each data source of the plurality of date sources located in a distinct network location of the network;
determining an aggregate defined by a portion of data in one or more of the data sources of the plurality of data sources used in satisfying the query;
receiving a designation of a preferred aggregate store, the preferred aggregate store having a more favorable access path than the data source from which the determined aggregate emanates;
identifying, for each of the plurality of data sources, a network cost associated with obtaining a respective portion of data in each of the plurality of data sources;
designating the preferred aggregate store from the data source corresponding to the lowest network cost from among the plurality of data sources having a portion of the data for satisfying the query; and
computing the aggregate by moving the corresponding portion of data in one or more of the data sources of the plurality of data sources to the preferred aggregate store for satisfying the query request.