Tiered database storage and replication

• US 7,613,747 B1
• Filed: 06/08/2005
• Issued: 11/03/2009
• Est. Priority Date: 06/08/2005
• Status: Active Grant

• Current Assignee: T-Mobile Innovations LLC (Deutsche Telekom AG)
• Original Assignee: Sprint Communications Company LP (Deutsche Telekom AG)
• Inventors: Mirza, Nasir Mahmood, Thakur, Brajendra Singh
• Primary Examiner(s): Vital; Pierre M
• Assistant Examiner(s): Nofal; Christopher P
• Application Number:
  US11/147,932
• Time in Patent Office: 1,609 Days
• Field of Search: 707/204
• US Class Current: 707/640
• CPC Class Codes: G06F 11/1451 by selection of backup contents
• CPC Class Codes: G06F 11/1456 Hardware arrangements for backup
• CPC Class Codes: G06F 11/1461 Backup scheduling policy
• CPC Class Codes: G06F 2201/80 Database-specific techniques
• CPC Class Codes: Y10S 707/99955 Archiving or backup

Abstract

A storage network comprising a production database configured to store a first production section on a first tier production storage system and a second production section on a second tier production storage system, a backup database configured to store a first backup section on a first tier backup storage system and a second backup section on a second tier production storage system, and a storage control system configured to replicate the first production section to the first backup session at a first frequency and replicate the second production section to the second backup section at a second frequency that is less than the first frequency.

Claims

1. A storage network comprising:

a first tier production storage system configured to store a first production section of a production database;

a second tier production storage system configured to store a second production section of the production database;

a first tier backup storage system configured to store a first backup section of a backup database;

a second tier backup storage system configured to store a second backup section of the backup database; and

a storage control system configured to replicate the first production section on the first tier production storage system to the first backup section on the first tier backup storage system at a first frequency and replicate the second production section on the second tier production storage system to the second backup section on the second tier backup storage system at a second frequency that is less than the first frequency;

wherein the first production section comprises a first collection of production data, wherein each of the first collection of production data is associated with a first time frame, and wherein the second production section comprises a second collection of production data, wherein each of the second collection of production data is associated with a second time frame older than the first time frame;

wherein the second time frame immediately precedes the first time frame;

wherein the first time frame and the second time frame each comprises a movable time frame defined in relation to a current time;

wherein the storage control system is configured to transfer data within the first production section on the first tier production storage system no longer associated with the first time frame to the second production section on the second tier production storage system; and

wherein the storage control system is configured to replicate the second production section on the second tier production storage system to the second backup section on the second tier backup storage system by transferring data within the first backup section on the first tier backup storage system no longer associated with the first time frame to the second backup section on the second tier backup storage system.

2. The storage network of claim 1 wherein the storage control system is further configured to receive new production data, process the new production data to determine if the new production data is associated with the first time frame or the second time frame, store the new production data in the first production section if the new production data is associated with the first time frame, and store the new production data in the second production section if the new production data is associated with the second time frame.

3. The storage network of claim 1 wherein the second tier production storage system has a lower quality than the first tier production storage system.

4. The storage network of claim 3 wherein the second tier backup storage system has a lower quality than the first tier backup storage system.

5. The storage network of claim 1 wherein the production database comprises a call record database.

6. The storage network of claim 1 wherein the first frequency comprises once per day and wherein the second frequency comprises once per month.

7. A computer-implemented method of operating a storage network, the method comprising:

storing a first production section of a production database on a first tier production storage system;

storing a second production section of the production database on a second tier production storage system;

storing a first backup section of a backup database on a first tier backup storage system;

storing a second backup section of the backup database a second tier backup storage system;

replicating the first production section on the first tier production storage system to the first backup section on the first tier backup storage system at a first frequency; and

replicating the second production section on the second tier production storage system to the second backup section on the second tier backup storage system at a second frequency that is less than the first frequency;

wherein the first production section comprises a first collection of production data, wherein each of the first collection of production data is associated with a first time frame, and wherein the second production section comprises a second collection of production data, wherein each of the second collection of production data is associated with a second time frame older than the first time frame;

wherein the second time frame immediately precedes the first time frame;

wherein the first time frame and the second time frame each comprises a movable time frame defined in relation to a current time;

wherein the method further comprises transferring data within the first production section on the first tier production storage system no longer associated with the first time frame to the second production section on the second tier production storage system; and

wherein replicating the second production section on the second tier production storage system to the second backup section on the second tier backup storage system comprises transferring data within the first backup section on the first tier backup storage system no longer associated with the first time frame to the second backup section on the second tier backup storage system.

8. The method of claim 7 further comprising receiving new production data, processing the new production data to determine if the new production data is associated with the first time frame or the second time frame, storing the new production data in the first production section if the new production data is associated with the first time frame, and storing the new production data in the second production section if the new production data is associated with the second time frame.

9. The method of claim 7 wherein the second tier production storage system has a lower quality than the first tier production storage system.

10. The method of claim 7 wherein the second tier backup storage system has a lower quality than the first tier backup storage system.

11. The method of claim 7 wherein the production database comprises a call record database.

12. The method of claim 7 wherein the first frequency comprises once per day and wherein the second frequency comprises once per month.

13. A computer-readable storage medium storing computer executable instructions for operating a storage control system, the computer executable instructions, when executed by a computer system, directing the computer system to:

store a first production section of a production database on a first tier production storage system, store a second production section of the production database on a second tier production storage system, store a first backup section of a backup database on a first tier backup storage system, store a second backup section of the backup database a second tier backup storage system, replicate the first production section on the first tier production storage system to the first backup section on the first tier backup storage system at a first frequency, and replicate the second production section on the second tier production storage system to the second backup section on the second tier backup storage system at a second frequency that is less than the first frequency;

wherein the first production section comprises a first collection of production data, wherein each of the first collection of production data is associated with a first time frame, and wherein the second production section comprises a second collection of production data, wherein each of the second collection of production data is associated with a second time frame older than the first time frame;

wherein the second time frame immediately precedes the first time frame;

wherein the first time frame and the second time frame each comprises a movable time frame defined in relation to a current time;

wherein the computer executable instructions direct the computer system to transfer data within the first production section on the first tier production storage system no longer associated with the first time frame to the second production section on the second tier production storage system; and

wherein the computer executable instructions direct the computer system to replicate the second production section on the second tier production storage system to the second backup section on the second tier backup storage system by directing the computer system to transfer data within the first backup section on the first tier backup storage system no longer associated with the first time frame to the second backup section on the second tier backup storage system.