US 12,353,422 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, Glen Allen, VA (US)
Assigned to Capital One Services, LLC, McLean, VA (US)
Filed by Capital One Services, LLC, McLean, VA (US)
Filed on Jun. 21, 2023, as Appl. No. 18/212,302.
Application 18/212,302 is a continuation of application No. 17/374,325, filed on Jul. 13, 2021, granted, now 11,669,529, issued on Jun. 6, 2023.
Prior Publication US 2023/0334052 A1, Oct. 19, 2023
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 17/00 (2019.01); G06F 9/50 (2006.01); G06F 16/2457 (2019.01); G06F 16/25 (2019.01); G06N 20/00 (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;
based on the processing complexity of the query and processing capabilities of the plurality of virtual warehouses, instantiate a new virtual warehouse different from the plurality of virtual warehouses; and
cause the new virtual warehouse to execute the query.