JP3004940B2 - Data transfer method and device - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data transfer device used in a database processing system, and more particularly to a data transfer device for transferring sort data of a sort device to a memory or a file.

[0002]

2. Description of the Related Art FIG. 12 shows an overall configuration of a data processing system provided with a sorting device.

The database processing system 20 is a system for rearranging a plurality of data recorded on a disk device 25 for each item key included in each data and writing the data back to a main storage device or a CPU.

Specifically, in the database processing system 20, when performing the above operation, first, data is read from the disk device 25 via the disk control device 24, and is temporarily written to the sort device 26. In the sorting device 26, each data is rearranged according to a specified rearrangement method for each item, and sorted data is generated. The sort data is transferred to the main storage device 23 as the transfer destination in accordance with the transfer destination area size specified in advance.
And to the address specified by the CPU 21 sequentially.

At the transfer destination, the sort data is stored as individual transfer data records, and a totaling process is performed based on the data recorded here. The aggregation process is
Aggregation calculations such as roll-up and cube are performed for each data item, and a total value for each item, a total value based on all data, and the like are calculated. Each summary value is inserted as a summary record at the delimiter position of each item of the data column, etc.
Post-aggregation data is generated.

FIG. 13 shows an example of a case where the sorting device performs an operation of obtaining sales by product at each branch. In this case, the tallying process was performed by a roll-up process. Product sales by product at each branch is disk unit 2
5 are input in a random order (a). In the input data, the branch name is written in the first key field 28, and the product name is written in the second key field 29. The first key field 28 and the second key field 2
The branch name and the product name recorded in 9 are the reference items in the sorting process. The total number field 30 indicates the number of sales, and the field 31 indicates the type of data, that is, the number of sales.
Whether the data is sales data or total data is written.

The data input to the disk device 25 is sorted by the sorting device 26 using the above-mentioned branch name and product name as reference items. here,
Sorting is performed with the branch name as the first item and then the product name as the second item. As a result, the sort data in FIG. 13B is generated. This sort data is transmitted by the data transfer device to the main storage device 23 or the CPU 21, where it is stored as a transfer data record, and a tallying process is performed.

In the tabulation process, tabulated values such as the number of sales for each product in each branch, the number of sales of all products in each branch, and the total number of sales in all branches are calculated. The calculated tally value is inserted and recorded as a tally record at the end of each item of the transfer data record, and the tally data is generated (c). Specifically, the total record 32 shown in FIG. 13C records the total value of the total number of TV units sold at the Fujisawa branch.
Further, in the total record 33, a total value of the number of sales of all products in the Fujisawa branch is recorded. In addition, aggregation record 3
In 4, the total value of the sales amount of all products at the Fujisawa branch and the Kamakura branch is recorded.

When the tabulation process is performed at the transfer destination as described above, a tabulated record in which the tabulated value is written is inserted, so that the number of records is increased by the number of tabulated records from the number of records of the transferred data. Will be.

[0010]

However, when the data transfer device transfers the sort data, it is not possible to know in advance the number of records that will increase after aggregation. For this reason, the transfer data may be transferred to the full storage capacity of the transfer destination main storage device or CPU. If the tallying process is performed in such a state, the capacity for recording the tally record is insufficient, and writing cannot be performed.

On the other hand, in order to avoid the above-mentioned problem, when transferring the sorted data to the transfer destination by the data transfer device, it is necessary to secure the maximum number of records required as the total number of records for each data record. Is also conceivable. Specifically, in the case of the above-described conventional technology, the number of records required as a totaling record at one item delimiter position is a maximum of two records, and this maximum number of records is uniformly secured at the time of each sort data transfer. It is also possible to do. In this way, by securing the area for writing the total record in advance, the total record can be reliably recorded.

However, when the maximum number of records as a total record is secured at the transfer destination at the time of each sort data transfer,
The storage area at the transfer destination cannot be used effectively. That is, the tally record is not recorded in all of these secured areas, and many are left as useless empty areas.

When the number of records secured for each sort data is reduced to reduce the useless free space as described above, for example, when the above-described two records are reduced to one record, There may be a shortage of space inside. If the area becomes insufficient during the aggregation, a large overhead such as temporarily saving the data and re-allocating the area occurs.

