JP2011108293A - Data tabulation device and data tabulation program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a data tabulation device for storing data to be transmitted at random time, and for, in response to the designation of a period, calculating tabulation data by tabulating the data in the period, and to calculate the tabulation data within the period in a short time in response to the designation of the period. <P>SOLUTION: The data tabulation device is provided with: a cumulative data creation part for creating cumulative data by successively cumulating tabulation data in every first period (per day) as the unit of the designation of a period for calculating tabulation data each time the first period passes until a prescribed second period (a month) composed of a plurality of first periods without waiting for the designation of the period; and a period tabulation data creation part for, in response to the designation of the period for calculating the tabulation data, creating tabulation data within the designated period based on the tabulation data created by the tabulation data creation part. <P>COPYRIGHT: (C)2011,JPO&INPIT

Description

  The present invention stores data transmitted at random times, and receives a designation of a period to calculate aggregated data obtained by aggregating data within the period, and information for executing a program The present invention relates to a data totaling program that is executed in a processing apparatus and causes the information processing apparatus to operate as the data totaling apparatus.

  For example, in a system that handles sales data (POS data) in the retail industry, a large amount of data that occurs every day is taken into the database, and when you want aggregated data for sales within a certain period, specify that period and use the database. Accessing and obtaining aggregated data within that period is performed (see, for example, Patent Document 1).

  As a method for calculating aggregate data in such a system, the following two methods are generally known.

(A) A method of directly accessing the database after a period is specified and totaling data within that period. (B) Every day of the day, the total data for the day is created. When the designation of the period is received, the aggregated data for the period is calculated by collecting the aggregated data for each day in the period and further summing up. However, the POS data in the above-mentioned retail business, etc. Millions of POS data are generated every day at large chain stores, etc. Therefore, in the method (a) above, it takes too much time to specify the period and obtain the aggregated result, and the system handles a huge amount of data. Is essentially unsuitable.

  In addition, since the method (b) only needs to total the number of days in the specified period, the calculation can be completed in a much shorter time than the above (a), but the specified period is long. For example, when a period of 6 months is specified, there is a performance problem in that it takes too much time for aggregation. In particular, the number of categories that are the starting point for analysis, such as the number of product items and the number of stores, tends to increase, and it will take time to calculate the number of categories as the number of categories increases, not just the problem for the specified period. There is a problem that the performance deteriorates accordingly.

Japanese Patent Laid-Open No. 11-250132

  In view of the above circumstances, an object of the present invention is to provide a data totaling apparatus and a data totaling program that can receive a designation of a period and calculate aggregate data within the period in a short time.

The data aggregation device in this case receives and stores the sales data of the store transmitted from the data transmission device installed in the store, receives aggregated data in which data within the period is aggregated in response to a period specification. A data aggregation device for calculating,
A totaling unit that totals sales data for each predetermined first period, which is a unit for specifying a period, and creates sales totaling data;
By summing up the sales summary data for each first period up to the predetermined second period consisting of a plurality of first periods, the total sales accumulated data that has accumulated all during the second period is obtained. By repeating the creation of the cumulative sales data group obtained each time the cumulative total sales data of the first period included in the second period is included, a plurality of obtained data for each second period A cumulative data creation unit that creates and stores sales cumulative data groups;
Based on the multiple sales cumulative data group created and saved in the cumulative data creation unit, receiving the designation of the period for calculating the sales summary data,
When the specified period belongs to one second period, from the accumulated sales data accumulated up to the sales summary data of the last first period of the specified period in the accumulated sales data group of the second period Create data as sales summary data by subtracting the accumulated sales data accumulated up to the sales summary data of the first period immediately before the first period of the specified period,
When the specified period spans different second periods, one of the first first periods obtained from the cumulative sales data group of the second period including the first first period of the specified period Data obtained by subtracting the total sales accumulated data for the second period from the accumulated sales data for the first period until the previous period, and the sales total for the last first period of the specified period A period totaling data creation unit that creates sales totaling data using data obtained by adding up the total sales data obtained from the total sales data group including the data to the last first period;
It is provided with.

  Here, in the data tabulation apparatus of the present case, the first period is one day, the second period is one month, and the cumulative data creation unit is composed of sales total data on the first day of the month. 1st cumulative sales data, 2nd cumulative sales data consisting of the sum of sales summary data on the first and second days of the month, ..., and total cumulative sales data consisting of the sum of sales summary data for the entire month May be created.

