公开(公告)号：US20200012659A1

公开(公告)日：2020-01-09

申请号：US16392258

申请日：2019-04-23

Applicant: Snowflake Inc.

Inventor： Benoit Dageville ,  Eric Robinson ,  Martin Hentschel

IPC: G06F16/27 ,  G06F16/245

Abstract: Replication and failover of database data is disclosed. A method includes replicating database data stored in a primary deployment such that the database data is further stored in a secondary deployment. The method includes executing one or more updates to the database data at the secondary deployment when the primary deployment is unavailable and propagating the one or more updates to the primary deployment when the primary deployment becomes available again. The method includes executing queries on the database data at the primary deployment when the primary deployment is available.

公开(公告)号：US20240422127A1

公开(公告)日：2024-12-19

申请号：US18810804

申请日：2024-08-21

Applicant: Snowflake Inc.

Inventor： Robert Bengt Benedikt Gernhardt ,  Mikhail Kazhamiaka ,  Nithin Mahesh ,  Eric Robinson

IPC: H04L9/40

Abstract: Different database deployments, or other data system deployments, may want to communicate with each other without sacrificing security or control. To this end, embodiments of the present disclosure may provide secure message exchange techniques for a source and/or target deployment. Configurable rule sets may be stored in the deployments; the rule sets may define what messages may be communicated between deployments. The deployments may implement a selective filtering scheme in one or more stages based on the rule sets to filter outgoing and/or incoming messages.

公开(公告)号：US20240370406A1

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

申请号：US18775830

申请日：2024-07-17

Applicant: Snowflake Inc.

Inventor： Lin Chan ,  Tianyi Chen ,  Robert Bengt Benedikt Gernhardt ,  Nithin Mahesh ,  Eric Robinson

IPC: G06F16/14 ,  G06F16/16

Abstract: Techniques for executing show commands are described herein. A plurality of navigation steps is utilized, each navigation step corresponding to a different layer in a database structure and each navigation step including an operator to fetch items from a metadata database up to respective bounded limits. Dependency information is also fetched for objects of the specified object type in the show command. After a set of objects from the last layer are processed, memory for the navigation steps is flushed and the next set of objects are processed.

公开(公告)号：US12105734B2

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

申请号：US16700958

申请日：2019-12-02

Applicant: Snowflake Inc.

Inventor： Benoit Dageville ,  Eric Robinson ,  Martin Hentschel

IPC: G06F16/245 ,  G06F16/27 ,  H04L67/1097

CPC classification number: G06F16/273 ,  G06F16/245 ,  H04L67/1097

Abstract: Replication and failover of database data is disclosed. A method includes replicating database data stored in a primary deployment such that the database data is further stored in a secondary deployment. The method includes executing one or more updates to the database data at the secondary deployment when the primary deployment is unavailable and propagating the one or more updates to the primary deployment when the primary deployment becomes available again. The method includes executing queries on the database data at the primary deployment when the primary deployment is available.

公开(公告)号：US20240273071A1

公开(公告)日：2024-08-15

申请号：US18456644

申请日：2023-08-28

Applicant: Snowflake Inc.

Inventor： Damien Carru ,  Benoit Dageville ,  Subramanian Muralidhar ,  Eric Robinson ,  Sahaj Saini ,  David Schultz

IPC: G06F16/21 ,  G06F16/28 ,  G06F21/62

CPC classification number: G06F16/212 ,  G06F16/285 ,  G06F21/6245

Abstract: Techniques for creating, sharing, and using bundles (also referred to as packages) in a multi-tenant database are described herein. A bundle is a schema object with associated hidden schemas. A bundle can be created by a provider user and can be shared with a plurality of consumer users. The bundle can be used to enable code sharing and distribution without losing control while maintaining security protocols.

公开(公告)号：US12007997B2

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

申请号：US18183483

申请日：2023-03-14

Applicant: Snowflake Inc.

Inventor： Lin Chan ,  Tianyi Chen ,  Benoit Dageville ,  Yiming Kang ,  Jun Luo ,  Nithin Mahesh ,  Eric Robinson ,  Brian Smith

