JPH03276239A - Record control system - Google Patents

Abstract

PURPOSE:To perform the closing processing of a data base without deteriorating the services to the users nor needing a large quantity of resources by storing the updating result into the data records chained to each other via a pointer when the data record that is added and updated before the closing time is updated. CONSTITUTION:In a retrieving state, a data retrieving means 6 retrieves and returns only the data record that is added and updated before the set business time. In an addition state, a data adding means 7 stores the data record together with the information on the present time. In an updating state, a data updating means 8 updates the records added and updated before the set closing time. In this case, the updating result is stored in a data record 11 chained by a pointer 12. Thus it is possible to close a data base 1 without deteriorating the services to the users nor needing a large quantity of resources.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a record management method in a database management system for an electronic computer.

[Conventional technology]

Conventionally, in database management systems, when there is a request to update a data record, the contents of the database are immediately updated to keep the database always up to date.

That is, a corresponding data record is read from a database, updated, and then the updated data record is written to the database.

Incidentally, as processing related to the database, in addition to processing such as normal updating, there is closing processing such as monthly processing. This is to obtain some information based on the contents of the database at a predetermined point in time, such as at the end of the month.

Conventionally, there have been two types of this tightening process:

■Prohibit database updates at the start of closing process,
In this state, the closing process is performed, and when the closing process is completed, the prohibition of updating the database is lifted.

■Create a copy of the database at the start of the closing process to create a finalized database at the closing time, and perform the closing process based on that database.

[Problem to be solved by the invention]

As mentioned above, in conventional database management systems, there are two types of closing processing.
Both had the following drawbacks.

That is, in the form (3), since other users cannot update the database during the closing process, the service provided to the user is significantly degraded.

In addition, in the form (2), in order to copy the database, a storage area of the same capacity as the original database is required, and a large amount of resources such as magnetic disk devices are required.

The present invention has been proposed in view of the above points, and its purpose is to provide record management that can perform database closing processing without degrading services to users and without requiring a huge amount of responsibility. The purpose is to provide a method.

[Means to solve the problem]

In order to achieve the above object, the present invention is a database management system that searches, adds, and updates data records to a database, and when searching, searches only data records that have been added or updated before a set business time. A data retrieval means for returning data as a result, a data addition means for adding and storing current time information to data records when adding data, and a data addition means for storing data records with current time information attached to them when adding data; When updating, data updating means is provided for storing the updated result in the data record tuned by the pointer.

[Effect]

In the record management system of the present invention, the data search means searches and returns only data records that were added or updated before a set business time when searching, and the data adding means when adding Stored with information on the current time, and when updating, if the data update means updates a data record that was added or updated before the set cut-off time, the update result is stored in the data record tuned by the pointer. do.

〔Example〕

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

FIG. 1 is a block diagram showing an embodiment of a database management system to which the record management method of the present invention is applied. 1st
In the figure, this embodiment has a database 1 storing a plurality of data records, a time unit 2 that outputs the current time, a closing time storage area 3, and a closing time storage area 3 that sets the business time. a business time storage area 4 for storing data; a data processing means 5 for processing requests for searches, additions, and updates from users to the database 1; a data search means 6 for searching for data records in the database 1; The data adding means 7 adds data records to the database 1, and the data updating means 8 updates data records to the database 1.

Note that the closing time is a time for specifying the state of the database 1 that is the target of the closing process, and the closing process is performed based on the state of the database 1 at that time. In addition, the business time is the time to identify the status of the target database 1 when searching for data records, and only data records added or updated before that time are searched. be.

FIG. 2 shows the structure of a database l, which is composed of a plurality of data records 11. FIG. 12, a timestamp 13 in which information about the time of addition/update of the data record 11 is stored, and a data section 14 in which the content of the data is stored.

Hereinafter, the operation of the above embodiment will be explained in accordance with the flowcharts shown in FIGS. 4 to 6.

(1) Data record search When a user requests a data record search process,
The data processing means 5 is activated, and after analyzing the processing request, the data processing means 5 activates the data retrieval means 6 and ends the processing.

As shown in FIG. 4, the data retrieval means 6 retrieves the business time from the business time storage area 4 (step 61), and then reads the corresponding database 1 from the database 1 (step 62).

Then, compare the display time of the time stamp 13 of the read data record 11 with the business time (step 63).
), if the displayed time of timestamp 13 is larger,
That is, if the data record 11 was added or updated after the specified business time, a status indicating that the data record was not found is returned to the user (step 64), and the process ends. do.

On the other hand, if the display time of the timestamp 13 is the same as or smaller than the business time, that is, if the data record 11 was added or updated before the specified business time, the pointer I2 is also empty. If it is empty, the data section 14 of the data record 11 is returned to the user (step 68), and the process ends.