In addition, the data aggregation program in this case is executed in an information processing apparatus that executes the program, and the information processing apparatus sequentially stores the sales data of the store transmitted from the data transmission apparatus installed in the store. A data totaling program that operates as a data totaling device that calculates sales totaling data in which sales data within the period is totaled in response to designation of a period,
The information processing apparatus is
A totaling unit that totals sales data for each predetermined first period, which is a unit for specifying a period, and creates sales totaling data;
By summing up the sales summary data for each first period up to the predetermined second period consisting of a plurality of first periods, the total sales accumulated data that has accumulated all during the second period is obtained. By repeating the creation of the cumulative sales data group obtained each time the cumulative total sales data of the first period included in the second period is included, a plurality of obtained data for each second period A cumulative data creation unit that creates and stores sales cumulative data groups;
Based on a plurality of cumulative sales data groups created and stored in the cumulative data creation unit, with the designation of the period for calculating sales summary data,
When the specified period belongs to one second period, from the accumulated sales data accumulated up to the sales summary data of the last first period of the specified period in the accumulated sales data group of the second period Create data as sales summary data by subtracting the accumulated sales data accumulated up to the sales summary data of the first period immediately before the first period of the specified period,
When the specified period spans different second periods, one of the first first periods obtained from the cumulative sales data group of the second period including the first first period of the specified period Data obtained by subtracting the total sales accumulated data for the second period from the accumulated sales data for the first period until the previous period, and the sales total for the last first period of the specified period A period totaling data creation unit that creates sales totaling data using data obtained by adding up the total sales data obtained from the total sales data group including the data to the last first period;
It is made to operate | move as a data totaling apparatus provided with.

  Here, also in the data aggregation program of the present case, the first period is one day, the second period is one month, and the cumulative data creation unit uses the sales aggregation data on the first day of the month. The first cumulative sales data, the second cumulative sales data consisting of the sum of sales summary data for the first and second days of the month, and so on, and the total cumulative sales data consisting of the sum of the total data for the entire month May be created.

  According to the present invention, since the above cumulative data is created in advance regardless of the designation of the period for calculating the aggregated data, after the designation of the period, the specified period of time is extremely short. Aggregated data can be created.