SUMMARY OF THE INVENTION The present invention has been made in consideration of the above problems, and has as its object to provide a data transfer method and a data transfer apparatus capable of appropriately securing a free space for writing data such as a tallying process at a transfer destination. It is to provide.

[0015]

In order to achieve the above object, a data transfer method according to the present invention comprises: a transfer step of sequentially transferring the sort data to a memory or a file; It is characterized by including a break position detecting step of detecting a separate break position, and a free area designating step of designating a predetermined free area in a memory or a file when the item-specific break position is detected.

According to the present invention, when a totaling process or the like is performed at the transfer destination based on the sort data, an area for recording a total value or the like is secured for each item.

The data transfer device of the present invention is used in a database processing system and is a data transfer device for transferring the sort data of the sort device to a memory or a file, and a transfer means for sequentially transferring the sort data to a memory or a file. And a break position detecting means for detecting a break position for each item in the transferred data string, and a free area designating means for specifying a predetermined free area in a memory or a file when the break position for each item is detected. It is characterized by the following.

According to the invention, the transfer means sequentially transfers the sort data to the memory or the file, and at the time of this transfer, the break position detecting means detects the break position for each item in the transferred data string. When the break position detecting means detects the break position, the free area specifying means specifies a predetermined free area in a memory or a file.

In the above data transfer device, the delimiter position detecting means may recognize the flag attached to the sort data by the sorter and detect the delimiter position of each item of the data string.

According to the above arrangement, the transfer means sequentially transfers the sort data to the memory or the file, and at the time of this transfer, the delimiter position detecting means recognizes the flag attached to the sort data to be transferred, and Detects column breaks by column. When the break position detecting means detects the break position, the free area specifying means specifies a predetermined free area in a memory or a file.

In the above data transfer apparatus, the free area designating means can be configured to designate a predetermined number of free areas in the memory or the file based on the type of the flag detected by the delimiter position detecting means. .

According to the above configuration, by setting the number of records of the free area specified by the type of the flag in advance, a free area of an appropriate number of records is secured in the memory or the file.

The data transfer device of the present invention may further comprise a monitor means for monitoring the presence or absence of a remaining area for transferring sort data or designating a free area in a memory or a file; Transfer control means for controlling the transfer of the sort data when it is detected that there is no or insufficient area.

According to the present invention, the monitor means monitors the presence or absence of a remaining area for transferring sort data or designating a free area in a memory or a file, and the monitor means has no or insufficient remaining area. When it is detected that the sorting is performed, the transfer control means stops the transfer of the sort data.

In the above invention, the transfer means transfers the data string for each item so as to be continuous from a start area in a memory or a file, and the free area designating means transfers each data string to the memory or the file. When a predetermined free area is designated at the end of the data string for each item, the monitor means stores the end area position of the memory or the file, and stores the end area position and the transfer area position of each sort data. Alternatively, the presence or absence of a remaining area in a memory or a file can be monitored by comparing with a designated free area position.

The monitor means may monitor the remaining area based on the total number of records in the recording area of the transferred sort data and the total number of records in the designated free area and the total number of areas in the memory or file. it can.

The data transfer apparatus according to the present invention may further comprise a totaling means for calculating a total value for each item of the data string to be transferred, and a free area designated in a memory or a file by said free area specifying means. A total value transfer unit that transfers the total value.

According to the above arrangement, the tallying means calculates the tally value for each item of the data string to be transferred, and the tally value transfer means stores the tally value in the free space designated in the memory or file by the free space designation means. Transfer the summary value.

[0029]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Preferred embodiments of the present invention will be described below with reference to the drawings.

[First Embodiment] FIG. 1 shows a data transfer apparatus 40 according to a first embodiment.

The data transfer device 40 is a transfer means 401 for transferring the sort data from the sort device via the sort device.
, An input buffer 402 and an output buffer 404 are provided. The output buffer 404 transfers the sort data to the transfer destination according to an instruction of the control circuit 422 described later.

