SYSTEMS AND METHODS FOR DATABASE ARCHIVING
1 Assignment
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.
42 Citations
21 Claims
-
1. (canceled)
-
2. A method of archiving database data, the method comprising:
-
with a first data agent separate from a first database application and executing on a first computing device comprising computer hardware; receiving instructions to archive a first subset of data in the first database, the first database stored in one or more first storage devices residing in a primary storage subsystem together with the first computing device, wherein the primary storage subsystem stores an aggregated group of data of the first database designated for archiving, the aggregated group of data being separate from the first database; identifying a second subset of data in the first database, the second subset referenced by the first subset; obtaining the first and second subsets of data from the first database; adding the first and second subsets to the aggregated group of data of the first database, the aggregated group of data including data accumulated from a plurality of prior archiving requests such that archived data can be copied from the primary storage subsystem to a secondary storage subsystem more efficiently and with less storage operations than in a piecemeal manner; with a secondary storage controller computer, copying the aggregated group of data from the primary storage subsystem to the one or more secondary storage devices, and deleting at least the first and second subsets of data from the first database. - View Dependent Claims (3, 4, 5, 6, 7, 8)
-
-
9. A data storage system configured to archive data generated by one or more database applications, the data storage system comprising:
-
one or more first storage devices residing in a primary storage subsystem; one or more secondary storage devices residing in a secondary storage subsystem; one or more secondary storage controller computers; 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 stored in the one or more first storage devices residing in the primary storage subsystem, wherein the primary storage subsystem stores an aggregated group of data of the first database designated for archiving, the aggregated group of data being separate from the first database; identify a second subset of data in the first database, the second subset referenced by the first subset; obtain the first and second subsets of data from the first database; and add the first and second subsets to the aggregated group of data of the first database, the aggregated group of data including data accumulated from a plurality of prior archiving requests such that archived data can be copied from the primary storage subsystem to the secondary storage subsystem more efficiently and with less storage operations than in a piecemeal manner; the one or more secondary storage controller computers configured to copy the aggregated group of data from the primary storage subsystem to the one or more secondary storage devices, and direct the deletion of at least the first and second subsets of the data. - View Dependent Claims (10, 11, 12, 13, 14)
-
-
15. A non-transitory computer readable medium comprising instructions for archiving database data, 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 stored in one or more first storage devices residing in a primary storage subsystem together with the first computing device, wherein the primary storage subsystem stores an aggregated group of data of the first database designated for archiving, the aggregated group of data being separate from the first database; identifying a second subset of data in the first database, the second subset referenced by the first subset; obtaining the first and second subsets of data from the first database; adding the first and second subsets to the aggregated group of data, the aggregated group of data including data accumulated from a plurality of prior archiving requests, such that archived data can be copied from the primary storage subsystem to a secondary storage subsystem more efficiently and with less storage operations than in a piecemeal manner; copying the aggregated group of data from the primary storage subsystem to the one or more secondary storage devices; and deleting at least the first and second subsets of data from the first database. - View Dependent Claims (16, 17, 18, 19, 20, 21)
-
Specification