1 is an overall configuration diagram of a system including a data aggregation device of the present invention. It is a hardware block diagram of the computer system which comprises the data totaling apparatus shown in FIG. FIG. 2 is a conceptual diagram of total data created by a total data creation unit shown in FIG. 1 and total data created by a period total data creation unit. It is a figure which shows the content of information DB shown in FIG. It is a total file of August 4, 2004 created from the contents of the information DB shown in FIG. It is a figure which shows the cumulative file of the previous day (August 3, 2004). It is a figure which shows the accumulation file of the day (August 4, 2004). It is a flowchart which shows the process of a total data creation part. It is a figure which shows the display screen in an inquiry terminal. It is a flowchart which shows the process of a period total data creation part. It is a figure which shows a process when there is correction of the past sales data from a POS system.

  Hereinafter, embodiments of the present invention will be described.

  FIG. 1 is an overall configuration diagram of a system including a data totaling apparatus according to the present invention.

  A data totaling apparatus 100 shown in the center of FIG. 1 is composed of a computer system having a schematic configuration shown in FIG. 2 to be described later, and a POS system 201 installed in many stores via a communication network 600, , 20n, and also connected to a plurality of inquiry terminals 301, 302,..., 30m via the communication line network 600. These POS systems 201, 202,..., 20n and inquiry terminals 301, 302,..., 30m are each configured by the same computer system as in FIG. However, in the POS system 201, 202,..., 20n, for example, a keyboard is a keyboard specialized for a POS system, unlike a general-purpose computer keyboard, and a barcode for reading a barcode attached to a product. The function is specialized for the POS system, such as a reader attached. In addition, although the inquiry terminals 301, 302,..., 30m are shown separately from the POS system here, focusing on the functions, they may be the same device as the POS system, or may be separated from the store, such as a management center. It may be a computer system installed in the computer.

  Since the subject here is the data totalization apparatus 100, further explanation about the POS systems 201, 202,..., 20n and the inquiry terminals 301, 302,.

  FIG. 2 is a hardware configuration diagram of a computer system that constitutes the data totaling apparatus 100 shown in FIG.

  This hardware configuration diagram shows CPU 111, RAM 112, hard disk controller 113, FD drive 114, CD / DVD drive 115, mouse controller 116, keyboard controller 117, display controller 118, and communication board 119. Are connected to each other by a bus 110.

  The FD drive 114 and the CD / DVD drive 115 are loaded with the FD 710, CD, or DVD 700, respectively, and access the loaded FD 710, CD, or DVD 700. The communication board 119 is connected to the communication line 600.

  2 also shows the hard disk 120 accessed by the hard disk controller 113, the mouse 104 controlled by the mouse controller 116, the keyboard 103 controlled by the keyboard controller 117, and the display 102 controlled by the display controller 118. ing.

  Returning to FIG. 1, the description will be continued.

  A data totaling apparatus 100 shown in FIG. 1 is a data totaling apparatus constructed in the computer system using the hardware resources shown in FIG. 2, and here, the following processing is performed.

  Sales data is transmitted from the multiple POS systems 201, 202,..., 20n via the communication network 600 at random times. The data totaling apparatus 100 sequentially stores the sales data in the basic DB (database) 10 every time it receives the sales data. This sales data is information of one record (one horizontal row) in FIG. 4 described later, that is, the store name, product name,..., Sales date, sales amount, sales number of the store that has transmitted the sales data. And so on.

  Sales data is stored in the core DB 10 at random times, but without interruption, so the sales data for the day is transferred to the information DB 20 at the end of the day (24:00) for the creation of cumulative data. The accumulated data creating unit 30 creates accumulated data while referring to the contents of the information DB 20 and stores the accumulated data in the accumulated data file 40. The process from transferring sales data for one day from the basic DB 10 to the information DB 20 to creating cumulative data and storing it in the cumulative data file accumulates sales data that is randomly transmitted once a day in the basic DB 10. It is executed as a background process of the process to be performed.

  When the total data creation request specifying the period is received from any of the inquiry terminals 301, 302,..., 30m via the communication network 600, the period total data creation unit 50 refers to the cumulative data file 40. Total data for the designated period is created and stored in the total data file 60. Thereafter, the data totaling apparatus 100 transmits the totaled data file 60 to the inquiry terminal that requested the totaled data creation request.

  The above is the overall flow of processing in the data tabulation apparatus 100. Here, the basic DB 10, the information DB 20, the cumulative data file 40, and the total data file 60 are databases or data files constructed in the hard disk 120 shown in FIG. Reference numeral 50 denotes a program component executed by the CPU 111.

  Details of these will be described later.

  FIG. 3 is a conceptual diagram of the total data created by the total data creation unit 30 shown in FIG. 1 and the total data created by the period total data creation unit 50.

  Here, the data for one month of August 2004 is taken up, and the data for one day of August 1 (cumulative data) at the end of August 1, 2004 (when it was August 2) Is created, and August 2nd, 2004 is completed. The cumulative data for 2 days is created by adding the August 1st cumulative to the August 1st cumulative. Cumulative data is created by adding the current day's total to the previous day's total until the day.

  Here, cumulative data for only one day on August 1, two-day cumulative data for August 1 and August 2, cumulative data for three days from August 1 to August 3, ..., August All the cumulative data for 31 days from 1st to 31st are saved.

  Here, August 2004 is taken up and explained. When the process moves to September 2004, the same aggregated data as in FIG. 3 is created sequentially from the first day of September.

  The accumulated data file 40 in FIG. 1 stores accumulated data as shown in FIG. 3 every day.

  Here, when there is a total data creation request from August 6, 2004 to August 26, 2004 from the inquiry terminal, the period total data creation unit 50 shown in FIG. 1 refers to the cumulative data file 40. , Cumulative data for the last day (August 26) of the specified period (August 6, 2004 to August 26, 2004) and the day before the first day (August 6) of the specified period Total data for (August 5) is taken out, and the difference between the two total data is calculated to calculate the total data for that period (August 6 to 26).

  In the present embodiment, basically, it is possible to obtain aggregate data for a specified period in a very short time by such a simple calculation.

  More specific description will be given below.

  FIG. 4 is a diagram showing the contents of the information DB 20 shown in FIG.

  Here, sales data as of August 4, 2004 is taken as an example.

  FIG. 5 is a summary data file of August 4, 2004 created from the contents of the information DB shown in FIG.

  Here, aggregate data is created in which the contents of the information DB shown in FIG. 4 are summarized for each store by product.

  FIG. 6 is a diagram showing a cumulative data file of the previous day (August 3, 2004).

  Here, the sales amount and the number of sales are recorded for each store and each product as a cumulative total of August 1, 2, 3 and 2004.

  FIG. 7 is a diagram showing a cumulative data file on the current day (August 4, 2004).

  The total data file for the day shown in FIG. 5 is added to the total data file for the day shown in FIG.

  FIG. 8 is a flowchart showing the processing of the cumulative data creation unit.

  First, the date of the current day, which day, what month, and what day is acquired from the calendar function in the computer program constituting the data totaling apparatus 100 (step a1), and the total data file for the current day is created (step a2). .

  As described above, FIG. 5 shows, as an example, a total data file on the day of August 4, 2004.

  Next, it is determined whether the current day (today) is one day, that is, the first day of the month (step a3). In the case of the first day of the month, the total data file of the day can be used as it is as the cumulative data file of the day, so the process proceeds to step a7, where the cumulative data file name is created and the cumulative data file is saved ( Step a8).

  Here, the cumulative file name in step a7 is, for example, the same as “accumulated file name for each store, sold separately by product_20040804”, which shows the cumulative file name of the cumulative file on August 4, 2004 in FIG. .

  In step a3, if the current day is not the first day of the month, the process proceeds to step a4 to obtain the previous day's cumulative data file (see FIG. 6), the current day's total data file (see FIG. 5) and the previous day's cumulative data. The key items are matched with the file (see FIG. 6) (step a5), and the data is merged (added) (step a6). The cumulative data file (see FIG. 7) is given a cumulative file name (step a7), and the cumulative data file is stored (step a8).

  Next, a description will be given of a scene in which a period is specified and total data within the period is created.

  FIG. 9 is a diagram showing a display screen in the inquiry terminal.

  When a period is specified from any of the inquiry terminals 301, 302,..., 30m shown in FIG. 1 and the creation of aggregate data within that period is requested, the inquiry terminal displays the screen shown in FIG. Then, enter the period on the display screen and click the “form display” button. Then, an aggregate data creation request for the specified period is transmitted from the inquiry terminal to the data aggregation device 100 via the communication network 600 (see FIG. 9).

  FIG. 9B is a screen based on the total data created based on the total data creation request transmitted from the data totaling apparatus 100.

  Here, it is assumed that the period from April 21, 2004 to June 20, 2004 is designated, and FIG. 9B shows the number of sales and the number of goods by store and product within the designated period. Has been.

  FIG. 10 is a flowchart showing the processing of the period totaling data creation unit.

  Here, a specified period is acquired (step b1), a cumulative file on the day before the start date of the specified period is acquired (step b2), and a cumulative file on the end date of the specified period is acquired (step b3). .

  Here, as an example, it is assumed that April 21, 2004 to June 20, 2004 is designated. At this time, in step b2, a cumulative data file of “sales by store / product sales — 200404020” is acquired, and in step b3, a cumulative data file of “sales by store / product sales — 20040620” is acquired. Next, it is determined whether the start date and end date of the specified period belong to the same year or month (step b4). If the year and month are different, the last day of every month in the specified period. Are accumulated (step b5), and this is repeated for the number of months included in the designated period. Here, the cumulative data file of “Sales by store / product-by-product_2004040” and “Sales by store / product-by-product_20040531” corresponds to this.

  Next, key items are matched (step b6) and data are merged (step b7) with respect to the cumulative file extracted in this manner, and this is performed for all the data items and for all the months included in the designated period. The total data file for the designated period is created and saved (step b8).

  The data tabulation device 100 (see FIG. 1) transmits the period tabulation data file created and stored in this way to the inquiry terminal that has made the tabulation data file creation request. The inquiry terminal receives the total data file and displays the total data as shown in FIG. 9B based on the total data file.

  FIG. 11 is a diagram illustrating processing when past sales data is corrected from the POS system.

  For example, at the time when the cumulative data on September 5, 2004 has been created, sales have been updated on September 3, 2004, and as a result, the difference indicated by the hatched lines in FIG. In the case where a change occurs by the amount of the file, the difference is reflected not only in the cumulative total of 3 days but also in all the cumulative data after that date, that is, in this case, the cumulative data on the 4th and 5th days. In this way, the cumulative concept described here can flexibly cope with correction of sales data. Sales data may be updated when, for example, the POS system becomes temporarily defective and sales data is input at a later date, or when sales are returned after being recorded as sales once.

