JPH05225443A - Sales data tabulator - Google Patents

Abstract

PURPOSE:To accelerate processing speed by tabulating the sales data of goods whose sales frequency is being increased at present in a file small in capacity to which fast processing can be applied, and tabulating the sales data other than that in a file large in capacity to which slow processing can be applied. CONSTITUTION:The file 2 large in capacity and the file 3 small in capacity are provided as storage parts to tabulate the sales data, and the file 3 small in capacity is retrieved first when the sales data of the goods is generated. and it is tabulated on the same goods data when it exists. When no same goods data exists, the file 2 large in capacity is retrieved, and the data is tabulated after being moved to the file 3 small in capacity when it exists. When the remainder of the file 3 small in capacity arrives at prescribed quantity, the data to which access is interrupted out of sales tabulation data stored in the file 3 small in capacity is selected, and it is transferred to the file 2 large in capacity, then, it is deleted.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a sales data totaling device used for a file controller or the like in an electronic cash register or POS (point of sale information management) system.

[0002]

2. Description of the Related Art In a mass retailer such as a supermarket, for example, a file controller equipped with a storage file for collecting sales data is connected to a terminal for selling merchandise registration installed in each sales floor or accounting place via a communication line. However, in some cases, a POS system is adopted in which sales data of each product registered for sale at each terminal is collected by a file controller and totaled in a storage file for each product.

In this system, a large-capacity file and a small-capacity file are provided as a storage file for accumulating sales data provided in the file controller, and in the small-capacity file, only the sales data of frequently sold products are totaled, It is already known that the sales data of the remaining products are aggregated in a large-capacity file to speed up the processing.

[0004]

However, in the conventional system in which the large-capacity file and the small-capacity file are provided as the storage files for totaling the sales data, the products whose sales are totalized by the large-capacity file are frequently used. Even if it becomes possible to sell, unless you change the setting so that the sales data of the product can be totaled in a small capacity file, sales will be aggregated in a large capacity file forever,
There is a problem that the data retrieval takes time and the processing speed is reduced.

Therefore, according to the present invention, sales data of products whose sales frequency is currently increasing is aggregated in a small-capacity file capable of high-speed processing, and sales data of other products are stored in a large-capacity file of low-speed processing. It is intended to provide a sales data totaling device capable of further increasing the processing speed by performing the totaling.

[0006]

SUMMARY OF THE INVENTION The present invention is a sales data totaling device for classifying sales data of sales-registered products for each product in a storage unit and totaling the sales data. When a sales data of a product is generated, a small-capacity file search means for searching a small-capacity file to determine whether or not there is sales total data of the same product, and a sales total data of the same product by this small-capacity file search means If it is determined that there is no sales total data for the same product by the first sales data totaling unit that adds and updates the sales data generated this time to the sales total data and the small-capacity file search unit, the large-capacity file is saved. A large-capacity file search means that searches for the existence of sales summary data for the same product, and the sales of the same product by this large-capacity file search means. If it is judged that there is aggregated data, the first data transfer means for transferring the corresponding sales aggregated data to the small capacity file and the sales aggregated data transferred to the small capacity file by this first data transfer means will occur this time. The second sales data totaling means for adding and updating the sales data, and the first total sales data stored in the small capacity file when the remaining capacity of the small capacity file reaches a predetermined amount.
Alternatively, it is provided with a second data transfer means for selecting the data whose access by the second sales data totaling means is interrupted, transferring it to the large capacity file and deleting it from the small capacity file.

[0007]

According to the present invention having such a structure, when sales data of a product is generated, a small capacity file is searched first. Then, when the sales total data of the same product is stored in the small-capacity file, the sales data generated this time is added and updated to the sales total data. If the sales summary data for the same product is not stored in the small file,
Large files are searched. When the sales total data of the same product is stored in the large-capacity file, the sales data generated this time is added and updated after the sales total data is transferred to the small-capacity file. Due to this data transfer, the remaining capacity of the small-capacity file becomes smaller, but when the remaining capacity reaches a predetermined amount, the data for which access due to sales data aggregation has been interrupted is selected from the sales total data stored in the small-capacity file. Is transferred to a large capacity file and deleted from the small capacity file.

Therefore, the sales data of products whose sales frequency is increasing without exceeding the capacity is aggregated in the small-capacity file, and the sales data of other products are aggregated in the large-capacity file.

[0009]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment in which the present invention is applied to a file controller in a POS system will be described below with reference to the drawings.

FIG. 1 is a block diagram showing the overall structure of a POS system, which is a file having a large capacity file 2 and a small capacity file 3 as a storage file for collecting sales data for a plurality of terminals 1 for registering sales merchandise. It is connected to the controller 4 via a communication line 5 such as a LAN (local area network). A host computer 7 is connected to the file controller 4 via a communication line 6 such as a telephone line.

