公开(公告)号：US20240320202A1

公开(公告)日：2024-09-26

申请号：US18678357

申请日：2024-05-30

Applicant: Snowflake Inc.

Inventor： Vlad Bunescu ,  Joshua Klahr ,  Louis Magarshack ,  Shiyu Qu ,  Zerui Wei ,  Jiaqi Yan

IPC: G06F16/22 ,  G06F16/25

CPC classification number: G06F16/2228 ,  G06F16/254

Abstract: Methods, systems, and computer programs are described for tracking evaluation of workload stability through performance indexing. A plurality of metric source data is received by at least one hardware processor. Based on this data, a workload is identified as a stable workload candidate. A performance index is then generated, reflecting the characteristics of the identified stable workload candidate. The performance index is continuously tracked over a period of time, enabling the detection and analysis of any modifications to the workload and the subsequent impact on system performance.

公开(公告)号：US20240232019A1

公开(公告)日：2024-07-11

申请号：US18618273

申请日：2024-03-27

Applicant: Snowflake Inc.

Inventor： Vlad Bunescu ,  Yan Huang ,  Jaeha Lee ,  Shiyu Qu ,  Jiaqi Yan

IPC: G06F11/14 ,  G06F11/34 ,  G06F16/21

CPC classification number: G06F11/1433 ,  G06F11/3414 ,  G06F16/213 ,  G06F2201/80

Abstract: A method includes updating, by at least one hardware processor, a table with a detected regression associated with database code of a database. A first stored procedure is performed to determine a root cause of the detected regression. A second stored procedure is performed to determine an impact of the detected regression based at least on the root cause. A determination is made on whether to perform mitigation of the detected regression based on the impact.

公开(公告)号：US12026140B1

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

申请号：US18112198

申请日：2023-02-21

Applicant: Snowflake Inc.

Inventor： Vlad Bunescu ,  Joshua Klahr ,  Louis Magarshack ,  Shiyu Qu ,  Zerui Wei ,  Jiaqi Yan

IPC: G06F17/00 ,  G06F16/22 ,  G06F16/25

CPC classification number: G06F16/2228 ,  G06F16/254

Abstract: Methods, systems, and computer programs are presented for providing performance metrics in an online performance analysis system employing customer production workloads. A plurality of metric source data is received from a cloud data platform. A workload is identified as a stable workload candidate based at least in part on the plurality of metric source data. The cloud data platform generates a performance index based on the workload being identified as a stable workload candidate. The performance index is tracked over a period of time to identify changes in workload.

公开(公告)号：US11971783B1

公开(公告)日：2024-04-30

申请号：US18340528

申请日：2023-06-23

Applicant: Snowflake Inc.

Inventor： Vlad Bunescu ,  Yan Huang ,  Jaeha Lee ,  Shiyu Qu ,  Jiaqi Yan

IPC: G06F11/14 ,  G06F11/34 ,  G06F16/21

CPC classification number: G06F11/1433 ,  G06F11/3414 ,  G06F16/213 ,  G06F2201/80

Abstract: A method includes decoding, by at least one hardware processor, a notification of a changed database code of a database. A query is executed responsive to the notification. The query indicates a data processing command and a data object in the database. A regression in the changed database code is detected based on multiple regression testing operations applied to the data processing command and the data object. Analysis of the regression is performed to detect a rollout parameter of a plurality of rollout parameters as a root cause of the regression. The plurality of rollout parameters are associated with the changed database code. A determination is made on whether to perform a mitigation action for the regression based on the rollout parameter.

公开(公告)号：US11734116B1

公开(公告)日：2023-08-22

申请号：US18060848

申请日：2022-12-01

Applicant: Snowflake Inc.

Inventor： Vlad Bunescu ,  Yan Huang ,  Jaeha Lee ,  Shiyu Qu ,  Jiaqi Yan

IPC: G06F11/14 ,  G06F16/21 ,  G06F11/34

CPC classification number: G06F11/1433 ,  G06F11/3414 ,  G06F16/213 ,  G06F2201/80

Abstract: Provided herein are systems and methods for automating the rollout of database changes. For example, a method includes detecting a change in database code of a database resulting in a changed database code. The change in the database code includes a parameter rollout for at least one parameter setting of the database. Execution of a query associated with the change in the database code is monitored. The query uses the at least one parameter setting. A regression in the changed database code is detected based on the monitoring. Impact analysis is performed to determine a scope of impact of the regression on at least another query using the at least one parameter setting. A determination is made on whether to perform a rollback of the change in the database code or perform mitigation based on the scope of impact.