JPH10232764A - Data marge transfer device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To synthesize sum-up object record data and summed-up result data described in different areas in required order and to transfer them by providing 1st and 2nd address storage parts and a data number storage part and controlling transfer while switching these parts in prescribed order. SOLUTION: The 1st address of transfer source is set to a main transfer source address storage device 2, the 2nd address of transfer source is set to a subordinate transfer source address storage device 3, the address of transfer destination is set to a transfer destination address storage device 4, and the number of data to be transferred from the 1st and 2nd addresses of transfer sources is set to a transfer data number storage device 5a. The number of data to be transferred is set successively from an address '0' onto the transfer data number storage device 5. Then, the number of transfer data set to the transfer data number storage device 5a is alternately transferred from the addresses shown by the main transfer source address storage device 2 and the subordinate transfer source address storage device 3 to the address of transfer destination everytime until the number of transfer data set to the transfer data number storage device 5a is finished.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data transfer apparatus for performing a tally operation for synthesizing record data to be operated and a partial tally operation result and transferring the final result. .

[0002]

2. Description of the Related Art FIG.
Is a conventional information transfer method with an arithmetic function. The conventional example has the following configuration. As a basic part, in an information transfer apparatus that takes out a transfer program consisting of a series of instructions and transfers information between the apparatus A and the apparatus B based on the analyzed instructions, The function commands 42 to 45 for performing a specific arithmetic process are set, and in the information transfer device, while the transfer command 41 subsequent to the function commands 42 to 45 is being executed, for the data handled by the transfer command, Means 31-35, 36a-36f for performing arithmetic processing indicated by the function command;
And means for sending a result obtained by executing the processing commands to .about.45 to the device B. B.

Further, a function start command 43 and a function end command 44 are set as the function commands, and the function end command 44 is a result obtained by executing the operation indicated by the function start command 43. Is instructed to transmit to the device B. Alternatively, when performing an operation on the data being transferred based on the function command, a determination result indicated by the function command 43 or 45 is obtained by the flag 43a or 45b specified by the function command 43 or 45. Until that time, the transfer of data from the information transfer device to the device B is inhibited, or the data transfer to the device B is inhibited after the determination result indicated by the function command 43 or 45 is obtained. Control. Further, when performing an operation on the data being transferred based on the function command, the data value 15a defined in the function command 45 is changed only when the determination condition indicated by the function command 45 is obtained. After transmitting the data value 15a to the device B and transmitting the data value 15a again, when the same determination condition is obtained again, the same data transfer is performed.

Further, when performing an operation on the data being transferred based on the above function command, when the operand 16 of the function command 15 is selected based on the data selection instruction 46b and the data selection instruction 46b. Data 16a on which the operation indicated by the function command is performed only on
Is set, and based on the function command 45, only the data specified by the operand 46 is selected from the data received by the information transfer device, and the function command 45 is set only for the selected data. Only when the instructed operation is performed and the determination result indicated by the function command 45 is obtained, the data value 45a defined in the function command 45 is sent to the device B.

In the prior art, the following operation is performed by the above configuration. Basically, a transfer program consisting of a series of commands is taken out, and based on the analyzed commands, an information transfer device interposed between the devices A and B to transfer information, for example, an input / output channel device ( CHP), a function command for performing a specific arithmetic processing on the data being transferred is set, and a transfer command following the function command 42 is executed in the information transfer apparatus. Means for performing arithmetic processing instructed by the function command on data to be handled and means for sending a result obtained by executing the function command to the device B are provided. While transferring the data, the operation specified by the function command is performed, and the result is transferred to the device B.

Further, in the above function command,
When the conditions for applying the function (judgment function) are set,
For example, "Search function command (SEARCH), etc."
Kip The Start, Start The
n Skip “condition”, when no judgment event is detected based on the above condition of the function command,
The data group is transferred from I / O to CHP, and is not transferred to the MSU. And, when the above determination event is detected,
The subsequent data group is transferred to the MSU. Alternatively, the data group is transferred to the MSU until the judgment event is detected, but after the judgment event is detected, the data group is transferred from I / O to CHP and transferred to the MSU. Don't do it. In the above data transfer, when the determination event is detected, the subsequent data group is transferred to the MSU by a designated data amount. Still further, in the data transfer described above, the data to be subjected to the search function is such that a specific field in one record (for example, 16 bytes) can be designated by mask data. Is transferred to the MSU.