As shown in FIG. 2, the file controller 4 includes a CPU (central processing unit) 41 which constitutes a main body of a control unit, and a ROM (read only memory) which stores program data for controlling each unit by the CPU 41. Memory) 42, a RAM (random access memory) 43 in which various memory areas for storing the data processed by the CPU 41 are formed, a clock circuit 44 for clocking date and time, and a hard disk device 45 are driven to write data. And a hard disk control circuit 46 for controlling reading,
A transmission control circuit 47 for controlling data transmission with each terminal 1 performed via the communication line 5, the communication line 6
It is configured by a transmission control circuit 48 and the like that controls data transmission with the host computer 7 via the.

In the RAM 43, as shown in FIG. 3, in particular, the small-capacity file 3 capable of storing a predetermined number N of records of sales total data including product codes, unit prices, sales points and sales amounts is formed.

The hard disk device 45 is formed with the large-capacity file 2 capable of storing a record of the sales totalization data sufficiently larger than the small-capacity file 3 as shown in FIG.

Therefore, the CPU 41 is program-controlled so as to execute the processing shown in FIG. That is, when the sales data of the product registered for sale at any one of the terminals 1 is received through the communication line 5 as ST (step) 1, the small capacity file 3 formed in the RAM 43 is searched first as ST 2. Here, the product sales data includes the product code, unit price, number of sales, and sales amount. Therefore, in ST3, it is determined whether or not there is a record of the sales total data in which the product code and the unit price in the sales data received in the small capacity file 3 match. (Small file search method)

If there is a corresponding record, the data of the small capacity file 3 is rearranged so that the record becomes the head of the small capacity file 3 as ST4 so that the other records do not change the order, and then ST5. Then, the sales data received this time is added and updated to the first record of the small capacity file 3, and the process returns to ST1. (First means for collecting sales data)

If there is no record corresponding to the small capacity file 3 in ST3, the large capacity file 4 formed in the hard disk device 45 is searched in ST6,
In ST7, it is determined whether or not there is a record of sales total data in which the product code and unit price in the sales data received in the large capacity file 2 match. (Large-capacity file search method)

If the corresponding record exists, it is determined in ST8 whether or not the remaining capacity of the small capacity file 3 is "0", that is, a full state. Then, only in the full state, as ST9, the Nth record, that is, the record of the sales aggregate data stored in the small-capacity file 3 for which access by the sales data is most interrupted is selected, and the content thereof is set to be large. The Nth record is deleted from the small capacity file 3 while writing to the capacity file 4. (Second data transfer means)

Here, when writing data to the large capacity file 4, it is checked whether or not there is data having the same unit price as the product code in the large capacity file 4. If there is the same data, the sales points and sales amount of the data are rewritten, and if the same data does not exist, the corresponding data is newly added.

Next, at ST10, the first record to the (N-1) th record of the small capacity file 3 are sequentially moved from the second record area to the Nth record area. Then, in ST11, in the first record area of the small-capacity file 3 which has become an empty area,
The corresponding record of the large capacity file 2 detected in ST7 is written. (First transfer means) Then, in ST12, the sales data received this time is added and updated to the first record of the small capacity file 3, and the process returns to ST1. (Second sales data counting means)

If there is no record corresponding to the large-capacity file 2 in ST7, it is determined in ST13 whether the remaining capacity of the small-capacity file 3 is "0" or a so-called full state. Only in the full state, the Nth record of the small capacity file 3 is selected in ST14, the contents are written to the large capacity file 4, and the Nth record is deleted from the small capacity file 3. (Second data transfer means)

Next, at ST15, the first record to the (N-1) th record of the small capacity file 3 are sequentially moved from the second record area to the Nth record area. Then, in ST16, in the first record area of the small-capacity file 3 which has become an empty area,
Write the sales data received this time and return to ST1.

In a mass-market store such as a supermarket in which the POS system having the above-mentioned configuration is introduced, the product code and unit price of each product are set in the large-capacity file 2 in advance.
In this case, if the unit price of the same product is different, the data is set as a different product.

In this state, when the product is registered for sale at the terminal 1, sales data including the registered product code, unit price, number of sales, amount of sales, etc. is collected in the file controller 4 via the communication line 5. To be done.

Upon receiving the sales data, the file controller 4 first searches the small capacity file 3. If the sales total data in which the product code and the unit price match is stored in the small-capacity file 3, after moving the sales total data to the first record area of the small-capacity file 3, this data occurs this time. The added sales data is updated.

On the other hand, when the sales total data in which the product code and the unit price match is not stored in the small capacity file 3, the large capacity file 2 is searched next. When the sales total data in which the product code and the unit price match is stored in the large-capacity file 2, the sales total data is transferred to the first record area of the small-capacity file 3, and then this data occurs this time. Update sales data. Sales data that does not exist in the large capacity file 2 is additionally set in the first record area of the small capacity file 3.

As a result, the sales data of the products registered for sale at each terminal 1 are collected and stored in the small-capacity file 3 in order from the latest one. And small file 3
When the capacity of the file is full, the data of the lowest record, that is, the data of which the access to the sales data is most interrupted among the sales total data stored in the small capacity file 3 is selected and transferred to the large capacity file 2. At the same time, it is deleted from the small capacity file 3.

