US 12,361,026 B2
Query alerts generation for virtual warehouse
Praveen Kandukuri, Ashburn, VA (US); Syed Salim, North Potomac, MD (US); Karamchandradatt Hardatt, Glen Allen, VA (US); Nagender Gurram, Glen Allen, VA (US); Ganesh Bharathan, Henrico, VA (US); and Yudhish Batra, Glen Allen, VA (US)
Assigned to Capital One Services, LLC, McLean, VA (US)
Filed by Capital One Services, LLC, McLean, VA (US)
Filed on Mar. 6, 2024, as Appl. No. 18/597,046.
Application 18/597,046 is a continuation of application No. 17/958,971, filed on Oct. 3, 2022, granted, now 11,954,128.
Application 17/958,971 is a continuation of application No. 17/374,479, filed on Jul. 13, 2021, granted, now 11,494,413, issued on Nov. 8, 2022.
Prior Publication US 2024/0211492 A1, Jun. 27, 2024
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/00 (2019.01); G06F 16/2453 (2019.01); G06F 16/2457 (2019.01); G06F 16/248 (2019.01); G06F 16/25 (2019.01); G06F 16/28 (2019.01)
CPC G06F 16/283 (2019.01) [G06F 16/24534 (2019.01); G06F 16/2457 (2019.01); G06F 16/248 (2019.01); G06F 16/256 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computing device comprising:
one or more processors; and
memory storing instructions that, when executed by the one or more processors, cause the computing device to:
receive, from a user device, a request to execute a query on at least one of a plurality of data warehouses;
predict, based on an execution plan for the query, a processing complexity of the query, wherein the processing complexity of the query indicates a quantity of computing resources required to execute the query;
determine, based on the processing complexity of the query and for each of a plurality of virtual warehouses, a plurality of predicted processing times, wherein each predicted processing time of the plurality of predicted processing times predicts how long a given virtual warehouse of the plurality of virtual warehouses will take to execute the query;
select, based on the plurality of predicted processing times, a first virtual warehouse, of the plurality of virtual warehouses, to execute the query, wherein each of the plurality of virtual warehouses comprises a respective set of computing resources;
modify, based on the plurality of predicted processing times and based on first computing resources available to the selected first virtual warehouse:
the query, and
a quantity of the first computing resources used to execute one or more other queries executing on the first virtual warehouse; and
cause the first virtual warehouse to execute the modified query.