JPH11242624A - Computer readable medium recording information managing data, data managing method and computer readable medium recording data managing program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To support the efficient non-conflict execution of the re-cancel of the cancel of the addition/change/deletion of information under processing. SOLUTION: Second information managing data 32 are provided for holding a register number for canceling the addition/change/deletion of information under processing and a register number, with which the information under processing is added/changed/deleted in the beginning, and a recovery indication is provided in first information managing data 31 for expressing a record, which is made invalid by adding/changing/deleting the information under processing, is to be made valid again. Thus, the cancel of the addition/change/deletion of information under processing can be canceled again.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

TECHNICAL FIELD The present invention relates to an SQL (Structur)
The present invention relates to an improvement in a data management method in an information management system created using a resource management mechanism such as a database or an indexed file.

[0002]

2. Description of the Related Art In a computer system having a data management mechanism such as a database or a file, the present inventors have proposed a system in which a service based on business information is started at a certain time (active information) and a business information before a certain time. Can read computer-readable information (log information) that has started a service based on the service but has already finished (logging information) and a service that is scheduled to start a service based on the business information after a certain point in time The information is managed on the medium, and the current information, log information and in-process information are searched, and the current information and in-process information are added / changed / deleted (addition is the addition of a record having new key information, and the change / Delete means a change / deletion to a record that has already been added.)
And a data management method capable of canceling addition / change / deletion of in-process information (Japanese Patent Application No. 9-185450, "Title of Invention: Computer-readable recording medium for recording information management data and data management method") ").

[0003]

In the above-mentioned method, retrieval of current information, log information and in-process information, addition / change / deletion of current information and in-process information, and addition / change of in-process information are performed. / Deletion can be canceled, but there is a problem that addition / change / deletion of in-process information cannot be undone again. (In the conventional method, the cancellation of record invalidation For the record holding the registration number at which the added / changed / deleted information has been deleted as the deletion number, delete the deletion number [return to the state before setting],
For the record that holds the “registration number at which the in-process information was added / changed / deleted at the beginning” as the registration number, the registration number for canceling the addition / change / deletion of the in-process information is added to the deletion number. Is set, and when the cancellation is canceled again, the record to be restored cannot be specified).

An object of the present invention is to support efficient and consistent execution of re-cancellation of addition / change / deletion of in-process information.

[0005]

In order to solve the above-mentioned problems, according to the present invention, a registration number for canceling the addition / change / deletion of the in-process information and the addition / initialization of the in-process information.
In addition to providing second information management data that holds the changed / deleted registration number, addition / change /
A resurrection display is provided to indicate that a record that has been invalidated due to deletion is re-enabled.
The cancellation of the deletion is performed by setting the resurrection display for the record in the second information management data which holds the “registration number at which the in-process information was initially added / changed / deleted” as the deletion number, In the record holding the “registration number at which the in-process information was added / changed / deleted at the beginning” in the second information management data as the registration number, the second number is added to the deletion number.
By setting the "registration number for canceling the addition / change / deletion of in-process information" in the information management data of the "In-process information", the addition / change / deletion of the in-process information is canceled and the display of the resurrection display / Re-cancel the cancellation of invalidation of record by hiding.

[0006]

Embodiments of the present invention will be described below in detail with reference to the drawings.

FIG. 1 is a block diagram of a system having a data management function according to the data management method of the present invention.

In FIG. 1, reference numeral 10 denotes a processing requester (end user) for accessing data managed by the data management system. Reference numeral 20 denotes an application program (AP), for example, a customer management system;
It means a program created for business systems such as a seat reservation system.

Reference numeral 30 denotes a file (actual file) storing data used by the AP 20. As shown in FIG. 2, the real file 30 includes first information management data 31 and second information management data 32, and has the following storage structure.

The start date and time (a) indicates the date and time when the service is started (or started) with the contents of the record.

The end date and time in (b) indicates the date and time when the service based on the contents of the record is ended (or ended).

The valid / invalid information in (c) is composed of a registration number and an erasure number. If the erasure number is not set, the record is valid. If the erasure number is set, the record is valid. Indicates invalid.

Here, the registration number is paid out in units of addition, change, deletion and its cancellation request. The deletion number is set for a record to be invalidated by the request, and its value is the value of the registration number issued by the request. The registration number is the information management data 32 added in the present invention.
Also set. In the case of a cancellation request, the registration number of the cancellation target is also set in the information management data 32.

