INFORMATION PROCESSOR, INFORMATION PROCESSING SYSTEM, DATA ARCHIVING METHOD, AND DATA DELETION METHOD

• US 20110178990A1
• Filed: 12/20/2010
• Published: 07/21/2011
• Est. Priority Date: 01/20/2010
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Ohkawa, Masahiro
• Granted Patent: US 8,849,766 B2
• Time in Patent Office: Days
• US Class Current: 707/662
• CPC Class Codes: G06F 13/00 Interconnection of, or transfer of information or other signals between, memories, input/output devices or central processing units interface circuits for specific input/output devices G06F3/00 ; multiprogram control therefor G06F9/46; multiprocessor systems G06F15/16
• CPC Class Codes: G06F 16/00 Information retrieval; Database structures therefor; File system structures therefor
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 17/00 Digital computing or data processing equipment or methods, specially adapted for specific functions information retrieval, database structures or file system structures therefor G06F16/00

Abstract

An information processor may include a command receiving unit that receives an immediate processing command in which a deletion target to be deleted from the database is conditioned, and a registration processing unit that registers information defining the deletion target into a management data unit. In addition, the information processor may include a deletion processing unit that deletes the deletion target from a database, and deregisters the deleted deletion target from the management data unit. The information processor can also include a data manipulation command processing unit, which, in the case where a data manipulation command having a manipulation target that coincides with a table of the deletion target registered in the management data unit is received, processes the data manipulation command in a state where a condition to exclude the deletion target from the manipulation target is added to the data manipulation command.

Claims

1. A computer program product for managing a database, the computer program product comprising:

a computer readable storage medium having computer readable program code embodied therewith, the computer readable program code including,

command receiving unit program code configured to receive an immediate processing command having a deletion target to be deleted from the database conditioned therein;

registration processing unit program code configured to register information defining the deletion target according to the immediate processing command into a management data unit;

deletion processing unit program code configured to delete the deletion target according to the immediate processing command from the database, and deregister the deletion target the deletion of which has been completed from the management data unit; and

data manipulation command processing unit program code configured to, in the case where a data manipulation command is received which has a manipulation target that coincides with a table of the deletion target that has been registered in the management data unit, process the data manipulation command in a state where a condition to exclude the deletion target from the manipulation target is added to the data manipulation command.

2. The computer program product of claim 1, wherein the deletion processing unit program code executes a deletion process in a state where the deletion target according to the immediate processing command is not locked in units of records.

3. The computer program product of claim 2, further comprising update or insert command processing unit program code configured to execute a process for an update or insert command, wherein

the deletion processing unit program code executes the deletion process in the state where the deletion target according to the immediate processing command is not locked in units of area, and

in the case where the update or insert command has an update or insert target that coincides with a range of the deletion target that has been registered in the management data unit, the update or insert command processing unit program code returns an error in response to the update or insert command.

4. The computer program product of claim 3, wherein

the immediate processing command is an archive preparation command which conditions the deletion target that is to be retrieved for archiving and then deleted, and

the deletion processing unit program code, in response to an archive deletion execution command instructing execution of the deletion of the intended deletion target, starts the process of deleting the deletion target according to the archive preparation command that has been registered in the management data unit.

5. The computer program product of claim 4, wherein

the registration processing unit program code registers the information into the management data unit by further associating thereto a requestor identifier of the archive preparation command, and

the data manipulation command processing unit program code refrains from adding the condition to exclude the deletion target from the manipulation target in the case where the deletion target has the same requestor as that of the data manipulation command.

6. The computer program product of claim 5, wherein in the case where the update or insert command has the update or insert target that coincides with only the range of the deletion target having the same requestor as that of the update or insert command, the update or insert command processing unit program code executes the processing according to the update or insert command without returning an error.

7. The computer program product of claim 3, wherein

the immediate processing command is an immediate deletion command which conditions the deletion target to be immediately deleted, and

the deletion processing unit program code starts the deletion process according to the immediate deletion command after information defining the deletion target according to the immediate deletion command is registered in the management data unit.

8. The computer program product of claim 7, wherein the database is a replication database which has been replicated from a production database,

the computer readable storage medium further including command relay unit program code configured to receive a command issued to the production database and transfer the command to the replication database, wherein

upon receipt of an archive preparation command which conditions a deletion target that is to be retrieved for archiving and then deleted from the production database and the replication database, the command relay unit program code registers information defining the deletion target into an archive management data unit,

upon receipt of a data manipulation command which is related to a table of the deletion target that has been registered in the archive management data unit, the command relay unit program code queues the data manipulation command, and

upon receipt of an archive deletion execution command instructing execution of the deletion of the intended deletion target, the command relay unit program code issues to the replication database an immediate deletion command for the deletion target that has been registered in the archive management data unit and deregisters the deletion target from the archive management data unit, and the command relay unit program code further issues to the replication database any of the queued data manipulation commands that is related to the table of the deregistered deletion target.

9. The computer program product of claim 2, wherein the deletion target according to the immediate processing command is modified to a range that is obtained by excluding, from the deletion target conditioned by the immediate processing command, the deletion target in the same table that has been registered in the management data unit.

10. The computer program product of claim 2, further comprising an environment variable which designates whether to lock the deletion target in units of area during the process of deleting the deletion target according to the immediate processing command, wherein

in the case where the environment variable designates a need of the per-area lock, when the update or insert target of the update or insert command coincides with the range of the deletion target that has been registered in the management data unit, the update or insert process according to the update or insert command is executed after the per-area lock is released in response to the completion of the deletion process according to the immediate processing command.

11. A computer program product for managing a production database and a replication database replicated from the production database by a plurality of computers, the computer program product comprising:

a computer readable storage medium having computer readable program embodied therewith, the computer readable program code including,

command relay unit program code configured to receive a command issued to the production database and transferring the command to the replication database, wherein

upon receipt of an archive preparation command which conditions a deletion target that is to be retrieved for archiving and then deleted from the production database and the replication database, the command relay unit program code registers information defining the deletion target into an archive management data unit,

upon receipt of a data manipulation command which is related to a table of the deletion target that has been registered in the archive management data unit, the command relay unit program code queues the data manipulation command, and

upon receipt of an archive deletion execution command instructing execution of the deletion of the intended deletion target, the command relay unit program code issues to the replication database an immediate deletion command for the deletion target that has been registered in the archive management data unit and deregisters the deletion target from the archive management data unit, and the command relay unit program code further issues to the replication database any of the queued data manipulation commands that is related to the table of the deregistered deletion target; and

the replication database, wherein the replication database comprises

registration processing unit program code, upon receipt of the immediate deletion command, configured to register information defining a deletion target conditioned by the immediate deletion command into a deletion target management data unit,

deletion processing unit program code configured to delete the deletion target according to the immediate deletion command from the replication database and deregister the deletion target the deletion of which has been completed from the deletion target management data unit, and

data manipulation command processing unit program code, upon receipt of a data manipulation command that has a manipulation target that coincides with a table of the deletion target that has been registered in the deletion target management data unit, configured to process the data manipulation command in a state where a condition to exclude the deletion target from the manipulation target is added to the data manipulation command.

12. The computer program product of claim 11, wherein

the deletion target conditioned by the archive preparation command is registered in association with a requestor identifier of the command, and

the command relay unit program code, upon receipt of the archive deletion execution command, issues the immediate deletion command for the deletion target that has been registered in the archive management data unit and that has the matching requestor.

13. The computer program product of claim 12, wherein in response to an inquiry about a status of archiving, the command relay unit program product returns information about the deletion target that has been registered in the archive management data unit and that has a requestor identifier matching a designated requestor identifier.

14. A method, performed by a computer, for archiving data stored in a database, comprising:

receiving an archive preparation command which conditions a deletion target that is to be retrieved for archiving and then deleted from the database;

registering information defining the deletion target according to the archive preparation command into a management data unit;

in a case where a data manipulation command having a manipulation target that coincides with a table of the deletion target that has been registered in the management data unit is received, processing the data manipulation command in a state where a condition to exclude the deletion target from the manipulation target is added to the data manipulation command;

in response to an archive deletion execution command, reading from the management data unit the intended deletion target registered therein and starting the process of deleting the intended deletion target from the database; and

in response to the completion of the deletion process, deregistering from the management data unit the deletion target the deletion of which has been completed.

15. The data archiving method according to claim 14, wherein in starting the process of deleting, the process of deleting the deletion target is executed in a state where the deletion target according to the archive preparation command is not locked in units of records.

16. The data archiving method according to claim 15, further comprising the steps, performed by the computer, of:

receiving an update or insert command; and

returning an error in response to the update or insert command having an update or insert target that coincides with a range of the deletion target that has been registered in the management data unit;

wherein

in starting the process of deleting, the process of deleting the deletion target is executed in the state where the deletion target is not locked in units of area either.

17. A method, performed by a computer, for deleting data from a database, comprising:

receiving an immediate deletion command having a deletion target to be immediately deleted from the database conditioned therein;

registering information defining the deletion target according to the immediate deletion command into a management data unit;

starting a process of deleting the deletion target according to the immediate deletion command from the database;

in a case where a data manipulation command is received which has a manipulation target that coincides with a table of the deletion target that has been registered in the management data unit, processing the data manipulation command in the state where a condition to exclude the deletion target from the manipulation target is added to the data manipulation command; and

in response to the completion of the deletion process, deregistering from the management data unit the deletion target the deletion of which has been completed.

18. The data deletion method according to claim 17, wherein the step of starting the process of deleting is executed in the state where the deletion target according to the immediate deletion command is not locked in units of records.

19. The data deletion method according to claim 18, further comprising the steps, performed by the computer, of:

receiving an update or insert command; and

returning an error in response to the update or insert command having an update or insert target that coincides with a range of the deletion target that has been registered in the management data unit;

wherein

in the step of starting the process of deleting, the process of deleting the deletion target is executed in the state where the deletion target is not locked in units of area either.

20. A method for archiving data, comprising the steps, performed by a command relay unit, of:

receiving an archive preparation command issued to a production database, the archive preparation command conditioning a deletion target that is to be retrieved for archiving and then deleted from the production database and a replication database, wherein the replication database is replicated from the production database by a plurality of computers;

registering information defining the deletion target conditioned by the archive preparation command into an archive management data unit;

receiving a data management command related to a table of the deletion target registered in the archive management data unit, and queuing the data manipulation command;

receiving an archive deletion execution command issued to the production database, the archive deletion execution command instructing execution of the deletion of the intended deletion target;

issuing to the replication database an immediate deletion command for the deletion target that has been registered in the archive management data unit;

deregistering from the archive management data unit the deletion target for which the immediate deletion command has been issued; and

issuing to the replication database any of the queued data manipulation commands that is related to the table of the deregistered deletion target;

the method further comprising the steps, performed by the replication database, of;

in response to the immediate deletion command, registering information defining the deletion target conditioned by the immediate deletion command into a deletion target management data unit;

deleting the deletion target conditioned by the immediate deletion command from the replication database;

in a case where a data manipulation command is received which has a manipulation target that coincides with the table of the deletion target that has been registered in the deletion target management data unit, processing the data manipulation command in a state where a condition to exclude the deletion target from the manipulation target is added to the data manipulation command; and

deregistering from the deletion target management data unit the deletion target the deletion of which has been completed.