公开(公告)号：US20240176711A1

公开(公告)日：2024-05-30

申请号：US18329348

申请日：2023-06-05

Applicant: Snowflake Inc.

Inventor： Loc Duc Bui ,  Hitesh Madan ,  Nithin Mahesh ,  Subramanian Muralidhar ,  Sahaj Saini ,  Di Wu

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

CPC classification number: G06F11/203 ,  G06F16/256 ,  G06F16/27

Abstract: The subject technology determines a set of share objects in a replication group. The subject technology, for each object from the set of share objects, determines a set of permissions for a set of objects of databases that has been granted to each share object from the replication group. The subject technology, for each permission from the set of permissions, determines a set of dependencies, the set of dependencies comprising a second set of objects. The subject technology generates a graph structure based at least in part on the set of share objects, the set of permissions, and the set of dependencies. The subject technology traverses at least a portion of the graph structure to determine a final set of dependencies for replication. The subject technology performs a replication process based at least in part on the final set of dependencies.

公开(公告)号：US12222828B2

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

申请号：US18329348

申请日：2023-06-05

Applicant: Snowflake Inc.

Inventor： Loc Duc Bui ,  Hitesh Madan ,  Nithin Mahesh ,  Subramanian Muralidhar ,  Sahaj Saini ,  Di Wu

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

Abstract: The subject technology determines a set of share objects in a replication group. The subject technology, for each object from the set of share objects, determines a set of permissions for a set of objects of databases that has been granted to each share object from the replication group. The subject technology, for each permission from the set of permissions, determines a set of dependencies, the set of dependencies comprising a second set of objects. The subject technology generates a graph structure based at least in part on the set of share objects, the set of permissions, and the set of dependencies. The subject technology traverses at least a portion of the graph structure to determine a final set of dependencies for replication. The subject technology performs a replication process based at least in part on the final set of dependencies.

公开(公告)号：US20240346038A1

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

申请号：US18301490

申请日：2023-04-17

Applicant: Snowflake Inc.

Inventor： Hitesh Madan ,  Chieh-Sheng Wang ,  Di Wu

IPC: G06F16/27 ,  G06F16/23

CPC classification number: G06F16/27 ,  G06F16/2365

Abstract: Provided herein are systems and methods for compatibility verification for listing auto-fulfillment. A system includes at least one hardware processor coupled to a memory and configured to decode a request for replication of data from a primary deployment account of a data provider to an account of a data consumer. A share object is retrieved in response to the request. The share object specifies a first plurality of data objects associated with the data. A determination is performed of the compatibility of each data object of the first plurality of data objects with the replication. A notification of the compatibility of each data object of the first plurality of data objects is output to the primary deployment account of the data provider.

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