JPH06274391A - Master file quick update processing system - Google Patents

Abstract

PURPOSE:To improve the execution speed of the processing of updating the record of a master file by the record of a transaction file. CONSTITUTION:This system is provided with a master output part 5 extracting only a necessary item from the record of the master file 1 and outputting it to a first work file 2 by appending a sequential number to it, a transaction output part 6 extracting only a necessary item from the record of a transaction file 3 and outputting it to a second work file 4 and a first sort processing part 7 sorting the first and second work files 2 and 4 with a common item as a key. Furthermore, the system is composed of a match updating part 8 updating the first work file 2 by successively matching the first work file 2 with the second work file 4 after sorting, a second sort processing part 9 resorting the first work file 2 by the sequential number and a master updating part 10 updating the master file 1 by matching the sorted first work file 2 with the master file 1.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a master file high-speed update processing method, and in particular, when a master file update processing is performed with transaction file data, the master file is subdivided to improve its execution speed. A high-speed update processing method.

[0002]

2. Description of the Related Art Conventionally, when updating an item in a master file with an item in a transaction file, as a general pattern, first, records of the master file (called master records) are sequentially accessed and then, After the record of the transaction file (called transaction record) is obtained by random access using the record identification item common to the master file as a key, the master record is updated with the transaction record item and the updated master record is used as the master file. A processing method such as writing back to is used.

[0003]

In the above-mentioned conventional master file update processing method, since the transaction file is randomly accessed, the transaction file needs an index portion, and a key block is read for the READ command. In addition to increasing the number of physical inputs and outputs, the number of processing steps required to retrieve the corresponding record also increases, and processing time also increases accordingly.

An object of the present invention is to provide a master file high-speed update processing system which does not require an index part in a transaction file and can perform update processing in a short time.

[0005]

A master file high-speed update processing method according to the present invention is a first work file in which a sequential number is added to a record identification item and an update target item of each record in target data from a master file. To the second work file, a master output unit that sequentially outputs the record identification item and the update processing item in the update data from the transaction file to the second work file, the first work file, and the second work file. A first sort processing unit that sorts each work file by the record identification item, and a matching process of the records of the first work file and the second work file after sorting is performed in the sorting order by the record identification item. A match update unit that updates the first work file; A second sort processing unit that re-sorts the first work file with the sequential number after updating; and a matching process of the first work file and the master file after processing by the second sort processing unit. And a master update unit for updating the master file.

[0006]

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

FIG. 1 is a block diagram showing the configuration of an embodiment of the present invention.

As shown in FIG. 1, the master file high-speed update processing method of this embodiment sequentially adds the sequential numbers from the master file 1 to the necessary items of each record and outputs them to the first work file 2. The master output unit 5 which outputs the necessary items of each record from the transaction file 3 to the second work file 4 and the first work file 2 and the second work file 4 are common. The first sort processing unit 7 that sorts by items and the matching processing of the first work file 2 and the second work file 4 after sorting are performed.
Match update section 8 for updating the work file 2 of
A second sort processing unit 9 for sorting the first work file 2 by the sequential number added at the time of output,
The master update unit 10 is configured to include a master work file 2 and a master file 1 that have undergone the sorting process and update the master file 1.

The operation of each unit will be described in detail below with reference to FIGS. The master file 1 and the transaction file 2 shown in FIG. 1 are files each containing a processing target data group read into a memory from a magnetic disk device or the like, and the transaction file 2 does not have an index portion, and records of each file. Are arranged in an arbitrary order. Here, it is assumed that an item (update target item) in the master record of the master file 1 is updated by an item (update processing item) in the transaction record of the transaction file 3 and is common to both the master record and the transaction record. A common CODE exists as a record identification item, a matching process is performed using this common CODE as a key, and the value of the update target item in the master record is updated with the value of the update process item in the corresponding transaction record.

As shown in the flow chart of FIG. 2, the master output unit 5 sequentially acquires the master records from the master file 1 one by one (step 11). If the master record can be acquired instead of the end of the records (step 12). ,
Only necessary items (record identification item and update target item) in the master record are extracted (step 13), a sequential number is added to the acquired order to create a sort record (step 14), and the created sort record Is output to the first work file 2 (step 1
5). When the above operation is repeated and the processing for all master records is completed, the master output unit 5 passes control to the transaction output unit 6.

An example of a record format output from the master output unit 5 to the first work file 2 is shown in FIG. 8 (a).
The master record format of the master file 1 is shown in FIG.
The record format of the sort record output to the first work file 2 when it is composed of item A, common CODE (record identification item), item B, item Z (update target item), and item C as shown in Is composed of only the common CODE, item Z, and sequential number.

As shown in the flow chart of FIG. 3, the transaction output unit 6 sequentially acquires transaction records one by one from the transaction file 3 (step 1
6) If it is not the end of the record (step 17), only the necessary items (record identification item and update processing item) are extracted from the acquired transaction record to create a sort record (step 18), and the created sort record Is output to the second work file 4 (step 1
9). When the above operation is repeated and the processing of all transaction records is completed, the transaction output unit 6
The control is passed to the sorting processing unit 7 of.