The input buffer 402 and the output buffer 4
A break flag detection circuit 406 for detecting a break flag for each sort data in the sorting apparatus is provided between the apparatus and the apparatus. The sort device creates the sort data and adds an appropriate break flag at the item-separated position of the data string. Therefore, the break flag detecting circuit 406 functions as a break position detecting means for detecting a break position for each item of the data string via the break flag.

The break flag detection circuit 406 includes:
A record configuration information register 408 is connected, and field configuration information such as the position of the break flag in the sort data and the record length of the transfer destination is set in the record configuration information register 408. The record configuration information register 408 supplies the set information to the break flag detection circuit 406 and a multiplication circuit described later.
That is, the break flag detection by the above-described break flag detection circuit 406 is performed by the record configuration information register 40.
8 is performed based on the information supplied.

The record number calculation circuit 410 connected to the break flag detection circuit 406 receives the break flag detected by the break flag detection circuit 406,
Based on the type of the break flag, the number of records for the free area designated as the transfer destination is calculated.

The multiplication circuit 412 connected to the record number calculation circuit 410 and the record configuration information register 408
The size of an area required as an empty area is calculated based on the number of records from the record number calculation circuit 410 and the record length set in the record configuration information register.

An adding circuit 414 connected to the multiplying circuit 412 adds the size of the area required to record the sort data to the size of the area required as a free area calculated by the multiplying circuit.

The transfer address register 416 connected to the addition circuit 414 stores the transfer start address in the transfer destination area, and assigns the sort data to be transferred and the address of the free area from the stored transfer start address. The address output buffer 424 temporarily stores the transfer address assigned here, and stores it in the control circuit 42 described later.
Output to the transfer destination according to the instruction of 2.

That is, these record number calculation circuits 410,
The multiplication circuit 412, the addition circuit 414, the transfer address register 416, and the address output buffer 424 cooperate to function as the empty area specifying means 405.

On the other hand, the transfer address register 416
Are connected to the comparison circuit 418. This comparison circuit 4
Reference numeral 18 functions as monitoring means for monitoring the presence or absence of a remaining area at the transfer destination. Specifically, the end address register 4
20, the end address of the transfer destination area set in
Monitoring is performed by comparing the transfer address assigned in the transfer address register 416 with the next address.

The control circuit 422 connected to the comparison circuit 418 controls the entire data transfer device based on the comparison result of the comparison circuit 418. That is, the control circuit 422
In the comparison circuit 418, when the final address and the comparison address match, the data transfer is stopped, and when they do not match, the data transfer is executed.

The operation of the data transfer apparatus 40 configured as described above when transferring the sort data shown in FIG. 2 will be described below. Here, the number of products sold at a plurality of branches is counted.

The sort data 440 shown in FIG. 2 is data sorted based on the branch name recorded in the first key field 441 and the product name recorded in the second key field 442. The total number of sales is recorded in the total field 443, and a total operation is performed later based on this numerical value. The flag column 444 describes the numerical value of the break flag. This break flag is added with “1” when the branch name of the first key field 441 is different from the lower data of the data string, or when the product name of the second key field 442 is different. Is appended with "2". If the branch names in the first key field 441 and the second key field 442 match, “0” is added. Specifically, since the product name of the second key field 442 is different between the data 445 and the data 446, “2” is added, and the branch name of the first key field 441 is the same between the data 447 and the data 448. Since they are different, “1” is added.

The sort data 41 with the appropriate break flag is input to the data transfer device 40 for transfer to a file or memory such as a main storage device or a CPU. Each sort data is input to the output buffer 404 via the input buffer 402, and is in a standby state for transfer to the transfer destination. During this time, the address of the transfer destination is specified by the following operation.

That is, the break flag detection circuit 406
When the sort data is transmitted from the input buffer 402 to the output buffer 404, the record configuration information register 40
The break flag attached to the sort data is detected based on the information of No. 8. Here, information on the detected break flag is sent to the record number calculation circuit 410. The record number calculation circuit 410 calculates the number of records for a free area designated as a transfer destination based on the type of the break flag. Specifically, when the break flag is "1", the number of records for the free area is two records, and when the break flag is "2", the number of records for the free area is one record. Become. If the break flag is "0", the number of records in the free area is determined to be 0, that is, unnecessary. This numerical value is sent to the multiplication circuit 412, where the record configuration information register 408
Is multiplied by the record length set in, and the size of the area required as a free area is calculated.

