IP Library Granted Patent US 11,615,114
Granted Patent B2
US 11,615,114 · App. 17/647,123 · Granted Mar 28, 2023

Cloning catalog objects

Inventors: Ashish Motivala (Foster City, CA); Benoit Dageville (Foster City, CA)
Assignee: Snowflake Inc.
G06F16/27G06F9/4881G06F9/5016G06F9/5044G06F9/5083G06F9/5088G06F16/148G06F16/1827G06F16/211G06F16/221G06F16/2365G06F16/2456G06F16/2471G06F16/24532G06F16/24545G06F16/24552G06F16/254G06F16/283G06F16/951G06F16/9535H04L67/1095H04L67/1097H04L67/568
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 11,615,114
App. No.
17/647,123
Granted
Mar 28, 2023
Kind
B2
Abstract

Example systems and methods for cloning catalog objects are described. In one implementation, a method identifies an original catalog object associated with data and creates a duplicate copy of the original catalog object without copying the data itself. The method allows access to the data using the duplicate catalog object and supports modifying the data associated with the original catalog object independently of the duplicate catalog object. The duplicate catalog object can be deleted upon completion of modifying the data associated with the original catalog object.

Claims (38)

1. A method comprising:

creating, by one or more processors, a duplicate database table of an original database table associated with the data without duplicating the data itself by copying metadata of the first plurality of metadata to create a second plurality of metadata for each of the plurality of files, wherein the original database table stores the data in a plurality of files and a first plurality of metadata that summarizes at least some of the data content of at least some of the plurality of files;

modifying a piece of data in the duplicate database table by modifying the piece of data in a duplicate one of the plurality of files; and

updating the second plurality of metadata to reference the duplicate one of the plurality of files.

2. The method claim 1 , wherein a system can determine whether one of the plurality of files needs to be accessed when processing a query without accessing that file from the one or more storage devices using the first plurality of metadata.

3. The method of claim 1 , wherein the first plurality of metadata comprises an inventory of data stored in the original database table.

4. The method of claim 1 , herein the original database table represents a logical grouping of data.

5. The method of claim 1 , wherein the modification comprises:

copying the one of the plurality f files to a duplicate file and modifying the piece of data in the duplicate file.

6. The method of claim 1 , further comprising:

allowing modification of the piece of data associated with the original database table independently of the duplicate database table and without copy of the data itself.

7. The method of claim 1 , further comprising:

allowing access to the data using the duplicate database table.

8. The method of claim 1 , wherein the original database table comprises a set of tables.

9. The method of claim 1 , wherein the duplicate database table is read only.

10. The method of claim 1 , wherein modified data associated with one of the original database table and the duplicate database table is not visible to the other table.

11. The method of claim 1 , wherein data deleted from one of the original database table and the duplicate database table remains visible to the other table.

12. The method of claim 1 , wherein inserted data associated with one of the original database table and the duplicate database table is not visible to the other table.

13. The method of claim 1 , further comprising deleting the original database table upon completion of modifying the data associated with the original database table.

14. A system, comprising:

one or more storage devices to store an original database table, wherein the original database table stores data in a plurality of files and a first plurality of metadata that summarizes at least some of the data content of at least some of the plurality of files; and

one or more processors, operatively coupled with the one or more storage devices, to:

create a duplicate database table of the original database table associated with the data without duplicating the data itself by copying metadata of the first plurality of metadata to create a second plurality of metadata for each of the plurality of files,

modify a piece of data in the duplicate database table by modifying the piece of data in a duplicate one of the plurality of files, and

update the second plurality of metadata to reference the duplicate one of the plurality of files.

15. The system of claim 14 , wherein the system can determine whether one of the plurality of files needs to be accessed when processing a query without accessing that file from the one or more storage devices using the plurality of metadata.

16. The system of claim 14 , wherein the first plurality of metadata comprises an inventory of data stored in the data.

17. The system of claim 14 , wherein the original database table represents a logical grouping of data.

18. The system of claim 14 , wherein the modification of the piece of data occurs by copying the one of the plurality of files to a duplicate file and modifying the piece of data in the duplicate file.

19. The system of claim 14 , wherein the one or processors further to allow modification of the data associated with the original database table independently of the duplicate database table and without copy of the data itself.

20. The system of claim 14 , wherein modified data associated with the original database table is not visible to the duplicate database table.

21. The system of claim 14 , wherein modified data associated with the duplicate database table is not visible to the original database table.

22. The system of claim 14 , wherein the modification of the piece of data is one of a write of the piece of data to the duplicate one of plurality of files and an update to the piece of data in the duplicate one of plurality of files.

23. The system of claim 14 , wherein the one or more storage devices is separate from the one or more processors.

24. A non-transitory computer-readable medium that, when executed, causes one or more processors to:

create, by the one or more processors, a duplicate database table of the original database table associated with the data without duplicating the data itself by copying metadata of the first plurality of metadata to create a second plurality of metadata for each of the plurality of files, wherein the original database table stores the data in a plurality of files and a first plurality of metadata that summarizes at least some of the data content of at least some of the plurality of files;

modify a piece of data in the duplicate database table by modifying the piece of data in a duplicate one of the plurality of files; and

update the second plurality of metadata to reference the duplicate one of the plurality of files.

Assignments (2)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jan 6, 2022
From: MOTIVALA, ASHISH; DAGEVILLE, BENOIT
To: SNOWFLAKE COMPUTING INC.
Reel/Frame 058584/0023 →
CHANGE OF NAME Recorded Jan 6, 2022
From: SNOWFLAKE COMPUTING INC.
To: SNOWFLAKE INC.
Reel/Frame 058662/0074 →
Continuity (7)
Continuation 17331464 · May 26, 2021
Continuation 16953315 · Nov 19, 2020
Continuation 16741693 · Jan 13, 2020
Continuation 15171859 · Jun 2, 2016
Continuation In Part 14518884 · Oct 20, 2014
Provisional Application 61941986 · Feb 19, 2014
Related Publication 20220129480A1 · Apr 28, 2022