JP2541788B2 - Product analysis database equipment - Google Patents

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a product analysis database device that collects and aggregates sales data from POS terminals and stores data for analyzing the sales tendency of each product in a database.

[0002]

2. Description of the Related Art FIG. 4 exemplifies a sales information management data record of a product analysis database used for conventional product analysis.
Referring to the sales information management data record 40,
A store number 411 and a product code 412 are assigned to the index section 41, and monthly sales data are stored in the order of months. When registering or updating the sales data, a required record is searched from the store number and the product code, and the sales data is registered or updated in the corresponding month.

In order to analyze the sales tendency of a product, it is necessary to accumulate data for a long period of time and grasp the time series fluctuation. The sales information management data record described above increases according to the accumulation period, and the database that stores the record also increases. When performing product analysis, in order to grasp the sales data for each product in a time series, it is inevitable that the processing time becomes long due to the increase of the database.

Further, according to Japanese Patent Laid-Open No. 1-233693, it is suitable to store the data of the POS system in the item-based management file, accumulate the date data by using the index, and grasp the time series data. Disclose the file.
However, even in this reference, it is inevitable that the item-based management file will increase according to the data accumulation period.

[0005]

In the process of obtaining the time-series data used for the conventional product analysis described above, it is possible to prevent the database from increasing due to the data accumulation period,
In addition, build a database that does not lengthen the processing time for updating and deleting the database.

[0006]

SUMMARY OF THE INVENTION An object of the present invention is to construct a commodity analysis database that prevents a database for storing aggregated data in time series from increasing in accordance with the accumulation period and prolonging the processing time.

Therefore, in the product analysis database device provided with a database for collecting sales data for each product from the POS terminal of the present invention in the host computer, totalizing the sales data in the management unit period, and storing the totalized data, A means for inputting the aggregated data for each product for each store, a date indicating the management unit period of the aggregated data is converted into a management number, the management number is registered in ascending order, and the number of registered management numbers is predetermined. When the number of items exceeds the number, the first management number registration is deleted, a new management number is replaced and a management table record for cyclic use is created for each product, and the management number and the product code of the product are stored as an index. An index unit, a common information management unit that stores the unique information of the product, and sales data of the management unit period for each store And a means for creating a product-specific record including a store-by-store management table to be registered in order, and a means for creating a product analysis database by storing the management table record and the product-specific record in files. And

[0008]

Next, the present invention will be described with reference to the drawings.

Referring to FIG. 1 showing the configuration of an embodiment of the present invention, a product analysis database device 1 has an input means 3 for inputting store-by-store product-by-product monthly data 2 which is sales total data, and a monthly data. When the management date of the data 2 is converted into a management number, the management number is used as an index number and registered in the management table record 7 in ascending order, and when the management table record 7 overflows due to a predetermined number of registrations, the first management number Management record creating means 4 for erasing the registration location of the management number and registering a new management number at the location, and product record recording means 5 for registering the monthly data of the management number in the product record 8 in ascending order of store numbers. And a record storage unit 6 for storing the management table record 7 and the product-specific record 8 in the product analysis database 9, respectively.

FIG. 2 exemplifying the management table 7
Referring to (a), the management table record 7 is composed of items of the date management table 1 to the date management table N defined by the management unit period, and each item has a date 712,
The date management number 711 that has been converted and used as an index is stored. Referring to FIG. 2B exemplifying the product-specific record 8, an index unit 81 including a date management number 811 and a product code 812, and a common information management unit including unique information such as the product name and type of the product code 81. 82, the store number, sales amount, and quantity of each store are stored in ascending order of store numbers.

Further, referring to FIG. 3 exemplifying the product analysis database system 30 provided with the product analysis database device 1 having the product analysis database 9, each store 31 has a terminal 32 and a POS terminal 32 connected thereto.
1 and 322 are installed, the terminal 32 is connected to the host computer 35 installed in the head office 34 through the communication line 33, and sales data is collected. The host computer 35 aggregates the sales data to generate time-series data for each product, and constructs the product analysis database 9.

Next, the operation of the embodiment shown in FIG. 1 will be described with reference to FIG.
The description will be made with reference to FIG.

Monthly data 2 consisting of a management date, a store number, a product code, a sales amount and a sales quantity is passed to the management record creating means 4 by the input means 3. The management record creating means 4 registers the date management number obtained by converting the management date of the monthly data 2 in the management table record 7 as an index. The number of items in the management table record 7 corresponds to 12 months of the year. When the management table record 7 becomes full with the registration of the date management numbers for 12 months, the new date management number is registered at the first registration point and the already registered date management number is automatically deleted. To be done. Since the management table record 7 is used cyclically, it does not continue to increase according to the accumulation period even when the monthly accumulation exceeds the management unit of the year. This date management number serves as an index of product-specific records for registering monthly data for each product and each store.

Next, the merchandise record creating means 5 creates a merchandise record 8 using the date management number and the merchandise code as an index. The product-specific record 8 stores the aforementioned index in the index unit 81, stores product-specific information in the common information management unit 82, and stores the same monthly sales amount and sales amount in the store management table 83 in the order of store numbers. Stored and created. The merchandise analysis database creating means 6 associates the management table record 7 and the merchandise item record 8 with each other and stores them in files to construct a merchandise analysis database 9.

In product analysis, when acquiring time-series data of sales, it is possible to obtain a date management number from a required monthly date and retrieve a product-specific record to acquire sales of the required product by store. it can.

In the above embodiment, monthly sales data is illustrated, but when monthly time series data is created based on daily data, or when annual time series is extended for a long period of time. Obviously, it can also be applied to the case of obtaining series data.

[0017]

As described above, according to the present invention, the product sales information in the management unit period is collectively recorded as a record for each product, so that the record for each product can be updated more and more stores. However, it can be done by writing once, and an increase in update processing time can be suppressed.

Further, according to the present invention, the date is managed as an index, registered in the management table, and the management table is circulated to prevent the increase of records by merchandise and to add and delete records. Can be suppressed and the update time can be shortened.

[Brief description of drawings]

FIG. 1 is a diagram showing a configuration of an embodiment of the present invention.

2A and 2B are diagrams illustrating a management table record and a product-specific record of FIG. 1, respectively.

FIG. 3 is a diagram illustrating a product analysis database system.

FIG. 4 is a diagram exemplifying a sales information management data record of conventional monthly data.

[Explanation of symbols]

 1 Product Analysis Database Device 2 Store-by-Product Monthly Data 3 Input Means 4 Management Table Record Creating Means 5 Merchandise Record Creating Means 6 Record Storage Means 7 Management Table Records 8 Merchandise Records 9 Merchandise Analysis Databases

Claims (2)

(57) [Claims] 1. A product analysis database device comprising a database for collecting sales data for each product from a POS terminal in a host computer, totaling the sales data in a management unit period, and storing the totalized data. A means for inputting the aggregated data for each product, a date indicating the management unit period of the aggregated data is converted into a management number, the management numbers are registered in ascending order, and the number of registered management numbers is a predetermined number. When the number exceeds, the first management number registration is deleted, a means for creating a management table record for cyclic use by replacing with a new management number, and an index unit for storing the management number and the product code of the product as an index And a common information management unit that stores the unique information of the product, and sales data for each management unit period for each store, which is registered in ascending order of store numbers A product analysis database comprising means for creating a product-specific record including a management table; and means for storing the management table record and the product-specific record in files and creating a product analysis database. apparatus. 2. The merchandise analysis database device according to claim 1, wherein the management unit period is daily, monthly, or yearly.