SYSTEMS AND METHODS FOR DATABASE ARCHIVING

• US 20140025641A1
• Filed: 03/06/2013
• Published: 01/23/2014
• Est. Priority Date: 07/20/2012
• Status: Active Grant

• Current Assignee: CommVault Systems Incorporated
• Original Assignee: CommVault Systems Incorporated
• Inventors: Kumarasamy, Paramasivam, Vallabhaneni, Brahmaiah
• Granted Patent: US 9,275,086 B2
• Time in Patent Office: Days
• US Class Current: 707/661
• CPC Class Codes: G06F 11/1456 Hardware arrangements for backup
• CPC Class Codes: G06F 11/2094 Redundant storage or storage space G06F11/2056 takes precedence
• CPC Class Codes: G06F 16/214 Database migration support
• CPC Class Codes: G06F 16/219 Managing data history or versioning querying versioned data G06F16/2474; querying temporal data G06F16/2477
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor

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.

Claims

1. A method of archiving data generated by one or more database applications in a networked data storage system, the method comprising:

receiving instructions to archive a logical subset of data in a stored database, the data organized in a plurality of tables, generated by a database application residing on a first client computing device, and stored in a first information store associated with the first client computing device;

processing, by one or more processors, the database data according to a native schema of the database application to identify data items in the stored database that correspond to the logical subset;

accessing the identified data items from the stored database;

copying the accessed data items to one or more secondary storage devices to create a secondary copy of the data items; and

following said copying, pruning the identified data items from the stored database.

2. The method of claim 1, wherein said accessing comprises using a native command interface of the database application to read the data items from the information store.

3. The method of claim 1, wherein said copying comprises using a native command interface of the database application.

4. The method of claim 1, wherein said pruning comprises using a native command interface of the database application.

5. The method of claim 1, wherein said processing further comprises:

identifying a record in a first table corresponding to a first portion of the logical subset;

identifying a record in a second table corresponding to a second portion of the logical subset and which references the record in the first table; and

deleting the record in the second table before deleting the record in the first table.

6. The method of claim 1, wherein said processing comprises traversing the tables in the database to identify each of the data items forming the logical subset, wherein at least some of the data items reside in different tables and reference one another.

7. The method of claim 1, wherein said copying comprises writing a plurality of the accessed data items to a temporary location and copying all or a subset of the plurality of the accessed data items from the temporary location to the one or more secondary storage devices.

8. The method of claim 1, wherein the database application comprises a relational database.

9. A data storage system configured to archive data generated by one or more database applications, comprising:

a client computing device; and

a database archiving module executing in one or more processors of the client computing device that is configured to;

receive instructions to archive a logical subset of data in a stored database, the data organized in a plurality of tables, generated by a database application residing on a first client computing device, and stored in a first information store associated with the first client computing device;

process the database data according to a native schema of the database application to identify data items in the stored database that correspond to the logical subset;

access the identified data items from the stored database;

copy the accessed data items to one or more secondary storage devices to create a secondary copy of the data items; and

following said copying, prune the identified data items from the stored database.

10. The data storage system of claim 9, wherein said accessing comprises using a native command interface of the database application to read the data items from the information store.

11. The data storage system of claim 9, wherein said copying comprises using a native command interface of the database application.

12. The data storage system of claim 9, wherein said pruning comprises using a native command interface of the database application.

13. The data storage system of claim 9, wherein said processing further comprises:

identifying a record in a first table corresponding to a first portion of the logical subset;

identifying a record in a second table corresponding to a second portion of the logical subset and which references the record in the first table; and

deleting the record in the second table before deleting the record in the first table.

14. The data storage system of claim 9, wherein said processing comprises traversing the tables in the database to identify all of the data items forming the logical subset, wherein at least some of the data items reside in different tables and reference one another.

15. The data storage system of claim 9, wherein said copying comprises writing a plurality of the accessed data items to a temporary location and copying all or a subset of the plurality of the accessed data items from the temporary location to the one or more secondary storage devices.

16. The data storage system of claim 9, wherein the database application comprises a relational database.

17. A computer readable medium comprising instructions for archiving data generated by one or more database applications in a networked data storage system, that cause a processor to:

receive instructions to archive a logical subset of data in a stored database, the data organized in a plurality of tables, generated by a database application residing on a first client computing device, and stored in a first information store associated with the first client computing device;

process the database data according to a native schema of the database application to identify data items in the stored database that correspond to the logical subset;

access the identified data items from the stored database;

copy the accessed data items to one or more secondary storage devices to create a secondary copy of the data items; and

following said copying, prune the identified data items from the stored database.