公开(公告)号：US20220116360A1

公开(公告)日：2022-04-14

申请号：US17644854

申请日：2021-12-17

Applicant: Snowflake Inc.

Inventor： Robert Bengt Benedikt Gernhardt ,  Mikhail Kazhamiaka ,  Eric Robinson ,  Rodney Weaver

IPC: H04L47/00 ,  G06F16/27

Abstract: A network device communication system can configure network devices (e.g., a primary and secondary database) to send and receive sequences messages, such as replication data, over a channel comprising a plurality of private network nodes. The messages can be generated and encrypted using one or more key pairs and changing wrapping replication keys to send and receive the messages between different types of database deployments.

公开(公告)号：US11063911B1

公开(公告)日：2021-07-13

申请号：US17162919

申请日：2021-01-29

Applicant: Snowflake Inc.

Inventor： Robert Bengt Benedikt Gernhardt ,  Mikhail Kazhamiaka ,  Eric Robinson ,  Rodney Weaver

IPC: H04L29/06 ,  G06F16/27

Abstract: A network device communication system can configure network devices (e.g., a primary and secondary database) to send and receive sequences messages, such as replication data, over a channel comprising a plurality of private network nodes. The messages can be generated and encrypted using one or more key pairs and changing wrapping replication keys to send and receive the messages between different types of database deployments.

公开(公告)号：US12072840B2

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

申请号：US18179793

申请日：2023-03-07

Applicant: Snowflake Inc.

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

IPC: G06F15/16 ,  G06F16/14 ,  G06F16/16

CPC classification number: G06F16/148 ,  G06F16/164

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.

公开(公告)号：US20230401229A1

公开(公告)日：2023-12-14

申请号：US18051657

申请日：2022-11-01

Applicant: Snowflake Inc.

Inventor： Robert Bengt Benedikt Gernhardt ,  Chong Han ,  Nithin Mahesh ,  Aravind Ramarathinam ,  Saurin Shah ,  Yanrui Zhang

IPC: G06F16/27 ,  G06F16/25

CPC classification number: G06F16/27 ,  G06F16/256

Abstract: The distributed database can implement unstructured data replication using an internal or external storage location. Metadata, such as a directory table that lists the unstructured files, can be replicated across different deployments, followed by replication of the staged data. Replicating the staged data can be implemented by replication of only the stage metadata or replication of the database files between the deployments.

公开(公告)号：US11748374B2

公开(公告)日：2023-09-05

申请号：US17457751

申请日：2021-12-06

Applicant: Snowflake Inc.

Inventor： Robert Bengt Benedikt Gernhardt ,  Mikhail Kazhamiaka ,  Nithin Mahesh ,  Laxman Mamidi ,  Subramanian Muralidhar ,  Vishnu Dutt Paladugu ,  Sahaj Saini

IPC: G06F16/00 ,  G06F16/27 ,  G06F11/14 ,  G06F16/25 ,  G06F11/20 ,  G06F16/182 ,  G06F16/13 ,  G06F16/178 ,  G06F16/11

CPC classification number: G06F16/27 ,  G06F11/1461 ,  G06F11/1464 ,  G06F11/2023 ,  G06F11/2097 ,  G06F16/128 ,  G06F16/137 ,  G06F16/1787 ,  G06F16/184 ,  G06F16/1827 ,  G06F16/1844 ,  G06F16/256

Abstract: Provided herein are systems and methods for configuring replication group objects. A system includes at least one hardware processor coupled to memory and configured to decode a replication request received from a client device of a data provider. The replication request indicates a plurality of account objects for replication. The plurality of account objects associated with a corresponding plurality of account object types. A replication group object is generated based on the replication request. The replication group object includes a manifest. The manifest lists the plurality of account objects. The replication of the plurality of account objects is performed from a source account of the data provider into at least one target account. The replication is based on the manifest of the replication group object.

公开(公告)号：US11704199B1

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

申请号：US17823690

申请日：2022-08-31

Applicant: Snowflake Inc.

Inventor： Robert Bengt Benedikt Gernhardt ,  Nithin Mahesh ,  Sahaj Saini ,  Matthew Uhlar

