JPH08263347A - Data totalization method and device - Google Patents

Abstract

PURPOSE: To reduce the capacity necessary for a data storage means and also to shorten the data totalization processing time by carrying out the data totaliza tion processing based on the final correction result of data. CONSTITUTION: A data totalization method/device consists of a data input means 11 which corrects and updates the registered data that are called out of a data storage means 12 which registers the data and stores these data, a totalizing object decision means 13 which compares the contents of the precedently totalized data and those of the presently corrected totalization data to decide whether or not the data to be sent to the means 12 from the means 11 should be totalized and then gives a marking only to the data that should be totalized, and a data totalization means 14 which extracts only the data that received the marking from the means 13, deletes the marking totalizes the data and updates a totalization file.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data totaling method and apparatus, and more particularly to a data totaling method and apparatus having a function of extracting data to be totaled in batch totaling processing and updating a totalization file.

[0002]

2. Description of the Related Art A conventional data totaling method and apparatus generate transaction data for updating a totaling file from data input by data input means, and are activated by a key input by a worker or automatic activation at regular intervals. Batch processing is performed on the data. With this method, for the file update to the same record, it is necessary to hold the multiple transaction data generated until the aggregation process is started in chronological order, and in the system that frequently updates the same record, This leads to an increase in transaction data to be processed, leading to an increase in the total processing time.

An example of a conventional data totaling method and apparatus is described in Japanese Patent Application Laid-Open No. 02-157947. The data aggregation method and device described in this publication are
It is a device that stores the input data as transaction data and totals the data when the data update condition given to the data is satisfied. This device
It is composed of a data storage means for storing transaction data, an update control means for judging from the data update condition whether or not the data is to be totalized, and a totalization processing means for totalizing data based on the extracted data. Among these, the aggregation processing means that is started in batch determines that the data called from the data storage means satisfies the conditions such as the aggregation execution time given to the data by the update control means. Data is passed only when it is done, and the data is aggregated. This device has not solved the above-mentioned problem of updating by transaction data.

[0004]

The above-described conventional data totaling method and apparatus store the result of data input (registration / correction) as transaction data, and totalize the data by a regular start or a batch process started by an operator. It is processing. Therefore, in the conventional data summarizing method and apparatus, since the input result must be stored as transaction data every time data is input (registered / corrected), in the apparatus in which the data is frequently corrected, Since a large number of transaction data exist for one data at the time of aggregating processing, it puts pressure on the capacity of the data storage means and increases the aggregating processing time because all transaction data are applied in chronological order. It was.

An object of the present invention is to reduce the required capacity of the data storage means by performing the data totalizing process only with the time-series final correction result data when starting the batch process of the data totaling process. An object of the present invention is to provide a data totaling method and device for reducing the data totaling processing time.

[0006]

SUMMARY OF THE INVENTION A data totaling method and apparatus of the present invention is a data totaling method and apparatus for updating a totalization file according to the contents of input data. Data input means for correcting / updating completed data, data storage means for storing data input by the data input means, and data passed from the data input means to the data storage means to be aggregated data It is determined whether or not, and the aggregation target determination means that marks only the data that is determined to be aggregated, and only the data marked by the aggregation target determination means is extracted, the marking is deleted, and the data is aggregated. And a data totalizing means for updating the totalization file.

[0007]

Embodiments of the present invention will now be described with reference to the drawings.

FIG. 1 is a block diagram showing an embodiment of a data totaling method and apparatus of the present invention.

An information input terminal such as a personal computer is used as the data input means 11 in the data totaling method and apparatus of this embodiment. This information input terminal receives the input of information corresponding to the key data part of the data file, and if the data having the same content as the input information is already registered in the data storage means 12, the registered key It has a function of accepting correction of information other than the data part and accepting new registration of other data such as the data part to be aggregated if data having the same content is not registered in the data storage means 12.

The data input by the data input means 11 is transferred to the totalization object determination means 13, and an example of data registration / update processing for the data file in the data totalization method and apparatus of this embodiment of FIG. 4 is shown. Processing according to the flow chart is performed. That is, the counting target determination means 1
3 receives the input data (step 4
1) Judge whether the data is new registration or update processing (step 42). In the case of new registration, set the value of the aggregation target flag to [1] (step 45), and in the case of update processing. , The data to be aggregated from the data input means 11 is compared with the description contents of the previously aggregated data portion of the data on the data file to be updated (step 4
3) If the contents are the same, set the value of the aggregation target flag to [0]
(Step 44), if not, set [1] (Step 45).

