US 12,189,645 B2
Methods and systems for generating recommendations in cloud-based data warehousing system
Hiren Shah, Stafford, CA (US); Ganesh Bharathan, Henrico, VA (US); Sridhar Maramreddy, Glen Allen, VA (US); Naga Venkata Sriram Vadakattu, Frisco, TX (US); Naveen Kumar Kilaru, Little Elm, TX (US); Nicole Ann Luo, Frisco, TX (US); David Ellis, San Diego, CA (US); Felix Li, Pittsburgh, PA (US); Yudhish Batra, Glen Allen, VA (US); Kishore Kolanu, Glen Allen, VA (US); and Fnu Syed Siraj Mehmood, Aldie, VA (US)
Assigned to Capital One Services, LLC, McLean, VA (US)
Filed by Capital One Services, LLC, McLean, VA (US)
Filed on Oct. 12, 2022, as Appl. No. 17/964,215.
Claims priority of provisional application 63/351,325, filed on Jun. 10, 2022.
Prior Publication US 2023/0409590 A1, Dec. 21, 2023
Int. Cl. G06F 16/25 (2019.01)
CPC G06F 16/252 (2019.01) 20 Claims
OG exemplary drawing
 
1. A method comprising:
receiving, by a first computing device associated with a first data manager account hosted in a first cloud region of a cloud-based data warehouse system, a request to collect data from one or more client accounts associated with a first client and hosted by the cloud-based data warehouse system;
sending, by the first computing device and to a second computing device associated with a first client account, from the one or more client accounts associated with the first client, first instructions for the second computing device to share, with a second data manager account hosted in a second cloud region of the cloud-based data warehouse system, data from the first client account;
sending, by the first computing device and to a third computing device associated with the second data manager account, second instructions for the third computing device to replicate the shared data to the first data manager account, upon receiving an indication that the shared data is accessible;
receiving, by the first computing device, an indication that the shared data has been replicated;
storing, by the first computing device, based on the indication that the shared data has been replicated, the shared data in a database associated with the first data manager account;
causing an analysis of the stored shared data to determine one or more new data warehouse resources since a previous request to collect the data;
retrieving, by the first computing device, configuration information associated with a plurality of recommendation algorithms associated with the first client, wherein the configuration information indicates an execution frequency for each of the plurality of recommendation algorithms;
retrieving, by the first computing device, information indicating a last execution date for each of the plurality of recommendation algorithms;
determining, by the first computing device and based on the configuration information, the execution frequency of each of the plurality of recommendation algorithms, and the last execution date for each of the plurality of recommendation algorithms, that a first recommendation algorithm of the plurality of recommendation algorithms is scheduled for execution;
causing, by the first computing device and using the stored shared data, execution of the first recommendation algorithm;
receiving, by the first computing device and based on the execution of the first recommendation algorithm, at least one recommendation associated with a first data warehouse associated with the first client, wherein the at least one recommendation comprising a recommendation of a set of operating parameters to be associated with the one or more new data warehouse resources; and
outputting, by the first computing device, the at least one recommendation.