According to the above embodiment,
-Inquiring directly to the database is better than simply adding daily data.

  -Since the file for each day is held, it is easy to manage by giving the date of the date to the file name (for example, sales data — 20040826.csv).

  -Accumulated results can be output by combining the data up to the day, so it is highly prompt.

  -Since the cumulative file itself uses the file up to the previous day, it is only necessary to query the database for the data of the cumulative day, so it can be created quickly, and you can create cumulative files with more patterns by night batch processing. it can.

・ Effects are reduced when data is updated.
There are various merits.

10 Core DB
20 Information DB
30 Total Data Creation Unit 40 Cumulative Data File 50 Period Total Data Creation Unit 60 Total Data File 100 Data Total Device 111 CPU
120 Hard disk 201, 202, ..., 20n POS system 301, 302, ..., 30m Inquiry terminal 600 Communication line

Claims (4)

A data aggregation device that receives and stores sales data of the store transmitted from the data transmission device installed in the store, calculates aggregate data in which data within the period is aggregated in response to a period specification. And
A totaling unit that totals sales data for each predetermined first period as a unit for specifying the period to create sales total data;
Total sales accumulation data that is accumulated for all of the second period by sequentially accumulating the sales aggregation data for each first period until the predetermined second period consisting of a plurality of the first periods. A plurality of data obtained for each second period by repeatedly creating a cumulative sales data group obtained each time the cumulative sales data of the first period included in the second period including A cumulative data creation unit that creates and stores the cumulative sales data group for
Based on a plurality of cumulative sales data groups created and stored in the cumulative data creation unit, in response to designation of a period for calculating the sales summary data,
When the specified period belongs to one second period, from the accumulated sales data accumulated up to the sales summary data of the last first period of the specified period in the accumulated sales data group of the second period Create data as sales summary data by subtracting the accumulated sales data accumulated up to the sales summary data of the first period immediately before the first period of the specified period,
When the specified period spans different second periods, one of the first first periods obtained from the cumulative sales data group of the second period including the first first period of the specified period Data obtained by subtracting the total sales accumulated data for the second period from the accumulated sales data for the first period until the previous period, and the sales total for the last first period of the specified period A period totaling data creation unit that creates sales totaling data using data obtained by adding up the total sales data obtained from the total sales data group including the data to the last first period;
A data aggregation device characterized by comprising:   The first period is one day, the second period is one month, and the cumulative data creation unit is configured to generate first sales cumulative data including sales summary data on the first day of the month, the month The second sales accumulation data that consists of the sum of the sales summary data of the first day and the second day of ......, and total sales accumulation data that consists of the sum of the sales summary data for the entire month The data totaling apparatus according to claim 1. The information processing apparatus is executed in the information processing apparatus that executes the program. The information processing apparatus sequentially stores the sales data of the store transmitted from the data transmission apparatus installed in the store, and receives the designation of the period. A data aggregation program that operates as a data aggregation device that calculates sales aggregation data in which sales data within a period is aggregated,
The information processing apparatus;
A totaling unit that totals sales data for each predetermined first period as a unit for specifying the period to create sales total data;
Total sales accumulation data that is accumulated for all of the second period by sequentially accumulating the sales aggregation data for each first period until the predetermined second period consisting of a plurality of the first periods. A plurality of data obtained for each second period by repeatedly creating a cumulative sales data group obtained each time the cumulative sales data of the first period included in the second period including A cumulative data creation unit that creates and stores the cumulative sales data group for
Based on a plurality of cumulative sales data groups created and stored in the cumulative data creation unit, in response to designation of a period for calculating the sales summary data,
When the specified period belongs to one second period, from the accumulated sales data accumulated up to the sales summary data of the last first period of the specified period in the accumulated sales data group of the second period Create data as sales summary data by subtracting the accumulated sales data accumulated up to the sales summary data of the first period immediately before the first period of the specified period,
When the specified period spans different second periods, one of the first first periods obtained from the cumulative sales data group of the second period including the first first period of the specified period Data obtained by subtracting the total sales accumulated data for the second period from the accumulated sales data for the first period until the previous period, and the sales total for the last first period of the specified period A period totaling data creation unit that creates sales totaling data using data obtained by adding up the total sales data obtained from the total sales data group including the data to the last first period;
A data totaling program which is operated as a data totaling apparatus including   The first period is one day, the second period is one month, and the cumulative data creation unit is configured to generate first sales cumulative data including sales summary data on the first day of the month, the month The second sales cumulative data that consists of the sum of the sales summary data of the first day and the second day of ......, and the total sales cumulative data that consists of the sum of the total data for the entire month The data totalizing program according to claim 3.

Images