JP2956593B2 - Transaction file processing method - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[0001] 1. Field of the Invention [0002] The present invention relates to a transaction file processing method for updating a master file stored in a host computer with a transaction file in a terminal device.

[0002]

2. Description of the Related Art Conventionally, in a transaction file processing method in which a master file of a host computer is updated using a transaction file created by a terminal device, a sequential file is used as the transaction file, and the transaction file is stored in the terminal device. When a file is updated or changed, a transaction file in which all such updates and changes are recorded is sent to the host computer.

[0003]

As described above, in the conventional transaction file processing method, a sequential access file is used. Therefore, when the transaction file is updated or changed in the terminal device, There may be multiple records with the same key, and there may be more data than necessary.

[0004] The present invention has been made in view of the above circumstances, and in a transaction file processing method,
An object of the present invention is to reduce the amount of data by maintaining an update category when records having the same key are input to reduce unnecessary records.

[0005]

Means for Solving the Problems] To achieve the above object, the present invention, the master file of the host computer, the transaction file processing method der update with a transaction file that the terminal device is created
Thus , the transaction file stores a key, an update category, and data content for each record, and when updating the transaction file, a record having the same key as the input record is stored in the transaction file. To check whether or not the transaction file is updated, based on the check result and the input record and the update division of the transaction file, change the setting of the update division of the transaction file, and update the transaction file. in transaction file processing method that performs, said end
The device is the same as the master file of the host computer.
With a local master file one content, the updated classification
Including registration, modification, and deletion, as entered
If the record's update indicator is Created,
Record with the same key as the local master
File does not exist and the transaction file
The transaction file, if it exists in the
Change the update category of the update to correct, update and enter the
If the update indicator of the record is correction, the input record
Record with the same key as the local master
File and said transaction file,
And if the update category of the record is registration,
Change the update indicator in the transaction file to Create ,
If the update category of the input record is delete,
The record having the same key as the input record is
Local master file and the transaction file
File and these update categories are registered
, The record is deleted .

[0006]

Embodiments of the present invention will be described below. In the embodiment of the present invention, when updating a file in the terminal device (1 in FIG. 1), a local master file (FIG. 1) having the same contents as the master file stored in the host computer (8 in FIG. 1) is used. 6) is updated, and a transaction file (5 in FIG. 1) is created accordingly.

The transaction file (5 in FIG. 1) is provided with an area for storing a key, an update category, and data contents for each record. The update category includes, for example, “register”, “correct”, and “delete”.

[0008] When a record having the same key as a record already existing in the local master file or the transaction file is input and an update is performed, the update classification of the input record and the update classification of the transaction file are determined according to the update classification. Thus, the update category of the transaction file is newly determined, and the data content of the newly input record is stored in the transaction file.

When updating the master file stored in the host computer, this transaction file is transferred to the host computer, and the transaction file of the terminal device is deleted.

In the embodiment of the present invention, by maintaining (maintaining and managing) the update division of the transaction file, the transaction file is transferred to the master file of the host computer (8 in FIG. 1). Even when the file is updated, unnecessary data is not provided in the transaction file, so that the amount of information transferred to the host computer can be reduced.

[0011]

Next, embodiments of the present invention will be described with reference to the drawings. FIG. 1 is a diagram for explaining the configuration of the embodiment of the present invention.

Referring to FIG. 1, the embodiment of the present invention comprises a terminal device 1 and a host computer 8 connected to the terminal device 1 via a communication line 7. The terminal device 1 has a record updating unit 4 to which a display 2 and a keyboard 3 are connected, and to which a transaction file 5 and a local master file 6 are connected.

The record update section 4 reads the update record input from the keyboard 3 and selects update categories of the update record into “registration”, “correction”, and “deletion”. Execute the processing that was performed.

FIG. 2 is a flowchart for explaining the flow of the process of updating the transaction file 5 when the update category of the input update record is “registration” in this embodiment. Referring to FIG. 2, when the update category of the update record input from keyboard 3 is "register", it is checked whether or not the input record exists in local master file 6 (step S11). ,
If not, it is checked whether the input record exists in the transaction file 5 (step S12).

In the processing of step S12, when the input record exists in the transaction file 5 (for example, after the record deletion processing has been performed, the transaction file 5 transfer processing has not been performed yet). Therefore, if this record exists in the master file of the host computer 8), "update" is set in the update category (step S1).
3) If it does not exist, "registration" is set in the update category (step S14).

Next, the local master file 6 and the transaction file 5 are updated respectively, and if a record with the same key exists, this record is overwritten (step S15). If it is determined in step S11 that the input record already exists in the local master file 6, that is, if the record has already been registered, the process is stopped and an error message is displayed on the display 2.

