US 11,693,857 B1
Managed tuning for data clouds
Alekh Jindal, Sammamish, WA (US); Barzan Mozafari, Ypsilanti, MI (US); Yongjoo Park, Champaign, IL (US); David Wolfgang Grömling, Frankfurt am Main (DE); Brian Westphal, Ypsilanti, MI (US); and Alan D. Cabrera, San Francisco, CA (US)
Assigned to Keebo Inc., Ypsilanti, MI (US)
Filed by Keebo Inc., Ypsilanti, MI (US)
Filed on Jun. 22, 2022, as Appl. No. 17/846,813.
Int. Cl. G06F 15/16 (2006.01); G06F 16/2453 (2019.01); G06F 16/21 (2019.01)
CPC G06F 16/24545 (2019.01) [G06F 16/217 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method to configure a data warehouse system, comprising:
obtaining, by a configuration management system, historical query workload metadata associated with a data warehouse from the data warehouse system;
determining, based on the historical query workload metadata, a predictive schedule that includes a first configuration setting associated with a configurable parameter for a first time period, wherein the first time period is a future time period, and wherein the first configuration setting is associated with a lower computing resource utilization at the data warehouse system when compared to a previous configuration setting, wherein the configurable parameter is an auto-suspend interval, and wherein determining the first configuration setting for the auto-suspend interval for the first time period comprises:
determining a plurality of time intervals between a time of completion of a first query and a time of arrival of a second query that immediately follows the first query for queries included in the historical query workload metadata; and
setting the first configuration setting to a minimum auto-suspend interval whereby a number of affected queries meets an affected queries threshold, wherein an affected query is a query with an associated time interval that exceeds a corresponding auto-suspend interval;
transmitting, to the data warehouse system, the first configuration setting for the configurable parameter;
receiving, from the data warehouse system, during the first time period, query workload metadata;
determining, based on the query workload metadata, whether the query workload metadata meets a threshold performance; and
based on a determination that the query workload metadata does not meet the threshold performance, transmitting a backoff configuration setting for the configurable parameter to the data warehouse system.