Query Alerts Generation for Virtual Warehouse

Patent metadata

Field	Value
Publication number	US-2025307267-A1
Application number	US-202519237925-A
Country	US
Kind code	A1
Filing date	Jun 13, 2025
Priority date	Jul 13, 2021
Publication date	Oct 2, 2025
Grant date	—

Abstract

Methods, systems, and apparatuses for generating notifications corresponding to queries submitted for execution by virtual warehouses are described herein. A request to execute a query may be received. An execution plan, for the query, may be identified. A processing complexity for the query may be predicted based on the query and the execution plan. A notification may be generated based on the processing complexity meeting an alert threshold. A user device may display the notification. A response to the notification comprising a selection of a first virtual warehouse, of a plurality of virtual warehouses, to execute the query may be received.

First claim

What is claimed is:

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;
select, based on a prediction of how long each virtual warehouse of a plurality of virtual warehouses will take to execute the query and based on a quantity of computing resources required to execute the query, 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 prediction of how long each virtual warehouse of the plurality of virtual warehouses will take to execute the query 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.

2 . The computing device of claim 1 , wherein the instructions, when executed by the one or more processors, further cause the computing device to:
identify the plurality of virtual warehouses; determine an operating status of the plurality of virtual warehouses; and determine processing capabilities of the plurality of virtual warehouses, wherein the prediction of how long each virtual warehouse of a plurality of virtual warehouses will take to execute the query is based on the operating status and the processing capabilities.

3 . The computing device of claim 1 , wherein the instructions, when executed by the one or more processors, further cause the computing device to modify the query by causing the computing device to remove one or more wildcard characters from the query.

4 . The computing device of claim 1 , wherein the instructions, when executed by the one or more processors, cause the computing device to:
cause output of a notification that comprises a cost corresponding to execution of the query, wherein the cost is based on a processing complexity of the query.

5 . The computing device of claim 1 , wherein the instructions, when executed by the one or more processors, further cause the computing device to select the first virtual warehouse by causing the computing device to:
identify the plurality of virtual warehouses; determine an operating status of the plurality of virtual warehouses; determine processing capabilities of the plurality of virtual warehouses; and select, based on the operating status, the prediction of how long each virtual warehouse of the plurality of virtual warehouses will take to execute the query, and the processing capabilities, the first virtual warehouse.

6 . The computing device of claim 1 , wherein the instructions, when executed by the one or more processors, cause the computing device to:
modify, based on a processing complexity of the query, a quantity of computing resources available to one or more servers that provide the first virtual warehouse.

7 . The computing device of claim 1 , wherein the instructions, when executed by the one or more processors, cause the computing device to:
determine a frequency of queries during a time period; and modify, based on the frequency, a size of the plurality of virtual warehouses.

8 . A method comprising:
receiving, from a user device, a request to execute a query on at least one of a plurality of data warehouses; selecting, based on a prediction of how long each virtual warehouse of a plurality of virtual warehouses will take to execute the query and based on a quantity of computing resources required to execute the query, 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; modifying, based on the prediction of how long each virtual warehouse of the plurality of virtual warehouses will take to execute the query 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
causing the first virtual warehouse to execute the modified query.

9 . The method of claim 8 , further comprising:
identifying the plurality of virtual warehouses; determining an operating status of the plurality of virtual warehouses; and determining processing capabilities of the plurality of virtual warehouses, wherein the prediction of how long each virtual warehouse of a plurality of virtual warehouses will take to execute the query is based on the operating status and the processing capabilities.

10 . The method of claim 8 , wherein the modifying the query comprises removing one or more wildcard characters from the query.

11 . The method of claim 8 , further comprising:
causing output of a notification that comprises a cost corresponding to execution of the query, wherein the cost is based on a processing complexity of the query.

12 . The method of claim 8 , further comprising:
identifying the plurality of virtual warehouses; determining an operating status of the plurality of virtual warehouses; determining processing capabilities of the plurality of virtual warehouses; and selecting, based on the operating status, the prediction of how long each virtual warehouse of the plurality of virtual warehouses will take to execute the query, and the processing capabilities, the first virtual warehouse.

13 . The method of claim 8 , further comprising:
modifying, based on a processing complexity of the query, a quantity of computing resources available to one or more servers that provide the first virtual warehouse.

14 . The method of claim 8 , further comprising:
determining a frequency of queries during a time period; and modifying, based on the frequency, a size of the plurality of virtual warehouses.

15 . One or more non-transitory computer-readable media storing instructions that, when executed by one or more processors of a computing device, 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; select, based on a prediction of how long each virtual warehouse of a plurality of virtual warehouses will take to execute the query and based on a quantity of computing resources required to execute the query, 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 prediction of how long each virtual warehouse of the plurality of virtual warehouses will take to execute the query 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.

16 . The one or more non-transitory computer-readable media of claim 15 , wherein the instructions, when executed by the one or more processors, further cause the computing device to:
identify the plurality of virtual warehouses; determine an operating status of the plurality of virtual warehouses; and dete

Assignees

• Capital One Services Llc

Inventors

• Kandukuri Praveen
• Salim Syed
• Hardatt Karamchandradatt
• Gurram Nagender
• Bharathan Ganesh
• Batra Yudhish

Classifications

• G06F16/24534 Primary

  Query rewriting; Transformation · CPC title

• G06F16/2457

  with adaptation to user needs · CPC title

• G06F16/248

  Presentation of query results · CPC title

• G06F16/256

  in federated or virtual databases · CPC title

• G06F16/283 Primary

  Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP · CPC title