The adding circuit 414 calculates the size of the free area calculated here and the total area for recording the sort data. In the transfer address register 416, addresses to transfer the total area obtained here are sequentially specified from the start address to the end address, and the transfer address is sent to the address output buffer 424.

On the other hand, after transmitting the transfer address to the address output buffer 424, the transfer address register 416 sends the next specified address to the comparison circuit 418. The comparison circuit 418 compares the sent address with the end address set in the end address register 420, and if the address exceeds the end address, the control circuit 42
2, the transfer of the sort data is stopped,
If not, transfer is executed. as a result,
An address is designated from the address output buffer 424, and the sort data sent from the output buffer 404 is recorded at the designated address. As a result, FIG.
As described above, the post-transfer data 451 is generated.

In the post-transfer data 451, when a break flag of "2" is added to the flag column 444 as in the record 452, a free area 453 for one record is formed at the next address, and the record 454 is recorded. In the case where the break flag of "1" is added to the flag column 444 as shown in FIG.
454 are formed. Also, like record 457,
When a break flag of “0” is attached to the flag column 444, no free area is formed.

As described above, by reading the break flag attached to the sort data and designating an empty area,
An area for writing a tally value when tally processing is performed at the transfer destination is secured. Therefore, it is possible to prevent the shortage of the area after the aggregation processing as in the related art. In addition, by setting an empty area having an appropriate number of records, the area of the transfer destination can be effectively used.

In the present embodiment, the number of key fields is two, but the number of key fields can be arbitrarily increased. In this case, the number of types of break flags can be increased, and an empty area having an appropriate number of records can be set.

[Second Embodiment] FIG. 4 shows a data transfer device according to a second embodiment. Hereinafter, the same components as those described above are denoted by the same reference numerals, and description thereof will be omitted.

The data transfer device 5 according to the second embodiment
0 is different from the data transfer device 40 of the first embodiment in that a break detection circuit 502 is provided instead of the break flag detection circuit 406, and other configurations are the same. Unlike the break flag detection circuit, the break detection circuit 502 has a function of detecting a break via a break flag, that is, detecting a break directly, instead of detecting a break position for each item of a data string. Specifically, in the case of the sort data as shown in FIG. 2, when the data is transferred, the key field information of the data transferred immediately before is stored, and the key field information of this information and the key field information of the data to be transferred are stored. Detect differences. Also in this case, when the information of the first key field 441 is different in advance,
The signal to be transmitted to the next record number calculation circuit 410 can be different depending on whether the information in the second key field 442 is different. Then, the record number calculation circuit 410 receiving the different signal can be set to calculate the number of records according to the signal. In addition,
The operation after the number of records is calculated in the record number calculation circuit is the same as that of the data transfer device 40 of the first embodiment.
As a result, the post-transfer data 451 shown in FIG. 3 is formed at the transfer destination in the same manner as described above.

As described above, in the present embodiment, since the break detection circuit 502 detects a break in a data string, even if the sorting device does not have a function of adding a break flag, the break detection circuit 502 counts the transfer destination. Free space can be formed.

[Third Embodiment] FIG. 5 shows a data transfer device 60 according to a second embodiment.

The data transfer device 6 according to the third embodiment
0 is different from the data transfer devices 40 and 50 in that it does not include a record number calculation circuit, and the other configuration is the same. FIG. 5 shows the break flag detection circuit 406 of the first embodiment for detecting the break position of each item in the data string. The break detection circuit 502 can also be used.

With the above configuration, the break in the data string is detected directly by the break detection circuit 502 or by the break flag detection circuit 406 via the break flag. In the case of the sort data 440 as shown in FIG. 2, the break flag attached to the flag column is read. Specifically, this break flag is "1", "2"
In this case, a break is detected. If it is "0", it is confirmed that the position is not the break position.

