US 11,669,529 B2
Dynamic query allocation to virtual warehouses
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 Jul. 13, 2021, as Appl. No. 17/374,325.
Prior Publication US 2023/0020782 A1, Jan. 19, 2023
Int. Cl. G06F 17/00 (2019.01); G06F 16/2457 (2019.01); G06F 9/50 (2006.01); G06N 20/00 (2019.01); G06F 16/25 (2019.01)
CPC G06F 16/24575 (2019.01) [G06F 9/5005 (2013.01); G06F 16/256 (2019.01); G06N 20/00 (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 query and the execution plan, a processing complexity of the query;
identify a plurality of virtual warehouses, wherein each of the plurality of virtual warehouses comprises a respective set of computing resources configured to:
execute one or more queries with respect to at least a portion of the plurality of data warehouses;
collect results from the one or more queries; and
provide, to the user device, access to the collected results;
determine an operating status of the plurality of virtual warehouses;
determine processing capabilities of the plurality of virtual warehouses;
select a subset of the plurality of virtual warehouses based on the processing complexity, the operating status of the plurality of virtual warehouses, and the processing capabilities of the plurality of virtual warehouses;
receive, from the user device and from the subset of the plurality of virtual warehouses, a selection of a first virtual warehouse; and
cause the first virtual warehouse to execute the query.