For example, when applying for the use of a service in the form of a service order, the information for using the service includes contractor information, contract information, service information, a service use start date, and the like. For example, information that can be applied for a plurality of times in one service order and information such as a desired date for starting service use that only one exists in one service order, and the other information is used as service order information. May be stored in the real file 30 separately.

The information management data 31 is, for example, the former information, and the information management data 32 corresponds to the service order information referred to here.

(D) is a resurrection display added in the present invention, and indicates that the invalidation of the record has been canceled (it is assumed that the deletion number is not set even if the deletion number is set) (ON). ). The resurrection display is set only for the record for which the deletion number has already been set. When the set deletion number is made valid again, the set restoration display is deleted (OFF).

(E) AP2 of customer information, contract information, etc.
0 is a portion (hereinafter, referred to as AP data) that holds the conscious information. The first column of the AP data is a key, but in this storage structure, there are a plurality of records having the same key value. The log information, active information, and in-process information having the same key value and being valid (the deletion number has not been set) are temporally continuous (excluding log information).

The above (a), (b), (c) and (d) are used as follows.

When the AP data is searched for “key information for uniquely identifying it (the key of the AP data)” and “a certain point in time”, generally, (a) 0 or one or more “end date / time <a certain point in time” "" Or "Erase number and no resurrection indication" record (b) Zero or more "start date / time <one point <end date and time" and "Essential number is absent or resurrected even if there is an evacuation number" Record with display "(c) Zero or one or more" a certain time point <start date and time "and a record" without a deletion number or with a resurrection display even with a deletion number "are obtained.

In the record (a), the service based on the AP data is terminated at a certain point in time, but the service was started before a certain point in time, or became invalid before starting the service. The “log record” and the record of (b) indicate that the service based on the AP data is started at a certain point in time. It is treated as a "work-in-progress record" that is scheduled to start the service after a certain point.

Reference numeral 40 denotes a data management function of the present invention, which includes a search function 41, an addition function 42, a change function 43, a delete function 44, an add / change / delete / cancel function 45, and an add / change / delete / , And a re-cancellation function 46 of the cancellation.

The search function 41 includes an AP 20 or a change function 43, a delete function 44, and an add / change / delete cancel function 4.
5. In accordance with an instruction from the re-cancellation function 46 of cancellation of addition / change / deletion, a record that is a log at a certain point in time, a record that is currently in use at a certain point in time, a record that is being processed at a certain point in time, Record having a certain registration number, record having a certain registration number as a deletion number, information management data 3 having a certain registration number or a registration number to be canceled
2. A process of searching for is performed.

The additional function 42 is operated by the
The process of adding the information management data 32 added this time and the record (information management data 31) of the new key value (key information of the AP data) to the actual file 30 is performed.

The change function 43 adds a record having the existing key value specified by the AP 20 in the information management data 32 and the real file 30 added this time, and the real file 30 becomes inconsistent due to the addition. It has a function to process it.

Specifically, the following processing is performed. 1. Give out your registration number. 2. In the information management data 32 added this time: Set the registration number of. 3. The record requested by the AP 20 includes: And adds it to the real file 30. 4. 1. From the actual file 30 A valid record of “start date / time <start date / time of additional record <end date / time <end date / time of additional record” is obtained by searching with the same key as the additional record of “1”. 5.4. Is copied to the end date and time, and the start date and time of the additional record and the registration number are 1. And adds it to the real file 30.

6.4. 1 for the deletion number of the copy source record Set the registration number of. 7. Real file 30 to 3. With the same key as the additional record, a valid record of “start date / time of additional record <start date / time <end date / time of additional record <end date / time” is obtained by search. 8.7. Is copied, the start date and time are the end date and time of the additional record, and the registration number is 1. And adds it to the real file 30. 9.7. 1 for the deletion number of the copy source record Set the registration number of. 10. 1. From the actual file 30 With the same key as the additional record of "Additional record start date and time <start date and time <end date and time <
The effective record of "additional record end date and time" is obtained by search.

11.10. 1 for the record erase number
Set the registration number of. 12. 1. From the actual file 30 A valid record of “start date / time <start date / time of additional record <end date / time of additional record <end date / time” is searched for using the same key as the additional record. 13.12. Is copied, the start date and time of the additional record are added to the end date and time, and 1. And adds it to the real file 30. 14.12. Is copied, the start date and time are the end date and time of the additional record, and the registration number is 1. And adds it to the real file 30. 15.12. 1 for the deletion number of the copy source record Set the registration number of.

The delete function 44 deletes information of a record in the real file 30 after or before a certain time point designated by the AP 20.

