JP2001356942A - Data base system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To guarantee data within a fixed period for retrieval transaction and to automatically delete the data the guarantee of which becomes unnecessary after elapse of the fixed period. SOLUTION: Insertion data is received from an input device 10, information to be managed by a system is created, the insertion data is stored in a data storage part 17, deleted data conditions are received, the deletion data is created based on deleting origin data to coincide with the deleted data conditions, stored in the data storage part 17, corrected data conditions and correction information are received, correction data is created based on correcting origin data to coincide with the corrected data conditions and the correction information, stored in the data storage part 17, retrieval conditions, retrieval date and time are received, the retrieved data to coincide the conditions whose update date and time is less than the retrieval date and time and maximum is extracted among acquired pieces of the data to coincide the conditions and outputted to an output device 15. When the term of guarantee expires for the data to coincide with the data conditions, the data is deleted from the data storage part.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database system for storing data, and more particularly, to a database system for guaranteeing data at one point in time within a certain period.

[0002]

2. Description of the Related Art Since a database system usually expresses only a current database state, if a business program issues a plurality of transactions, inconsistencies may occur in acquired data.

If the database expresses the state of the database from the present to the past, the amount of data increases each time the data is updated. It is necessary to prevent the unilateral increase in the amount and to make effective use of resources.

[0004]

In the invention described in Japanese Patent Application Laid-Open No. 5-61737, which is a conventional database system, in order to prevent the data amount from increasing each time data is updated, the data expiration date is fixed. Expired data is automatically deleted for effective use of resources. In the invention described in Japanese Patent Application Laid-Open No. 5-61738, data outside the holding period is automatically deleted to save resources. We are trying to use it effectively.

However, the invention described in Japanese Patent Laid-Open No. 5-61737 has a problem that the data expiration date is fixed and the data is not automatically updated. However, there is a problem that the data is deleted if it is outside the data holding period.

SUMMARY OF THE INVENTION An object of the present invention is to provide a database which guarantees data at a single point in time within a fixed period for a search transaction and automatically deletes data which has become unnecessary after a fixed period. An object of the present invention is to provide a database system in which the expiration date of data is automatically updated, and the latest data is not deleted even if the data is out of the retention period, and the database system keeps retaining the data.

[0007]

According to the present invention, there is provided a database system comprising: a data storage section having an information section for storing information managed by the database system in addition to a user-defined data section for storing user-defined data; A system definition value holding unit that stores a warranty period that is a period, an insertion update processing unit that receives insertion data from an input device, creates the information to be stored in the information unit, and stores the insertion data in the data storage unit. Receiving a deletion data condition from the input device, acquiring deletion source data matching the deletion data condition from the data storage unit, creating deletion data based on the deletion source data, storing the deletion data in the data storage unit, A deletion / update processing unit for deleting data from the data storage unit when the deletion source data has passed the warranty period; Receiving the data and the correction information, acquiring correction source data matching the correction data condition from the data storage unit, creating correction data based on the correction source data and the correction information, and storing the correction data in the data storage unit, When the correction source data has passed the warranty period, a correction update processing unit that deletes data from the data storage unit, a search condition and a search date / time from the input device, and obtains condition matching data from the data storage unit Then, from the acquired condition matching data, the maximum data whose update date time is equal to or less than the search date time is extracted and output to the output device. When the condition matching data has passed the guarantee period, the data storage unit And a search processing unit for further deleting data.

Further, the database system according to the present invention has a data storage unit having an information unit for storing information managed by the database system, in addition to a user-defined data unit for storing user-defined data, and a guarantee for a fixed period. A system-defined value storage unit that stores a period, an insertion update processing unit that receives the insertion data, creates the information to be stored in the information unit and stores the insertion data in the data storage unit, and receives a deletion data condition. A deletion update processing unit that acquires deletion source data matching the deletion data condition from the data storage unit, creates deletion data based on the deletion source data, and stores the deletion data in the data storage unit; and a correction data condition and correction information. Received from the data storage unit, and obtains correction data based on the correction data and the correction information. A correction / update processing unit that creates and stores data in the data storage unit, a search data condition and a search date / time, obtains condition matching data from the data storage unit, and updates the update date from among the obtained condition matching data. A search processing unit for extracting the largest one whose time is equal to or less than the search date and time and outputting the extracted data to the output device; receiving the insertion data from the input device and distributing the data to the insertion / update processing unit; Receiving the search data condition and the search date and time, and allocating the search data condition and the search date / time to the search processing unit; the deletion data condition and the correction data condition. Receiving the search data condition, and the deletion source data, the correction source data, and the condition matching data that match the condition exceed the warranty period. If that is characterized by and a-warranty data deletion section to delete data from the data storage unit.

