公开(公告)号：US20220083534A1

公开(公告)日：2022-03-17

申请号：US17536180

申请日：2021-11-29

Applicant: Snowflake Inc.

Inventor： Benoit Dageville ,  Johan Harjono ,  Kunal Prafulla Nabar ,  Steven James Pelley

IPC: G06F16/23 ,  G06F16/2455

Abstract: Systems, methods, and devices for retrying a query. A method includes receiving a query directed to database data and assigning execution of the query to one or more execution nodes of an execution platform, the one or more execution nodes configured to execute the query on a first version of a database platform. The method includes determining that execution of the query was unsuccessful. The method includes assigning a first retry execution of the query to the one or more execution nodes of the execution platform and determining whether a regression or an intermittent fault caused the execution of the query to be unsuccessful based at least in part on whether the first retry execution of the query was successful or unsuccessful.

公开(公告)号：US11216446B2

公开(公告)日：2022-01-04

申请号：US16555970

申请日：2019-08-29

Applicant: Snowflake Inc.

Inventor： Benoit Dageville ,  Johan Harjono ,  Kunal Prafulla Nabar ,  Steven James Pelley

IPC: G06F16/23 ,  G06F16/2455

Abstract: Systems, methods, and devices for retrying a query. A method includes receiving a query directed to database data and assigning execution of the query to one or more execution nodes of an execution platform, the one or more execution nodes configured to execute the query on a first version of a database platform. The method includes determining that execution of the query was unsuccessful. The method includes assigning a first retry execution of the query to the one or more execution nodes of the execution platform and determining whether a regression or an intermittent fault caused the execution of the query to be unsuccessful based at least in part on whether the first retry execution of the query was successful or unsuccessful.

公开(公告)号：US11099962B2

公开(公告)日：2021-08-24

申请号：US17200740

申请日：2021-03-12

Applicant: Snowflake Inc.

Inventor： Benoit Dageville ,  Johan Harjono ,  Simon Holm Jensen ,  Kunal Prafulla Nabar ,  Steven James Pelley

IPC: G06F11/30 ,  G06F11/32 ,  G06F16/248 ,  G06F16/2458 ,  G06F16/242 ,  G06F11/34 ,  G06F11/14

Abstract: Systems, methods, and devices for retrying a query. The method includes receiving from a client a query directed to database data stored on a database platform the query being received by a first component of the database platform. The method includes making by the first component an attempt to execute the query and based on determining that the attempt to execute the query was unsuccessful, the first component sending a query retry job to a second component of the database platform. The method includes selecting by the second component based at least in part on the indicated version of the database platform a version of the database platform on which to attempt a first retry attempt to execute the query.

公开(公告)号：US11055193B2

公开(公告)日：2021-07-06

申请号：US17082993

申请日：2020-10-28

Applicant: Snowflake Inc.

Inventor： Benoit Dageville ,  Johan Harjono ,  Simon Holm Jensen ,  Kunal Prafulla Nabar ,  Steven James Pelley

IPC: G06F11/30 ,  G06F11/32 ,  G06F16/248 ,  G06F16/2458 ,  G06F16/242 ,  G06F11/34 ,  G06F11/14

Abstract: Systems, methods, and devices for automatically retrying a query. A method includes receiving a query directed to database data and assigning execution of the query to one or more execution nodes of a database platform. The method includes determining that execution of the query was unsuccessful. The method includes assigning a first retry execution of the query on the first version of the database platform and assigning a second retry execution of the query on a second version of the database platform.

公开(公告)号：US20210124664A1

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

申请号：US17142962

申请日：2021-01-06

Applicant: Snowflake Inc.

Inventor： Benoit Dageville ,  Johan Harjono ,  Simon Holm Jensen ,  Kunal Prafulla Nabar ,  Steven James Pelley

IPC: G06F11/30 ,  G06F16/2458 ,  G06F16/242 ,  G06F11/32 ,  G06F11/14 ,  G06F16/248 ,  G06F11/34

Abstract: Disclosed herein are systems and methods for query-attempt assignment in a database environment. In an embodiment, a database platform includes first and second database query managers respectively configured to manage external and internal tasks of the database platform. The first database query manager receives a query directed to database data in a client account of the database platform, and an attempt to execute the query is assigned to one or more execution nodes. Based on determining that the attempt was unsuccessful, the database platform transfers the query to the second database manager, which assigns a first retry attempt to execute the query to one or more execution nodes.

