US 11,954,128 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, McLean, VA (US)
Assigned to Capital One Services, LLC, McLean, VA (US)
Filed by Capital One Services, LLC, McLean, VA (US)
Filed on Oct. 3, 2022, as Appl. No. 17/958,971.
Application 17/958,971 is a continuation of application No. 17/374,479, filed on Jul. 13, 2021, granted, now 11,494,413.
Prior Publication US 2023/0028478 A1, Jan. 26, 2023
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;
identify an execution plan for the query by determining one or more sub-queries to be executed with respect to one or more of the plurality of data warehouses;
predict, based on the 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; and
cause the first virtual warehouse to execute the query.