公开(公告)号：US11921708B1

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

申请号：US17823801

申请日：2022-08-31

Applicant: Snowflake Inc.

Inventor： Thierry Cruanes ,  Moritz Eyssen ,  Max Heimel ,  Lishi Jiang ,  Alexander Miller

IPC: G06F16/23 ,  G06F16/2455

CPC classification number: G06F16/2379 ,  G06F16/24568

Abstract: The subject technology receives, at a first execution node, a first transaction, the first transaction to be executed on linearizable storage. The subject technology determines whether the first execution node corresponds to a rank indicating a leader worker. The subject technology, in response to the first execution node corresponding to the rank indicating the leader worker, performs, by the first execution node, an initialization process for executing the first transaction. The subject technology broadcasts a first read timestamp associated with the first transaction to a set of execution nodes, the set of execution nodes being different than the first execution node. The subject technology executes, by the first execution node, at least a first operation from the first transaction.

公开(公告)号：US20240070143A1

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

申请号：US17823801

申请日：2022-08-31

Applicant: Snowflake Inc.

Inventor： Thierry Cruanes ,  Moritz Eyssen ,  Max Heimel ,  Lishi Jiang ,  Alexander Miller

IPC: G06F16/23 ,  G06F16/2455

CPC classification number: G06F16/2379 ,  G06F16/24568

Abstract: The subject technology receives, at a first execution node, a first transaction, the first transaction to be executed on linearizable storage. The subject technology determines whether the first execution node corresponds to a rank indicating a leader worker. The subject technology, in response to the first execution node corresponding to the rank indicating the leader worker, performs, by the first execution node, an initialization process for executing the first transaction. The subject technology broadcasts a first read timestamp associated with the first transaction to a set of execution nodes, the set of execution nodes being different than the first execution node. The subject technology executes, by the first execution node, at least a first operation from the first transaction.

公开(公告)号：US20240028567A1

公开(公告)日：2024-01-25

申请号：US18326929

申请日：2023-05-31

Applicant: Snowflake Inc.

Inventor： Benoit Dageville ,  Adrian Hamza ,  Lishi Jiang ,  William Waddington ,  Khaled Yagoub ,  Wumengjian Zhu

IPC: G06F16/21 ,  G06F16/22

CPC classification number: G06F16/213 ,  G06F16/221

Abstract: The subject technology generates, by a compute service manager, a schema hash value for a new schema version associated with a new schema version value, the schema hash value based on determining a sum of hash values of a set of attributes of value columns, the set of attributes comprises a column identifier, and a logical type of a column. The subject technology stores a mapping of the schema hash value to the new schema version value for a table in a metadata database. The subject technology stores a new schema entry based on the schema hash value, the new schema version value, and a new column for the table in the metadata database, the metadata database storing multiple entries for different schema versions, each entry including a particular schema hash value for mapping to a corresponding schema version from the different schema versions.

公开(公告)号：US11709808B1

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

申请号：US17656558

申请日：2022-03-25

Applicant: Snowflake Inc.

Inventor： Benoit Dageville ,  Adrian Hamza ,  William Waddington ,  Khaled Yagoub ,  Wumengjian Zhu ,  Lishi Jiang

IPC: G06F16/21 ,  G06F16/22

CPC classification number: G06F16/213 ,  G06F16/221

Abstract: The subject technology receives a statement to perform an operation to add a new column into a table. The subject technology generates a schema hash value for a new schema version associated with a new schema version value. The subject technology stores a mapping of the schema hash value to the new schema version value for the table in a metadata database. The subject technology stores a new schema entry based on the schema hash value, the new schema version value, and the new column for the table in the metadata database. The subject technology performs an operation to add the new column to the table.

公开(公告)号：US12235833B2

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

申请号：US18415826

申请日：2024-01-18

Applicant: Snowflake Inc.

Inventor： Thierry Cruanes ,  Moritz Eyssen ,  Max Heimel ,  Lishi Jiang ,  Alexander Miller

IPC: G06F16/23 ,  G06F9/46 ,  G06F9/52 ,  G06F16/2455

Abstract: The subject technology receives, at a first execution node, a first transaction, the first transaction to be executed on linearizable storage. The subject technology determines whether the first execution node corresponds to a rank indicating a leader worker. The subject technology, in response to the first execution node corresponding to the rank indicating the leader worker, performs, by the first execution node, an initialization process for executing the first transaction. The subject technology broadcasts a first read timestamp associated with the first transaction to a set of execution nodes, the set of execution nodes being different than the first execution node. The subject technology executes, by the first execution node, at least a first operation from the first transaction.

公开(公告)号：US12135697B2

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

申请号：US18326929

申请日：2023-05-31

Applicant: Snowflake Inc.

Inventor： Benoit Dageville ,  Adrian Hamza ,  Lishi Jiang ,  William Waddington ,  Khaled Yagoub ,  Wumengjian Zhu

IPC: G06F16/21 ,  G06F16/22

Abstract: The subject technology generates, by a compute service manager, a schema hash value for a new schema version associated with a new schema version value, the schema hash value based on determining a sum of hash values of a set of attributes of value columns, the set of attributes comprises a column identifier, and a logical type of a column. The subject technology stores a mapping of the schema hash value to the new schema version value for a table in a metadata database. The subject technology stores a new schema entry based on the schema hash value, the new schema version value, and a new column for the table in the metadata database, the metadata database storing multiple entries for different schema versions, each entry including a particular schema hash value for mapping to a corresponding schema version from the different schema versions.

公开(公告)号：US20240232173A1

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

申请号：US18415826

申请日：2024-01-18

Applicant: Snowflake Inc.

Inventor： Thierry Cruanes ,  Moritz Eyssen ,  Max Heimel ,  Lishi Jiang ,  Alexander Miller

IPC: G06F16/23 ,  G06F16/2455

CPC classification number: G06F16/2379 ,  G06F16/24568

Abstract: The subject technology receives, at a first execution node, a first transaction, the first transaction to be executed on linearizable storage. The subject technology determines whether the first execution node corresponds to a rank indicating a leader worker. The subject technology, in response to the first execution node corresponding to the rank indicating the leader worker, performs, by the first execution node, an initialization process for executing the first transaction. The subject technology broadcasts a first read timestamp associated with the first transaction to a set of execution nodes, the set of execution nodes being different than the first execution node. The subject technology executes, by the first execution node, at least a first operation from the first transaction.