The data for which the totaling target has been set is returned to the data input means 11 together with the determination result of the setting, and a registration / update processing request for the data storage means 12 is issued there. The data storage means 12 that has received the registration / update processing request registers / registers according to the contents of the request.
Execute the update process.

The above processing is carried out as necessary, and the data registration / update processing for the data file is performed.

Here, the format of the data file will be described. As shown in FIG. 2 which is a diagram showing the format of the data file in the data totaling method and apparatus of the present embodiment, the format of the data file is roughly composed of five parts. That is, the key data part, the general data part, the aggregation target data part, the aggregation target flag part, and the previous aggregation data part. The key data part, the general data part, and the data part to be aggregated are all data input means 1
The part that stores the data directly input from 1.
The contents stored in each part are different. The key data part stores the totaling key when totaling, that is, “ordering month”, “ordering department code”, and “item code”, and the data to be totaled includes the data to be aggregated, that is, “ordering quantity” and “delivery quantity”. All the remaining data stored in the general data part that does not correspond to the key data part or the data part to be aggregated out of the data input by the data input means 11, that is, "ordering date", "department name", and "product name" Is memorized. The aggregation target flag unit is a part that stores the determination result of the aggregation target determination unit 13, that is, the aggregation target flag is stored, and this aggregation target flag is used when the data aggregation unit 14 extracts the aggregation target data. The last time data section is
Data to be compared by the aggregation target determination unit 13 with the aggregation target data unit, that is, “ordered quantity” and “delivery quantity” are stored, and when the data aggregation is performed, the data aggregation unit 14 stores the stored contents of the aggregation target data unit. Updated by copying.

The data totaling means 14 is the data inputting means 1
It is activated by an instruction from 1. As a method of issuing this instruction, a key input by an operator in the data input means 11 or a regular activation process by automatic activation setting can be adopted.

When the data totalizing means 14 is activated, FIG.
FIG. 3 is a diagram showing a format of a totalizing file in the data totaling method and apparatus of this embodiment shown in FIG. Create a summary file in. That is, the data of the data file stored in the data storage means 12 is read (step 51), and the value of the aggregation target flag is
The data of [1] is extracted (step 52).
For the data subject to aggregation of the data in the summary file that has a key data portion with the same content as the key data portion of the data in the extracted data file, specify the contents of the data subject to aggregation in the data of the extracted data file. Add and subtract the contents of the previous aggregated data section (step 53). This processing will be described using the data item names in FIGS. 2 and 3, and the “total order quantity of the data part to be aggregated in FIG. 3” is “FIG.
2 is added to the "total order quantity of the data part to be aggregated" and the "order quantity of the data part of the aggregate of Fig. 2" is subtracted, and the "order quantity of the previously aggregated data part of Fig. 2" is subtracted. "Total delivery quantity of the target data section" is the "total delivery quantity of the aggregation target data section of Fig. 3" plus "delivery quantity of the aggregation target data section of Fig. 2" to obtain "delivery quantity of the previous aggregation data section of Fig. 2". It will be subtracted. After the above processing is completed, the value of the aggregation target flag of the data extracted from the data file is updated to [0] (step 54), and the contents of the previous aggregation data part are updated to the contents of the aggregation target data part (step 55). ).

In the update processing of data for the data file / totalized file in the above processing, the update request issued from the data totalizing means 14 is executed in the data storage means 12 according to the contents of the request. By doing so, the contents stored in the data storage means 12 are reflected. If the data equivalent to the key data part of the data read from the data file is registered and there is no data in the summary file, the content of the key data part of the data extracted from the data file is used as the key data part. The generated data is automatically generated in the summary file.

The above processing is carried out for all the data whose aggregation target flag is [1] registered in the data file, and the registration / update processing of the data file and the aggregation file is carried out.

