SYSTEMS AND METHODS FOR DATABASE ARCHIVING
First Claim
1. A method of archiving database data a first database application in a networked data storage system, the method comprising:
- with a first data agent separate from the first database application and executing on a first computing device comprising computer hardware;
receiving instructions to archive a first subset of data in the storcd first database, the first database organized as a plurality of tables and stored in one or more first storage devices, the first subset of data contained in one or more first tables of the plurality of tables, the first database generated by a first database application residing on the first computing device;
identifying a second subset of data in the first database, the second subset referenced by the first subset and contained in one or more second tables of the plurality of tables;
obtaining the first and second subsets of data from the first database;
adding the first subset and second subsets to a group of data of the first database previously designated for archiving; and
deleting at least the first and second subsets of data from the first database,wherein subsequent to said adding, the group of data designated for archiving, including the first and second subsets, is copied to one or more secondary storage devices, andwherein the first subset includes at least a first data item and the second subset includes at least one data item referenced by the first data item.
2 Assignments
0 Petitions
Accused Products
Abstract
A data storage system according to certain aspects can archive database data associated with different database applications. The data storage system according to certain aspects may provide database archiving modules that include logic incorporating and/or based on the native schema and/or native commands specific to particular database applications. The database archiving modules according to certain aspects may determine the relationship between tables associated with corresponding database applications and archive selected database data based on the native schema and native commands.
14 Citations
20 Claims
-
1. A method of archiving database data a first database application in a networked data storage system, the method comprising:
-
with a first data agent separate from the first database application and executing on a first computing device comprising computer hardware; receiving instructions to archive a first subset of data in the storcd first database, the first database organized as a plurality of tables and stored in one or more first storage devices, the first subset of data contained in one or more first tables of the plurality of tables, the first database generated by a first database application residing on the first computing device; identifying a second subset of data in the first database, the second subset referenced by the first subset and contained in one or more second tables of the plurality of tables; obtaining the first and second subsets of data from the first database; adding the first subset and second subsets to a group of data of the first database previously designated for archiving; and deleting at least the first and second subsets of data from the first database, wherein subsequent to said adding, the group of data designated for archiving, including the first and second subsets, is copied to one or more secondary storage devices, and wherein the first subset includes at least a first data item and the second subset includes at least one data item referenced by the first data item. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A data storage system configured to archive data generated by one or more database applications:
-
one or more first storage devices residing in a primary storage subsystem; one or more secondary storage devices residing in a secondary storage subsystem; and a plurality of client computing devices residing in the primary storage subsystem and including a first client computing device that is associated with one or more first storage devices and comprises a first database application and a first data agent residing thereon, the first data agent being separate from the first database application and configured to; receive instructions to archive a first subset of data in a first database, the first database organized as a plurality of tables and stored in one or more first storage devices residing in a primary storage subsystem, the first subset of data contained in one or more first tables of the plurality of tables, the first database generated by the first database application; identify a second subset of data in the first database, the second subset referenced by the first subset and contained in one or more second tables of the plurality of tables; obtain the first and second subsets of data from the first database; add the first and second subsets to a group of data of the first database previously designated for archiving; and delete at least the first and second subsets of data from the first database, wherein subsequent to the addition of the first and second subsets to the group of data designated for archiving, the group of data designated for archiving, including the first and second subsets, is copied to one or more secondary storage devices, and wherein the first subset includes at least a first data item and the second subset includes at least one data item referenced by the first data item. - View Dependent Claims (9, 10, 11, 12, 13)
-
-
14. A non-transitory computer readable medium comprising instructions for archiving data generated by one or more database applications in a networked data storage system, where the instructions when executed by a computing system comprising one or more computing devices, cause the computing system to perform a method comprising:
-
receiving instructions to archive a first subset of data in a first database, the first database organized as a plurality of tables and stored in one or more first storage devices, the first subset of data contained in one or more first tables of the plurality of tables, the first database generated by a first database application residing on the first computing device; identifying a second subset of data in the first database, the second subset referenced by the first subset and contained in one or more second tables of the plurality of tables; obtaining the first and second subsets of data from the first database; adding the first and second subsets to a group of data of the first database previously designated for archiving; and deleting at least the first and second subsets of data from the first database, wherein subsequent to said adding, the group of data designated for archiving, including the first and second subsets, is copied to one or more secondary storage devices, and wherein the first subset includes at least a first data item and the second subset includes at least one data item referenced by the first data item. - View Dependent Claims (15, 16, 17, 18, 19, 20)
-
Specification