# US 2024/0004901 A1 · Data object replication using database identification

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2024/0004901 A1
- Document ID: US20240004901A1
- Status: Published application
- Kind: A1
- Application number: 18/467,876
- Filed: 2023-09-15
- Published: 2024-01-04
- Earliest claimed: 2021-12-10
- Assignees: Snowflake Inc.
- Applicants: Snowflake Inc.
- Inventors: Robert Bengt Benedikt Gernhardt; Chao-Yang Lo; Nithin Mahesh; Subramanian Muralidhar; Sahaj Saini
- Web page: https://patentgrep.com/patent/US20240004901A1

## CPC

- G06F 16/184: {implemented as replicated file system}
- G06F 16/273: {Asynchronous replication or reconciliation}
- G06F 16/11: File system administration, e.g. details of archiving or snapshots (error detection or correction of the data by redundancy in operations G06F11/14)
- G06F 16/13: File access structures, e.g. distributed indices (arrangements of input from, or output to, record carriers G06F3/06)
- G06F 16/185: Hierarchical storage management [HSM] systems, e.g. file migration or policies thereof (details of archiving G06F16/11)
- G06F 16/275: {Synchronous replication}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A system for data object replication includes at least one hardware processor and at least one memory storing instructions. The instructions cause the at least one hardware processor to perform operations including parsing a replication request to obtain a data object and identification information identifying a set of databases at a first deployment of a data provider. A dependency of the data object to one or more additional data objects stored in the set of databases is detected. A sequential replication of the data object and the one or more additional data object from the first deployment to a second deployment of the data provider is performed. The second deployment is identified by the replication request. A sequence of the sequential replication is based on the detected dependency.

## Claims

### Claim 1

A system comprising:
at least one hardware processor; and
at least one memory storing instructions that cause the at least one hardware processor to perform operations comprising:
parsing a replication request to obtain a data object and identification information identifying a set of databases at a first deployment of a data provider;
detecting a dependency of the data object to one or more additional data objects stored in the set of databases; and
performing a sequential replication of the data object and the one or more additional data object from the first deployment to a second deployment of the data provider, the second deployment identified by the replication request, and a sequence of the sequential replication based on the detected dependency.

### Claim 2 (depends on 1)

The system of claim 1, wherein the data object and the one or more additional data objects are associated with a corresponding account object type of a plurality of account object types, and wherein the replication is performed from a first account into a second account of a data provider.

### Claim 3 (depends on 2)

The system of claim 2, wherein the plurality of account object types comprises at least one of:
a user account object type, wherein a user account object of the user account object type lists a user authorized to access the second account;
a roles account object type, wherein a roles account object of the roles account object type configures privileges for accessing an account object, the privileges associated with a role of the user;
a grant account object type, wherein a grant account object of the grant account object type configures a grant of at least one of the privileges for accessing the account object to at least another object;
a warehouse object type, wherein a warehouse object of the warehouse object type indicates compute resources for executing a workload associated with one or more databases of the set of databases; and
a resource monitor object type, wherein a resource monitor object of the resource monitor object type configures monitoring usage of the compute resources.

### Claim 4 (depends on 3)

The system of claim 3, wherein the data object is the user account object, and wherein the instructions further cause the at least one hardware processor to perform operations comprising:
determining the roles account object is one of the one or more additional data objects based on the object dependencies.

### Claim 5 (depends on 3)

The system of claim 3, wherein the plurality of account object types further comprises:
a database account object type, and wherein a database account object of the database account object type indicates the one or more databases;
a share account object type, wherein a share account object of the share account object type configures sharing of the one or more databases from the first account to at least another account of the user;
an integration account object type, wherein an integration account object of the integration account object type configures application programming interfaces (APIs) and allowed network access points for accessing the first account or the second account; and
a network policy account object type, wherein a network policy object of the network policy account object type provides network configurations for accessing the first account and the second account of the user.

### Claim 6 (depends on 5)

The system of claim 5, wherein the replication request further includes the database account object and a list of the set of databases, and wherein the instructions further cause the at least one hardware processor to perform operations comprising:
configuring the one or more additional data objects to include the list of the set of databases; and
performing a replication of the set of databases according to the replication sequence.

### Claim 7 (depends on 1)

The system of claim 1, wherein the replication request further includes scheduling information, and wherein the instructions further cause the at least one hardware processor to perform operations comprising:
performing the replication of the data object and at least one of the one or more additional data objects according to a replication schedule, the replication schedule configured based on the scheduling information.

### Claim 8 (depends on 1)

The system of claim 1, wherein the instructions further cause the at least one hardware processor to perform operations comprising:
retrieving the object dependencies using object dependency information maintained at a first account of a data provider.

### Claim 9 (depends on 8)

The system of claim 8, wherein the instructions further cause the at least one hardware processor to perform operations comprising:
performing the replication of the data object and the at least one of the one or more additional data objects into a second account of the data provider.

### Claim 10 (depends on 9)

The system of claim 9, wherein the instructions further cause the at least one hardware processor to perform operations comprising:
determining the first account and the second account based on the replication request.

### Claim 11

A method comprising:
parsing, by at least one hardware processor, a replication request to obtain a data object and identification information identifying a set of databases at a first deployment of a data provider;
detecting a dependency of the data object to one or more additional data objects stored in the set of databases; and
performing a sequential replication of the data object and the one or more additional data object from the first deployment to a second deployment of the data provider, the second deployment identified by the replication request, and a sequence of the sequential replication based on the detected dependency.

### Claim 12 (depends on 11)

The method of claim 11, wherein the data object and the one or more additional data objects are associated with a corresponding account object type of a plurality of account object types, and wherein the replication is performed from a first account into a second account of a data provider.

