公开(公告)号：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.

公开(公告)号：US20230418711A1

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

申请号：US18465355

申请日：2023-09-12

Applicant: Snowflake Inc.

Inventor： Hitesh Madan ,  Nithin Mahesh ,  Matthew Uhlar

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

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. Example methods, systems, and techniques are disclosed regarding batch database replication (e.g., backup) and failover (e.g., automatic transition to a backup) between multiple database deployments or database providers. For example, a system causes database data to be stored in a primary deployment and replicated in one or more secondary deployments. In the event that data in the primary deployment is unavailable, transactions may be executed on one or more of the secondary deployments. When the original primary deployment becomes available again, any transactions executed on secondary deployments may be propagated to the primary deployment. The system may be configured such that queries on the database data are executed on the primary deployment at any time when the primary deployment is available.

公开(公告)号：US20250061026A1

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

申请号：US18937919

申请日：2024-11-05

Applicant: Snowflake Inc.

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

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

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.

公开(公告)号：US12141032B2

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

申请号：US18349688

申请日：2023-07-10

Applicant: Snowflake Inc.

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

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

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.

公开(公告)号：US20230409431A1

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

申请号：US18349688

申请日：2023-07-10

Applicant: Snowflake Inc.

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

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

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.