JP5252010B2 - Data aggregation device and data aggregation program - Google Patents

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 tabulation apparatus of the present case receives the designation of the period and receives data within the period for the period data having a plurality of second periods consisting of a plurality of first periods and a plurality of the first periods. Is a data aggregation device that calculates aggregated data,
The total data of the first period belonging to the second period is sequentially accumulated, and a total data group is created while storing the cumulative data individually for each accumulation, and the total of all of the second period is accumulated. by repeating the creating a cumulative data for a plurality of the second period, cumulative data creation unit a pair of cumulative meter data group and the total cumulative data obtained for each second period to save create multiple When,
Receiving a specified time period for calculating the aggregate data, based on the plurality of accumulated data group and the total cumulative data stored created by the cumulative data creation unit,
When the specified period belongs within one second period, the specified period from the accumulated data obtained by accumulating up to the aggregate data of the last first period of the specified period in the accumulated data group of the second period In addition to creating the aggregate data, the data obtained by subtracting the accumulated data accumulated up to the aggregate data of the first period immediately before the first period of the first,
When the specified period spans a different second period, the previous first period obtained from the cumulative data group of the second period including the first first period of the specified period a first data the cumulative data accumulated up to summary data for the first period obtained by subtracting from the total cumulative data of the second period to the general aggregation of the end of the first period of the specified time period The second data obtained by accumulating the accumulated data obtained from the included accumulated data group up to the last first period, and the total of the second period completely included in the designated period A period total data creation unit that creates data obtained by adding the third data obtained by acquiring the cumulative data as total data;
It is provided with.

Here, the data aggregation unit of the present, is the first period is 1 day, the second period may be I 1 month der.

In addition, the data aggregation program of the present case is executed in an information processing apparatus that executes the program, and the information processing apparatus is divided into a first period that is a unit for specifying a period and a second period that includes a plurality of the first periods. A data totaling program that operates as a data totaling device that calculates total data in which data within a period is totaled in response to designation of a period for period data having a plurality of periods ,
The information processing apparatus is
The total data of the first period belonging to the second period is sequentially accumulated, and a total data group is created while storing the cumulative data individually for each accumulation, and the total of all of the second period is accumulated. by repeating the creating a cumulative data for a plurality of the second period, cumulative data creation unit a pair of cumulative meter data group and the total cumulative data obtained for each second period to save create multiple When,
Receiving a specified time period for calculating the aggregate data, based on the plurality of accumulated data group and the total cumulative data stored created by the cumulative data creation unit,
When the specified period belongs within one second period, the specified period from the accumulated data obtained by accumulating up to the aggregate data of the last first period of the specified period in the accumulated data group of the second period In addition to creating the aggregate data, the data obtained by subtracting the accumulated data accumulated up to the aggregate data of the first period immediately before the first period of the first,
When the specified period spans a different second period, the previous first period obtained from the cumulative data group of the second period including the first first period of the specified period a first data the cumulative data accumulated up to summary data for the first period obtained by subtracting from the total cumulative data of the second period to the general aggregation of the end of the first period of the specified time period The second data obtained by accumulating the accumulated data obtained from the included accumulated data group up to the last first period, and the total of the second period completely included in the designated period A period total data creation unit that creates data obtained by adding the third data obtained by acquiring the cumulative data as total data;
It is made to operate | move as a data totaling apparatus provided with.

Here, also in the present data tabulation program is the first period is 1 day, the second period may be I 1 month der.

According to the present invention, since the above cumulative data group is created in advance regardless of the designation of the period for calculating the total data, the designated period is received in a very short time after the designation of the period. Total 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 year, month, and day 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)

For period data having a plurality of first periods and a plurality of second periods consisting of a plurality of the first periods as a unit for specifying a period, aggregated data obtained by collecting the periods and receiving data for the period is aggregated. A data aggregation device for calculating,
The total data of the first period belonging to the second period is sequentially accumulated, and a total data group is created while storing the cumulative data individually for each accumulation, and the total of all of the second period is accumulated. by repeating the creating a cumulative data for a plurality of the second period, cumulative data creation unit a pair of cumulative meter data group and the total cumulative data obtained for each second period to save create multiple When,
Based on a plurality of cumulative data groups and total cumulative data created and stored in the cumulative data creation unit, in response to designation of a period for calculating the aggregate data,
When the specified period belongs within one second period, the specified period from the accumulated data obtained by accumulating up to the aggregate data of the last first period of the specified period in the accumulated data group of the second period In addition to creating the aggregate data, the data obtained by subtracting the accumulated data accumulated up to the aggregate data of the first period immediately before the first period of the first,
When the specified period spans a different second period, the previous first period obtained from the cumulative data group of the second period including the first first period of the specified period a first data the cumulative data accumulated up to summary data for the first period obtained by subtracting from the total cumulative data of the second period to the general aggregation of the end of the first period of the specified time period The second data obtained by accumulating the accumulated data obtained from the included accumulated data group up to the last first period, and the total of the second period completely included in the designated period A period total data creation unit that creates data obtained by adding the third data obtained by acquiring the cumulative data as total data;
A data aggregation device characterized by comprising: The first period is 1 day, the data collection apparatus of claim 1, wherein said second period is characterized by one month der Rukoto. For period data that is executed in an information processing apparatus that executes a program and that includes a plurality of first periods that are units for specifying a period and a plurality of second periods that are a plurality of the first periods. A data aggregation program that operates as a data aggregation device that calculates the aggregate data in which data within the period is aggregated in response to designation of a period,
The information processing apparatus;
The total data of the first period belonging to the second period is sequentially accumulated, and a total data group is created while storing the cumulative data individually for each accumulation, and the total of all of the second period is accumulated. by repeating the creating a cumulative data for a plurality of the second period, cumulative data creation unit a pair of cumulative meter data group and the total cumulative data obtained for each second period to save create multiple When,
Based on a plurality of cumulative data groups and total cumulative data created and stored in the cumulative data creation unit, in response to designation of a period for calculating the aggregate data,
When the specified period belongs within one second period, the specified period from the accumulated data obtained by accumulating up to the aggregate data of the last first period of the specified period in the accumulated data group of the second period In addition to creating the aggregate data, the data obtained by subtracting the accumulated data accumulated up to the aggregate data of the first period immediately before the first period of the first,
When the specified period spans a different second period, the previous first period obtained from the cumulative data group of the second period including the first first period of the specified period a first data the cumulative data accumulated up to summary data for the first period obtained by subtracting from the total cumulative data of the second period to the general aggregation of the end of the first period of the specified time period The second data obtained by accumulating the accumulated data obtained from the included accumulated data group up to the last first period, and the total of the second period completely included in the designated period A period total data creation unit that creates data obtained by adding the third data obtained by acquiring the cumulative data as total data;
A data totaling program which is operated as a data totaling apparatus including The first period is 1 day, claim 3, wherein the data tabulation program of the second period, wherein 1 month der Rukoto.

Images