# US 2022/0019599 A1 · Cloning catalog objects

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

- Number: US 2022/0019599 A1
- Document ID: US20220019599A1
- Status: Published application
- Kind: A1
- Application number: 17/491,357
- Filed: 2021-09-30
- Published: 2022-01-20
- Earliest claimed: 2014-02-19
- Assignees: Snowflake Inc.
- Applicants: Snowflake Inc.
- Inventors: Ashish Motivala; Benoit Dageville
- Web page: https://patentgrep.com/patent/US20220019599A1

## CPC

- G06F 16/273: {Asynchronous replication or reconciliation}
- A61F 5/566: {Intra-oral devices}
- G06F 9/4881: {Scheduling strategies for dispatcher, e.g. round robin, multi-level priority queues}
- G06F 9/5016: {the resource being the memory}
- G06F 9/5044: {considering hardware capabilities}
- G06F 9/5083: {Techniques for rebalancing the load in a distributed system}
- G06F 9/5088: {involving task migration}
- G06F 16/128: {Details of file system snapshots on the file-level, e.g. snapshot creation, administration, deletion (error detection or correction of the data by redundancy in operations or in hardware G06F11/14, G06F11/16)}
- G06F 16/148: {File search processing}
- G06F 16/1827: {Management specifically adapted to NAS (management of storage area networks [SAN] G06F3/067)}
- G06F 16/211: {Schema design and management}
- G06F 16/221: {Column-oriented storage; Management thereof}
- G06F 16/2365: {Ensuring data consistency and integrity}
- G06F 16/24532: {of parallel queries}
- G06F 16/24545: {Selectivity estimation or determination}
- G06F 16/24552: {Database cache management}
- G06F 16/2456: {Join operations}
- G06F 16/2471: {Distributed queries}
- G06F 16/254: {Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses}
- G06F 16/27: Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F 16/283: {Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP}
- G06F 16/951: Indexing; Web crawling techniques
- G06F 16/9535: Search customisation based on user profiles and personalisation
- G06F 16/9538: Presentation of query results
- H04L 67/1095: Replication or mirroring of data, e.g. scheduling or transport for data synchronisation between network nodes
- H04L 67/1097: for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS]
- H04L 67/568: Storing data temporarily at an intermediate stage, e.g. caching
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- A61F: FILTERS IMPLANTABLE INTO BLOOD VESSELS; PROSTHESES; DEVICES PROVIDING PATENCY TO, OR PREVENTING COLLAPSING OF, TUBULAR STRUCTURES OF THE BODY, e.g. STENTS; ORTHOPAEDIC, NURSING OR CONTRACEPTIVE DEVICES; FOMENTATION; TREATMENT OR PROTECTION OF EYES OR EARS; BANDAGES, DRESSINGS OR ABSORBENT PADS; FIRST-AID KITS (dental prosthetics A61C)
- H04L: TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION (arrangements common to telegraphic and telephonic communication H04M)

## Abstract

Example systems and methods for cloning catalog objects are described. In one implementation, a method includes creating a copy of a catalog object without copying a data associated with the catalog object by only coping metadata associated with the object. The method further includes modifying, by one or more processors, the data associated with the catalog object independently of the copy of the catalog object such that modified data is not visible to the copy of the catalog object and wherein the modified data is not visible to the catalog object in a database. The method further includes deleting the copy of the catalog object following completion of the modification of the data associated with the catalog object.

## Claims

### Claim 1

A system comprising:
a memory; and
one or more processors, operatively coupled to the memory, the one or more processors to:
copy a first catalog object of a database by creating a second catalog object, the first catalog object and the second catalog object comprising first and second metadata, respectively,
wherein the first metadata comprises first mappings to first data of the first catalog object, and
wherein the second metadata comprises second mappings to the first data of the first catalog object; and
respond to a data storage and/or data retrieval request to the first catalog object by accessing the second metadata of the second catalog object.

### Claim 2 (depends on 1)

The system of claim 1, wherein the data storage and/or data retrieval request is one of a plurality of data storage and/or data retrieval requests to the first catalog object, and
wherein the one or more processors are to copy the first catalog object of the database responsive to another of the plurality of data storage and/or data retrieval requests to the first catalog object that modifies the first data of the first catalog object.

### Claim 3 (depends on 1)

The system of claim 1, wherein the one or more processors are further to delete the second catalog object after responding to the data storage and/or data retrieval request to the first catalog object.

### Claim 4 (depends on 1)