IPC: G06F16/00 ,  G06F7/14 ,  G06F16/22 ,  G06F16/23 ,  G06F16/2453 ,  G06F21/62

CPC classification number: G06F16/24549 ,  G06F7/14 ,  G06F16/2228 ,  G06F16/2379 ,  G06F21/6218 ,  G06F21/6227

Abstract: As described herein, a N-Gram index may be created and the search may be conducted using the index, which will lead to faster search results. The N-Gram index may also include partial N-Gram components to capture more relevant data. Moreover, as described herein, the search may also take into account recent log data that has not yet been indexed. Techniques for building an index store using log data and efficiently searching the index store and log data to process search requests are described herein.

公开(公告)号：US20230344796A1

公开(公告)日：2023-10-26

申请号：US18341954

申请日：2023-06-27

Applicant: Snowflake Inc.

Inventor： Robert Bengt Benedikt Gernhardt ,  Mikhail Kazhamiaka ,  Nithin Mahesh ,  Eric Robinson

IPC: H04L9/40

CPC classification number: H04L63/0218 ,  H04L63/0236 ,  H04L63/0245

Abstract: Different database deployments, or other data system deployments, may want to communicate with each other without sacrificing security or control. To this end, embodiments of the present disclosure may provide secure message exchange techniques for a source and/or target deployment. Configurable rule sets may be stored in the deployments; the rule sets may define what messages may be communicated between deployments. The deployments may implement a selective filtering scheme in one or more stages based on the rule sets to filter outgoing and/or incoming messages.

公开(公告)号：US11797497B2

公开(公告)日：2023-10-24

申请号：US18068998

申请日：2022-12-20

Applicant: Snowflake Inc.

Inventor： Damien Carru ,  Benoit Dageville ,  Subramanian Muralidhar ,  Eric Robinson ,  Sahaj Saini ,  David Schultz

IPC: G06F16/21 ,  G06F21/62 ,  G06F16/28

CPC classification number: G06F16/212 ,  G06F16/285 ,  G06F21/6245

Abstract: Techniques for creating, sharing, and using bundles (also referred to as packages) in a multi-tenant database are described herein. A bundle is a schema object with associated hidden schemas. A bundle can be created by a provider user and can be shared with a plurality of consumer users. The bundle can be used to enable code sharing and distribution without losing control while maintaining security protocols.

公开(公告)号：US20230267131A1

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

申请号：US18123108

申请日：2023-03-17

Applicant: Snowflake Inc.

Inventor： Benoit Dageville ,  Eric Robinson ,  Martin Hentschel

IPC: G06F16/27 ,  G06F16/245

CPC classification number: G06F16/273 ,  G06F16/245 ,  H04L67/1097

Abstract: Methods and systems of managing database failure based on transaction request time is disclosed. A method includes copying a first dataset stored in a primary deployment to a secondary deployment to generate a second dataset. The method includes determining a first arrival time of a first request to perform a first transaction. The method includes determining a second arrival time of a second request to perform a second transaction. The method includes e00000xecuting the first transaction on the first dataset at the primary deployment in response to determining the first arrival time of the first request to perform the first transaction. The method includes executing the second transaction on the second dataset at the secondary deployment in response to determining the second arrival time of the second request to perform the second transaction.

公开(公告)号：US20230214391A1

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

申请号：US18183483

申请日：2023-03-14

Applicant: Snowflake Inc.

Inventor： Lin Chan ,  Tianyi Chen ,  Benoit Dageville ,  Yiming Kang ,  Jun Luo ,  Nithin Mahesh ,  Eric Robinson ,  Brian Smith

IPC: G06F16/23 ,  G06F16/22 ,  G06F7/14 ,  G06F21/62

CPC classification number: G06F16/2379 ,  G06F16/2228 ,  G06F7/14 ,  G06F21/6218

Abstract: As described herein, a N-Gram index may be created and the search may be conducted using the index, which will lead to faster search results. The N-Gram index may also include partial N-Gram components to capture more relevant data. Moreover, as described herein, the search may also take into account recent log data that has not yet been indexed. Techniques for building an index store using log data and efficiently searching the index store and log data to process search requests are described herein.