Specifically, the following processing is performed. [Delete record information after a certain point] Give out your registration number. 2. In the information management data 32 added this time: Set the registration number of. 3. A record of “start date / time <a certain point in time when deletion requested from AP 20 is started <end date / time” is obtained by searching the actual file 30. 4.3. Is copied, and the “time point” is set as the end date and time. 5.3. 1 for the deletion number of the copy source record Set the registration number of. 6. A record of “a certain point in time at which the deletion requested by the AP 20 is started <start date and time” is obtained from the actual file 30 by searching, and 1. Set the registration number of.

[Deleting information of a record before a certain point] Give out your registration number. 2. In the information management data 32 added this time: Set the registration number of. 3. A record of “current date / time <start date / time <a certain time point at which the deletion requested from the AP 20 is completed <end date / time” is obtained by searching the real file 30. 4.3. Copy the record and set the "time" to the start date and time. 5.3. 1 for the deletion number of the copy source record Set the registration number of. 6. A record of “current date / time <start date / time <end date / time <a certain point in time when the deletion requested from AP 20 is completed” is retrieved from the actual file 30 by searching, and 1 Set the registration number of.

The add / change / delete cancel function 45 returns the record operated by the add function 42, the change function 43, and the delete function 44 to the state before the operation.

Specifically, the following processing is performed. 1. Give out your registration number. 2. In the information management data 32 added this time: Set the registration number and the registration number to be canceled. 3. The record with the registration number to be canceled is stored in the real file 3.
It is obtained by searching from 0, and 1 is added to the deletion number of the record.
Set the registration number of. 4. A record having the registration number to be canceled as an erasure number is found by searching the real file 30 and its resurrection display (added in the present invention) is set.

Re-cancellation function 46 for cancellation of addition / change / deletion
Returns the record operated by the add / change / delete cancel function 45 to the state before the operation.

Specifically, the following processing is performed. 1. Give out your registration number. 2. In the information management data 32 added in the present invention: Set the registration number and the registration number to be canceled. 3. The registration number of the information management data 32 is 2. The information management data 32, which is the registration number to be canceled, is obtained from the actual file 30 by searching. 4.3. The record having the registration number of the cancellation target of the information management data 32 as the deletion number is obtained from the actual file 30 by searching, and the resurrection display of the record is deleted. 5. A record having the registration number to be canceled as the deletion number is obtained from the actual file 30 by searching, and the resurrection display is set.

The data management function 40 described above is realized by a program that is recorded on a computer-readable medium and that, when read by a computer, executes the functions 41 to 46 on the computer.

Next, search, addition, change,
The operation in the case of requesting deletion, addition / change / deletion cancellation, and addition / change / deletion cancellation cancellation will be described with reference to the drawings.

(1) Search function 41 AP 20 or change function 43, delete function 44, add /
Information (key information) for identifying the AP data portion of the real file 30, a certain time point, a certain registration number, and a certain deletion number are designated from the change / delete cancel function 45 and the add / change / delete cancel re-cancel function 46. A search request is issued.

For example, in the case of a file holding customer information, a customer ID number or the like is designated, and at a certain point in time, a log record, a current record, a record in process, or a registration number is stored. A record, a record having a certain registration number as an erasure number, and information management data 32 having a certain registration number or a registration number to be canceled are searched, and the record is retrieved by the AP 20 or the change function 4.
3, deletion function 44, addition / change / deletion cancellation function 45,
Return to the processing of the re-cancellation function 46 of cancellation of addition / change / deletion.

(2) Additional function 42 [FIGS. 2 and 3 (at H9.11 / 1)] From the AP 20, the AP data portion (customer ID number =
1, a telephone number = 1000, a FAX number = 1000), a record start date and time (H10.4 / 1) and a record end date and time (H10.12 / 31) are designated, and a change request is issued. 2. Pay out registration number = 1. 3. 1. In the information management data 32 added this time, And adds it to the real file 30 (information management data 32-1 in FIGS. 2 and 3). 4.1. , The registration number = 1 is set to the record and added to the real file 30 (record 1 in FIGS. 2 and 3). (3) Change Function 43 [FIGS. 2 and 4 (at H9.112 / 1)] From the AP 20, the AP data portion (customer ID number =
1, a telephone number = 2000, a FAX number = 2000), a record start date and time (H10.7 / 1) and a record end date and time (H10.9 / 1) are designated, and a change request is issued. 2. Pay out registration number = 2. 3. 1. In the information management data 32 added this time, Is set and added to the real file 30 (information management data 32-2 in FIGS. 2 and 4). 4.1. , The registration number = 2 is set to the record and added to the real file 30 (record 3 in FIGS. 2 and 4). 5. A record of “start date / time <H10.7 / 1 <end date / time <H10.9 / 1” is retrieved from the actual file 30 with the customer ID number = 1 (there is no corresponding record in FIGS. 2 and 4).

