Method and system for a safe archiving of data

Patent metadata

Field	Value
Publication number	US-10013312-B2
Application number	US-201414495412-A
Country	US
Kind code	B2
Filing date	Sep 24, 2014
Priority date	Nov 19, 2013
Publication date	Jul 3, 2018
Grant date	Jul 3, 2018

Abstract

A method for archiving a predefined portion of a table residing in a database system includes: creating a first backup copy of the portion of the table; assigning to the portion of the table an access state flag; setting the access state flag; using the access state flag for preventing modification of existing backup copies of the portion of the table and for preventing further backup operations on the portion of the table; archiving the portion of the table to a separate system; deleting the content of the portion of the table from the database system and retaining the access state flag in the database system.

First claim

What is claimed is:

1. A computer implemented method for archiving a portion of a table residing in a database system, the method comprising:
creating a first backup copy of the portion of the table and assigning a first identifier to the first backup copy using a first identification algorithm;
assigning to the portion of the table an access state flag;
in response to the creation of the first backup copy, setting the access state flag assigned to the portion of the table, wherein the access state flag is used for preventing modification of the first backup copy of the portion of the table and for preventing further backup operations on the portion of the table after the access state flag is set;
archiving and deleting the content of the portion of the table from the database system and retaining the access state flag in the database system;
determining a second backup copy of the portion of the table was created and assigned a second identifier using a second identification algorithm after the first backup copy was created and before the setting of the access state flag assigned to the portion of the table;
in response to determining that the second backup copy was created, unsetting the access state flag assigned to the portion of the table and creating a third backup copy of the portion of the table using the first backup copy, and assigning a third identifier to the third backup copy using the first identification algorithm; and
in response to the creation of the third backup copy, resetting the access state flag assigned to the portion of the table.

2. The method of claim 1 , further comprising:
unsetting the access state flag before deleting the content of the portion of the table from the database system; and
resetting the access state flag after deleting the content of the portion of the table from the database system.

3. The method of claim 1 , further comprising after deleting the content of the portion of the table from the database system:
determining that the portion of the table was unmodified by an operation excluding the deleting of the content of the portion of the table from the database system after creating the third backup copy of the portion of the table;
determining that the third backup copy is the last backup copy of the portion of the table, and ending the method successfully.

4. The method of claim 3 , further comprising:
determining that the portion of the table was unmodified by an operation excluding the deleting of the content of the portion of the table from the database system after creating the third backup copy of the portion of the table;
determining that the third backup copy is invalid in response to a determination that a fourth later backup copy of the portion of the table exists, the fourth later backup copy created before the resetting of the access state flag;
unsetting the access state flag;
restoring the portion of the table using the third backup copy;
creating a new backup copy of the portion of the table;
reassigning to the portion of the table the access state flag;
resetting the access state flag; and
archiving and deleting the content of the portion of the table from the database system and retaining the access state flag in the database system.

5. The method of claim 4 , further comprising:
in response to a determination, after creating the third backup copy of the portion of the table, that the portion of the table was modified by an operation excluding the deleting of the content of the portion of the table from the database system, the determining of the modification to the portion of the table using statistical data associated with the portion of the table, the modification occurring before the deletion of the content of the portion of the table,
unsetting the access state flag;
restoring the portion of the table using the third backup copy,
applying the determined modification to the portion of the table;
creating a fourth backup copy of the modified portion of the table;
assigning to the modified portion of the table the access state flag;
setting the access state flag, wherein the access state flag is used for preventing modification of the fourth backup copy of the modified portion of the table and for preventing further backup operations on the modified portion of the table; and
archiving and deleting content of the modified portion of the table from the database system and the retaining of the access state flag in the database system.

6. The method of claim 1 , wherein the deleting of the content of the portion of the table from the database system is performed by a deletion module of the database system, the method further comprising: controlling the deletion module to delete the portion of the table independent of the access state flag being set or not.

7. The method of claim 1 , wherein the creation of a first backup copy is performed by a backup module of the database system, the method further comprising controlling the backup module to include the creating of the first backup copy, and assigning of the portion of the table the access state flag, and the setting of the access state flag as an atomic operation.

8. The method of claim 1 , further comprising:
receiving a request to restore the portion of the table;
unsetting the access state flag;
restoring the portion of the table using the third backup copy.

9. A computer program product for archiving a portion of a table residing in a database system, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, wherein the computer readable storage medium is not a transitory signal per se, the program instructions executable by a processor to cause the processor to perform a method comprising:
creating a first backup copy of the portion of the table and assigning a first identifier to the first backup copy using a first identification algorithm;
assigning to the portion of the table an access state flag;
in response to the creation of the first backup copy, setting the access state flag wherein the access state flag is used for preventing modification of the first backup copy of the portion of the table and for preventing further backup operations on the portion of the table after the access state flag is set;
archiving and deleting the content of the portion of the table from the database system and retaining the access state flag in the database system;
determining a second backup copy of the portion of the table was created and assigned a second identifier using a second identification algorithm after the first backup copy was created and before the setting of the access state flag assigned to the portion of the table;
in response to determining that the second backup copy was created, unsetting the access state flag assigned to the portion of the table and creating a third backup copy of the portion of the table using the first backup copy, and assigning a third identifier to the third backup copy using the first identification algorithm; and
in response to the creation of the third backup copy, resetting the access state flag assigned to the portion of the table.

10. A database system for archiving a portion of a table residing in the database system, the database system comprising:
a processor; and
a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a processor to cause the processor to perform a method comprising:
creating a first backup copy of the portion of the table and assigning a first identifier to the first backup copy using a first identification algorithm;
assigning to the portion of the table an acces

Assignees

• IBM

Inventors

• Broll Bjoern
• Kempfert Claus
• Koeth Oliver
• Kunioka-Weis Laura M
• Stolze Knut

Classifications

• G06F16/27 Primary

  Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor · CPC title

• G06F16/21 Primary

  Design, administration or maintenance of databases · CPC title

• G06F16/113

  Details of archiving (lifecycle management in storage systems G06F3/0649; point-in-time backing up or restoration of persistent data G06F11/1446) · CPC title

• G06F11/1451 Primary

  by selection of backup contents · CPC title

• G06F11/1458

  Management of the backup or restore process · CPC title