公开(公告)号：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.

公开(公告)号：US11921716B1

公开(公告)日：2024-03-05

申请号：US18453079

申请日：2023-08-21

Applicant: Snowflake Inc.

Inventor： Hossein Ahmandi ,  Jayanta Das ,  Joshua Klahr ,  Boyung Lee ,  Wenye Li ,  Abdul Q. Munir ,  Yi Pan

IPC: G06F16/00 ,  G06F16/2453 ,  G06F16/2455 ,  G06F16/27

CPC classification number: G06F16/24537 ,  G06F16/2456 ,  G06F16/278 ,  G06F16/24544

Abstract: A method includes parsing a query to determine a plurality of data processing operations associated with the query and including an AS OF JOIN operation between first time series data in a first table and second time series data in a second table. A query plan of the query is generated. The query plan includes a plurality of nodes corresponding to the plurality of data processing operations. At least one of the plurality of nodes corresponding to the AS OF JOIN operation is modified to generate a modified query plan of the query. The modifying is based on applying a UNION operation on at least a first portion of column data in the first table and the second table to obtain a combined table. Execution of the query by at least one of a plurality of computing nodes is scheduled based on the modified query plan.

公开(公告)号：US20250068628A1

公开(公告)日：2025-02-27

申请号：US18392385

申请日：2023-12-21

Applicant: Snowflake Inc.

Inventor： Hossein Ahmandi ,  Jayanta Das ,  Joshua Klahr ,  Boyung Lee ,  Wenye Li ,  Abdul Q. Munir ,  Yi Pan

IPC: G06F16/2453 ,  G06F16/2455 ,  G06F16/27

Abstract: A method includes generating, by at least one hardware processor, a query plan of a query. The query includes a JOIN operation between first time series data and second time series data. At least one node in the query plan corresponding to the JOIN operation is modified to generate a modified query plan. The modifying is based on replacing the at least one node with a new node including a UNION operation. The UNION operation is based on the first time series data and the second time series data. Execution of the query is scheduled based on the modified query plan.

公开(公告)号：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.