6.5. Is copied, the end date and time are set to H10.7 / 1, the registration number is set to 2, and the record is added to the actual file 30 (there is no corresponding record in FIGS. 2 and 4). 7.5. Is set to 2 for the deletion number of the copy source record (No corresponding record in FIGS. 2 and 4). 8. From the actual file 30, the customer ID number = 1 and “H10.
A record of 7/1 <start date / time <H10.9 / 1 <end date / time "is obtained by retrieval (there is no corresponding record in FIGS. 2 and 4). 9.8. Is copied, and H10.
9/1. The registration number is set to 2 and added to the real file 30 (there is no corresponding record in FIGS. 2 and 4). 10.8. Is set to 2 for the deletion number of the copy source record (No corresponding record in FIGS. 2 and 4).

11. Customer ID number from actual file 30 =
1 and “H10.7 / 1 <start date and time <end date and time <H10.
The record of “9/1” is obtained by retrieval (there is no corresponding record in FIGS. 2 and 4). 12.11. Is set to 2 for the deletion number of the record (No corresponding record in FIGS. 2 and 4). 13. A record of “start date and time <H10.7 / 1 <H10.9 / 1 <end date and time” is found by searching the actual file 30 with the customer ID number = 1 (record 1 in FIGS. 2 and 4). 14.13. Is copied and the end date and time is H1
0.7 / 1. The registration number is set to 2 and added to the real file 30 (record 1 in FIGS. 2 and 4). 15.13. Is copied and the start date and time
0.9 / 1, the registration number is set to 2 and added to the real file 30 (record 3 in FIGS. 2 and 4). 16.13. Is set to 2 for the deletion number of the copy source record (record 1 in FIGS. 2 and 4).

[FIG. 2, FIG. 5 (at time H10.1 / 1)] From the AP 20, the AP data portion (customer ID number =
1, a telephone number = 3000, a FAX number = 3000), a record start date and time (H10.6 / 1) and a record end date and time (H10.10 / 1) are designated, and a change request is issued. 2. Pay out registration number = 3. 3. 1. In the information management data 32 added this time, And adds it to the real file 30 (information management data 32-3 in FIGS. 2 and 5). 4.1. In the record of 2. Is set to 3 and added to the real file 30 (record 6 in FIGS. 2 and 5). 5. A record of “start date / time <H10.6 / 1 <end date / time <H10.10 / 1” is found by searching the actual file 30 with the customer ID number = 1 (record 2 in FIGS. 2 and 5).

6.5. Is copied, the end date and time is H10.6 / 1, and the registration number is 2. Is set to 3 and added to the real file 30 (record 5 in FIGS. 2 and 5). 7.5. In the deletion number of the copy source record of 2. The registration number = 3 is set (record 2 in FIGS. 2 and 5). 8. From the actual file 30, the customer ID number = 1 and “H10.
The record of 6/1 <start date / time <H10.10.1 / <end date / time] is obtained by search (record 4 in FIGS. 2 and 5). 9.8. Is copied, and H10.
10/1. The registration number is 2. The registration number = 3 is set and added to the real file 30 (record 7 in FIGS. 2 and 5). 10.8. In the deletion number of the copy source record of 2. The registration number = 3 is set (record 4 in FIGS. 2 and 5).

11. Customer ID number from actual file 30 =
1 and “H10.6 / 1 <start date and time <end date and time <H10.
A record of “10/1” is obtained by a search (FIGS. 2 and 5).
Record 3). 12.11. In the deletion number of the record of 2. Registration number =
3 (record 3 in FIGS. 2 and 5). 13. A record of “start date and time <H10.6 / 1 <H10.10 / 1 <end date and time” is found by searching the actual file 30 with the customer ID number = 1 (there is no corresponding record in FIGS. 2 and 5). 14.13. Is copied and the end date and time is H1
0.7 / 1, registration number 2. Is set to 3 and added to the real file 30 (there is no corresponding record in FIGS. 2 and 5). 15.13. Is copied and the start date and time
0.9 / 1. The registration number is 2. Is set to 3 and added to the real file 30 (there is no corresponding record in FIGS. 2 and 5). 16.13. In the deletion number of the copy source record of 2. (No corresponding record in FIGS. 2 and 5).

