Message-based database replication
    13.
    发明授权

    公开(公告)号:US10862873B1

    公开(公告)日:2020-12-08

    申请号:US16863191

    申请日:2020-04-30

    Applicant: Snowflake Inc.

    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.

    DATA REPLICATION WITH CROSS REPLICATION GROUP REFERENCES

    公开(公告)号:US20250061026A1

    公开(公告)日:2025-02-20

    申请号:US18937919

    申请日:2024-11-05

    Applicant: Snowflake Inc.

    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.

    Virtual network replication using staggered encryption

    公开(公告)号:US11943203B2

    公开(公告)日:2024-03-26

    申请号:US18055493

    申请日:2022-11-15

    Applicant: Snowflake Inc.

    CPC classification number: H04L63/0272 G06F16/27 H04L63/0281 H04L63/0435

    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.

    CATALOG QUERY FRAMEWORK ON DISTRIBUTED KEY VALUE STORE

    公开(公告)号:US20230138110A1

    公开(公告)日:2023-05-04

    申请号:US17809829

    申请日:2022-06-29

    Applicant: Snowflake Inc.

    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.

Patent Agency Ranking