Consider an operation of transferring data from the device A to the device B while performing the partial tabulation process shown in FIG. In the database process, as shown in FIG. 9A, a totaling process is performed to obtain a subtotal by dividing the record into key1 and key2 for each field. That is, the same k
The key combinations, for example, data in which key1 is 0 and key2 is also 0 are partially summed once in the F-1 field, and the sum is totaled as shown in FIG. 9B. In some cases, the user may want to transfer this result. At this time, the area of FIG. 9A in which the record data to be subjected to the tallying processing is arranged and the data area obtained as a result of the tallying processing (FIG. 9B)
May be different on account of processing. In any case, in order to transfer the final processing result as shown in FIG. 9B from the record data to be tabulated and the result data of the partial tabulation process, the result data group is added to the record data group to be processed. Should usually be interrupted. In addition, the contents of the tallying process may be complicated, such as calculation of a total over a plurality of record data, calculation of an average value, calculation of a range of values, and the like. It is necessary to create a complicated function command sequence for the device.

[0008]

The conventional data processing / transferring device is configured as described above, and it is necessary to create a complicated function command sequence for data transfer involving partial counting and calculation. In the case of performing a complicated process, there is a problem that the data transfer device itself has a structure as complicated as a CPU.

SUMMARY OF THE INVENTION The present invention has been made in order to solve the above-mentioned problems, and a data merge transfer apparatus for combining and transferring the record data to be tabulated and the tabulated result data arranged in different areas in a necessary order. The purpose is to gain.

[0010]

A data merge transfer apparatus according to the present invention includes a first address storage unit for storing an address corresponding to main data to be transferred to a transfer destination, and a sub-data storage unit for storing sub data to be transferred to the transfer destination. A second address storage unit that stores addresses, a destination address storage unit that stores a destination address, and data described in the first address storage unit or data described in the second address storage unit. A data number storage unit for storing the number of data to be transferred to the area described in the transfer destination address;
A control unit that controls the transfer of the data of the area set in the address storage unit and the data of the area set in the second address storage unit to the area described in the transfer destination address by the number set in the data number storage unit. Equipped.

Further, in place of the data number storage unit, the control unit is provided with a break flag detection mechanism for detecting a break flag indicating that there is a difference between data before and after the data, and a first address storage unit. Alternatively, if this break flag is detected during the transfer of the data in the area set in the second address storage unit, the second address storage unit or the first address is detected.
Is switched to data transfer in the area set in the address storage unit.

Further, the break flag detecting mechanism detects a transfer amount described in the break flag area, and switches to a transfer corresponding to the detected transfer amount of the data in the area set in the other address storage unit. I did it.

[0013]

BEST MODE FOR CARRYING OUT THE INVENTION

Embodiment 1 FIG. Hereinafter, an embodiment of a data merge transfer device according to the present invention will be described with reference to the drawings. In FIG. 1, reference numeral 1 denotes a data transfer device according to the present invention. 2 is a main transfer source address storage device for holding a main transfer source address,
Reference numeral 3 denotes a secondary transfer source address storage device that holds a secondary transfer source address, 4 denotes a transfer destination address storage device that holds a transfer destination address, 5a denotes a transfer data number storage device, and 5b denotes a transfer data number to the transfer data number storage device. An address pointer for performing writing / reading of data, 6 is a data number counter for holding the number of transfer data taken out from the transfer data number storage device, 7 is a control unit for controlling the data transfer device, and 8 is data to be transferred. A transfer data register temporarily held, 9 is a parameter setting bus for setting values required for a main / sub transfer source address storage device, a transfer destination address storage device, and a transfer data number storage device, and 10 is a main or sub transfer. A source address path for sending an address value resulting from selecting the value of the source address storage device to the source, 1
1 is a data read path for transferring data read from the transfer source to the transfer data register, 12 is a transfer destination address path for sending an address value to the transfer destination, and 13 is a transfer path from the transfer data register to the transfer destination. This is a data write path for writing data.