A totaling file for storing the totaling result concerning the key data part of the data registered in the data file is as shown in FIG. 3 showing the format of the totaling file in the data totaling method and apparatus of this embodiment.
It is composed of three parts: a key data part, an aggregation target data part, and a general data part. The key data section is a data section that faces the key data section of the data file, and stores a totaling key, that is, "ordering month", "ordering department code", and "product name code". The aggregation target data part is a part for storing the result of totaling the respective values of the aggregation target data part of the data file, that is, "total order amount" and "total delivery amount". In the general data section, accompanying information relating to aggregation such as aggregation date and time, that is, “aggregation execution date and time” is stored.

The data storage means 12 is a storage medium such as a hard disk for storing a registration / update request issued to a data file or a total file and a data file or total file.

Next, the operation of this embodiment will be described with reference to a transition diagram showing an example of data registration / update processing for explaining the operation of the data totaling method and apparatus of this embodiment shown in FIG. This shows a state in which the stored contents of a data file of one piece of data changes with the operation of this embodiment. In the state 1 of FIG. 6, the key code is the ordering month [01] + ordering department code [23601] + product name code [3
61-266487-25] is newly input from the data input means 11. At this time, since the data has been newly registered, the aggregation target determination unit 13 determines that the data is to be aggregated, sets the value of the aggregation target flag to [1], and performs marking indicating that the data is to be aggregated. In the previous aggregation data section, the data in the aggregation target data section has not been processed by the data aggregation means 14 even once.
] [] Is empty.

The state 2 is a state in which the "delivery quantity" item of the data portion to be aggregated has been updated to [000050] by the data input means 11 since 50 items have been delivered. At this time, the aggregation target determination unit 13 sets the value of the aggregation target flag to [] because the registered content of the previous aggregation data part is [] [], which is different from [000500] [000050] of the modified aggregation target data part. 1] and mark it to indicate that it is a target for aggregation.

In the state 3, the data input means 11 automatically issues an instruction by the regular processing and the data totalization means 14
Is activated, and the aggregation process is performed. At this time, the value of the aggregation target flag becomes [0] indicating that the marking was removed due to the aggregation processing being performed, and the content of the aggregation data part of the previous time is copied because the content of the aggregation data part is copied. It is [000500] [000050]. Also, the same key data part as the key data part of the data file ([01]
+ [23601] + [361-266487-25]) The contents of the data part of the aggregation target of the data of the aggregation file is +500 to the total order quantity,
+50 is added to the total delivered quantity.

In this aggregation processing, in the method using the conventional transaction, the aggregation processing by the transaction in the state 1 and the aggregation processing by the transaction in the state 2 are executed twice.
The data totaling method and apparatus shown in FIG. 1 perform only the totaling process in the state 2. This is because the aggregation process is performed by the data itself (only the description content of the data in the state 2), not by using the transaction.

Both the state 4 and the state 5 show the state in which the value of the delivered quantity is updated by the data input means 11.
This shows how 50 items were delivered after the state 3, but were returned due to quality problems. Therefore, once the value of the delivered quantity in state 4
After being updated to [000100], it is updated again to [000050] in state 5. The value [000050] in this state 5 is the same as the value of the delivered quantity in the last time data section [00005].
Therefore, the aggregation target determination unit 13 determines that the aggregation target is not the aggregation target, and does not perform marking to indicate that the aggregation target is set. Therefore, the value of the aggregation target flag is determined to be the aggregation target in the state 4. The marking (the updating of the value of the aggregation target flag to [1]) is deleted and updated to [0]. Even if the data totalizing means 14 is activated at this point, this data does not become the target data for aggregation and does not affect the implementation of the aggregation process. If this is the conventional transaction method,
The aggregation processing is performed on the transactions generated by the data update processing in the states 4 and 5.

The state 6 is a state in which the value of the delivered quantity of the data portion to be totalized is updated to [000080] by the data input means 11 because 30 articles have been delivered after the state 5. By updating this data, the aggregation target determination unit 13 compares the value of the aggregation target data part of this data with the value of the previous aggregation data part, and the value of the aggregation target flag that is a marking indicating that the data is the aggregation target. Is being updated to [1].

