JPH01288920A - Data sorting device - Google Patents

Abstract

PURPOSE:To shorten a time necessary for the sorting processing of data by providing a data sorting mechanism, an ascending sequence sorting mechanism, and a descending sequence sorting mechanism, and processing sorting data strings generated in the respective sorting mechanisms so as to be reduced. CONSTITUTION:A data sorting mechanism 1 decides whether the data inputted from a magnetic disk device 200 are to be sent to an ascending sequence sorting mechanism 2 or to a descending sequence sorting mechanism 3. That is, based on the value of an inputted sorted data 11, the last data value of the ascending sequence sorting data string presently outputted by the mechanism 2, and the last data value of the descending sequence sorting data string presently outputted by the mechanism 3, the sorting data strings generated by the mechanisms 2 and 3 are outputted so that the number of the strings may be extremely reduced. Thus, the time necessary for obtaining the sorting data string to be processed by a merging mechanism 4 is reduced, the sorting processing of the data is promptly attained, and the time necessary for the processing can be shortened.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a data sorting device that sorts a large amount of data in ascending or descending order.

[Conventional technology]

For example, as shown in FIG. 2, a conventional data sorting device of this type uses a heap sort method, in which data is input sequentially from a sorted data string 51 consisting of a large number of data stored in an auxiliary storage device such as a magnetic disk device. The merging mechanism 6 is equipped with one sorting mechanism (ascending sorting mechanism 5) that sorts data in ascending order by A data sorting device 400 that generates one sorted data string 71 is known.

[Problem to be solved by the invention]

The conventional data sorting device 400 described above is configured to use only one ascending order sorting mechanism 5 as a sorting mechanism, so when the sorted data column 51 is in descending order, sorting is performed in ascending order. In extreme cases, many ascending sort data sequences 61-1 to 61-Z are generated due to the characteristics of the heap sort method.
It takes a lot of time for the merge mechanism 6 to convert into one sorted data string 71, and the data sorting processing time increases.

An object of the present invention is to provide a data sorting device that can shorten the time required for data sorting.

[Means to solve the problem]

In order to achieve the above object, the data sorting device of the present invention includes an ascending order sorting mechanism that generates an ascending sorted data string from sequentially input sorted data strings, and a data sorting mechanism that generates an ascending sorted data string from sequentially input sorted data strings. The descending order sort m structure generates a descending sorted data column from data, and the data is input sequentially from the data column to be sorted, and the value of this input data,
Based on the value of the last data in the ascending sort data string currently output by the ascending sort i structure and the value of the last data in the descending sort data string currently output by the descending sort mechanism, a data distribution mechanism that determines whether to send data to the ascending order sorting mechanism or the descending order sorting mechanism, and the ascending sort data string obtained by the ascending order sorting mechanism and the descending sorting obtained by the descending sort a side. It consists of a merging mechanism that obtains one sorted data string from a data string.

[Effect]

In the data sorting device of the present invention, the data sorting mechanism manually inputs data sequentially from the data string to be sorted stored in the auxiliary storage device, etc., and the values of the input data,
Based on the value of the last data in the ascending sort data column currently output by the ascending sort mechanism and the value of the last data in the descending sort data column currently output by the descending sort mechanism, and determining whether to send the input data to the field J head sorting mechanism or to the descending sorting mechanism so that the number of sorted data strings generated by the descending sorting mechanism is reduced;
The ascending sort mechanism sorts the input data in ascending order,
The descending sort mechanism sorts the input data in descending order,
A merging mechanism merges an ascending sorted data string obtained by the ascending sorting mechanism and a descending sorted data string obtained by the descending sorting mechanism to generate one sorted data string.

〔Example〕

Next, embodiments of the present invention will be described in detail with reference to the drawings.

FIG. 1 is a block diagram of an embodiment of the present invention.
is a data sorting device according to the present invention, and this example shows a data sorting device that sorts data in ascending order. Further, 11 is a sorted data string consisting of a large number of data stored in the magnetic disk device 200, and 41 is a sorted data string stored in the magnetic disk device 300. The data sorting device 100 includes an ascending order sorting mechanism 2 that sorts data in ascending order using a heap sort method, a descending order sorting mechanism 3 that sorts data in descending order using a heap sort method, and data from a sorted data column 11 in a magnetic disk device 200. A data sorting mechanism 1 reads the read data one by one and determines whether to input the read data to the ascending sorting mechanism 2 or conversely to the descending sorting mechanism 3, and the data generated by the ascending sorting mechanism 2. A storage means 22 consisting of a main storage area and an auxiliary storage area for storing the ascending sorted data strings 21-1 to 21-X, and several intermediate sorted data strings 3 generated by the descending sorting structure 3.
1-1 to 31-y, a storage means 32 consisting of a main storage area and an auxiliary storage area, and an ascending sorted data string 21-1 to 21-X stored in the storage means 22 and the storage means 32.
Descending sorted data columns 31-1 to 31-y stored in
By merging them, one sorted data string 41 sorted in ascending order is generated, and this is stored in the magnetic disk device 3.
It is composed of a merge mechanism 4 that writes data to 00.

The data distribution mechanism 1 described above includes a magnetic disk device 20
The value of the data input from 0, the value of the last data in the ascending sorted data string currently output by the ascending sorting mechanism 2,
and based on the value of the last data of the descending sort data string currently output by the descending sort mechanism 3, so that the number of sort data strings generated by the ascending sort mechanism 2 and the descending sort mechanism 3 is as small as possible. It is determined whether the input data is sent to the ascending order sorting mechanism 2 or the descending order sorting mechanism 3. Now, the value of the data manually input from the magnetic disk device 200 is a, the value of the last data in the ascending sort data string currently output by the ascending sort mechanism 2 is Assuming that the value of the last data in the descending sorted data string is C, the above sorting is performed, for example, as follows.

(1) When a≧b and a≦C In this case, ascending sorting mechanism 2 and descending sorting mechanism 3
Sort data to the sorting mechanism with the closest value so that the length of one sorted data string generated by is longer. That is, (1-1) If a-b≦c-a, send a to the ascending sorting mechanism 2.

(1-2) If a-b>c-a, send a to the descending sorting mechanism 3.

(2) When a≧b and arc In this case, if a is sent to the descending sorting mechanism 3, the data string input to the descending sorting mechanism 3 will be in ascending order, so it is sent to the ascending sorting mechanism 2.

(3) When a<b and a≦C In this case, if a is sent to the ascending sorting mechanism 2, the data string input to the ascending sorting mechanism 2 will be in descending order, so it is sent to the descending sorting mechanism 3.

(4) When a<l) and arc In this case, ascending sorting mechanism 2 and descending sorting mechanism 3
Sort the data to the sorting mechanism with the farthest value so that the length of one sorted data string generated by is longer. That is, (4-1) If b-a≧a-c, send a to the ascending sorting mechanism 2.

(4-2) If ba<ac, send a to the descending sorting mechanism 3.

Mechanism for sorting data in ascending order as described above 2. By distributing the data to the descending sorting mechanism 3, the number of sort data strings generated by the ascending sorting mechanism 2 and the descending sorting mechanism 3 can be reduced. For example, as an extreme example, when the data columns 11 to be sorted are arranged in descending order, ascending l@
When the data sorting device of this embodiment and the second
A comparison with the conventional device shown in the figure is as follows.

■In the case of the embodiment of the present invention shown in FIG. 1, regardless of the number of data in the sorted data column 11, the ascending sort data column and the descending sort data column produced by the ascending order sorting mechanism 2 and the descending order sorting mechanism 3 are At most, there will be one each, and the number of sorted data strings that the merging mechanism 4 should merge is two at most. In the case of ascending sorting, the merging mechanism 4 reads the ascending sorted data string stored in the storage means 22 from the beginning, and reads the descending sorted data string stored in the storage means 32 from the end. , which performs the merge.

■In the case of the conventional device shown in FIG. 2, the number of sorted data strings 51 is m, and the maximum length of the ascending sorted data string that the ascending I'll sorting mechanism 5 can create for the descending sorted data strings 51 is n. Then, the number of sorted data columns 61-1 to 61-2 in ascending order is (m/n)−
become individual.

When the number of data in the data string to be sorted is large due to the above items ① and ②, in the conventional device, the number of ascending sorted data strings that are input to the merging mechanism 6 increases, and the merging process takes time. Although the sorting process is slower, in this embodiment, the number of sorted data strings that are input to the merging mechanism 4 is smaller, the time required for the merging process is shorter, and the data sorting process is faster.

In the above embodiments, the present invention is applied to a data sorting device that sorts in ascending order, but the present invention also applies to a data sorting device that sorts in descending order, or to a data sorting device that sorts data in a specified order of ascending or descending order. It can be applied to data sorting devices.

〔Effect of the invention〕

As explained above, the data sorting device of the present invention has two sorting mechanisms, an ascending sorting mechanism and a descending sorting mechanism, whose arrangement order is opposite to each other, and the data sorting mechanism is a sorted data string generated by each sorting mechanism. Since the data to be sorted is divided and given to the ascending sorting mechanism and the descending sorting mechanism so that the number of sorted data is as small as possible, the number of sorted data strings that the merging mechanism has to process is smaller than before, until one sorted data string is obtained. This has the effect of reducing the time required for data sorting and speeding up data sorting.

[Brief explanation of the drawing]

FIG. 1 is a block diagram of an embodiment of the present invention, and FIG. 2 is a block diagram of a conventional example. In the figure, 1...Data sorting mechanism 2...Ascending order sorting mechanism 3...Descending order sorting mechanism 4...Merge mechanism 11...Sorted data columns 21-1 to 21-χ...Ascending order Sort data column 22.
32... Storage means 31-1 to 31-y... Descending sorted data string 41.
...Sort data column 100...Data sorting device

Claims (1)

[Scope of Claims] An ascending order sorting mechanism that generates an ascending sorted data string from sequentially input sorted data strings, and a descending sort mechanism that generates a descending sorted data string from sequentially inputted sorted data strings. a sorting mechanism, which sequentially inputs data from a data column to be sorted, the value of the input data, the value of the last data of the ascending sort data column currently output by the ascending sort mechanism, and the value of the last data of the ascending sort data column currently output by the descending sort mechanism; a data sorting mechanism that determines whether to send the input data to the ascending sorting mechanism or the descending sorting mechanism based on the value of the last data of the descending sorted data string being output; and the ascending sorting mechanism; A data sorting device comprising: a merging mechanism for obtaining one sorted data string from the obtained ascending sorted data string and the descending sorted data string obtained by the descending sorting mechanism.