[0009]

Next, an embodiment of the present invention will be described with reference to the drawings.

FIG. 1 is a block diagram showing an embodiment of a database system according to the present invention. The database system shown in FIG.
1, correction update processing unit 12, search processing unit 13, output device 1
5, a system definition value holding unit 16 and a data storage unit 17.

The data storage section 17 has an information section 19 for storing information managed by the database system, in addition to a user-defined data section 18 for storing user-defined data. The information section 19 includes an update date and time, deletion information, and old and new information. The deletion information indicates whether the data is in a deleted state, and the new / old information indicates whether the data is the latest.

Further, the system definition value holding unit 16 stores a guarantee period which is a fixed period.

The insert / update processing unit 11 receives the insert data from the input device 10, creates the information to be stored in the information unit 19, and stores the insert data in the data storage unit 17.

The deletion / update processing unit 12 receives the deletion data condition from the input device 10, acquires the deletion source data matching the deletion data condition from the data storage unit 17, and creates the deletion data based on the deletion source data. Stored in the data storage unit 17. If the deletion source data has passed the warranty period, the data is deleted from the data storage unit 17.

The correction / update processing unit 13 receives correction data conditions and correction information from the input device 10, acquires correction source data matching the correction data conditions from the data storage unit 17, and based on the correction source data and the correction information. The correction data is created and stored in the data storage unit 17. If the correction source data has passed the guarantee period, the data is deleted from the data storage unit 17.

The search processing unit 14 receives a search condition and a search date and time from the input device 10. If the search date and time are outside the warranty period, an error is output to the output device 15. If the search date and time are within the guarantee period, condition matching data is obtained from the data storage unit 17. When there are a plurality of pieces of data having the same primary key in the acquired data, one of the data whose update date / time is less than or equal to the search date / time is extracted and output to the output device 15. If the condition matching data has passed the guarantee period, the data is deleted from the data storage unit 17.

Next, the operation of the insert / update processing unit 11 will be described with reference to the flowchart of FIG.

When receiving the insert data from the input device 10, the insert / update processing unit 11 first sets the update date and time to the current date and time in step 101, and
In step 2, deletion information and non-deletion are set. In step 103, update date and time, deletion information, and old and new information managed by the database system are newly created as new and old information, and are set in the information section 19.

Next, in step 104, the inserted data is set in the data definition data section 18 as user-defined data. Thereafter, in step 105, the data is stored in the data storage unit 17.

Next, the operation of the delete / update processing unit 12 will be described with reference to the flowchart of FIG.

First, in step 201, a guarantee start date and time is obtained. In step 202, data matching the deletion data condition is obtained from the data storage unit.

In step 203, new / old information is determined. If the new and old information is new, it is to be deleted, and if it is old, it is not to be deleted. In step 204, delete data is created based on this data and stored in the data storage unit 17.
For the deletion data, the update date and time are set to the current date and time, the deletion information is set to deletion, the new and old information is set to new, and this data is set as the user definition data in the user definition data section.

In step 205, since the original data which is the source of the deleted data is the old data, the data storage unit 1
Change the old and new information of 7 to old. Here, the data to be deleted is not deleted from the data storage unit 17. In step 206, it is determined whether or not the data is to be guaranteed.
If the data is not covered by the guarantee, step 207 is performed and the data is deleted from the data storage unit 17. In the case of a guarantee target, nothing is done and the data is left in the data storage unit 17 as it is.

Next, the operation of the correction / update processing unit 13 will be described with reference to FIG.

In step 202, data matching the correction data condition is obtained from the data storage unit 17. In step 204, correction data is created based on the main data and the correction information, and stored in the data storage unit 17. The correction data is the update date and time, the current date and time, the deletion information is not deleted, the old and new information is new, and the data created based on this data and the correction information is the user-defined data in the user-defined data section. Is set.

Next, the operation of the search processing section 14 will be described with reference to the flowcharts of FIGS.

In step 301, a guarantee start date and time is obtained. In step 302, if the search date / time is earlier than the guarantee start date / time, the process of the search processing unit 14 ends as an error.

In step 303, all data matching the search condition is obtained from the data storage unit 17. In step 304, data whose update date / time is greater than the search date / time is excluded from the data matching the search condition.

In step 305, data matching the search condition is grouped by the primary key. In steps 306 to 308, step 307 is performed for each group. Step 307 will be described with reference to FIG.

