公开(公告)号：US20230385305A1

公开(公告)日：2023-11-30

申请号：US18051148

申请日：2022-10-31

Applicant: Snowflake Inc.

Inventor： Fabio Angius ,  Krishna B. Nibhanupudi ,  Zechao Shang

IPC: G06F16/28 ,  G06F16/23 ,  G06F16/182

CPC classification number: G06F16/283 ,  G06F16/23 ,  G06F16/182

Abstract: The subject technology sends a first statement to an execution node for executing the first statement on first storage using micro-partitions. The subject technology sends a second statement to the execution node for executing the second statement on linearizable storage. The subject technology sends a request to prepare a commit of a cross domain transaction associated with the first statement and the second statement. The subject technology generates a new version of a set of tables that were modified by the cross domain transaction and updating first metadata in a metadata database to indicate the new version. The subject technology finalizes the commit of the cross domain transaction and updates second metadata that the cross domain transaction has been committed.

公开(公告)号：US12204559B2

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

申请号：US18051148

申请日：2022-10-31

Applicant: Snowflake Inc.

Inventor： Fabio Angius ,  Krishna B. Nibhanupudi ,  Zechao Shang

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

Abstract: The subject technology sends a first statement to an execution node for executing the first statement on first storage using micro-partitions. The subject technology sends a second statement to the execution node for executing the second statement on linearizable storage. The subject technology sends a request to prepare a commit of a cross domain transaction associated with the first statement and the second statement. The subject technology generates a new version of a set of tables that were modified by the cross domain transaction and updating first metadata in a metadata database to indicate the new version. The subject technology finalizes the commit of the cross domain transaction and updates second metadata that the cross domain transaction has been committed.

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

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

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

公开(公告)号：US11514080B1

公开(公告)日：2022-11-29

申请号：US17810990

申请日：2022-07-06

Applicant: Snowflake Inc.

Inventor： Fabio Angius ,  Krishna B. Nibhanupudi ,  Zechao Shang

IPC: G06F16/00 ,  G06F16/28 ,  G06F16/23 ,  G06F16/182 ,  G06F16/30

Abstract: The subject technology receives a cross domain transaction, the cross domain transaction including a plurality of statements. The subject technology sends a first statement to an execution node for executing the first statement on first storage using micro-partitions. The subject technology sends a second statement to the execution node for executing the second statement on linearizable storage. The subject technology updates, using a metadata database, a status of the cross domain transaction to a pre-commit state. The subject technology sends a request to prepare a commit of the cross domain transaction. The subject technology updates, using the metadata database, the status of the cross domain transaction to a committing state. The subject technology finalizes the commit of the cross domain transaction and updating second metadata that the cross domain transaction has been committed.