The presence / absence of a break confirmed here is determined, for example, as a detection signal "1" and a non-detection signal "0".
12 is sent. The multiplication circuit 412 multiplies the received signal by the record length set in the record configuration information register, and when a break is detected, obtains a uniform empty area size. Then, the adding circuit 414 adds the size of the area for recording the sort data to be transferred to the size of the free area obtained here, and transfers the added value to the transfer address register 416. In the transfer address register 416, a free area and the address of the sort data to be transferred are assigned in the same manner as described above, and the destination is designated via the address output buffer 424.

In this case, for example, the sort data 440 shown in FIG.
00 is formed. In this embodiment, since the maximum number of record areas for totaling is two records, in the post-transfer data 600, an empty area for two records is uniformly set in the area next to the break position. Specifically, “2” is added to the flag column 602 as in the data area 604.
, Or when “1” is added to the flag column 602 as in the data area 606, free areas 608 and 610 for two records are formed in the next area.

The number of records necessary for this free space is determined according to the number of key fields of the sort data and the like.
By setting the information in the record configuration information register 408 in advance, a desired number can be formed.

As described above, according to the present embodiment, some extra free space is formed at the transfer destination, but the structure as a data transfer device can be simplified and the processing speed can be improved. It is possible to do.

[Fourth Embodiment] FIG. 7 shows a data transfer apparatus 70 according to a fourth embodiment.

The data transfer device 7 of the fourth embodiment
0 is different from the above-described data transfer apparatus in the method of specifying a free area. In the data transfer device described above, an empty area is actually specified and secured as a transfer destination. In the case of the present embodiment, when a break is detected, a necessary empty area is calculated and the empty area is calculated. Is virtually specified.

Specifically, it has the following configuration.

The transfer record number calculation circuit 410 is connected to the break flag detection circuit 406 in the same manner as described above. The transfer record number calculation circuit 410 calculates the number of records for a free area according to the break flag detected by the break flag detection circuit 406. Then, the total number of records is calculated by adding the number of records for recording the sort data to be transferred to this number. Subtraction circuit 702
Receives the counter value of the area remaining record number 704 described later, and
Is subtracted, and the subtracted value is transmitted to the area remaining record number counter 704.

This area remaining record number 704 is set by converting the size of all areas secured at the transfer destination into the number of records. This value is updated by the subtraction circuit 702 every time the sort data is transferred, as described above. Finally, when the number of remaining records becomes 0, the area remaining record counter 704 sends a signal to the control circuit 422 to stop the data transfer device 70.

The data transfer device 70 configured as described above
In the following, a case where the sort data 41 shown in FIG. 2 is transferred will be described below.

Each sort data is sequentially input to the output buffer 404 via the input buffer 402 in the same manner as described above, and during this time, the destination address is specified by the following operation.

The break flag detection circuit 406 detects a break flag attached to the sort data based on the position information of the break flag in the record configuration information register 408, and sends the detected break flag information to the record number calculation circuit 410. The record number calculation circuit 410 calculates the number of records for a free area designated as a transfer destination based on the type of the break flag, and obtains a value obtained by adding the number of records for recording the sort data to be transferred to this value. Specifically, when the break flag is "1", the number of records for the free area is two records, and one record for recording the sort data is added to this. This addition value is transferred to the subtraction circuit 702, and the subtraction circuit 702 subtracts the added value from the counter value of the area remaining record number counter 704. This subtraction value is returned to the area remaining record number counter 704, and the number of records of the area currently remaining at the transfer destination is updated. Then, the control circuit 422 controls the data transfer based on the updated value. That is, if the updated value is not equal to or less than 0, the control circuit 422 executes the transfer of the sort data, and if the updated value is equal to or less than 0, the control circuit 422 stops the transfer of the sort data.

When the transfer of sort data is instructed by the control circuit 422, the sort data in the output buffer 404 is transferred to the address specified by the transfer address register 416. Accordingly, in the post-transfer data 710 illustrated in FIG. 8, unlike the above, an empty area is not actually secured at the break position of each item, and a record for an area that increases after aggregation is virtually secured. Will be.

