HYBRID BACKUP AND RECOVERY MANAGEMENT SYSTEM FOR DATABASE VERSIONING AND VIRTUALIZATION WITH DATA TRANSFORMATION

• US 20170075765A1
• Filed: 09/14/2015
• Published: 03/16/2017
• Est. Priority Date: 09/14/2015
• Status: Abandoned Application

• Current Assignee: ProphetStor Data Services, Inc.
• Original Assignee: ProphetStor Data Services, Inc.
• Inventors: CHEN, Wen Shyen
• Application Number:
  US14/852,864
• Publication Number:
  US 20170075765A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 11/1451 by selection of backup contents
• CPC Class Codes: G06F 11/1464 for networked environments
• CPC Class Codes: G06F 11/1469 Backup restoration techniques
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 2201/80 Database-specific techniques
• CPC Class Codes: G06F 2201/805 Real-time
• CPC Class Codes: G06F 2201/84 Using snapshots, i.e. a logical point-in-time copy of the data

Abstract

A hybrid backup and recovery management system for database versioning and virtualization with data transformation is disclosed. The hybrid backup and recovery management system includes at least one original storage device, at least one target storage device, a database managing sub-system, and a conversion module. The present invention takes advantages of fast speed of data transmitting in volume level format while let DBAs see the procedure and interface of backup and recovery are the same as what they are used to (file level format). Current database management system can be kept just with some modules plugged in. Fast backup and recovery can be achieved.

Claims

1. A hybrid backup and recovery management system for database versioning and virtualization with data transformation, comprising:

at least one original storage device, capable of processing snapshot on an original volume therein where a database is located;

at least one target storage device, for building up image of the original volume;

a database managing sub-system, for receiving an initial backup command and an incremental backup command, flushing current actions in the original volume according to the initial backup command or the incremental backup command, recording the time the initial backup command or the incremental backup command is received as a time tag in a time tag area, instructing the original storage device(s) to process snapshot on the original volume, storing all snapshotted blocks in the original volume to a target volume in according to the initial backup command, storing changed files between last two snapshots to the target volume according to the incremental backup command, and recovering the database; and

a conversion module, for converting the blocks in the target volume after storing of blocks in the target volume has finished into a format of a plurality of files which are the same as the files in the original volume when the first snapshot took place, and storing changed parts of the changed files which were changed between two snapshots to other available blocks in the target volume.

wherein a mapping table in the conversion module keeps a mapping relationship between the blocks and the corresponding converted files or between the changed files and corresponding blocks.

2. The hybrid backup and recovery management system according to claim 1, wherein a recovery management module is connected to the at least one original storage device via the database managing sub-system, for sending the initial backup command and the incremental backup command, checking if the files being backed up in the target volume are the same as that in the original volume, and sending a recovery command to the database managing sub-system to conduct recovering of the database.

3. The hybrid backup and recovery management system according to claim 1, wherein the conversion module is a software, a hardware or a firmware.

4. The hybrid backup and recovery management system according to claim 1, further comprising:

an application module, for changing data format of data in the target volume from one database system to another, and/or adding a new function to the target volume so that the stored data are able to provide the new function to the original volume after the database is recovered by the stored data.

5. The hybrid backup and recovery management system according to claim 4, wherein the new function is booting a host, or changing the at least one original storage device to at least one virtual machine disks.

6. The hybrid backup and recovery management system according to claim 4, wherein the application module is a software, a hardware or a firmware.

7. The hybrid backup and recovery management system according to claim 1, wherein the original storage device is a Hard Disk Drive (HDD), a Solid State Disk (SSD), or a hybrid disk.

8. A backup method using the hybrid backup and recovery management system according to claim 2, comprising the steps of:

A. sending the initial backup command to the database managing sub-system by the recovery management module;

B. flushing current actions in the original volume according to the initial backup command;

C. recording the time the initial backup command is received as the time tag;

D. processing snapshot on the original volume by the at least one original storage device instructed by the recovery management module;

E. storing all snapshotted blocks in the original volume to the target volume in the at least one target storage device according to the initial backup command;

F. converting the blocks in the target volume after storing of blocks in the target volume has finished into a format of a plurality of files by the conversion module; and

G. checking if the files being backed up in the target volume are the same as that in the original volume by the recovery management module.

9. The backup method according to claim 8, further comprising the steps of:

H. sending the incremental backup command to the database managing sub-system by the recovery management module;

I. flushing current actions in the original volume according to the incremental backup command;

J. recording the time the incremental backup command is received as another time tag in the time tag area;

K. processing snapshot on the original volume by the at least one original storage device instructed by the recovery management module;

L. storing changed parts of the changed files which were changed between two snapshots according to the incremental backup command to other available blocks in the target volume;

M. keeping a mapping relationship between the changed part of the changed files and corresponding blocks; and

N. checking if the files being backed up in the target volume are the same as that in the original volume by the recovery management module.

10. A backup method using the hybrid backup and recovery management system according to claim 2, comprising the steps of:

A. sending the recovery command to the database managing sub-system to conduct recovering of the database by the recovery management module;

B. assigning a recovery time from one specific time tag to be recovered; and

C. recovering the database to the condition at the recovery time by copying files mapped to the associated files in the target volume according to the mapping table.