In steps 310 to 315, processing is performed on each data in the group. First, step 3
In step 11, if the data is the latest data in the group, nothing is performed as the condition matching data.

If it is determined in step 312 that the data is out of the warranty period, the data is deleted from the data storage unit 17 in step 313. If it is determined in step 312 that the data is within the guarantee period, step 314
This data is excluded from the data matching the condition.
It is not deleted from the data storage unit 17.

Returning to step 309 in FIG. 4, the data whose deletion information is deleted is excluded from the data matching the condition. The data matching the search conditions remaining so far is output to the output device 15.
Output to

Next, the operation of the embodiment of the present invention will be described with reference to the sequence diagram of FIG.

First, at the date and time 1, the business program 1 sets the current date and time as the search date and time 1 and the search condition (search date and time = 1, data item 2 = X%).
, Data 1 and data 2 which are data before the current date and time are acquired from the database system.

At the date and time 2, the business program 2
Deletes data 2, changes data 2 in the data storage unit, and inserts data 3.

At date and time 3, business program 1
Acquires data 1 and data 2 from the database system using search date time 1 and search conditions (search date time = 1, data item 2 = X%).

Next, another embodiment of the present invention will be described. FIG. 7 is a block diagram showing another embodiment of the database system of the present invention.

FIG. 7 differs from the embodiment shown in FIG. 1 in that it includes a distribution processing unit 20 and a data deletion processing unit 21 outside the warranty period. When the distribution processing unit 20 distributes the data to the insertion / update processing unit 11, the distribution processing unit 20 is the same as the embodiment of FIG. 1, but the deletion / update processing unit 12 and the correction / update processing unit 1
3. When assigning data to the search processing unit 14, the data condition is simultaneously passed to the out-of-warranty period data deletion processing unit 21. The out-of-warranty-period data deletion processing unit 21 deletes, from the data storage unit 17, data whose update date and time is earlier than the guarantee start date and time from the data that matches the data condition.

Then, the data deletion portions of the deletion / update processing section 12, the correction / update processing section 13, and the search processing section 14 become unnecessary.

In the above-described embodiment, the insertion / update processing unit 11, the deletion / update processing unit 12, the correction / update processing unit 13, and the search processing unit 14 execute software (program) recorded on a recording medium. It can be realized by:

[0041]

As described above, according to the present invention, old data remains in the database, but does not continue to increase, so that a certain amount of data can be held. Further, the business program can express one point of the database state in time series at any time during the warranty period. Further, the business program is not aware of the existence of old data.

[Brief description of the drawings]

FIG. 1 is a block diagram showing an embodiment of a database system according to the present invention.

FIG. 2 is a flowchart illustrating an operation of an insertion update processing unit.

FIG. 3 is a flowchart illustrating an operation of a deletion update processing unit.

FIG. 4 is a flowchart illustrating an operation of a search processing unit.

FIG. 5 is a flowchart illustrating the operation of step 307 in FIG.

FIG. 6 is a sequence diagram illustrating an operation of the embodiment of the present invention.

FIG. 7 is a block diagram showing another embodiment of the database system of the present invention.

[Explanation of symbols]

 Reference Signs List 10 input device 11 insertion update processing unit 12 deletion update processing unit 13 correction update processing unit 14 search processing unit 15 output device 16 system definition value holding unit 17 data storage unit 18 user definition data unit 19 information unit 20 distribution processing unit 21 warranty period External data deletion processing unit

Continuation of the front page (72) Inventor Hideaki Tokunaga 4-1-1, Minamiichijo Nishi, Chuo-ku, Sapporo-shi, Hokkaido In-house F-term (reference) 5B075 NR03 PP23 5B082 AA11 BA03 CA11 EA10 GA18 GA20

Claims (6)