In the state 7, the data input means 11 automatically issues an instruction by the regular processing and the data totalization means 14
Is activated, and the aggregation process is performed. At this time, the value of the aggregation target flag becomes [0] indicating that the marking was removed due to the aggregation processing being performed, and the content of the aggregation data part of the previous time is copied because the content of the aggregation data part is copied. It is [000500] [000080]. Also, the same key data part as the key data part of the data file ([01]
+ [23601] + [361-266487-25]) The contents of the aggregation target data part of the data of the aggregation file that has +0 ([000
Addition of 500] and subtraction of [000500]), +3 to the delivered quantity
0 (the result of addition of [000080] and subtraction of [000050]) is added.

In this tabulation process, in the method using the conventional transaction, the tabulation process by the transaction in the state 4, the tabulation process by the transaction in the state 5 and the tabulation process by the transaction in the state 6 are performed in total. However, the data totaling method and apparatus of the present invention only perform the totalizing process in the state 6. This is because the aggregation process is performed by the data itself (only the description content of the data in the state 6), not by using the transaction.

In this way, the marking of the data judged as the data to be totaled is performed only when the values of the data to be totalized and the previous totalized data part of the data of the data file are different, and the data totaling means 14 At the time of activation, only the minimum necessary data is aggregated by extracting the marked data indicating that it is the aggregation target, that is, the data whose aggregation target flag is [1] and performing the data aggregation process. It is possible to reduce the data aggregation processing time. Further, since transaction data is not required separately, it is not necessary to prepare a storage capacity other than actual data in the data storage means 12.

In the above embodiment, the ordering data has been described, but the same applies to other types of data such as data indicating quality status and data indicating odds indicating a horse racing rate. Also, regarding the content of the data described in the data part to be aggregated, the target is not limited to numerical data in particular, even if it is character data, calculation by the character code and counting of the number of cases etc. When using the data aggregation method of No. 2, this data aggregation method and apparatus can be applied.

[0030]

As described above, the data summarizing method and apparatus of the present invention, when the data summarizing means is activated, change from the value of the data portion to be summed when the previous data summarizing means was activated. By collecting only the data that has been present and performing the aggregation process, it is sufficient to perform the minimum necessary data aggregation by the value of the final aggregated data section,
The processing time for data aggregation can be reduced.

Further, since the data summarization method and apparatus of the present invention does not generate transaction data, the data storage means need not have a capacity other than actual data, and the capacity of the data storage means can be easily assumed. is there.

[Brief description of drawings]

FIG. 1 is a block diagram showing an embodiment of a data totaling method and device of the present invention.

FIG. 2 is a diagram showing the format of a data file in the data totaling method and apparatus of this embodiment.

FIG. 3 is a diagram showing a format of an aggregation file in the data aggregation method and apparatus of this embodiment.

FIG. 4 is a flow chart showing an example of data registration / update processing for a data file in the data totaling method and apparatus of the present embodiment.

FIG. 5 is a flowchart showing an example of data registration / update processing for a totalization file in the data totalization method and apparatus of the present embodiment.

FIG. 6 is a transition diagram showing an example of data registration / update processing for explaining the operation of the data totaling method and apparatus of the present embodiment.

[Explanation of symbols]

 11 Data Input Means 12 Data Storage Means 13 Aggregation Target Determination Means 14 Data Aggregation Means

Claims (4)

[Claims] 1. A data input means registers data, calls registered data, corrects / updates the registered data, stores the data input by the data input means in the data storage means, and totalizes the data. The object determining unit determines whether the data transferred from the data input unit to the data storage unit is the data to be aggregated, and only the data determined to be aggregated is marked, and the data aggregation unit A data totaling method characterized in that only the data marked by the totaling object judging means is extracted, the marking is deleted, the data is totaled, and the totalization file is updated. 2. The data storage means retains information at the time of data aggregation, and the aggregation object determination means,
The data totaling method according to claim 1, wherein it is determined whether or not the data held by the data storage means becomes the totaling target data when the data is corrected. 3. The data totaling method according to claim 1,
A data totaling apparatus comprising: a data inputting unit, a totaling target determining unit, and a data totaling unit. 4. The data aggregation method according to claim 2,
A data totaling apparatus comprising: a data inputting unit, a totaling target determining unit, and a data totaling unit.