公开(公告)号：US20210064497A1

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

申请号：US16555951

申请日：2019-08-29

Applicant: Snowflake Inc.

Inventor： Benoit Dageville ,  Johan Harjono ,  Simon Holm Jensen ,  Kunal Prafulla Nabar ,  Steven James Pelley

IPC: G06F11/30 ,  G06F16/242 ,  G06F16/2458 ,  G06F16/248 ,  G06F11/34 ,  G06F11/32

Abstract: Systems, methods, and devices for automatically retrying a query. A method includes receiving a query directed to database data and assigning execution of the query to one or more execution nodes of a database platform. The method includes determining that execution of the query was unsuccessful. The method includes assigning a first retry execution of the query on the first version of the database platform and assigning a second retry execution of the query on a second version of the database platform.

公开(公告)号：US12164405B2

公开(公告)日：2024-12-10

申请号：US18160720

申请日：2023-01-27

Applicant: Snowflake Inc.

Inventor： Benoit Dageville ,  Johan Harjono ,  Simon Holm Jensen ,  Kunal Prafulla Nabar ,  Steven James Pelley

IPC: G06F11/30 ,  G06F11/34 ,  G06F16/242 ,  G06F16/2458

Abstract: Techniques for automated query retry in a database platform include decoding, by at least one hardware processor, a query directed to database data. The query is received by a first management node from a client account of a database system. The method further includes configuring an execution of the query by a first computing node associated with the first management node. The method includes detecting the execution of the query results in a failed execution. The query is transferred from the first management node to a second management node based on the failed execution. The second management node is configured to process tasks that are internal to the database system. A retry execution of the query by a second computing node is configured. The second computing node is associated with the second management node. A cause of the failed execution is determined based on a result of the retry execution.

公开(公告)号：US20240061709A1

公开(公告)日：2024-02-22

申请号：US18497260

申请日：2023-10-30

Applicant: Snowflake, Inc.

Inventor： Johan Harjono ,  Daniel Geoffrey Karp ,  Kunal Prafulla Nabar ,  Rares Radut ,  Arthur Kelvin Shi

IPC: G06F9/50 ,  G06F9/355

CPC classification number: G06F9/5005 ,  G06F9/3555 ,  G06F9/505 ,  G06F9/5077 ,  G06F9/5083

Abstract: Techniques described herein can optimize usage of computing resources in a data system. Dynamic throttling can be performed locally on a computing resource in the foreground and autoscaling can be performed in a centralized fashion in the background. Dynamic throttling can lower the load without overshooting while minimizing oscillation and reducing the throttle quickly. Autoscaling may involve scaling in or out the number of computing resources in a cluster as well as scaling up or down the type of computing resources to handle different types of situations.

公开(公告)号：US11842215B2

公开(公告)日：2023-12-12

申请号：US18161044

申请日：2023-01-28

Applicant: Snowflake Inc.

Inventor： Johan Harjono ,  Daniel Geoffrey Karp ,  Kunal Prafulla Nabar ,  Rares Radut ,  Arthur Kelvin Shi

IPC: G06F9/50 ,  G06F9/355

CPC classification number: G06F9/5005 ,  G06F9/3555 ,  G06F9/505 ,  G06F9/5077 ,  G06F9/5083

Abstract: Techniques described herein can optimize usage of computing resources in a data system. Dynamic throttling can be performed locally on a computing resource in the foreground and autoscaling can be performed in a centralized fashion in the background. Dynamic throttling can lower the load without overshooting while minimizing oscillation and reducing the throttle quickly. Autoscaling may involve scaling in or out the number of computing resources in a cluster as well as scaling up or down the type of computing resources to handle different types of situations.

公开(公告)号：US11599389B2

公开(公告)日：2023-03-07

申请号：US17463366

申请日：2021-08-31

Applicant: Snowflake Inc.

Inventor： Johan Harjono ,  Daniel Geoffrey Karp ,  Kunal Prafulla Nabar ,  Rares Radut ,  Arthur Kelvin Shi

IPC: G06F9/50

Abstract: Techniques described herein can optimize usage of computing resources in a data system. Dynamic throttling can be performed locally on a computing resource in the foreground and autoscaling can be performed in a centralized fashion in the background. Dynamic throttling can lower the load without overshooting while minimizing oscillation and reducing the throttle quickly. Autoscaling may involve scaling in or out the number of computing resources in a cluster as well as scaling up or down the type of computing resources to handle different types of situations.