[Claims] 1. A data storage section having an information section for storing information managed by a database system in addition to a user-defined data section for storing user-defined data, and a system-defined value for storing a warranty period as a fixed period. A holding unit, an insertion update processing unit that receives the insertion data from the input device, creates the information to be stored in the information unit, and stores the insertion data in the data storage unit, receives the deletion data condition from the input device, and deletes the data. When the deletion source data matching the data condition is obtained from the data storage unit, the deletion data is created based on the deletion source data and stored in the data storage unit, and the deletion source data has passed the warranty period. Receiving a correction data condition and correction information from an input device, and deleting the data from the data storage unit; From the data storage unit, creates correction data based on the correction source data and the correction information, and stores the corrected data in the data storage unit.If the correction source data has passed the warranty period, A correction update processing unit that deletes data from the data storage unit; a search data condition and a search date / time received from an input device; condition match data is obtained from the data storage unit; and updated from the obtained condition match data. A search processing unit that extracts the largest one whose date time is equal to or less than the search date time and outputs it to the output device, and deletes the data from the data storage unit when the condition matching data has passed the warranty period. A database system, comprising: 2. A data storage section having an information section for storing information managed by a database system, in addition to a user-defined data section for storing user-defined data, and a system-defined value for storing a warranty period as a fixed period. A holding unit, an insertion update processing unit that receives the insertion data, creates the information to be stored in the information unit, and stores the insertion data in the data storage unit, and receives a deletion data condition, and deletes the deletion data condition. Original data is acquired from the data storage unit, a deletion update processing unit that creates deletion data based on the deletion original data and stores the deletion data in the data storage unit, and receives the correction data condition and the correction information. Acquiring matching original data from the data storage unit, creating corrected data based on the original data and the correction information, and storing the corrected data in the data storage unit. Receiving a search data condition and a search date and time, acquiring condition match data from the data storage unit, and obtaining a condition update data having a maximum update date and time equal to or less than the search date and time from the acquired condition match data. A search processing unit for extracting and outputting the data to the output device; receiving the insertion data from the input device and distributing the data to the insertion / update processing unit; receiving a deletion data condition and distributing the data to the deletion / update processing unit; Receiving and distributing to the correction / update processing unit, receiving a search data condition and a search date and time, and distributing to the search processing unit; and receiving the delete data condition, the correction data condition, and the search data condition, and matching the condition. When the deletion source data, the correction source data, and the condition matching data have passed the warranty period, the data is stored in the data storage unit. Database system comprising: the Warranty outside data deletion section, the Remove. 3. The information managed by the database system includes an update date and time, deletion information indicating whether data is in a deleted state, and new / old information indicating whether data is latest. Item 3. The database system according to item 1 or 2. 4. The search processing unit receives a search condition and a search date and time, outputs an error to an output device when the search date and time are outside the warranty period, and outputs an error when the search date and time is within the warranty period. The condition matching data is obtained from the data storage unit, and when there are a plurality of data having the same primary key in the obtained data, an output device that extracts the largest one whose update date / time is less than or equal to the search date / time is extracted therefrom. The database system according to any one of claims 1 to 3, wherein the data is output to a database. 5. A procedure for receiving insertion data from an input device, creating information managed by a database system and storing the insertion data in a data storage unit, and receiving a deletion data condition from the input device and matching the deletion data condition. The deletion source data is obtained from the data storage unit, the deletion data is created based on the deletion source data and stored in the data storage unit, and when the deletion source data has passed the warranty period, the data storage is performed. Receiving the correction data condition and the correction information from the input device, acquiring the correction source data matching the correction data condition from the data storage unit, and correcting the data based on the correction source data and the correction information. Create data and store it in the data storage unit, and delete the data from the data storage unit when the correction source data has passed the warranty period Receiving the search condition and the search date and time from the input device, outputting an error to the output device when the search date and time are outside the warranty period, and outputting the error from the data storage unit when the search date and time are within the warranty period. Acquires condition matching data, extracts the largest one whose update date and time is less than or equal to the search date and time from the acquired condition matching data and outputs it to the output device.If the condition matching data has passed the warranty period, And deleting the data from the data storage unit. 6. A procedure for receiving insertion data from an input device, creating information managed by a database system and storing the insertion data in a data storage unit, and receiving a deletion data condition from the input device and matching the deletion data condition. The deletion source data is obtained from the data storage unit, the deletion data is created based on the deletion source data and stored in the data storage unit, and when the deletion source data has passed the warranty period, the data storage is performed. Receiving the correction data condition and the correction information from the input device, acquiring the correction source data matching the correction data condition from the data storage unit, and correcting the data based on the correction source data and the correction information. Create data and store it in the data storage unit, and delete the data from the data storage unit when the correction source data has passed the warranty period Receiving the search condition and the search date and time from the input device, outputting an error to the output device when the search date and time are outside the warranty period, and outputting the error from the data storage unit when the search date and time are within the warranty period. Acquires condition matching data, extracts the largest one whose update date and time is less than or equal to the search date and time from the acquired condition matching data and outputs it to the output device.If the condition matching data has passed the warranty period, A computer-readable recording medium on which a program for executing the steps of: deleting data from the data storage unit;