公开(公告)号：US20230289367A1

公开(公告)日：2023-09-14

申请号：US18321564

申请日：2023-05-22

Applicant: Snowflake Inc.

Inventor： Benoit DAGEVILLE ,  Thierry CRUANES ,  Marcin ZUKOWSKI

IPC: G06F16/27 ,  G06F9/50 ,  G06F16/14 ,  G06F16/21 ,  G06F16/22 ,  G06F16/951 ,  G06F16/182 ,  G06F16/23 ,  G06F16/2455 ,  G06F16/2458 ,  G06F16/9535 ,  G06F16/2453 ,  H04L67/568 ,  G06F16/28 ,  G06F16/25 ,  A61F5/56 ,  G06F9/48 ,  H04L67/1095 ,  H04L67/1097

CPC classification number: G06F16/27 ,  G06F9/5016 ,  G06F16/148 ,  G06F16/211 ,  G06F16/221 ,  G06F16/951 ,  G06F16/1827 ,  G06F16/2365 ,  G06F16/2456 ,  G06F16/2471 ,  G06F16/9535 ,  G06F16/24532 ,  G06F16/24545 ,  G06F16/24552 ,  H04L67/568 ,  G06F16/283 ,  G06F16/254 ,  A61F5/566 ,  G06F9/4881 ,  G06F9/5088 ,  H04L67/1095 ,  G06F9/5044 ,  H04L67/1097 ,  G06F9/5083

Abstract: A system and method of scaling capacity of data warehouses to user-defined levels. The method includes monitoring a processing of one or more queries by a data warehouse, the data warehouse including one or more processing resources and a storage platform. The method includes receiving a request to process database data stored on the storage platform. The method includes determining a performance of the processed request as observed by a user device. The method includes adjusting, by a processing device, a timing associated with the processing of the one or more queries based on the performance of the processed request.

公开(公告)号：US20210124761A1

公开(公告)日：2021-04-29

申请号：US17141220

申请日：2021-01-04

Applicant: Snowflake Inc.

Inventor： Thierry CRUANES ,  Benoit DAGEVILLE ,  Marcin ZUKOWSKI

IPC: G06F16/27 ,  G06F9/50 ,  G06F16/14 ,  G06F16/21 ,  G06F16/22 ,  G06F16/951 ,  G06F16/182 ,  G06F16/23 ,  G06F16/2455 ,  G06F16/2458 ,  G06F16/9535 ,  G06F16/2453 ,  G06F9/48 ,  H04L29/08

Abstract: A method and apparatus managing a set of processors for a set of queries is described. In an exemplary embodiment, a device receives a set of queries for a data warehouse, the set of queries including one or more queries to be processed by the data warehouse. The device further provisions a set of processors from a first plurality of processors, where the set of processors to process the set of queries, and a set of storage resources to store data for the set of queries. In addition, the device monitors a utilization of the set of processors as the set of processors processes the set of queries. The device additionally updates a number of the processors in the set of processors provisioned based on the utilization/ Furthermore, the device processes the set of queries using the updated set of processors.

公开(公告)号：US20200257703A1

公开(公告)日：2020-08-13

申请号：US16861790

申请日：2020-04-29

Applicant: Snowflake Inc.

Inventor： Benoit DAGEVILLE ,  Thierry CRUANES ,  Marcin ZUKOWSKI

IPC: G06F16/27 ,  G06F16/14 ,  G06F16/2453 ,  H04L29/08 ,  G06F16/951 ,  G06F16/182 ,  G06F16/9535 ,  G06F16/21 ,  G06F16/2455 ,  G06F9/50 ,  G06F16/23 ,  G06F16/22 ,  G06F16/2458 ,  G06F9/48

Abstract: Example resource provisioning systems and methods are described. In one implementation, multiple processing resources are provided within a data warehouse. The processing resources include at least one processor and at least one storage device. At least one query to process database data is received. At least some of the processing resources may process the database data. When a processing capacity of the processing resources has reached a threshold processing capacity, the processing capacity is automatically scaled by adding at least one additional processor to the data warehouse.

公开(公告)号：US20200226148A1

公开(公告)日：2020-07-16

申请号：US16827103

申请日：2020-03-23

Applicant: Snowflake Inc.

Inventor： Benoit DAGEVILLE ,  Thierry CRUANES ,  Marcin ZUKOWSKI

IPC: G06F16/27 ,  G06F16/951 ,  G06F9/48 ,  G06F9/50 ,  H04L29/08 ,  G06F16/182 ,  G06F16/9535 ,  G06F16/21 ,  G06F16/2455 ,  G06F16/23 ,  G06F16/22 ,  G06F16/2453 ,  G06F16/2458 ,  G06F16/14

Abstract: Example resource provisioning systems and methods are described. In one implementation, multiple processing resources are provided within a data warehouse. The processing resources include at least one processor and at least one storage device. At least one query to process database data is received. At least some of the processing resources may process the database data. When a processing capacity of the processing resources has reached a threshold processing capacity, the processing capacity is automatically scaled by adding at least one additional processor to the data warehouse.