JP2000148548A - Unnecessary record deleting device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a device capable of simply, quickly and accurately deleting an unnecessary data record. SOLUTION: This unnecessary record deleting device is provided with a means 16 for storing a storage device management record including history information and information indicating storing addresses in a storage device in each data record having the same history information, a means 12 for retrieving the storage device management record, a means 13 for comparing the history information of the retrieved storage device management record with set deleting limit information, and a means 14 for collectively deleting data records stored in the corresponding storing address in the storage device by referring to the information indicating the storing address in the storage device which is included in the storage device management record when the date of the history information of the storage device management record is before the deleting limit of the deleting limit information as the compared result of the comparing means 13.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an unnecessary data record deleting device for deleting unnecessary data records in a storage device in a database system or the like.

[0002]

2. Description of the Related Art Conventionally, when an unnecessary data record in a storage device is deleted, the data record in the storage device is searched, and data indicating the content of the data added to the data record is referred to as an unnecessary record. It is determined whether or not there is any data, and an unnecessary data record is deleted by giving an individual deletion instruction to the data record determined to be unnecessary.

[0003]

However, in the prior art, the user searches individual data records, judges the contents of the data, and gives an individual data deletion instruction to the unnecessary data records. The work of deleting the unnecessary data records becomes complicated, and not only takes time to delete the unnecessary data records, but also there is a risk that the necessary data records are erroneously deleted due to an operation error.

SUMMARY OF THE INVENTION The present invention has been made in consideration of the above-described conventional problems, and has as its object to provide an unnecessary data record deleting apparatus capable of deleting unnecessary data records easily and accurately in a short time.

[0005]

According to the present invention, there is provided an unnecessary record deleting apparatus for deleting unnecessary data records in a storage device for storing data records, wherein the data records are stored or updated. History information including the latest date information is added, and data records having the same history information are stored in the same storage device, and the history information and the storage are stored for each data record having the same history information. Means for storing a storage device management record including information indicating a storage location in the device; means for searching for the storage device management record; and history information of the searched storage device management record and set deletion time limit information. Means for comparing, the storage device when the date of the history information is before the time limit of the deletion time limit information as a result of the comparison by the comparing means. Means for referring to the information indicating the storage location in the storage device included in the physical record and deleting the data records stored in the corresponding storage location in the storage device all at once. And

[0006]

Embodiments of the present invention will be described below in detail with reference to the drawings. FIG. 1 is a block diagram showing the configuration of an embodiment of the unnecessary record deletion device of the present invention. In FIG. 1, first, an unnecessary record delete unit 11 controls each unit when deleting an unnecessary data record, and deletes an instructed unnecessary data record. A storage device management unit 12 operates based on an instruction from the unnecessary record delete unit 11. This is a storage device search unit that searches for a storage device management record stored in the device 16. The storage device management record will be described later in detail.

[0007] Further, reference numeral 13 compares the deletion term information (deletion term information such as month and date) designated by the unnecessary record deletion means 11 with the history information of the storage management record retrieved by the storage retrieval means 12. The history comparison unit 14 is a data deletion unit that deletes data records to be deleted in the storage device 17 at one time. Further, 16 is a storage device management device for storing storage device management records, 17 is a storage device for storing data records, and 15 is a storage device management means for managing the storage device management devices 16 and 17.

FIG. 2 is a diagram showing a data record in the storage device 17. First, the data record 20 contains the history information 2
1 and data 22. The history information 21 is information indicating the latest date when the data was stored in the storage device 17 or the latest date when the data was updated. History information 21 is added to the head of each data, and history information 2
1 and data 22 constitute a data record.

FIG. 3 is a diagram showing a storage device management record stored in the storage device management device 16. First, in the present embodiment, a data record having the same history information (the latest date stored or updated) among a plurality of data records stored in the storage device 17 is stored in the same storage device. That is, the storage device 17 is composed of a plurality of storage devices as shown in FIG. 1, and data records having the same history information are stored in the same storage device.

Here, the storage device management record 30 is composed of history information 31 and storage device information 32, and the history information 31 is stored in the data record 20 having the same history information as described above. Is the information indicating the date. The storage device information 32 is information indicating a storage location of a data record having the same history information in the storage device 17.

FIG. 4 is a flowchart showing the flow of processing for deleting unnecessary data records. Hereinafter, a specific operation of the present embodiment will be described with reference to FIGS. First, when deleting an unnecessary data record in the storage device 17, the user sets deletion deadline information indicating a deadline for deleting the data record in the unnecessary record deletion unit 11. For example, set the deletion deadline information on a monthly basis or on a monthly basis, such as year / month / day or year / year / month / day.
An instruction is given to delete all data records stored or updated before year / month / year / year / month / day.
That is, data records having history information before the deletion deadline information are deleted from the storage device 17 as unnecessary records.

