US 12,261,905 B2
Distributing dataset requests across service tiers
Robert C. Woollen, San Rafael, CA (US); and Max H. Seiden, San Francisco, CA (US)
Assigned to SIGMA COMPUTING, INC., San Francisco, CA (US)
Filed by SIGMA COMPUTING, INC., San Francisco, CA (US)
Filed on Apr. 4, 2023, as Appl. No. 18/295,410.
Prior Publication US 2024/0340337 A1, Oct. 10, 2024
Int. Cl. H04L 67/10 (2022.01); G06F 16/28 (2019.01); G06F 40/166 (2020.01); G06F 40/194 (2020.01)
CPC H04L 67/10 (2013.01) [G06F 16/283 (2019.01); G06F 40/166 (2020.01); G06F 40/194 (2020.01)] 12 Claims
OG exemplary drawing
 
1. A method for distributing dataset requests across service tiers, the method comprising:
prefetching data from a cloud-based data warehouse into a set of service tiers based on a prefetching policy;
generating, by a workbook client, a dataset request for a dataset to populate a workbook for presentation on a client computing system, including:
determining a fetch order for each portion of the dataset request; and
determining at least one selection policy associated with each portion of the dataset request;
determining, by the workbook client, the set of service tiers capable of servicing at least a portion of the dataset request, wherein the set of service tiers comprises the cloud-based data warehouse, and wherein data to service at least one portion of the dataset request exists on the cloud-based data warehouse and at least one service tier external to the cloud-based data warehouse;
selecting, by the workbook client from the set of service tiers, a combination of service tiers to service the dataset request based on the at least one selection policy;
issuing, by the workbook client, the dataset request to the selected combination of service tiers;
receiving the dataset from the selected combination of service tiers; and
populating the workbook on the client computing system with the dataset.