Furthermore, if the pointer 12 is not empty, the pointer 12
Reads another data record pointed to from database 1 (step 66), then compares the display time of the timestamp of that data record with the business time (step 67), and determines whether the display time of the timestamp is the same as or smaller than the business time. In other words, if the other data record tuned by the pointer 12 was added or updated before the specified business time, the data part of the other data record is returned to the user (step 68).
, ends the process.

On the other hand, if the display time of the timestamp is larger, that is, if the other data record tuned by pointer 12 was added or updated after the specified business time, then the original data record 11 data department engineer 4 is returned (step 69), and the process ends.

With the above process, if you set the business time as the closing time,
Only data records added or updated before the closing time are searched, and closing processing can be performed based on this. Further, by setting the business time to the current time, a search can be performed based on the latest state of the database 1, and a general user can thereby perform the same business as usual. Note that by arbitrarily setting the business time, the search process can be performed based on the state of the database 1 at that time.

(2) Addition of data records When a user requests additional processing of a data record', the data processing means 5 is activated, and the data processing means 5 analyzes the processing request and then activates the data addition means 7. Finish the process.

The data adding means 7 includes the time device 2 as shown in FIG.
Step 71) to extract the current time from 'Create a data record 11 in the format shown in FIG.
2). At this time, the pointer 12 is left blank, the time stamp 13 stores the current time, and the data section 14 stores data passed from the user.

Next, the created data record 11 is stored in the database 1.
(step 73), and the process ends.

(3) Data record update When a user requests processing to update a data record,
The data processing means 5 is activated, and after analyzing the processing request, the data processing means 5 activates the data updating means 8 and ends the processing.

The data updating means 8 includes the time device 2 as shown in FIG.
Step 81) of extracting the current time from the cut-off time storage area 3, step 82) of extracting the cut-off time from the cut-off time storage area 3, and then reading the corresponding data record 11 from the database 1 (step 83).

Then, compare the display time of the time stamp 13 of the read data record 11 with the closing time in step 84.
), if the displayed time of timestamp 13 is larger,
That is, if the data record 11 to be updated was added or updated after the specified closing time, the timestamp 13 of the data record 11 is updated to the current time, and the data section 14 is updated. is updated with the data given by the user (step 87), and the process ends.

On the other hand, if the display time of the timestamp 13 is the same as or smaller than the closing time, that is, if the data record 11 was added or updated before the specified closing time, the pointer 12 is also empty. (step 85), and if it is not empty, read other data records pointed to by pointer 12 from database I (step 86), update the timestamps of the other data records to the current time, and update the data section. The process is updated with the data given by the user (step 87), and the process ends.

In addition, if the pointer 12 is empty, a new data record with the updated contents specified by the user is created and added to the database 1 (step 88), and the data record added to the pointer 12 of the original data record 11 is added. The address is stored (step 89), and the process ends. Note that the process of adding a new data record follows the process explained in FIG.

〔Effect of the invention〕

As explained above, in the record management system of the present invention, by setting a closing time, the contents of data records added or updated before that time are retained as they are, and the contents after updating are By later setting the business time as the closing time, the closing process can be performed with the database state before the closing time, while other users can set the business time to the current time. By setting it, you can process with the latest database status. Therefore, there is no need to prohibit other users from updating the database for the closing process, so the database service will not deteriorate.

■Since there is no need to copy the contents of the database at the time of closing, there is no need for huge resources for copying.

There are other effects.

[Brief explanation of drawings]

Figure 1 is a configuration diagram showing an embodiment of a database management system to which the record management method of the present invention is applied; Figure 2 is a configuration diagram of a database; Figure 3 is a configuration diagram of data records; Figure 4 is a data search FIG. 5 is a flowchart of the processing of the data adding means, and FIG. 6 is a flowchart of the processing of the data updating means. In the figure, 1...Database 1...Data record 12...Pointer 13...Time stamp 14...Data section 2...Time unit 3... - Closing time storage area 4... Business time storage area 5... Data processing means 6... Data search means 7... Data addition means 8... ...Data update means

Claims (2)

[Claims] (1) In a database management system that searches, adds, and updates data records to a database, a data search means that searches and returns only data records that were added or updated before a set business time when searching. , A data addition method that attaches and stores current time information to a data record when adding, and a pointer tuning method when updating data records that have been added or updated before the set cut-off time. A record management method comprising a data update means for storing update results in a data record. (2) In addition to providing a timestamp in the data record that indicates the time of addition/update to the data record, a time device that outputs the current time, a closing time storage area for setting the closing time, and a business time are set. 2. The record management system according to claim 1, further comprising a business time storage area for storing business time.