The operation of the apparatus shown in FIG. 1 will be described.
In the data transfer device 1 according to the present invention, the first address of the transfer source is set in advance in the main transfer source address storage device 2 via the parameter setting path, and the second address of the transfer source is set in the sub transfer source address storage device 3. Is set in the transfer destination address storage device 4, and the number of data to be transferred from the first and second addresses of the transfer source is set in the transfer data number storage device 5a. Data transfer device 1
When the operation is started, the value of the address pointer 5b of the transfer data number storage device 5a is set to 0, and when one transfer data number is written in the transfer data number storage device 5a, the value of the address pointer is incremented by the +1 circuit,
When the setting of the transfer data number in the transfer data number storage device 5a is completed, the value becomes 0 again. As a result, the number of transfer data is sequentially set on the transfer data number storage device 5a from address 0.

When data transfer is started, the data transfer device 1 first takes out one transfer data number from the transfer data number storage device 5a, sets it in the data number counter 6, and increments the value of the address pointer 5b by a +1 circuit. Next, the data transfer device 1 sends the value of the main transfer source address storage device 2 to the transfer source address path 10, transfers one piece of data from the transfer source to the transfer data register 8, and stores the data in the main transfer source address storage device 2. The value is incremented by a +1 circuit, and the value of the data number counter 6 is decremented by a -1 circuit. If the value of the data number counter 6 is not 0, the value of the main transfer source address storage device 2 is further sent to the transfer source address path 10, and one piece of data is transferred from the transfer source to the transfer data register 8, and at the same time, the transfer destination The value of the address storage device 4 is sent out to the transfer destination address path 12, and at that time, the transfer data register 8
The upper data is written to the transfer destination, and at the same time, the value of the main transfer source address storage device 2 is incremented by +1 circuit, and the value of the data number counter 6 is decremented by -1 circuit.

When the value of the data number counter 6 is 0, the value of the destination address storage device 4 is stored in the destination address path 1
2, the data in the transfer data storage device is written to the transfer destination, and at the same time, the next transfer data number is taken out from the transfer data number storage device and set in the data transfer number counter 5b, and the value of the address pointer is incremented. Next, data transfer from the sub-transfer source address is performed in the same procedure as transfer from the main transfer source address, and when the value of the data number counter becomes 0, data transfer from the main transfer source address is performed again. Such an operation is repeated until the transfer data number set in the transfer data number storage device 5a is completed, and the transfer from the address indicated by the main transfer source address storage device 2 and the address indicated by the sub transfer source address storage device 3 is performed. The transfer data number set in the data number storage device 5a is alternately transferred to the transfer destination address.

The transfer operation of the device having the above configuration will be described using a specific example. FIG. 2 shows, as an example, data from districts, store names, product names, and sales
It is a figure explaining operation | movement which obtains the result which calculated | required the sales for every product of a store, the sales for every store, and the sales for every area as a subtotal. As described above, the area (table) in which the main transfer source has the data to be processed and the area (table) in which the sub-transfer source has the calculation result data are different from each other for convenience of processing (table). It is in. In such a case, in order to finally obtain the target processing result as shown in FIG. 2C from the record data to be tabulated and the result data of the tabulation process, the record data to be processed and the result data And need to be rearranged. In this specific example, the data transfer device 1 first sets the number of data to be transferred from the main transfer source to two. After the transfer of the two data in the main transfer source address area is completed, the number of data to be transferred from the sub transfer source is set to two. When the transfer of two data from the sub-transfer source address area is completed, the number of data to be transferred from the main transfer source is set to 1 and the data is transferred from the main transfer source address area. Thereafter, by repeating the same operation, FIG.
Is obtained.

Embodiment 2 FIG. A description will be given of a data sort transfer apparatus that achieves the same purpose with another configuration. FIG. 3 is a diagram showing a configuration of the device according to the present embodiment. In FIG. 3, components denoted by the same reference numerals as those in FIG. 1 have the same functions as those described in FIG.
Is a path for sending the value of the break flag, which is a part of the transfer data held in the transfer data register, to the control unit.
0a is a break flag which is a part of the transfer data held in the transfer data register. In this device, the transfer data register performs the equivalent of the data number storage unit, and a break flag that changes when the code of the specific area (key area) of the data before and after as the system changes is provided. It was configured to memorize.
Therefore, while the break flag does not indicate a change, the control unit performs data transfer from the same transfer source address area. Switch to transfer.

