JPH02253352A - Data base update controller - Google Patents

Abstract

PURPOSE:To keep the input received from a terminal equipment in a non-stop state without stopping an on-line process by deciding the executing time required for update of a data base of the on-line process based on a batch process. CONSTITUTION:A state holding means 23 receives the start/end information on a batch processor 11 and holds an executing or unexecuting state of a batch process. An information means 22 receives the batch process executing state from the means 23 and holds and stores the information received from an input means 13 to an update means 15 for an instruction of execution. Thus the executing time can be automatically controlled for update of the data base of an on-line process based on the batch process. As a result, an operator is not required to decide the executing state of the batch process nor to stop the on-line process. At the same time, the input received from a terminal equipment 12 can be kept in a non-stop state.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a database update control device, and particularly to a database update control device suitable for executing parallel database update processing with batch processing in an online system.

[Conventional technology]

A conventional device will be explained with reference to FIG.

Generally, when online processing and batch processing are executed in parallel, multiple updates from online processing occur randomly. Therefore, the contents of the database are updated during batch processing, that is, between reading and writing.

In the batch processing apparatus shown in FIG.
When one of the reading means 17 for reading out data in a batch from the online processing device 10, the data processing means 18 for processing the read data by the reading means 17, and the writing means for writing the data processed by the data processing means 18 in a batch is executed, the online processing device 10 When the contents of the database 9 are updated, if an inconsistency occurs in the processing performed by the data processing means 18, the online processing device 10 may be stopped by human judgment between reading 4 and writing 6 in batch processing. I'm letting you do it.

[Problem to be solved by the invention]

For this reason, when reading processing, data processing processing, and writing processing are handled in separate processes in batch processing, a person makes a judgment and stops the online processing.

Therefore, an object of the present invention is to provide database update control that eliminates the need to stop online processing by determining the execution time of database update from batch processing to online processing, and that can maintain input from a terminal device in an uninterrupted state. The purpose is to provide equipment.

[Means to solve the problem]

According to the present invention, "a database, an input means for receiving data input from a terminal device, an update data processing means for processing data based on the data from the input means, and the update data processing means" an online processing device having an update data accumulation file for storing processed data; and an update means for extracting update data from the update data accumulation file and updating the database; a data processing means for performing necessary processing on the data read by the reading means; and a writing means for writing the data processed by the data processing means into the database all at once. The update control device includes a holding unit that receives information on start and end of the batch processing device and holds a status of whether batch processing is being executed or not, and a holding unit that receives the status of batch processing from the status holding unit. and notification means for suspending and accumulating notifications of execution instructions from the input means to the update means.

〔Example〕

Next, the present invention will be described in more detail with reference to the drawings showing one embodiment of the present invention.

Referring to FIG. 1, one embodiment of the present invention includes a database 9, an online processing device 10, and a batch processing device 1.
1, a terminal device 12, an input device 13, an update data processing device 14, an update device 15, a start instruction means 16,
It is composed of a reading means 17, a data processing means 18, a writing means 19, an end notification means 20, an update data accumulation file 21, a notification means 22, and a state holding means 23.

Next, the operation of this embodiment will be explained with reference to FIGS. 1 and 2.

In the batch processing device 11, at the start of batch processing, the start instructing means 16 sets the state holding means 23 to a state in which the batch processing is being executed, and then the reading means 8 reads the data read out from the database 9 all at once. is processed by the data processing means 18 and written to the writing means 1.
9, when the batch processing is completed, the state holding means 23 is sent by the completion notification means 20.
Set to batch processing not executed. That is, the state of the state holding means 23 is changed by the start instruction means 16 to batch processing not being executed by the end notification means 20 while the batch processing is being executed, and the execution state of the batch processing is maintained.

On the other hand, in the online processing device 19, the terminal bag W1
The input means 13 receives the input data from the update data processing means 14, and instructs the notification means 22 to notify the update means 15 of the occurrence of update data.

The update data processing means 3 that receives the input data from the input means 13 processes the input data to create update data and stores it in the update data accumulation file 21.

The notification means 22, which is notified of the occurrence of update data from the input means 13, refers to the execution state of the batch process in the state holding means 23, and immediately issues an instruction to execute the update process if the batch process is not yet executed. is notified to the updating means 15, and if the batch processing is being executed, the notification of the update processing execution instruction to the updating means 15 is suspended, and the state of the state holding means 23 is changed to the state where the batch processing is not executed. Later update means 15
The updating means 15, which has been notified of the instruction to execute the update processing by the notification means 22, extracts the update data from the update data accumulation file 21 and actually updates it in the database 9.

In this way, updates that occur in online processing between read 4 and write 6 in batch processing in Figure 2 will be suspended and updated at time 8, and processing in batch processing will be suspended. No contradiction occurs in 5. In other words, since the database update control device of this embodiment automatically controls the execution timing of database update for online processing, there is no need for a person to stop online processing after determining the execution status of batch processing, and the terminal device It is possible to maintain an uninterrupted state of input from.

Note that the present invention is effective not only in a case where online processing and batch processing are performed in separate devices, but also in a system in which online processing and batch processing are implemented within a device, for example.

Further, the present invention is effective in the configuration of functional blocks of a batch processing device, when the execution time of the means for reading from the database and the means for writing to the database are different, without any processing being performed between them.

〔Effect of the invention〕

As explained above, according to the present invention, by making it possible to automatically control the execution time of database update for online processing rather than batch processing, it is no longer necessary for a person to judge the execution status of batch processing and stop online processing. Eliminate the
It also makes it possible to maintain uninterrupted input from the terminal device.

[Brief explanation of drawings]

Fig. 1 is a functional block diagram of a database update control device according to an embodiment of the present invention, Fig. 2 is an explanatory diagram of execution timing of database update in parallel processing of online processing in this embodiment, and Fig. 3 is a diagram of a conventional database update control device. FIG. 2 is a functional block diagram of a database update control device. 1.2, 3: Timing of updating the database by online processing, 4: Timing of bulk reading of the database by batch processing, 5: Time elapse of data processing by batch processing, 6: Timing of bulk writing to the database by batch processing, 8: Database update timing by online processing for 2 in which update is executed after being retained according to the present invention; 9: Database; 1Oco online processing device;
11: Batch processing device, 12: Online input device for terminal processing, etc., 13: Input device that receives input from the terminal device, 14: Update data processing device that processes input data, 1
4: Update means for actually updating the database, 16:
17: reading means for reading out data from the database in batch processing in batch processing; 18: data processing means for processing read data in batch processing; 19: data processed in batch processing. A writing method that writes data to the database in bulk,
20: Termination notification means indicating termination of the batch processing device, 21
：Update data accumulation file for accumulating update data to the database after input data is processed by online processing; 22: Notification means for notifying the update means of generation of update data from the input means; 23: Indicating the execution status of batch processing. means for maintaining the state. Agent Patent Attorney Shina Uchihara Diagram

Claims (1)

[Scope of Claims] A database, input means for receiving data input from a terminal device, update data processing means for processing data based on the data from the input means, and processing performed by the update data processing means. an online processing device having an update data storage file for storing updated data; and an update means for extracting update data from the update data storage file and updating the database; a data processing means for performing necessary processing on the data read by the reading means; and a writing means for writing the data processed by the data processing means into a database all at once. In the control device, a holding means receives start/end information of the batch processing device and holds a state of whether batch processing is being executed or not, and a holding means receives a state of batch processing being executed from the status holding means A database update control device comprising: notification means for suspending and accumulating notifications of execution instructions from the input means to the update means.