### Claim 13 (depends on 12)

The method of claim 12, wherein the plurality of account object types comprises at least one of:
a user account object type, wherein a user account object of the user account object type lists a user authorized to access the second account;
a roles account object type, wherein a roles account object of the roles account object type configures privileges for accessing an account object, the privileges associated with a role of the user;
a grant account object type, wherein a grant account object of the grant account object type configures a grant of at least one of the privileges for accessing the account object to at least another object;
a warehouse object type, wherein a warehouse object of the warehouse object type indicates compute resources for executing a workload associated with one or more databases of the set of databases; and
a resource monitor object type, wherein a resource monitor object of the resource monitor object type configures monitoring usage of the compute resources.

### Claim 14 (depends on 13)

The method of claim 13, wherein the data object is the user account object, and wherein the method further comprises:
determining the roles account object is one of the one or more additional data objects based on the object dependencies.

### Claim 15 (depends on 13)

The method of claim 13, wherein the plurality of account object types further comprises:
a database account object type, and wherein a database account object of the database account object type indicates the one or more databases;
a share account object type, wherein a share account object of the share account object type configures sharing of the one or more databases from the first account to at least another account of the user;
an integration account object type, wherein an integration account object of the integration account object type configures application programming interfaces (APIs) and allowed network access points for accessing the first account or the second account; and
a network policy account object type, wherein a network policy object of the network policy account object type provides network configurations for accessing the first account and the second account of the user.

### Claim 16 (depends on 15)

The method of claim 15, wherein the replication request further includes the database account object and a list of the set of databases, and wherein the method further comprises:
configuring the one or more additional data objects to include the list of the set of databases; and
performing a replication of the set of databases according to the replication sequence.

### Claim 17 (depends on 11)

The method of claim 11, wherein the replication request further includes scheduling information, and wherein the method further comprises:
performing the replication of the data object and at least one of the one or more additional data objects according to a replication schedule, the replication schedule configured based on the scheduling information.

### Claim 18 (depends on 11)

The method of claim 11, wherein the method further comprises:
retrieving the object dependencies using object dependency information maintained at a first account of a data provider.

### Claim 19 (depends on 18)

The method of claim 18, wherein the method further comprises:
performing the replication of the data object and the at least one of the one or more additional data objects into a second account of the data provider.

### Claim 20 (depends on 19)

The method of claim 19, wherein the method further comprises:
determining the first account and the second account based on the replication request.

### Claim 21

A computer-storage medium comprising instructions that, when executed by one or more processors of a machine, configure the machine to perform operations comprising:
parsing, by at least one hardware processor, a replication request to obtain a data object and identification information identifying a set of databases at a first deployment of a data provider;
detecting a dependency of the data object to one or more additional data objects stored in the set of databases; and
performing a sequential replication of the data object and the one or more additional data object from the first deployment to a second deployment of the data provider, the second deployment identified by the replication request, and a sequence of the sequential replication based on the detected dependency.

### Claim 22 (depends on 21)

The computer-storage medium of claim 21, wherein the data object and the one or more additional data objects are associated with a corresponding account object type of a plurality of account object types, and wherein the replication is performed from a first account into a second account of a data provider.

### Claim 23 (depends on 22)

The computer-storage medium of claim 22, wherein the plurality of account object types comprises at least one of:
a user account object type, wherein a user account object of the user account object type lists a user authorized to access the second account;
a roles account object type, wherein a roles account object of the roles account object type configures privileges for accessing an account object, the privileges associated with a role of the user;
a grant account object type, wherein a grant account object of the grant account object type configures a grant of at least one of the privileges for accessing the account object to at least another object;
a warehouse object type, wherein a warehouse object of the warehouse object type indicates compute resources for executing a workload associated with one or more databases of the set of databases; and
a resource monitor object type, wherein a resource monitor object of the resource monitor object type configures monitoring usage of the compute resources.

### Claim 24 (depends on 23)

The computer-storage medium of claim 23, wherein the data object is the user account object, and wherein the operations further comprise:
determining the roles account object is one of the one or more additional data objects based on the object dependencies.

### Claim 25 (depends on 23)

The computer-storage medium of claim 23, wherein the plurality of account object types further comprises:
a database account object type, and wherein a database account object of the database account object type indicates the one or more databases;
a share account object type, wherein a share account object of the share account object type configures sharing of the one or more databases from the first account to at least another account of the user;
an integration account object type, wherein an integration account object of the integration account object type configures application programming interfaces (APIs) and allowed network access points for accessing the first account or the second account; and
a network policy account object type, wherein a network policy object of the network policy account object type provides network configurations for accessing the first account and the second account of the user.

### Claim 26 (depends on 25)

The computer-storage medium of claim 25, wherein the replication request further includes the database account object and a list of the set of databases, and wherein the operations further comprise:
configuring the one or more additional data objects to include the list of the set of databases; and
performing a replication of the set of databases according to the replication sequence.

### Claim 27 (depends on 21)

The computer-storage medium of claim 21, wherein the replication request further includes scheduling information, and wherein the operations further comprise:
performing the replication of the data object and at least one of the one or more additional data objects according to a replication schedule, the replication schedule configured based on the scheduling information.

### Claim 28 (depends on 21)

The computer-storage medium of claim 21, wherein the operations further comprise:
retrieving the object dependencies using object dependency information maintained at a first account of a data provider.

### Claim 29 (depends on 28)

The computer-storage medium of claim 28, wherein the operations further comprise:
performing the replication of the data object and the at least one of the one or more additional data objects into a second account of the data provider.

### Claim 30 (depends on 29)

The computer-storage medium of claim 29, wherein the operations further comprise:
determining the first account and the second account based on the replication request.