[Fifth Embodiment] FIG. 9 shows a data transfer device 80 according to a fifth embodiment.

The data transfer device 80 of the present embodiment includes a data conversion circuit 802.
As a result, the transfer destination forms a free area for aggregation, and the key field information to be written into this free area is transferred.

Specifically, similarly to the above, the break flag of the sort data is detected by the break flag detection circuit 406, and this information is transmitted to the record number calculation circuit 410. The record number calculation circuit 410 calculates an appropriate number of records as an empty area according to the type of the received break flag. The number of records obtained here is sent to the data conversion circuit 802, and the transfer is repeated by the number of records. At this time, the data conversion circuit 802 masks the key field information received from the input buffer one by one with the ALL value. On the other hand, the transfer address register 416 increases by one record each time the transfer is repeated via the data conversion circuit 802, and counts the address of the area actually transferred.

In this embodiment, also in the comparison circuit 418, the end address set in the end address register 420 and the transfer address register 416
And the control circuit 422 controls the data transfer according to the result.

FIG. 10 shows post-transfer data after the sort data shown in FIG. 2 has been transferred to the transfer destination by the data transfer device 80. As shown in FIG. 10, in the case of the present data transfer device 80, not only a total free area is formed, but also an item is described in a key field in the total area. That is, in FIG. 10, a totaling area 818 is set at the address next to the end of the data string for each product as in the transfer record 816, and the first and second key fields 812 and 814 are set in this area. Is written. Also, the transfer record 82
Totaling areas 822 and 824 for two records are set at the address next to the end of the data string for each branch, such as 0. Of these, the aggregation area 822 contains
The information of the first and second key fields is written, and the information of the first key field is written in the totaling area 824, and is masked with the ALL value.

Therefore, according to the present embodiment, the transfer destination only needs to calculate the numerical value of the total feed. Therefore, the function of the transfer destination can be simplified.

[Sixth Embodiment] FIG. 11 shows a data transfer device 90 according to a sixth embodiment.

The data transfer device 90 of the present embodiment includes
An aggregation operation circuit 902 is provided, which has a function of performing an aggregation process together with the transfer of the sort data and transferring the aggregation data in which the aggregation result is written. Specifically, the data transfer device 90 is provided with a tally operation circuit 902 instead of the data conversion circuit 802 in the data transfer device 80 described above. Other configurations are the same as those of the data transfer device 80 of the fifth embodiment.

The counting operation circuit 902 has a counting processing function in addition to the function of the data conversion circuit 802, and generates and outputs the counting data in which not only the key field information but also the counting result is written. Send to buffer.

As a result, by transferring the sort data to the transfer destination by the data transfer apparatus 90, the post-aggregation data shown in FIG. 13C is formed at the transfer destination.

Therefore, the data transfer device 90 is effective when the transfer destination does not have a totaling function.

Each of the above-described embodiments can be implemented independently, but can also be implemented by arbitrarily combining the configurations of the above-described embodiments.

Further, in the present embodiment, an example of control by hardware has been described, but the above-described data transfer method can be realized by software. Also, a sorting device applicable to the data transfer device may use either hardware or software.

[0082]

As described above, the data transfer method and apparatus of the present invention preliminarily calculates an area for writing a total result or the like generated at a transfer destination at the time of sort data transfer, and secures an area for that. As a result, it is possible to avoid the problem that the area for writing the tally result after the tally is performed based on the data transferred to the transfer destination becomes insufficient as in the related art.

Further, since the data transfer device of the present invention can accurately calculate the area in which the result of aggregation and the like are to be written,
The area to be secured can be minimized. As a result, the transfer destination area can be effectively utilized without leaving useless space.

Further, by having the data transfer device of the present invention hold the tally processing means, the tally result can be transferred simultaneously with the hand data transfer.

[Brief description of the drawings]

FIG. 1 is a diagram illustrating an overall configuration of a data transfer device according to a first embodiment.

FIG. 2 is a diagram showing sort data before transfer.

FIG. 3 is a diagram illustrating post-transfer data when data is transferred to a transfer destination by the data transfer device according to the first embodiment;

FIG. 4 is a diagram illustrating an overall configuration of a data transfer device according to a second embodiment.