IPC: G06F16/25 ,  G06F16/27 ,  G06F11/14

CPC classification number: G06F11/1435 ,  G06F16/256 ,  G06F16/27 ,  G06F2201/84

Abstract: This disclosure provides methods and techniques of data replication involving cross replication group (RG) references. The present disclosure avoids automatic replication failing when an entity in an RG refers to another entity external to the RG. The entity to be replicated within the RG is referred to as the “referring entity,” and the entity as the dangling reference is referred to as the “referred entity.” Although the referring and referred entities are not replicated together in a replication operation, the referred entity may have already been replicated to the target account in another replication operation on a different replication group. In such cases, the data replication procedure may, according to aspects of the present disclosure, check if the referred entity has already been replicated, and if so, proceed to replicate the referring entity without fail, and link the referring and referred entities to enable normal functioning of the referring entity.

公开(公告)号：US20230205735A1

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

申请号：US18179793

申请日：2023-03-07

Applicant: Snowflake Inc.

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

IPC: G06F16/14 ,  G06F16/16

CPC classification number: G06F16/148 ,  G06F16/164

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.

公开(公告)号：US20230169090A1

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

申请号：US17457751

申请日：2021-12-06

Applicant: Snowflake Inc.

Inventor： Robert Bengt Benedikt Gernhardt ,  Mikhail Kazhamiaka ,  Nithin Mahesh ,  Laxman Mamidi ,  Subramanian Muralidhar ,  Vishnu Dutt Paladugu ,  Sahaj Saini

IPC: G06F16/27 ,  G06F11/14 ,  G06F11/20 ,  G06F16/25

CPC classification number: G06F16/27 ,  G06F11/1464 ,  G06F11/1461 ,  G06F11/2023 ,  G06F16/256

Abstract: Provided herein are systems and methods for configuring replication group objects. A system includes at least one hardware processor coupled to memory and configured to decode a replication request received from a client device of a data provider. The replication request indicates a plurality of account objects for replication. The plurality of account objects associated with a corresponding plurality of account object types. A replication group object is generated based on the replication request. The replication group object includes a manifest. The manifest lists the plurality of account objects. The replication of the plurality of account objects is performed from a source account of the data provider into at least one target account. The replication is based on the manifest of the replication group object.

公开(公告)号：US20230073653A1

公开(公告)日：2023-03-09

申请号：US18055493

申请日：2022-11-15

Applicant: Snowflake Inc.

Inventor： Robert Bengt Benedikt Gernhardt ,  Mikhail Kazhamiaka ,  Eric Robinson ,  Rodney Weaver

IPC: H04L9/40 ,  G06F16/27

Abstract: A method includes selecting, by at least one hardware processor of a first database deployment, data for transmission to a second database deployment. The data includes a plurality of files forming a data stream. At least a first file of the plurality of files is encoded using a first encryption key which is stored in at least a second file of the plurality of files. The at least a first file is further encoded to include a second encryption key associated with at least a third file of the plurality of files. A set of nodes is identified in a virtual private network connected to the first and second database deployments. The data stream is transmitted from the first database deployment to the second database deployment via the set of nodes of the virtual private network that is connected to the first database deployment and the second database deployment.

公开(公告)号：US20220217125A1

公开(公告)日：2022-07-07

申请号：US17656620

申请日：2022-03-25

Applicant: Snowflake Inc.

Inventor： Damien Carru ,  Robert Bengt Benedikt Gernhardt ,  Martin Hentschel ,  Nithin Mahesh ,  Eric Robinson

IPC: H04L9/40 ,  H04L9/08 ,  G06F16/27 ,  H04L9/30

Abstract: A networked device communication system can configure network devices (e.g., a primary and secondary database) to send and receive sequences of messages, such as replicated data, using one or more keypairs and wrapping keys. The sequences of messages can include an initial set of messages that are encrypted by a wrapping key, and further include another set of messages that are encrypted by a replaced staggered key. The sequence of messages can be configured to be decrypted without exporting keys of hardware security modules.