The operation of the apparatus having the configuration shown in FIG. 3 will be described.
In the data transfer device 1 according to the present invention, the first address of the transfer source is set in the main transfer source address storage device 2 via the parameter setting path in advance, and the second address of the transfer source is set in the sub transfer source address storage device 3. Is set in the transfer destination address storage device 4. When the data transfer device 1 starts data transfer, it sends out the value of the main transfer source address storage device 2 to the transfer source address path 10, transfers one piece of data from the transfer source to the transfer data register 8, and sets the main transfer source The value of the address storage device 2 is incremented by a +1 circuit. When the value of the break flag section 20a of the data stored in the transfer data register is 0 and the break is not a break, the value of the main transfer source address storage device 2 is further sent to the transfer source address path 10 to transfer one value from the transfer source. At the same time as transferring the data to the transfer data register 8, the value of the transfer destination address storage device 4 is sent out to the transfer destination address path 12, and the data in the transfer data register 8 at that time is written to the transfer destination, and at the same time, the main transfer source address is The value of the storage device 2 is incremented by a +1 circuit. If the value of the break flag section 20a is 1 and a break occurs, the value of the sub-source address storage device 3 is sent to the source address path 10 to transfer one piece of data from the source to the transfer data register 8. At the same time, after writing the value in the transfer data register 8 to the transfer destination, the data transfer from the transfer source address is restarted.

A data sorting apparatus which achieves the same object with another configuration will be described. FIG. 4 shows the configuration of the apparatus.
In the figure, a new element 20b is break data which is a part of the transfer data held in the transfer data register. Other elements are the same as those in FIG. 1 or FIG. In this configuration, the break data is written with a value when a change occurs in data in a specific area, that is, a key field, and the value indicates the number of data to be transferred that requires subsequent data transfer.

The operation of the apparatus having the configuration shown in FIG. 4 will be described. The setting of the first address in the main transfer source address storage device 2, the setting of the second address in the sub transfer source address storage device 3, and the setting of the transfer destination address in the transfer destination address storage device 4 are as follows. This is the same as the previous embodiment. When starting the data transfer, the data transfer device 1 sends the value of the main transfer source address storage device 2 to the transfer source address path 10 to transfer one data from the transfer source to the transfer data register 8, The value of the address storage device 2 is incremented by a +1 circuit. Transfer data register 8
If the value of the break data portion 20b of the data stored in the memory does not indicate a break, the value of the main transfer source address storage device 2 is further transmitted to the transfer source address path 10 and one data is transferred from the transfer source to the transfer data. Simultaneously with the transfer to the register 8, the value of the transfer destination address storage device 4 is sent out to the transfer destination address path 12, and the data in the transfer data register 8 at that time is written to the transfer destination. Is incremented by a +1 circuit.

When the value of the break data section 20b is a break, the control section 7
Is set in the data transfer number counter 6 according to the value of. Next, the value of the secondary transfer source address storage device 3 is sent to the transfer source address path 10 and one data is transferred from the transfer source to the transfer data register 8, and at the same time, the value of the transfer destination address storage device 4 is transferred to the transfer destination address path 10. 12
At that time, the data in the transfer data register 8 is written to the transfer destination, the value of the transfer destination address storage device is incremented, and the value of the transfer data number counter 6 is decremented. When the value of the transfer data number counter 6 is not 0, the data from the sub-transfer source address is further transferred. When the value of the transfer data number counter 6 becomes 0, the transfer source is switched to the main transfer source address and the transfer from the main transfer source is performed. Resume data transfer.

As described above, the aggregation result, that is, the final result data can be easily transferred while switching between the main transfer source and the sub transfer source and performing a predetermined merge with the transfer destination by the break flag or the break data.

Embodiment 3 FIG. Main transfer source address storage unit,
The sub-transfer source address storage unit and the data number storage unit may be collectively used as a transfer information storage unit. FIG. 5 is a diagram showing a configuration of the data sort transfer device according to the present embodiment.
In the figure, components denoted by the same reference numerals as those in FIG. 1 and the like have functions equivalent to those described in FIG. 1 and the like. As a new element, 21a is a transfer information storage device for storing transfer information in which a transfer source address and the number of data to be transferred are paired, and 21b is an address for writing / reading transfer information to / from the transfer information storage device. A pointer 22 is a transfer source address storage device that holds a transfer source address.