(4) Deletion Function 44 [When Deletion Start Date and Time is Specified] [FIG. 2, FIG. 6 (at H10.2 / 1)] From the AP 20, the key portion of the AP data (customer ID number = 1), the record deletion start date and time (H10.
8/1) is specified and a deletion request is issued. 2. Pay out registration number = 4. 3. 1. In the information management data 32 added this time, And adds it to the real file 30 (information management data 32-4 in FIGS. 2 and 6). 4. A record of “start date / time <H10.8 / 1 <end date / time” is found by searching the actual file 30 with the customer ID number = 1 (record 6 in FIGS. 2 and 6).

5.4. Is copied, and H10.8 / 1. The registration number Is set to 4 and added to the real file 30 (record 8 in FIGS. 2 and 6). 6.4. In the deletion number of the copy source record of 2. The registration number = 4 is set (record 6 in FIGS. 2 and 6). 7. From the actual file 30, the customer ID number = 1 and “H10.
A record of “8/1 <start date and time” is obtained by search (record 7 in FIGS. 2 and 6). 8.7. In the deletion number of the record of 2. The registration number = 4 is set (record 7 in FIGS. 2 and 6).

[When Deletion End Date and Time is Specified] [FIG. 2, FIG. 7 (at H10.3 / 1)] From the AP 20, the key portion of the AP data (customer ID number = 1), the record deletion end date and time (H10.
7/1) is designated and a deletion request is issued. 2. Pay out registration number = 5. 3. 1. In the information management data 32 added this time, And adds it to the real file 30 (information management data 32-5 in FIGS. 2 and 7). 4. A record of “current date / time <start date / time <H10.7 / 1 <end date / time” is found by searching the actual file 30 with the customer ID number = 1 (record 8 in FIGS. 2 and 7).

5.4. Is copied, the start date and time is H10.7 / 1, and the registration number is 2. Is set to 5 and added to the real file 30 (record 9 in FIGS. 2 and 7). 6.4. In the deletion number of the copy source record of 2. Is set (record 8 in FIGS. 2 and 7). 7. A record of “current date / time <start date / time <end date / time <H10.7 / 1” is obtained from the actual file 30 by searching with the customer ID number = 1 (record 5 in FIGS. 2 and 7). 8.7. In the deletion number of the record of 2. The registration number = 5 is set (record 5 in FIGS. 2 and 7).

(5) Addition / change / deletion cancellation function 45 [FIG. 2, FIG. 8 (at H10.3 / 10)] The registration number = 5 for identifying the operation to be canceled is specified from the AP 20, and a request for cancellation of addition / change / deletion is issued. 2. Pay out registration number = 6. 3. 1. In the information management data 32 added this time, Of the real file 30 by setting the registration number of the
(Information management data 32-6 in FIGS. 2 and 8). 4. Search for record with registration number = 5, real file 3
0 (record 9 in FIGS. 2 and 8).

5.4. The registration number = 6 is set as the deletion number of the record (record 9 in FIGS. 2 and 8). 6. A record with the deletion number = registration number (= 5) to be canceled is obtained from the actual file 30 by searching (records 5 and 8 in FIGS. 2 and 8). 7.6. Of the record is set (ON) (records 5 and 8 in FIGS. 2 and 8).

(6) Addition / change / deletion cancellation function 46 [FIG. 2, FIG. 9 (as of H10.3 / 20)] The registration number = 6 for identifying the operation to be canceled is specified from the AP 20, and a request for cancellation of addition / change / deletion is issued. 2. Pay out registration number = 7. 3. 1. In the information management data 32 added this time, Of the real file 30 by setting the registration number of the
(Information management data 32-7 in FIGS. 2 and 9). 4. The registration number of the information management data 32 is 3. Information management data 32 whose registration number = 6 to be canceled
It is obtained by searching from 0 (information management data 32-7 in FIGS. 2 and 9). 5.4. Registration number of the information management data 32 to be canceled =
5 is retrieved from the actual file 30 by searching for the record having the deletion number, and the resurrection display of the record is deleted (O
FF) (records 5 and 8 in FIGS. 2 and 9). 6.3. A record having the registration number = 6 to be canceled as the deletion number is obtained from the actual file 30 by searching, and the resurrection display is set (ON) (record 9 in FIGS. 2 and 9).