FIG. 3 is a flowchart for explaining the flow of the process of updating the transaction file 5 when the update category of the input update record is “correction” in this embodiment. Referring to FIG. 3, when the update category of the update record input from keyboard 3 is “correction”, it is checked whether the input record exists in local master file 6 (step S21). ,
If it exists, it is checked whether the input record exists in the transaction file 5 (step S).
22).

In the process of step S22, if the input record does not exist in the transaction file 5, "update" is set in the update category (step S22).
25) If it exists, it is checked whether or not the update category of the record of the transaction file 5 is “registration” (step S23). In the process of step S23, when the update category is "register", that is, when the registration process of this record has been performed but the transfer process of the transaction file 5 has not been performed yet, "registration" is set to the update category. Set (step S24), if the update category is not "register", ie, the host computer 8
Is already registered in the master file, "update" is set in the update category (step S2).
5).

Next, the local master file 6 and the transaction file 5 are updated with the record in which the update category is set, and if a record with the same key exists, this record is overwritten (step S26). If the record input in the check in step S21 does not exist in the local master file 6, that is, if there is no corresponding record to be corrected, the process is stopped and an error message is displayed on the display 2.

FIG. 4 is a flowchart for explaining the flow of the process of updating the transaction file 5 when the update category of the input update record is "delete" in this embodiment. Referring to FIG. 4, if the update category of the update record input from keyboard 3 is "delete", it is checked whether the input record exists in local master file 6 (step S31). ,
If it exists, it is checked whether the input record exists in the transaction file 5 (step S).
32).

In the process of step S32, if the input record does not exist in the transaction file 5, "update" is set in the update category (step S32).
35), update the transaction file 5 (set the data and / or key of the input record) (step S36). On the other hand, in the process of step S32, the input record is the transaction file 5
If it exists, it is checked whether or not the update category of the record of the transaction file 5 is “registration” (step S33). If the transaction file 5 has not been transferred to the host computer 8 yet, the record of the transaction file 5 is deleted (step S34). If the registration has been completed, "delete" is set in the update category (step S35), and the data and / or key of the record input to the transaction file 5 are set (records with the same key exist). In this case, this record is overwritten) (step S3).
6).

Next, the record of the local master file 6 is deleted (step S37). Step S3
If the record input in the check 1 does not exist in the local master file 6, that is, if there is no corresponding record to be deleted, the processing is stopped and an error message is displayed on the display 2.

As described above, the record updating unit 4 processes the record input from the keyboard 3 and generates the transaction file 5. Host computer 8
Is updated by transferring the transaction file 5 to the host computer 8 via the communication line 7.

In this embodiment, the update record is inputted from the keyboard 3. However, the present invention is not limited to such a constitution, and the record is inputted from another file device or the like. Needless to say, it may be.

[0025]

As described above, according to the transaction file processing method of the present invention, by maintaining the update division of the transaction file, there is no useless part in the information of the transaction file and the transfer time to the host computer is shortened. When the communication line is provided between the host computer and the terminal, the communication cost can be reduced.

[Brief description of the drawings]

FIG. 1 is a diagram for explaining a configuration of an embodiment of the present invention.

FIG. 2 is a diagram showing an example in which an update category is “registered” in an embodiment of the present invention;
9 is a flowchart for explaining the operation in the case of FIG.

FIG. 3 is a diagram showing an example in which the update category is “correct” in the embodiment of the present invention.
9 is a flowchart for explaining the operation in the case of FIG.

FIG. 4 shows an example in which the update category is “delete” in the embodiment of the present invention.
9 is a flowchart for explaining the operation in the case of FIG.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Terminal device 2 Display 3 Keyboard 4 Record update part 5 Transaction file 6 Local master file 7 Communication line 8 Host computer

──────────────────────────────────────────────────続 き Continued on the front page (58) Fields surveyed (Int.Cl. ⁶ , DB name) G06F 12/00 G06F 15/16 G06F 15/00 G06F 3/06

Claims (1)

(57) [Claims] 1. A master file of a host computer,
A transaction file processing method for updating using the transaction file created by the terminal device.
The transaction file stores, for each record, a key, an update category, and data content, and when updating the transaction file,
Checking whether a record having the same key as the input record exists in the transaction file; and updating the transaction file based on the check result and the input record and the update category of the transaction file. change the setting of the division, Trang to perform the update of the transaction file
In the transaction file processing method, the terminal device is a master file of the host computer.
If the update category of the input record is registration, the local master file has the same contents as the file, and the update category includes registration, correction, and deletion.
The record having the same key as the input record is
If it does not exist in the local master file and the transaction
If it exists in the transaction file,
Change the update category of the input file to correction and update it.If the update category of the input record is
The record having the same key as the input record is
Local master file and the transaction file
File and the update category of the record is registered
In this case, update the transaction file
Change to registration , and if the update category of the input record is
The record having the same key as the input record is
Local master file and the transaction file
File and these update categories are registered
, The record is deleted .