Therefore, in the small-capacity file 3, the sales data of the products that have recently been sold are always tabulated without exceeding the capacity, and the sales tabulation data of the other products that are rarely sold or the sales of which have already been stopped are collected. The sales data of merchandise is collected in the large-capacity file 2.

As described above, according to the present embodiment, when a product for which sales data is already collected in the small-capacity file 3 is newly registered for sale, the file to be searched has a small amount of data and high-speed processing is possible. Since only the small-capacity file 3 is possible, the sales data generated this time can be processed in a short time.

On the other hand, for products for which sales data has not yet been aggregated in the small-capacity file 3, the large-capacity file 2 that has a large amount of data and cannot be processed at high speed is searched. It takes time to count.
However, if the product is registered for sale within the next short period of time, the sales data of the product is already aggregated in the small-capacity file 3, so it is only necessary to search the small-capacity file 3 for a short time. You can complete the aggregation process.

As a result, the sales data of the products whose sales frequency is high can be constantly aggregated in the small-capacity file capable of high-speed processing, and the sales data of the other products can be aggregated in the large-capacity file of low-speed processing. Therefore, it is possible to achieve higher speed processing as compared with the conventional case in which a file for sales data totalization is simply provided with a small capacity file and a large capacity file.

In the above embodiment, the case where the present invention is applied to the file controller 4 of the POS system has been described. However, in a single electronic cash register, the RAM is used.
Besides, the present invention can be applied as long as it has a large-capacity storage medium such as a hard disk device or a floppy disk device.

Further, in the above embodiment, when the small capacity file 3 is full, the data with the most interrupted access is selected and transferred to the large capacity file and deleted. One or more data may be selected, transferred to a large capacity file, and deleted.
Also, the timing of data transfer and deletion from the small capacity file 3 is not limited to before the new setting of new data, but when the remaining capacity becomes a predetermined amount after the additional setting, the data transfer and deletion are performed and empty. Capacity may be secured.

Further, in the above embodiment, the small capacity file 3
The latest sales data is aggregated in the first record of, and the records to be transferred to the large-capacity file 2 can be selected by arranging the data in order from the shortest period after the access is interrupted. It goes without saying that the method of managing the period is not limited to the above-mentioned embodiment. For example, if an area for storing date and time data is provided in the record of the small-capacity file 3 and the current date and time measured by the clock circuit 44 is written in the date and time data area each time sales data is added and updated. ,
You can manage the period after the access is cut off. Besides this,
Needless to say, various modifications can be made without departing from the scope of the present invention.

[0034]

As described above in detail, according to the present invention, the sales data of the products with high sales frequency are aggregated in the small-capacity file capable of high-speed processing, and the sales are performed by the large-capacity file of low-speed processing. Even for products for which data has been tabulated, when sales are made, the data is moved to a small-capacity file and data is tabulated, so it is possible to provide a sales data tabulation device capable of further increasing the processing speed.

[Brief description of drawings]

FIG. 1 is an overall view of a POS system that is an embodiment of the present invention.

FIG. 2 is a block configuration diagram of a file controller in the embodiment.

FIG. 3 is a configuration diagram of a small capacity file provided in the file controller.

FIG. 4 is a configuration diagram of a large-capacity file provided in the file controller.

FIG. 5 is a flowchart showing a main part of a process executed by a CPU of the file controller.

[Explanation of symbols]

1 ... Terminal, 2 ... Large-capacity file, 3 ... Small-capacity file, 4 ... File controller, 5, 6 ... Communication line,
7 ... Host computer, 41 ... CPU, 42 ... RO
M, 43 ... RAM, 45 ... Hard disk device.

Claims (1)

[Claims] 1. A sales data totaling device for classifying and totalizing sales data of registered products for sale in a storage unit, wherein a large-capacity file and a small-capacity file are provided as the storage unit, When data is generated, a small-capacity file search means for searching the small-capacity file to determine the presence or absence of sales aggregate data for the same product, and a small-capacity file search means for determining that there is sales aggregate data for the same product If the first sales data totaling means for adding and updating the sales data generated this time to the sales totalization data and the small capacity file searching means determine that there is no sales totalization data for the same product, the large capacity file is searched for and the same. A large-capacity file search means that determines whether or not there is sales total data for a product, and a sales total If it is determined that there is data, the first data transfer means for transferring the corresponding sales total data to the small capacity file and the sales total data transferred to the small capacity file by the first data transfer means are A second sales data totaling means for adding and updating the generated sales data, and the first or second sales totalizing data stored in the small capacity file when the remaining capacity of the small capacity file reaches a predetermined amount. A sales data totaling device, comprising: second data transfer means for selecting data that has been interrupted by the sales data totaling means, transferring the data to the large capacity file, and deleting the data from the small capacity file.