The operation of the apparatus having the configuration shown in FIG. 5 will be described. In the data transfer device 1 according to this embodiment, a transfer destination address is set in the transfer destination address storage device 4 in advance via a parameter setting path, and the transfer information storage device 21 is set.
In a, transfer information in which a transfer source address and the number of transfer data at the time of data transfer from the transfer source are set is set. When the data transfer device 1 starts operation, the transfer information storage device 21a
The value of the address pointer 21b is set to 0, and when one piece of transfer information is written to the transfer information storage device 21a, the value of the address pointer is incremented by the +1 circuit, and when the setting of the transfer information to the transfer information storage device 21a is completed. It becomes 0 again. As a result, the transfer information is sequentially set on the transfer information storage device 21a from address 0.

When the data transfer apparatus 1 starts data transfer, it first takes out one piece of transfer information from the transfer information storage device 21a, stores the address portion of the transfer information in the transfer source address storage device 22, and stores it in the data number counter 6. The transfer data number part of the transfer information is stored. Next, the value of the transfer source address is transmitted to the transfer source address path 10, and 1
This data is read into the transfer data register 8, and at the same time, the value of the transfer source address is incremented and the value of the data number counter is decremented. If the value of the data number counter is other than 0, the next data is further transferred from the transfer source to the transfer data register 8, and the value of the transfer destination address storage device 22 is sent out to the transfer destination address path 10 to transfer the transfer data register 8 The above data is written to the transfer destination, and the value of the transfer destination address is incremented. When the value of the data number counter is 0, the transfer information storage device 2
The next transfer information is read from 1a, set in the transfer source address storage device 22 and the data number counter 6, the address pointer of the transfer information storage device 21a is incremented, and the data transfer from the transfer source is restarted. With the above-described configuration and operation, the data of FIGS.
Can be transferred.

If these addresses can be obtained in order according to the transfer order without separately providing the main transfer source address storage unit and the sub transfer source address storage unit, these are integrated into one transfer source address storage unit. It may be a unit. FIG.
Is a configuration diagram of the device in this case. In the figure, components denoted by the same reference numerals as those in FIG. 1 and the like are the same as those in FIG. 1 and the like.

The operation of the present invention will be described with respect to the components of the configuration shown in FIG. In the data transfer device having this configuration, a transfer destination address is set in the transfer destination address storage device 4 via a parameter setting path in advance. When data transfer is started, the data transfer device 1 sets a predetermined unit transfer amount value in the data number counter 6 and transfers the value set in the transfer source address storage device 22 via the parameter setting path. The data is sent out to the original address path 10 to read data from the transfer source and write it to the transfer data register 8, and at the same time, the value of the transfer source address storage device 22 is incremented. When the value of the data number counter is not 0, the data is further transferred from the transfer source to the transfer data register 8, and at the same time,
Transfers the value of the destination address storage device 4 to the destination address path 1
2, the data in the transfer data register 8 is decremented by the write data number counter 6 to the transfer destination. If the value of the data number counter is 0, the value of the unit transfer amount is reset in the data number counter 6 and the source address storage device 22 is set via the parameter setting path.
The next data transfer is performed according to the value set in.

Embodiment 4 An embodiment of a database processing device using the data sort transfer device of the present invention will be described with reference to the drawings. FIG. 7 is a diagram showing a configuration of the database processing device according to the present embodiment. In the figure, 1
Is a data transfer device, 9 is a parameter setting bus for the data transfer device, 10 is a transfer source address route from the data transfer device, 11 is a data read route from the data storage device, and 12 is a transfer destination address route 1 from the data storage device.
3 is a data path from the data transfer device, 14 is an arithmetic processing device for performing a tallying process on the processing target data, 16 is a data storage device for storing the processing target data and the tallying result data, and 17 is a data storage device. The expanded processing target data 18 is the aggregation result data stored in the data storage device. Although the inside of the data transfer device is omitted in the figure, the inside of the data transfer device is the same as in FIG.

