DATA REPLICATION WITH CROSS REPLICATION GROUP REFERENCES

    公开(公告)号:US20230409431A1

    公开(公告)日:2023-12-21

    申请号:US18349688

    申请日:2023-07-10

    申请人: Snowflake Inc.

    IPC分类号: G06F11/14 G06F16/25 G06F16/27

    摘要: 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.

    Materialized view sub-database replication

    公开(公告)号:US11640412B2

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

    申请号:US17804753

    申请日:2022-05-31

    申请人: Snowflake Inc.

    摘要: A system for sub-table replication within a materialized view of a source data table. A materialized view of a source data table is generated based on a query, the source data table having a plurality of data table rows associated with a plurality of client identifiers and including an entitlements column and data content, the entitlements column including a plurality of provider account identifiers and a plurality of consumer account identifiers. An update to an entitlements table of the source data table is detected where the entitlements table includes a plurality of entitlements table rows and where the entitlements table rows are associated with the client identifiers, the consumer account identifiers, and the provider account identifiers. An update to the source data table based on the first update to the entitlements table is detected, and an incremental replication of the materialized view of the source data table is performed.

    MESSAGE-BASED DATABASE REPLICATION
    40.
    发明申请

    公开(公告)号:US20210344655A1

    公开(公告)日:2021-11-04

    申请号:US17219700

    申请日:2021-03-31

    申请人: Snowflake Inc.

    IPC分类号: H04L29/06 G06F16/27 H04L9/30

    摘要: 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.