JPH03265029A - Data sum-up processing system - Google Patents

Abstract

PURPOSE:To reduce the generating rate of bugging in a program and to simplify a test by registering a sum-up rule to a file, successively reading the rule by the program and executing the read, calculation and write of data according to the registered sum-up rule. CONSTITUTION:A data file (DF) 4 inputs items to be summed up to a record and a sum-up file (SF) is composed of the same number of records corresponding to the DF4 and respectively stores the sum-up rules of respective records for four items such as a sum-up destination 1, arithmetic 1, sum-up destination 2 and arithmetic 2. An application program (AP) 1 is composed of a calculating means 2 and a file read/write means 3 and when the AP1 is executed, the DF4 is updated so as to read the SF5 for each record. When the records are not summed up, the sum-up destination 1 becomes 0 and therefore, the next record is read. When the records are summed up, calculation is executed by the means 2 according to the arithmetic 1 item and the result of arithmetic is written to the records, which is instructed by the sum-up destination 1 item, by the means 3. When there are two sum-up destinations, the processing is executed according to the sum-up destination 2 item and arithmetic 2 item. Thus, the contents of the program are simplified, the generation of bugging is suppressed and the test can be simplified.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a data file aggregation method, and particularly to a aggregation method when performing aggregation between records in a large-scale data file.

[Conventional technology]

Conventionally, when performing inter-record aggregation of a data file, an application program has an aggregation rule for each record, specifies and reads the data to be aggregated, performs aggregation according to each record, and stores the aggregated data in the aggregate optical record. write to.

[Problem to be solved by the invention]

Conventionally, the application program has aggregation rules, so the application program itself
The algorithms are extremely complex, the rate of bugs due to mistakes in the definition of aggregation rules is high, and testing and checking after creating an application program requires a large amount of man-hours. Additionally, since changes to aggregation rules occur frequently after they have been created, the application program source must be modified, recompiled, and linked each time a change is made.

The drawback is that a testing procedure must be followed, and the number of man-hours required for modification is extremely large. In other words, the versatility of the application program is low, and there is a high risk of bugs occurring during modification.

[Means for solving problems]

The data aggregation processing method of the present invention includes a data file, an aggregation file having an aggregation rule indicating to which record the numerical value of each record is to be aggregated, and a file readout that reads and writes the data file and the aggregation file. It has a writing means, and an arithmetic means for performing calculations on the data file according to information registered in the aggregation file while sequentially reading records of the aggregation file.

〔Example〕 Next, the present invention will be explained with reference to the drawings.

FIG. 1 is an overall configuration diagram showing an embodiment of the present invention. In the figure, 4 is a data file, and records include items to be totaled. 5 is an aggregation file, which consists of the same number of records corresponding to the data file, and stores aggregation rules for each record.

When the application program 1 is executed, the data file 4 is updated. Also, this program contains 2
The calculation means 2 performs calculations on the items of the read records according to the rules specified in the summary file, and the file reading/writing means 3 sequentially reads the summary file and the data file and stores the results calculated by the calculation means in the summary file. Write to the record specified by .

Figures 2 (a> and (b) are configuration diagrams of the data file 4 and the total file 5.These two files are each composed of the same number of records.The item 6 to be totaled in the data file 4 is an application It is updated when program 1 is executed. 7 and 9 are the record numbers of data file 4 where the calculation results are written, 8 and 10
indicates addition, subtraction, etc. during arithmetic processing. As shown in the record layout of the tally file 5, it is possible to specify up to one tally light for each code.

FIG. 3 is a flowchart showing the processing procedure of the application program 1. Read the tally file 5 code by code (step 31), and if you do not want to tally it, read the tally light 1
is 0 (step 32), so the next record is read. In the case of totaling, arithmetic processing is performed according to calculation 1 (step 33), and the calculation results are written to the record specified by the totalization light 1 (step 34). If there are two aggregate lights (step 35), aggregate lights 2. Process according to operation 2 (steps 36 and 37>).

FIG. 4 shows the result of executing the application program 1 using the data file 4 and total file 5 shown in FIG. In item 6 of data file 4, the fourth and sixth records have been updated.

〔Effect of the invention〕

The data aggregation method according to the present invention can bring about the following effects.

According to the present invention, by registering aggregation rules in a file, an application program can simply read the aggregation file one by one and perform operations such as reading, calculating, and writing data files in accordance with the aggregation rules registered in the aggregation file.

Therefore, the content of the program becomes concise, the bug occurrence rate of the program is reduced, and testing after creation can be simplified.

Furthermore, the created application program can be used for aggregation processing by replacing the data file or the aggregation file for the aggregation processing, making it highly versatile.

In the past, when the aggregation rules changed, the application program had to be modified, but by having the aggregation file, you only need to modify the contents of the aggregation file, improving operability and safety. .

[Brief explanation of drawings]

Fig. 1 is an overall configuration diagram showing an embodiment of the present invention, Fig. 2 is a file configuration diagram, Fig. 3 is a flow chart showing the processing procedure of an application program, and Fig. 4 shows an example of executing the application program. It is an explanatory diagram. 1... Application program, 2... Arithmetic processing, 3... File read/write processing, 4.・
・Data file, 5...Tally file.

Claims (2)

[Claims] (1) a data file, a totalization file having aggregation rules indicating to which record the numerical value of each record is to be aggregated, a file read/write means for reading and writing the data file and the totalization file, and the aggregation file. 1. A data aggregation processing method, comprising: arithmetic means for performing arithmetic operations on the data file according to information registered in the aggregation file while sequentially reading records of the file. (2) It has a data file and an aggregation file that has an aggregation rule indicating which record to aggregate the numerical value of each record, reads and writes the data file and the aggregation file, and writes the aggregation file to the aggregation file. 2. The data aggregation processing method according to claim 1, wherein calculations are performed on the data file according to information registered in the aggregation file while sequentially reading records.