Cloning catalog objects
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.
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 within a first data file and to second data of the first catalog object within a second data file, and
wherein the second metadata comprises second mappings to the first data of the first catalog object within the first data file, such that at least portions of the first mappings and at least portions of the second mappings are mapped to a same portion of the first data file containing the first data;
modify the second data of the first catalog object independently of the second catalog object; and
generate a response to a data storage or data retrieval request to the first catalog object by accessing the second mappings of the second metadata of the second catalog object.
2. The system of claim 1 , wherein the data storage or data retrieval request is one of a plurality of data storage 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 or data retrieval requests to the first catalog object that modifies the first data of the first catalog object.
3. 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 or data retrieval request to the first catalog object.
4. 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.
5. The system of claim 1 , wherein to access the second mappings of 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 within the first data file while leaving the first metadata mapped to the portion of the first data within the first data file.
6. The system of claim 1 , wherein to access the second mappings of 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 within a second data file; and
updating the second mappings of the second metadata to reference the second data within the second data file.
7. 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.
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 within a first data file and to second data of the first catalog object within a second data file, and
wherein the second metadata comprises second mappings to the first data of the first catalog object within the first data file, such that at least portions of the first mappings and at least portions of the second mappings are mapped to a same portion of the first data file containing the first data;
modifying the second data of the first catalog object independently of the second catalog object; and
generating a response to a data storage or data retrieval request to the first catalog object by accessing the second mappings of the second metadata of the second catalog object.
9. The method of claim 8 , wherein the data storage or data retrieval request is one of a plurality of data storage 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 or data retrieval requests to the first catalog object that modifies the first data of the first catalog object.
10. The method of claim 8 , further comprising deleting the second catalog object after responding to the data storage or data retrieval request to the first catalog object.
11. 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.
12. The method of claim 8 , wherein accessing the second mappings of 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 within the first data file while leaving the first metadata mapped to the portion of the first data within the first data file.
13. 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.
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 within a first data file and to second data of the first catalog object within a second data file, and
wherein the second metadata comprises second mappings to the first data of the first catalog object within the first data file, such that at least portions of the first mappings and at least portions of the second mappings are mapped to a same portion of the first data file containing the first data;
modify the second data of the first catalog object independently of the second catalog object; and
generate a response to a data storage or data retrieval request to the first catalog object by accessing the second mappings of the second metadata of the second catalog object.
15. The non-transitory computer-readable storage medium of claim 14 , wherein the data storage or data retrieval request is one of a plurality of data storage 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 or data retrieval requests to the first catalog object that modifies the first data of the first catalog object.
16. 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 or data retrieval request to the first catalog object.
17. 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.
18. The non-transitory computer-readable storage medium of claim 14 , wherein to access the second mappings of 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 within the first data file while leaving the first metadata mapped to the portion of the first data within the first data file.
19. The non-transitory computer-readable storage medium of claim 14 , wherein to access the second mappings of 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 within a second data file; and
updating the second mappings of the second metadata to reference the second data within the second data file.
20. 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.