JPS6138498B2 - - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION The present invention relates to a recovery processing control method for a summary table, etc. on main memory.

Generally, for example, in POS systems, etc.
The sales data of the POS terminal is transferred to the terminal control device, etc.
Aggregation is performed for each POS terminal.

Furthermore, such systems are equipped with a tally table, and the data in the tally table is saved to an external storage device such as a save file at regular time intervals so that the contents of the table will not be lost in the event of a failure.

However, in department stores, etc.
There are many POS terminals, and not only does it take a long time to save the data, but it also has the drawback that data that is being saved cannot be recovered.

SUMMARY OF THE INVENTION An object of the present invention is to provide a recovery processing control system that is capable of recovering data that is in the middle of being saved and that also allows processing such as intensive processing to be performed during the saving process, in order to eliminate the above-mentioned conventional drawbacks.

In order to achieve the above object, the present invention stores the updated management number in the area where the data was stored when the data is saved, and the input data is processed after the aggregation process. Add a management number to the target data and log it, and at the time of failure recovery, if the management number of this logging data is different from the management number extracted from the backup file in main memory, logging will be performed. The data is used to perform update processing such as aggregation processing.

This will be explained below using examples.

The drawing is a block diagram of one embodiment of the invention.

In the figure, REG is an input register, for example,
CR is the aggregation unit that stores the POS terminal address data transferred from the POS terminal and the input data to be aggregated, and the aggregation table TBL
is read accessed by addressing with the POS terminal address data, the input data is cumulatively added to the already read total data, and the added data is stored in the target address, table TBL. stores the aggregated data in the address corresponding to the POS terminal, and a management number is stored in each address.LC is the logging control unit, and stores the data stored in the register REG and in area a of the table TBL. The data of the POS terminal stored in the register REG and the management number of the corresponding tally data are stored in the logging file F2 every time the tally is completed.TIM is a timer that generates a pulse at every predetermined time. CT is a counter that counts the pulses and generates a management number. SC is a save control unit that is activated by the pulse of timer TIM.
Each piece of tally data in the tally table TBL is read out and saved to the save file F1, and the management number corresponding to the saved tally data is written to the write control unit WC.
, RCC1 is a recovery controller that expands the aggregated data including the management number saved in save file F1 to table TBL at the time of failure recovery, RCC2 is a recovery controller and writes to logging file F2. RC is the read controller that reads the first logging data of the recovery controller RCC2, extracts the POS terminal address data from the logging data read by the recovery controller RCC2, and uses this address data to manage from the table TBL. The one that reads the number, CM is the comparison part and table
A is an AND gate that compares the management number read from TBL and the management number read from logging file F2.

Explain the operation.

(i) Aggregation operation From the control device (not shown), register REG
The aggregated data and POS terminal address are stored in .

The aggregation control unit CR accesses the table TBL based on the POS terminal address, adds up the input data to the already read out aggregation data, and writes the aggregation data to the table TBL again. When the aggregation process is completed, the logging control unit LC registers
The management number read out by the access from the aggregation control unit CR is added to the input data stored in the REC, and the data is stored in the logging file F2. Thereafter, the table is updated in the same manner every time input data is stored in the register.

(ii) Saving operation Timer TIM issues an output at predetermined intervals. As a result, the evacuation control unit SC is activated.
The evacuation control unit SC is connected to the
Detect empty period of access of table TBL, for example, table with small address
The total data and management number are read out and stored in the save file F1 in order from the data on the TBL.
Every time data of one POS terminal is stored in the save file, the write control unit WC is activated and a counter is written to the address where the data is stored.
Update the management number that is the output value of CT.

When the update is completed, the next total data and management number are saved and the management number is updated. Thereafter, save processing and update processing are performed for all the aggregated data and management numbers in the same manner.

Note that this save process and update process are performed using a timer.
The period of timer TIM is set widely so that the timer TIM ends within the generation period of the output of TIM. And more (ii)
The term saving process refers to processing such that even if the aggregated data is saved on the table TBL, the aggregated data remains on the table TBL.

(iii) Failure recovery operation When failure recovery is detected by the failure recovery detection unit (not shown), the recovery controller
RCC1 is activated. recovery controller
The RCC1 writes the aggregated data of each POS terminal saved in the save file F1 as described above and each management number onto the table TBL.

All aggregated data and management numbers are in a table
After being written to TBL and restoring table TBL, recovery controller RCC2 is activated. The recovery controller RCC2 reads data including the last logged input data, management number, and POS terminal address from the logging file F2 as described above. Among the read data, POS terminal address data is stored in the read control section.
The management number for RC and AND gate A is the comparison section.
Supplied to CM. Input data (data to be aggregated) is also supplied to AND gate A. Read control unit RC is expanded table
The control number for the data of the corresponding POS terminal is read from the TBL and the read control number is supplied to the comparison unit CM.

The comparison unit CM compares both supplied management numbers. As a result of the comparison, if the management number of the logging data is larger than the management number of the table TBL, this indicates that the input data has not been aggregated in the saved data.
The CM opens AND gate A, sets the POS terminal address data and input data among the logging data in the register REG, and activates the aggregation processing unit CR to cumulatively add them to the corresponding already aggregated data. When the cumulative addition is completed, the recovery controller RCC2 reads out the logging data logged immediately before the last logging data from the logging file F2, and similarly checks it.

Further, if the management number read from the table TBL is equal to the management number of the logging data, or if the management number of the logging data is smaller, the comparison unit CM notifies a control device (not shown) of a recovery end signal.

Note that the logging data read to the recovery controller RCC2 at this time is reset.

Also, at the time of recovery, as a method for detecting the address of the last logged data in logging file F2, for example, in the event of a failure, logging file F2 indicated by logging controller LC is detected.
A method can be adopted in which the address is saved in a non-volatile storage means, and the save address is notified not only to the logging controller LC but also to the recovery controller RCC2 at the time of failure recovery.

As explained above, according to the present invention, a management number is added to each data to be saved, and the management number of the latest corresponding processed data is added to the input data, so there is no difference in the management number. Not only can the recovery process be performed quickly, but also the table empty time is checked when evacuation is performed, so it has the effect that it does not affect the tabulation process or the like.

In addition, although the above embodiment has been explained focusing only on the aggregation process and the table, it is not limited to the aggregation process or even the table, and instead of the aggregation process, update processing or other arithmetic processing may be used. , it is clear that instead of a table, various types of data placed in main memory may be used.

[Brief explanation of the drawing]

The drawing is a block diagram of one embodiment of the invention. In the figure, CR is the aggregation processing unit, TBL is the table, and CT
is a counter, F1 is a save file, F2 is a logging file, CM is a comparison section, and RCC1 and RCC2 are recovery controllers.

Claims (1)

[Claims] 1 In a recovery processing control method that saves data that has been processed at predetermined intervals to an external storage device, restores the saved data, and restarts the process when recovering from a failure, the data that is saved every time data is saved. a number updating means for sequentially updating a management number for data corresponding to the data; and a first storage means for logging and adding a management number to data input to be processed each time the input data is processed. , a second storage means for adding and storing the management number to the processed data, and at the time of failure recovery, the management number of the data restored from the external storage device and the management number of the logged input data are provided. Compare the
A recovery processing control method characterized by reprocessing only data that has not been processed.