JPH0731668B2 - Data aggregation system - Google Patents

Description

DETAILED DESCRIPTION [Overview] In order to arbitrarily change the calculation method of a total calculation program, means for designating the calculation program, aggregated data, and past total result data for the calculation program are provided. A method in which a relaying means for passing is provided and a specified arithmetic program is controlled so as to aggregate the data supplied from the relaying means.

[Industrial application field]

The present invention relates to a data aggregation control method for aggregating input aggregated data with respect to aggregated data obtained in the past such as a total of sales products and a sum of amounts like a POS (Point of Sales) terminal, In particular, the present invention relates to a data totalization control system in which a person who uses the device or an organization such as a company can easily change the totalization method arbitrarily.

[Prior Art] Usually, in a POS terminal device or the like, for sales management or inventory management, the total sales amount or total number of the day, the total sales amount or total number of individual items, the total sales amount of each operator, etc. The tabulation is done.

In addition, the product developer should
Each company or individual who delivers a terminal individually investigates the aggregation method and creates a series of aggregation programs that operate uniquely, or one program is created and the company or individual I had no choice but to be satisfied with one tally program.

In order to increase the degree of freedom in designing, one basic tabulation program whose mode changes with parameters is created, and parameters are given according to the needs of companies and individuals, thereby creating programs according to companies and individuals. However, the present situation is that there is a wide variety of ways of counting, and it is not always possible to realize a counting method that corresponds to companies and individuals.

[Problems to be solved by the invention]

SUMMARY OF THE INVENTION An object of the present invention is to provide a data totalization control method that can increase the degree of freedom of the totalization method for a device and easily adapt to the totalization method desired by a company or an individual who uses the device in order to eliminate the above-mentioned conventional drawbacks. Especially.

[Means for solving problems]

 FIG. 1 shows the principle of the present invention.

In the present invention, input means 1 for inputting data to be tabulated
And a totalization file 2 that stores a plurality of types of totalization result data corresponding to a search key, and the respective calculation methods are rewritable. A plurality of calculation program means 3 for calculating by the method, a specification means 4 for specifying a calculation program corresponding to the data input by the input means 1, and a totaling key (table in FIG.
No., shown as a totaling key) The totaling result data of the corresponding key is read from the totaling file 2 by the data, and the identification information B of the corresponding arithmetic program is specified from the designating means 4.
Then, the relay means 5 for transferring the read totalization result data and the input totaled information to the corresponding arithmetic program 3 is provided.

That is, the arithmetic program 3 is independent so that it can be changed appropriately, and the relay means 5 is configured to activate the arithmetic program based on the information provided by the input means and to supply the information to be aggregated. It becomes.

[Action]

Therefore, when the relay means 5 receives the tabulated data input by the input means 1, the relay means 5 supplies the identification information of the corresponding calculation program means 3 to the designation means 4 with the table No. and the key information shown in the figure. Get by doing.

Next, the relay means 5 supplies the key information to the totalization file 2 and reads the corresponding totalization result data.

Thereafter, the relay means 5 activates the calculation program 3 corresponding to the identification information of the calculation program 3 obtained as described above, and collects the counted data obtained from the input means and the counting result data obtained by reading. Supply to the started program.

The new tabulation result data, which is the computation result obtained by the computation program 3, is returned to the relay means 5, and the relay means 5 operates to store the new tabulation result data in the storage area of the tabulation file 2 having the corresponding key information. To do.

Therefore, the relay means does not participate in the arithmetic program at all, and the arithmetic program means B can be individually created, so that the degree of freedom is infinitely expanded.

〔Example〕

 FIG. 2 is a block diagram of an embodiment of the present invention.

In the figure, the same components as those used in FIG. 1 are indicated by the same symbols or numerals.

Further, 10 is a keyboard on which a product number related to a product or key information such as operator identification information is input and operated.

Reference numeral 500 denotes a processing device, which is composed of a microprocessor and a program memory, and has a processing flow shown in FIG.
Those that perform processing in accordance with S1 to S10.

A memory 6 is a rewritable memory used when the processing device 500 operates.

An external storage device 4, such as a bubble memory, stores a plurality of programs, especially arithmetic programs.

Further, in the processing step S1, a plurality of processing programs corresponding to the type of processing are operated selectively.

For example, the sales registration process, the settlement process, the operator registration process, etc. of the POS terminal are configured to be selectively executed by the processing device 500 in response to the pressing of a key on the keyboard 10.

Further, although detailed description is omitted, programs SA, SB, ... SN
Are stored in an external storage medium such as the bubble memory 4 and loaded into the program memory at the start of operation of the apparatus.

The operation will be described below with reference to the processing flowchart shown in the frame of the processing apparatus 500 in FIG.

As an example, a case of registering sales of one product will be described as an example.

The operator of the apparatus uses the keyboard 10 to input the target data for which he / she wants to collect.

In this case, the keyboard 10 is used to operate the numerical value indicating the product number and the numerical value indicating the quantity related to the sales product, and input them to the processing device 500.

The processing device 500 carries out the processing step S1 accordingly.

In the processing step S1, the processing device 500 creates and stores the definition body of the input data in the area 6a on the memory 6.

This processing step S1 is composed of a plurality of steps, and first generates table information TK relating to the aggregation of the input aggregated information.

This table information TK is fixedly set for each process of creating the input data definition structure, and when each of the processes, for example, sales registration process, operator registration process, and settlement process, is performed, a fixed constant that is different from each other is executed. It is configured to generate table information.

Further, the unit price corresponding to the product number is obtained from an external table (not shown). This operation is a known PLU process (price lookup process).

Further, in this processing step S1, the processing device 500 creates the input information for the aggregation processing by storing the various data obtained by these steps in the area 6a.

After that, processing steps S2 to S6 which are the relay means 5
The processing device 500 carries out.

In the processing step S2, the table information TK which is the key information of the definition information stored in the storage area 6a of the memory 6.
And the product number data is read first.

Next, this key information is given to the totalization file 2 as a search key, and the corresponding totalization result data of the totalization file 2 is read.

In the totalization file 2, totalized result data such as table information, a product number, the past total sales quantity of the product of the product number, the total amount, the number of transactions, and the like are stored for each key information.

Further, in another storage area of the totalization file 2, for example,
The table information, the operator number (written as an operator), the total transaction time of the operator, the transaction amount, etc. are stored for each key information.

In the operation example of the present embodiment, the totaling for each product number is described as the totaling data, but it goes without saying that the same processing is performed for the totaling for each operator.

In the processing step S2, when the processing device 500 reads the storage information of the summary file 2 corresponding to the key information of the definition program,
The read data is stored in the storage area 6b of the memory 6, and the process proceeds to the next processing step S3.

In the processing step S3, the data stored in the storage areas 6a and 6b are combined in the communication area 6c of the memory 6.

For example, after storing all definition information of storage area 6A in the communication area, the area is stored in the storage area that follows the storage area.
Among the read data stored in 6b, the information that does not overlap with the above definition body, in this case, the total number of sales, the total amount, the number of transactions, etc. are stored.

When the processing step S3 ends, the processing shifts to the processing step S4.

In processing step S4, the processing device 500 takes out the internal table information TK of the definition stored in the area 6a, and the table information stored in the storage area 6d of the memory 6 with this table information as a key-program code / storage address Search the conversion table.

The storage address indicates the top address of a program memory (not shown) in which a plurality of arithmetic programs are stored.

The processing device 500 stores the program code and the storage address thus obtained in, for example, a program counter.
Set to 5.

As a result, the execution right of the program shifts from the operation flow of the relay means 5 to the programs S7 to S10 of the arithmetic program means 3.

The program means 3 is provided with a number of programs SA, SB, ... SN corresponding to the program code,
Further, these are stored in the above-mentioned program memory, and the head address thereof coincides with each storage address shown in the above table information-program code / storage address conversion table.

Therefore, when the program address is set in the processing step S4, it means that one of the flowcharts SA, SB, ... SN has been started.

Each of the programs SA, SB, ... SN has processing steps S7, S9,
S10 is common, and step S8 is configured to individually perform calculation by different calculation methods.

Therefore, here, assuming that the program SA is selected, the operation will be described according to the flowchart described in the frame of the program SA.

First, in the processing step S7 of the program SA, the processing device 500 reads out the necessary information stored therein from the communication area 6c of the memory 6.

The processing step S8 to be executed next is an arithmetic program for a specific type of totaling, and in the processing step S7, only the information necessary for the arithmetic program is taken out.

For example, when the calculation program is configured to total only the total sales amount, the quantity, unit price, and total amount are taken out in this processing step S7.

Then, the process proceeds to processing step S8.

In the processing step S8, if the calculation program calculates only the total sales amount as described above, the calculation of “quantity × unit price + total amount” is performed, and the process proceeds to the next processing step S9.

In processing step S9, this calculation result is used as the communication area of the memory 6.
Store in the corresponding area of 6c, in this case the area labeled "Gross".

Further, in the processing step S8, when totaling the total amount, the total amount, and the number of transactions, the respective calculations are performed and the results are stored in the corresponding area of the memory 6.

Therefore, in the processing step S9, any aggregation method can be adopted, and according to the request of the company or the individual who uses the device,
By creating a calculation program and storing it in the bubble memory 4, it is possible to deal with any aggregation method.

When the above processing steps are completed, the program SA moves to the processing step S10, and when the processing device 500 executes this step, the processing device 500 transfers the program execution right to the processing step S6 of the original relay means 5.

In the processing step S6, the processing device 500 reads the key information composed of the table information TK and the product number data from the communication area 6c of the memory 6, and uses this key information as the key information of the storage area of the totalization file 2 to perform the totalization. Table information TK, product number, total number
The total amount and other data are read out and stored in the totalization file.

After that, each time a total processing request occurs, the above processing steps
The calculation process is repeated from S1 in the same way, and the calculation program
Only the corresponding items in the total file 2 corresponding to S8 will be totaled.

Such tabulation result data is sequentially fetched from the tabulation file 2 when a settlement processing request or the like is issued from the keyboard 10 or a host computer (not shown) or the like, and is output to a printer (not shown) or a host computer or the like that has made a request. .

〔The invention's effect〕

As described above, according to the present invention, an arithmetic program is individualized, and information necessary for the arithmetic program is taken out from a totalization file and input data and given to the program, and a new total value which is the arithmetic result of the arithmetic program is given. Since the relay means is configured to store it in the totalization file, there is an effect that the degree of freedom of the arithmetic program is extremely increased.

[Brief description of drawings]

FIG. 1 is a principle diagram of the present invention, and FIG. 2 is a block diagram of an embodiment of the present invention. In the figure, 1 is an input means, 2 is a totaling file, 3 is a calculation program, 4 is a command means, and 5 is a relay means.

Claims (1)

[Claims] 1. An input means (1) for inputting data to be tabulated and a tabulation key, a tabulation file (2) for storing tabulation results together with tabulation keys, and an arithmetic program means each comprising a plurality of rewritable tabulation programs. (3) and a designating means (4) for designating the tallying program in the arithmetic program means (3) based on the tallying key, and reading data from the tallying file (2) based on the tallying key and A data totaling system comprising: a relay means (5) for starting a designated program and storing the totalization result in a totaling file (2).