The system of claim 1, wherein to copy the first catalog object of the database the one or more processors are to recursively copy elements of the first catalog object to create the second catalog object.

### Claim 5 (depends on 1)

The system of claim 1, wherein to access the second metadata of the second catalog object the one or more processors are to delete a portion of the first data in the second catalog object independently of the first catalog object by unmapping the second metadata from the portion of the first data while leaving the first metadata mapped to the portion of the first data.

### Claim 6 (depends on 1)

The system of claim 1, wherein to access the second metadata of the second catalog object the one or more processors are to modify a portion of the first data associated with the second catalog object independently of the first catalog object by:
copying a modified portion of the first data to second data; and
updating the second mappings of the second metadata to reference the second data.

### Claim 7 (depends on 1)

The system of claim 1, wherein the first catalog object comprises one or more of a schema, a table, a view, a column, a constraint, a sequence, a function, a file format, and a stage.

### Claim 8

A method comprising:
copying a first catalog object of a database by creating a second catalog object, the first catalog object and the second catalog object comprising first and second metadata, respectively,
wherein the first metadata comprises first mappings to first data of the first catalog object, and
wherein the second metadata comprises second mappings to the first data of the first catalog object; and
responding to a data storage and/or data retrieval request to the first catalog object by accessing the second metadata of the second catalog object.

### Claim 9 (depends on 8)

The method of claim 8, wherein the data storage and/or data retrieval request is one of a plurality of data storage and/or data retrieval requests to the first catalog object, and
wherein copying the first catalog object of the database is performed responsive to another of the plurality of data storage and/or data retrieval requests to the first catalog object that modifies the first data of the first catalog object.

### Claim 10 (depends on 8)

The method of claim 8, further comprising deleting the second catalog object after responding to the data storage and/or data retrieval request to the first catalog object.

### Claim 11 (depends on 8)

The method of claim 8, wherein copying the first catalog object of the database comprises recursively copying elements of the first catalog object to create the second catalog object.

### Claim 12 (depends on 8)

The method of claim 8, wherein accessing the second metadata of the second catalog object comprises deleting a portion of the first data in the second catalog object independently of the first catalog object by unmapping the second metadata from the portion of the first data while leaving the first metadata mapped to the portion of the first data.

### Claim 13 (depends on 8)

The method of claim 8, wherein the first catalog object comprises one or more of a schema, a table, a view, a column, a constraint, a sequence, a function, a file format, and a stage.

### Claim 14

A non-transitory computer-readable storage medium comprising instructions which, when executed by one or more processors, cause the one or more processors to:
copy a first catalog object of a database by creating a second catalog object, the first catalog object and the second catalog object comprising first and second metadata, respectively,
wherein the first metadata comprises first mappings to first data of the first catalog object, and
wherein the second metadata comprises second mappings to the first data of the first catalog object; and
respond to a data storage and/or data retrieval request to the first catalog object by accessing the second metadata of the second catalog object.

### Claim 15 (depends on 14)

The non-transitory computer-readable storage medium of claim 14, wherein the data storage and/or data retrieval request is one of a plurality of data storage and/or data retrieval requests to the first catalog object, and wherein the one or more processors are to copy the first catalog object of the database responsive to another of the plurality of data storage and/or data retrieval requests to the first catalog object that modifies the first data of the first catalog object.

### Claim 16 (depends on 14)

The non-transitory computer-readable storage medium of claim 14, wherein the one or more processors are further to delete the second catalog object after responding to the data storage and/or data retrieval request to the first catalog object.

### Claim 17 (depends on 14)

The non-transitory computer-readable storage medium of claim 14, wherein to copy the first catalog object of the database the one or more processors are to recursively copy elements of the first catalog object to create the second catalog object.

### Claim 18 (depends on 14)

The non-transitory computer-readable storage medium of claim 14, wherein to access the second metadata of the second catalog object the one or more processors are to delete a portion of the first data in the second catalog object independently of the first catalog object by unmapping the second metadata from the portion of the first data while leaving the first metadata mapped to the portion of the first data.

### Claim 19 (depends on 14)

The non-transitory computer-readable storage medium of claim 14, wherein to access the second metadata of the second catalog object the one or more processors are to modify a portion of the first data associated with the second catalog object independently of the first catalog object by:
copying a modified portion of the first data to second data; and
updating the second mappings of the second metadata to reference the second data.

### Claim 20 (depends on 14)

The non-transitory computer-readable storage medium of claim 14, wherein the first catalog object comprises one or more of a schema, a table, a view, a column, a constraint, a sequence, a function, a file format, and a stage.