The operation of the apparatus having the configuration shown in FIG. 7 will be described. The arithmetic processing device 14 sets the area address of the processing target data 17 on the data storage device 16 in the main transfer source address storage device 2 of the data transfer device 1, and sets the area address of the tally processing result data 18 to the secondary address of the data transfer device. The address is set in the transfer source address storage device 3 and the address of the area for storing the final result at the transfer destination is set in the transfer destination address storage device 4 of the data transfer device. The arithmetic processing unit 14 then reads the data to be processed from the data storage device 16 and stores the result of the tallying operation in the storage area 18 for the tallying result data. At this time, the number of processed data items until the tally result is obtained is simultaneously stored in the transfer data number storage device 5a of the data transfer device 1, and the obtained number of tally result data is stored in the transfer data number storage device of the data transfer device 1. Store. The arithmetic processing unit 14 performs the tallying result until the processing target data is exhausted to obtain the tallying result, and sets the number of the processing target data and the tallying result data in the transfer data number storage device 5a of the data transfer device 1, and performs the processing. When the target data is exhausted, the data transfer by the data transfer device 1 is started. When the data transfer device performs the above-described operation, it is possible to obtain a total result at the transfer destination.

[0031]

As described above, according to the present invention, the first address storage section, the second address storage section, and the number-of-data storage section are provided, and the transfer is controlled by switching in a predetermined order. There is an effect that a large-scale device which takes time, such as performing a transfer while creating a complicated command sequence and performing these processes, becomes unnecessary.

[Brief description of the drawings]

FIG. 1 is a configuration diagram of a data sort transfer device according to a first embodiment of the present invention.

FIG. 2 is a diagram for explaining the operation of the data sort transfer device of the present invention.

FIG. 3 is a configuration diagram of a data sort transfer device according to a second embodiment of the present invention.

FIG. 4 is a configuration diagram of another data sort transfer device according to the second embodiment.

FIG. 5 is a configuration diagram of a data sort transfer device according to a third embodiment of the present invention.

FIG. 6 is a configuration diagram of another data sorting apparatus according to the third embodiment.

FIG. 7 is a diagram showing a configuration of a database processing device using the data sort transfer device of the present invention.

FIG. 8 is a configuration diagram of a conventional data transfer device.

FIG. 9 is a diagram for explaining a data sort transfer operation.

[Explanation of symbols]

1 data transfer device, 2 main transfer source address storage device,
3 sub transfer source address storage device, 4 transfer destination address storage device, 5a transfer data number storage device, 5b transfer data number storage device address pointer, 6 data number counter, 7 control unit, 8 transfer data register, 9 parameter setting path, Reference Signs List 10 transfer source address path, 11 data read path, 12 transfer destination address path, 13 data write path, 14 arithmetic processing unit, 16 data storage unit, 17 processing target data, 18 total processing result data, 19 break flag to control unit (Break data) transfer path, 20a break flag section, 20b break data section, 21a transfer information storage device, 21b transfer information storage device address pointer, 22 transfer source address storage device.

Claims (3)

[Claims] A first address storage unit for storing an address corresponding to main data to be transferred to a transfer destination; a second address storage unit storing an address corresponding to sub data to be transferred to the transfer destination; A transfer destination address storage unit for storing the transfer destination address, and data for transferring data described in the first address storage unit or data described in the second address storage unit to an area described in the transfer destination address A data number storage unit for storing the number, based on a predetermined order and number, the data of the area set in the first address storage unit and the data of the area set in the second address storage unit are stored in the data number A data merge transfer device comprising a control unit for controlling transfer to an area described in the transfer destination address by a number set in a storage unit. 2. A control system according to claim 1, wherein the control unit includes a break flag detecting mechanism for detecting a break flag indicating that there is a difference between data before and after the data.
If the break flag is detected during the transfer of data in the area set in the first address storage unit or the second address storage unit, the break flag is detected in the area set in the second address storage unit or the first address storage unit. 2. The data merge transfer apparatus according to claim 1, wherein the apparatus is switched to data transfer. 3. A break flag detecting mechanism detects a transfer amount described in a break flag area and switches to a transfer corresponding to the detected transfer amount of data in an area set in the other address storage unit. 3. The data merge transfer device according to claim 2, wherein: