JPH0488476A - Data totalization system - Google Patents

Abstract

PURPOSE:To eliminate limitations by a processing time, the memory of a computer, etc., by reading key contents, which are stored in a storage medium, in a program, developing them in the program, and identifying and totalizing input data individually. CONSTITUTION:The key contents stored in a key contents storage file 1 are developed in a totalization area 3 in the storage order through the operation of a key contents development processing part 2 and the input data are read in successively. The totalization area 3 is retrieved according to the key value of the input data; when there is a corresponding key value in the totalization area 3, a totalization item addition process is carried out and next data is read in. When the data of the input file are all read, the contents of the totalization area 3 are written in an output file and the data in the totalization area 3 are rearranged in the quantity order of the input data. The key contents of the rearranged totalization area 3 are written back in the key contents storage file 1. Consequently, the limitations by the processing time, the memory of the computer, etc., are eliminated.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a data aggregation method in data batch processing in which the content of the aggregation key is aggregation of a large number of data, such as the update history of a database, using a specific aggregation key.

[Conventional technology]

Conventionally, data aggregation in data batch processing has been performed by directly accessing an external storage medium for each data item and performing additions and subtractions, or by adding and subtracting in the memory of a program and storing it in an external storage medium after the aggregation is completed.

[Problem to be solved by the invention]

Conventional methods of directly accessing an external storage medium for each data item or aggregating data in memory have the problem of being limited by processing time, computer memory, etc.

Furthermore, processing must be performed in response to the increasing number of key types.

[Means to solve the problem]

The data aggregation process of the present invention is a data aggregation method in which data input from a storage medium storing data having aggregation key items is aggregated using aggregation key items specified by a program, and the key contents to be aggregated are stored. It includes means for storing on a medium, means for reading stored key contents into a program, means for developing the read key contents into a program, and means for identifying and individually totaling input data.

Further, the data aggregation method of the present invention is configured to include means for outputting the input data to an external storage medium when the aggregation key content of the input data does not correspond to the expanded key content.

〔Example〕

Embodiments of the present invention will be described in detail below with reference to the drawings.

FIG. 1 is a block diagram showing an embodiment of the present invention. In the figure, the data aggregation method consists of a key content storage file 1 that stores the key content of data to be aggregated, a key content development processing unit 2 that develops the stored key content on the memory of the program when the program is started, and a program. a totalization area 3 realized on the memory of , a data input processing section 4 that inputs external data, and a data totalization processing section 5 that totalizes the data input by the data input processing section 4 using the totalization area 3.
and a data processor 6 that outputs the totalized contents of the total area 3 to an external file.

Furthermore, the data aggregation method in this data batch processing is implemented by applying it to a computer system.

FIG. 2 is a flowchart showing the operation of the data aggregation method described above. In step 11 in the figure, the key contents expansion processing unit 2 expands the key contents stored in the key contents storage file 1 into the total area 3 in the order in which they are stored. Next, input data is submitted one after another.

Step 12 is step 13 if there is input data.
- 19 are executed, and when there is no more input data, steps 20 - 22 are terminated.

Step 13 searches the total area 3 using the key value of the input data. If the corresponding key value exists in the total area 3, a total item addition process is performed in step 14, and the next data is read.

If the corresponding key value does not exist in the aggregation area 3, the output file is read in step 15 using the key value of the input file, and if data exists in the output file, the data of the input file is added to the contents of the read output file. (step 16.18) and written back to the output file (step 19). If no data exists in the output file, the contents of the input file are edited in step 17 and written to an output file in step 19.

If there are no more input files, proceed to step 20.
Move to. Step 20 writes the contents of the total area 3 to an output file. Step 2o rearranges the total area 3 in order of the number of applicable input data. Step 22 writes back the rearranged key contents of the total area 3 to the key contents storage file 1.

〔Effect of the invention〕

As is clear from the above explanation, by using the data aggregation method of the present invention, items that occur frequently are always resident in the first area of the program memory, improving search efficiency, and items that occur less frequently can make effective use of program memory by directly accessing the output file.

Furthermore, there is no need to deal with the increasing number of key types every day.

[Brief explanation of drawings]

FIG. 1 is a block diagram showing an embodiment of the present invention, and FIG. 2 is a flowchart showing an example of an operating procedure. DESCRIPTION OF SYMBOLS 1...Key content storage file, 2...Key content expansion processing section, 3...Aggregation area, 4...Data input processing section, 5...Data aggregation processing section, 6...Data pressure processing section.

Claims (1)

[Claims] 1. In a data aggregation method in which data input from a storage medium storing data having aggregation key items is aggregated using aggregation key items specified by a program, the key contents to be aggregated are stored in the storage medium. The present invention is characterized by comprising means for storing the stored key contents in the program, means for loading the stored key contents into the program, means for expanding the read key contents into the program, and means for identifying and individually aggregating the input data. data aggregation method. 2. The data aggregation method according to claim 1, further comprising means for outputting the input data to an external storage medium when the aggregation key content of the input data does not correspond to the expanded key content. .