[0052]

As described above, according to the present invention,
It is possible to re-cancel the addition / change / deletion of in-process information, thereby expanding the scope of the system.

[Brief description of the drawings]

FIG. 1 is a configuration diagram of an entire data management system according to the present invention.

FIG. 2 is a configuration diagram of a real file in FIG. 1;

FIG. 3 is a configuration diagram of a real file when an additional request is made;

FIG. 4 is a configuration diagram of a real file when a change is requested;

FIG. 5 is a configuration diagram of a real file when a change is requested;

FIG. 6 is a configuration diagram of a real file when a deletion is requested;

FIG. 7 is a configuration diagram of a real file at the time of a deletion request;

FIG. 8 is a configuration diagram of an actual file when a registration number 5 is canceled.

FIG. 9 is a configuration diagram of an actual file when registration number 6 is canceled.

[Explanation of symbols]

10: Requester, 20: Application (AP),
30: real file, 31: first information management data, 3
2,32-1,32-2,32-3,32-4,32-
5, 32-6, 32-7: second information management data, 4
0: Data management function, 41: Search function, 42: Add function, 43: Change function, 44: Delete function, 45: Add / change / delete / cancel function, 46: Add / change / delete / cancel Cancel function.

Claims (3)

[Claims] 1. A computer-readable medium storing information management data for managing data such as a database and a file in units of records, a key information indicating a classification of a record, and a date and time when a service based on business information of the record is started. Or the date and time when the service is scheduled to start, the date and time when the service based on the business information of the record is ended or scheduled to be terminated, the registration number that enabled the record, the deletion number that invalidated the record, and the cancellation of the invalidation of the record Holding the first information management data provided with a resurrection display indicating that the record is valid, a registration number for canceling the validation of the record, and a registration number for initially validating the record for which the validation is canceled A computer which records information management data characterized by comprising second information management data Readable media. 2. A computer system which manages data such as a database and a file, wherein information (working information) which starts a service based on business information at a certain point in time,
Information that started a service based on business information before a certain point in time, but has already ended (log information), and information on work in progress that will start a service based on business information after a certain point in time (work-in-progress information) Are managed on a computer-readable medium, and the current information, log information and in-process information are searched, the current information and in-process information are added / changed / deleted, and the in-process information is added / changed / In a data management method capable of canceling a deletion, a registration number for canceling addition / change / deletion of in-process information and a registration number at which the addition / change / deletion of the in-process information was initially performed are retained. In addition to providing the information management data of item 2, a resurrection display is provided to indicate that a record that has become invalid due to the addition / change / deletion of in-process information is re-enabled, and the addition / change / deletion of in-process information is provided. The cancellation is performed by setting the resurrection display for a record in the second information management data, which holds the “registration number at which the in-process information was initially added / changed / deleted” as the deletion number, In the record holding the “registration number at which the in-process information was initially added / changed / deleted” in the second information management data as the registration number, the deletion number is added to the record in the second information management data. Setting of "registration number for canceling addition / change / deletion of in-process information" is performed to cancel addition / change / deletion of in-process information, and the record is invalidated by displaying / hiding the resurrection display A data management method characterized by performing re-cancellation of cancellation of conversion. 3. Key information indicating a classification of a record, date and time when a service based on the business information of the record is started or scheduled to be started, and date and time when the service based on the business information of the record is ended or scheduled to be ended. First information management data including, on a record-by-record basis, a registration number for validating a record, a deletion number for invalidating the record, and a resurrection display indicating that the invalidation of the record has been canceled; Computer readable recording of a data management program for managing information management data comprising a registration number for canceling the information and a second information management data holding a registration number for which the record to be canceled is initially made valid When the data management program is read by a computer, the computer From the information management data, a record that is a log at a certain time, a record that is active at a certain time, a record that is in process at a certain time, a record that has a certain registration number, a record that has a certain registration number as an erasure number, and a certain registration A search function for searching for second information management data having a number or a registration number to be canceled, an additional function for adding information of a record having second information management data and a new key value to the information management data, A change function for adding information of a second information management data and a record having a specified existing key value in the information management data to the information management data, and performing processing so as not to cause inconsistency by the addition; A deletion function for deleting information of a record after a specified point in time or before a point in the information management data; and the additional function An add / change / delete cancel function for returning a record operated by the change function and the delete function to a state before the operation; and an add / return function for returning a record operated by the add / change / delete function to the state before the operation. A computer readable medium having recorded thereon a data management program for executing a change / deletion cancellation function.