公开(公告)号：US20250005022A1

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

申请号：US18656008

申请日：2024-05-06

Applicant: Snowflake Inc.

Inventor： Fabio Angius ,  Chen Luo ,  Sarvesh Singh

IPC: G06F16/2453 ,  G06F16/23 ,  G06F16/28

Abstract: Techniques for multi database query processing are described. Objects located in a plurality of databases referenced in a query can be compiled. A connection string based on the compiled objects can be generated. The connection string can include mapping information related to the related to the plurality of databases and cluster information of where the plurality of databases are stored in the network-based data system. The connection string can then be included in a query plan to allow for execution of the query plan using the connection string to access the objects in the plurality of databases.

公开(公告)号：US20240104082A1

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

申请号：US18326619

申请日：2023-05-31

Applicant: Snowflake Inc.

Inventor： Lin Chan ,  Krishna B. Nibhanupudi ,  Sahaj Saini ,  Sarvesh Singh

IPC: G06F16/23

CPC classification number: G06F16/2343 ,  G06F16/2379

Abstract: Techniques for constructing transaction lock wait history showing blocker queries are described. A first transaction referencing a resource saved in a network-based data warehouse is received where the first transaction being blocked due to second transaction accessing the resource. A first telemetry event based on the first transaction being blocked is transmitted. After acquiring lock ownership of the resource by the first transaction, a second telemetry event based on acquiring lock ownership by the first transaction is transmitted.

公开(公告)号：US12235843B2

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

申请号：US18656008

申请日：2024-05-06

Applicant: Snowflake Inc.

Inventor： Fabio Angius ,  Chen Luo ,  Sarvesh Singh

IPC: G06F16/00 ,  G06F16/23 ,  G06F16/2453 ,  G06F16/28

Abstract: Techniques for multi database query processing are described. Objects located in a plurality of databases referenced in a query can be compiled. A connection string based on the compiled objects can be generated. The connection string can include mapping information related to the related to the plurality of databases and cluster information of where the plurality of databases are stored in the network-based data system. The connection string can then be included in a query plan to allow for execution of the query plan using the connection string to access the objects in the plurality of databases.

公开(公告)号：US12222923B2

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

申请号：US18326619

申请日：2023-05-31

Applicant: Snowflake Inc.

Inventor： Lin Chan ,  Krishna B. Nibhanupudi ,  Sahaj Saini ,  Sarvesh Singh

IPC: G06F16/00 ,  G06F16/23

Abstract: Techniques for constructing transaction lock wait history showing blocker queries are described. A first transaction referencing a resource saved in a network-based data warehouse is received where the first transaction being blocked due to second transaction accessing the resource. A first telemetry event based on the first transaction being blocked is transmitted. After acquiring lock ownership of the resource by the first transaction, a second telemetry event based on acquiring lock ownership by the first transaction is transmitted.

公开(公告)号：US12007993B1

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

申请号：US18345900

申请日：2023-06-30

Applicant: Snowflake Inc.

Inventor： Fabio Angius ,  Chen Luo ,  Sarvesh Singh

IPC: G06F16/00 ,  G06F16/23 ,  G06F16/2453 ,  G06F16/28

CPC classification number: G06F16/24542 ,  G06F16/2329 ,  G06F16/24535 ,  G06F16/285

Abstract: Techniques for multi database query processing are described. Objects located in a plurality of databases referenced in a query can be compiled. A connection string based on the compiled objects can be generated. The connection string can include mapping information related to the related to the plurality of databases and cluster information of where the plurality of databases are stored in the network-based data system. The connection string can then be included in a query plan to allow for execution of the query plan using the connection string to access the objects in the plurality of databases.