When the deletion time limit information is set as described above,
The unnecessary record deletion unit 11 executes the deletion processing of FIG. First, when the deletion time limit information is set, the unnecessary record deletion unit 11 activates the storage device search unit 12 (Step 401 in FIG. 4), and the storage device search unit 12 manages the storage device via the storage device management unit 15. The storage device management record stored in the device 16 is searched. The storage device management record 30 includes history information 31 and storage device information 32 as shown in FIG. 3, and the storage device information 32 is information indicating the storage location in the storage device 17 of the data record having the same history information. is there.

When the storage device management unit 30 searches the storage device management record 30 in the storage device management unit 16, the unnecessary record deletion unit 11 executes the storage device search unit 12.
The history comparison unit 13 is activated by giving the storage management record 30 retrieved by the above and the set deletion time limit information (step 402). The history comparison means 13 compares the history information 31 included in the storage device management record with the set deletion time limit information, and stores the latest date of storage or update of the data record in the history information 31 of the storage device management record 30. Is determined to be before the expiration date of the deletion expiration information (step 403).

If the date of the history information 31 of the storage management record 30 is not before the set deletion deadline information (step 403: No), the data record managed by the storage management record is deleted. Therefore, the unnecessary record deleting unit 11 ends the processing as it is. On the other hand, when the date of the history information of the storage device management record is before the set time limit of the deletion time limit information (Yes in step 403), the data record managed by the storage device management record is not to be deleted, and thus is unnecessary. The record deleting unit 11 activates the data deleting unit 14 (Step 404), and deletes the corresponding data record in the storage device 17.

Specifically, the data deletion means 14 stores the storage device information 32 included in the storage device management record 30;
In other words, the information indicating the storage location of the data record in the storage device 17 is referred to, and the data records stored in the corresponding storage location in the storage device 17 are collectively deleted via the storage device management means 15. As a result, unnecessary data records stored or updated before the deletion time limit of the deletion time limit information, that is, unnecessary data records in the storage device 17 that have not been used for a certain period can be collectively deleted.

As described above, in the present embodiment, the storage device 17
Data records having the same history information can be collectively deleted, and the processing time can be remarkably reduced as compared with the conventional method of individually deleting data records and deleting the data records. In addition, unnecessary data records can be accurately deleted without deleting necessary data records by mistake. Thus, the deletion processing for one storage device management record is completed.

Hereinafter, the unnecessary record deleting means 11 repeats the processing of steps 401 to 404, sequentially searches the storage device management records from the storage device management device 16, and stores the history information of the storage device management records and the set deletion time limit information. Will be compared. Then, when the history information of the storage device management record is before the set deletion time limit, the data record of the corresponding storage location in the storage device 17 is collectively deleted as described above, and the data record in the storage device management device 16 is deleted. When there are no more storage management records, all deletion processing is terminated.

In the above embodiment, the history information of the data record is the latest date information stored or updated. However, the history information may be date information. In this way, if deletion time limit information including time information is set, unnecessary data records can be deleted in smaller units.

[0019]

As described above, according to the present invention, each data record having the same history information is managed by using a storage device management record including the history information and the information indicating the storage location of the storage device. When the date of the history information of the storage management record is earlier than the set deletion deadline of the deletion deadline information, the storage device management record is referred to the storage location of the storage device, and the data records of the corresponding storage location are collectively collected. Thus, unnecessary data records in the storage device can be deleted easily and in a short processing time, and unnecessary data records can be deleted accurately without mistakenly deleting necessary data records.

[Brief description of the drawings]

FIG. 1 is a block diagram showing an embodiment of an unnecessary record deletion device of the present invention.

FIG. 2 is a diagram showing a configuration of a data record.

FIG. 3 is a diagram showing a configuration of a storage device management record.

FIG. 4 is a flowchart showing an unnecessary record deleting operation of the embodiment of FIG. 1;

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 11 Unnecessary record deletion means 12 Storage device search means 13 History comparison means 14 Data deletion means 15 Storage device management means 16 Storage device management device 17 Storage device 20 Data record 21 History information 22 Data 30 Storage device management record 31 History information 32 Storage device information

Claims (1)

[Claims] 1. An unnecessary record deletion apparatus for deleting unnecessary data records in a storage device storing data records, wherein the data records are added with history information including the latest date information stored or updated, and Data records having the same history information are stored in the same storage device, and a storage device management record including history information and information indicating a storage location in the storage device is stored for each data record having the same history information. Means for searching for the storage device management record, means for comparing the history information of the searched storage device management record with the set deletion time limit information, and a result of the comparison by the comparing means, When the date of the history information of the management record is before the deletion time limit of the deletion time limit information, the date is included in the storage device management record. Means for deleting data records stored in a corresponding storage location in the storage device by referring to information indicating a storage location in the storage device.