An example of a record format output from the transaction output unit 6 to the second work file 4 is shown in FIG. 8 (b).
If the transaction record format of the transaction file 3 is composed of common CODE (record identification item), item A ′, item Z ′ (update processing item), and item B ′ as shown in FIG. 8B, The record format of the sort record output to the work file 4 of No. 2 is composed of only the common CODE and the item Z ′.

The first sort processing section 7 uses a common C for each of the first work file 2 and the second work file 4.
Sort by ODE. FIG. 4 is a flow chart showing the operation. First, in order to sort the first work file 2 and the second work file 4, sort information having a common CODE as a key is created (step 20), and the first work file 2 and the second work file 4 are sorted based on the sort information. Two
The work file 4 is sorted (steps 21 and 22), and control is passed to the matching update section 8.

The match update unit 8 matches the sort records of the first work file 2 sorted by the common CODE with the sort records of the second work file 4, and updates the records until the records of the first work file 2 are exhausted. I do. FIG. 5 is a flow chart showing the operation.
1 sort record from the beginning of the first work file 2
Records are acquired one by one (step 23), it is judged whether or not the record is finished (step 24), and if it is finished, control is passed to the second sort processing section 9. If not completed, it is determined whether or not the sort record has already been acquired from the second work file 4 (step 25). If not already acquired, the sort record is acquired in order from the beginning of the second work file 4 ( Step 26), the acquired sort record and the sort record acquired from the first work file 2 are compared with the common CODE which is a matching key (step 27), and if they are equal, the update processing of the sort record of the second work file 4 is performed. The update target item (item Z) of the first work file 2 is updated with the item (item Z ′) (step 28), and the updated sort record is written back to the first work file 2 (step 29). The sort record acquired from the second work file 4 is deleted (step 30). The common CODE is not equal, and the common CODE of the sort record acquired from the first work file 2
Is lower than the common CODE of the sort records acquired from the second work file 4 (<: small in ascending order, large in descending order), the process returns to step 26 and the second work file 4 Get the next sorted record from. On the contrary, if the common CODE of the sort records acquired from the first work file 2 has a higher sort rank (>: large in the case of ascending order, small in the case of descending order), return to step 23 and return to the first work. Get the next sort record from file 2.

The second sort processing section 9 includes a master output section 5
The first work file 2 is re-sorted with the sequential number added in. FIG. 6 is a flow chart of the operation. First, sort information having a sequential number as a key is created (step 31), the first work file 2 is sorted based on the created sort information (step 32), and the master information is created. Control is passed to the updating unit 10.

The master updating unit 10 performs the matching update processing of the first work file 2 and the master file 1 until there are no records in the master file 1. FIG. 7 is a flow chart showing the details of the operation. First, master records are sequentially acquired from the master file 1 (step 33),
It is judged whether or not the record is finished (step 34), and if it is finished, all the processes for updating the master are finished. If it is not the end, the sort records are sequentially acquired from the first work file 2 sorted in the order of the sequential numbers (step 35), and the update target item (item Z) of the master record is the update target item of the updated sort record. After updating with (item Z) (step 36) and writing the updated master record back to the master file 1 (step 37), the process returns to step 33 to acquire the next master record from the master file 1. The above-described processing is repeated until the master record is exhausted, and when the master record is exhausted, the entire master file update processing is terminated.

[0018]

As described above, according to the master file high-speed update processing method of the present invention, transaction files are processed by sequential access rather than random access, so that the transaction file does not need an index section. Further, only the necessary items are extracted from the update target master file and the update transaction file, and are output to the first and second work files, respectively, and the common C file is output.
After performing the sorting process by ODE, update the records by matching the sorted records sorted in the common CODE order, and re-sorting the updated first work file by the sequential number assigned at the time of record acquisition Since the file is updated, the matching process for each record can be performed sequentially, which has the effect of reducing the processing time.

[Brief description of drawings]

FIG. 1 is a block diagram showing the configuration of an embodiment of the present invention.

FIG. 2 is a flowchart showing an operation of a master output unit of this embodiment.

FIG. 3 is a flowchart showing the operation of a tran output unit of this embodiment.

FIG. 4 is a flowchart showing the operation of the first sort processing unit of the present embodiment.

FIG. 5 is a flowchart showing the operation of the second sort processing unit of the present embodiment.

FIG. 6 is a flowchart showing the operation of the match update unit of this embodiment.

FIG. 7 is a flowchart showing the operation of the master updating unit of this embodiment.

FIG. 8 is an explanatory diagram of record formats of first and second work files according to the present embodiment.

[Explanation of symbols]

 1 Master File 2 First Work File 3 Transaction File 4 Second Work File 5 Master Output Section 6 Tran Output Section 7 First Sort Processing Section 8 Match Update Section 9 Second Sort Processing Section 10 Master Update Section

Claims (1)

[Claims] 1. A master output unit for sequentially adding a sequential number to a record identification item and an update target item of each record in target data from a master file and sequentially outputting to a first work file, and update data from a transaction file. A transaction output unit that sequentially outputs the record identification item and the update processing item in the second work file, and a first output unit that sorts the first work file and the second work file by the record identification item. A sort processing unit, and a matching update unit that performs the matching process of the records of the first work file and the second work file after sorting in the sorting order by the record identification item to update the first work file, After updating, update the first work file to the sequential number A second sort processing unit that re-sorts with the first sort processing unit, and
The master file high-speed update processing method, comprising: a master file update process for updating the master file by matching the work file with the master file.