FIG. 5 is a diagram illustrating an overall configuration of a data transfer device according to a third embodiment.

FIG. 6 is a diagram illustrating post-transfer data when data is transferred to a transfer destination by the data transfer device according to the third embodiment.

FIG. 7 is a diagram illustrating an overall configuration of a data transfer device according to a fourth embodiment.

FIG. 8 is a diagram illustrating data after transfer when data is transferred to a transfer destination by the data transfer device according to the fourth embodiment.

FIG. 9 is a diagram illustrating an overall configuration of a data transfer device according to a fifth embodiment.

FIG. 10 is a diagram illustrating post-transfer data when data is transferred to a transfer destination by the data transfer device according to the fifth embodiment.

FIG. 11 is a diagram illustrating an overall configuration of a data transfer device according to a sixth embodiment.

FIG. 12 is a diagram showing an overall configuration of a conventional database processing system.

FIG. 13 is a diagram showing a process in a case where data input by a conventional database processing system is transferred to a transfer destination and tabulation processing is performed.

[Explanation of symbols]

40, 50, 60, 70, 80, 90 Data transfer device, 401 transfer means, 406 break flag detection circuit, 440 sort data, 502 break detection circuit, 405 free area designation means, 418 comparison circuit, 7
04 transfer area remaining counter, 422 control circuit, 902
Aggregation operation circuit.

────────────────────────────────────────────────── ─── Continuation of front page (56) References JP-A-1-232425 (JP, A) JP-A-4-264637 (JP, A) JP-A-4-337867 (JP, A) JP-A-6-320 103144 (JP, A) JP-A-7-281939 (JP, A) JP-A 8-286966 (JP, A) JP-A 8-314819 (JP, A) (58) Fields investigated (Int. Cl. ⁷ , DB name) G06F 12/00 G06F 13/00

Claims (8)

(57) [Claims] 1. A data transfer method for use in a database processing system, wherein a data transfer method for transferring sort data of a sort device to a memory or a file, wherein a transfer step of sequentially transferring the sort data to a memory or a file; The method includes a step of detecting a break position by item for a transferred data string, and a step of specifying a free space in a memory or a file at the time of detecting the break position by item. Characteristic data transfer method. 2. A data transfer device for use in a database processing system, wherein the data transfer device transfers the sort data of the sort device to a memory or a file; a transfer means for sequentially transferring the sort data to a memory or a file; For a transferred data string, a break position detecting means for detecting a break position for each item, and a free area designating means for specifying a predetermined free area in a memory or a file when the break position for each item is detected are included. Characteristic data transfer device. 3. The data according to claim 2, wherein the delimiter position detecting means recognizes a flag attached to the sort data by a sorter and detects a delimiter position for each item of the data string. Transfer device. 4. The apparatus according to claim 3, wherein the free area specifying means specifies a predetermined number of free areas in the memory or the file based on the type of the flag detected by the delimiter position detecting means. Data transfer device. 5. A monitoring means for monitoring the presence or absence of a remaining area for transferring sort data or designating a free area in a memory or a file, and wherein said monitoring means has no or insufficient remaining area. 5. The data transfer device according to claim 2, further comprising: a transfer control unit that restricts transfer of the sorted data when the data is detected. 6. The transfer means transfers the data string so as to be continuous from a start area in a memory or a file for each item, and the empty area designation means transfers a data string for each item transferred to a memory or a file. A predetermined free area is specified at the end of the data string. The monitor means stores the end area position of the memory or the file, and stores the end area position and the transfer area position of each sort data or the specified free area position. 6. The data transfer device according to claim 5, wherein the presence or absence of a remaining area in the memory or the file is monitored by comparing the data with the data. 7. The monitor means monitors the remaining area based on the number of records in the recording area of the transferred sort data, the number of records in the designated free area, and the total number of areas in the memory or the file. The data transfer device according to claim 5, wherein 8. A totaling means for calculating a total value for each item of a data string to be transferred, a total value transferring means for transferring the total value to a free area designated in a memory or a file by said free area specifying means, The data transfer device according to claim 2, further comprising: