Information processor, information processing system, data archiving method, and data deletion method
First Claim
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 to cause the deletion target untouched during the processing of the data manipulation command; and
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,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, andthe 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.
1 Assignment
0 Petitions
Accused Products
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.
24 Citations
14 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 to cause the deletion target untouched during the processing of the data manipulation command; and 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, 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, and 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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. 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 to cause the deletion target untouched during the processing of the data manipulation command; and wherein; the deletion target conditioned by the archive preparation command is registered in association with a requestor identifier of the command, 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, and 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. - View Dependent Claims (11, 12, 13, 14)
-
Specification