JP2008015806A - Accumulation method, accumulation device and computer program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide an accumulation method and accumulation device which are correspondable even when types are changed during an accumulation period in the case of accumulating transaction contents of a transaction database for recording transaction contents while associated with identification information of a transaction object with reference to a type table for recording types of transaction objects shown by the identification information, and to provide a computer program. <P>SOLUTION: When changing types, a first type of a transaction object shown by first identification information, second type of the transaction object previously shown by the first identification information and a change time of types for the first identification information are recorded in the type table. The accumulation device 1 compares sales dates of transaction contents recorded in the transaction database with change dates of the type table, accumulates the sales dates as transaction contents of types after the change dates (S5) when the sales dates are after the change dates (S4: YES), and accumulates the sales dates as transaction contents of types before the change dates (S6) when the sales dates are before the change dates (S4: NO). <P>COPYRIGHT: (C)2008,JPO&INPIT

Description

  The present invention reads a transaction content from a transaction database that records transaction content including transaction time in association with identification information for identifying a transaction object, and a type table that records the type of transaction target indicated by the identification information of the transaction database. With reference to a counting method using a counting device for counting and referring to read transaction contents based on the type of transaction target, a counting device to which the counting method is applied, and a computer program for realizing the counting device, particularly for each type The present invention relates to a totaling method, a totaling apparatus, and a computer program that are used for totaling transaction details.

  A transaction database that records transaction details including transaction time such as sales time in association with identification information (product number) for identifying a transaction object such as a television, and a transaction object type (product type) indicated by the identification information of the transaction database. A system that includes a type table (product type master) to be recorded, reads transaction contents for each type, for example, sales results of plasma televisions from a transaction database, and totals them is used for sales result management.

  The types that are recorded in the transaction database in association with the identification information are switched as necessary for the sales management strategy of the business. For example, when the transaction target is a television, the totals that were divided into a category indicating a normal television and a category indicating a flat-screen television are classified into a category indicating a plasma television and a category indicating a liquid crystal television. It can be switched according to changes in sales status.

As a system for changing the contents to be recorded in the database, for example, Patent Document 1 discloses a system for changing an address as a delivery destination of a delivery according to a user's move.
JP 2002-24346 A

  However, if the type associated with the identification information is changed during the predetermined aggregation period, different types associated with the same identification information are recorded in the transaction database. There is a problem that it is impossible to perform aggregation processing such as aggregation for the purpose of analyzing changes in accompanying transactions.

  In the invention disclosed in Patent Document 1, processing such as counting for each address is not assumed, so the above-described problems cannot be solved.

  The present invention has been made in view of such circumstances, and in the type table, the first type of the transaction target indicated by the first identification information, and the first type of the transaction target previously indicated by the first identification information. By recording the type 2 change time and the type change time for the first identification information, even if the type associated with the identification information is changed during the totaling period, the change in transactions associated with the totaling and type switching for each type It is an object of the present invention to provide a totaling method capable of dealing with various tabulations such as tabulation for the purpose of analysis, a tabulation device to which the tabulation method is applied, and a computer program for realizing the tabulation device.

  The tabulation method according to the first invention reads transaction contents from a transaction database that records transaction contents including transaction time in association with identification information for identifying transaction objects, and sets the transaction object type indicated by the identification information of the transaction database. In the tabulation method using the tabulation device that tabulates the read transaction contents based on the type of transaction target with reference to the type table to be recorded, the type table includes the first type of transaction target indicated by the first identification information , And the second classification of the transaction target previously indicated by the first identification information and the classification change time for the first identification information are recorded, and the aggregation device reads the transaction timing read from the transaction database. The transaction details that are after the change time are aggregated as the first type of transaction details, and the transaction time read from the transaction database is before the change time. The transaction contents, characterized by aggregate as a transaction contents of the second type.

  The tabulation device according to the second invention reads transaction contents from a transaction database that records transaction contents including transaction time in association with identification information for identifying transaction objects, and sets the transaction object type indicated by the identification information of the transaction database. In the aggregation device that refers to the type table to be recorded and totals the read transaction contents based on the type of transaction target, the type table includes the first type of transaction target indicated by the first identification information, and the first type The identification information is configured to record the second type of the transaction target previously indicated and the change time of the type for the first identification information, and the transaction time read from the transaction database is after the change time. Means for counting transaction contents as the first type of transaction contents, and transaction contents whose transaction time read from the transaction database is earlier than the change time. Characterized in that it comprises a means for aggregate as a transaction contents of the second type.

  A tabulation device according to a third aspect of the present invention relates to a transaction database that records transaction details including transaction time in association with identification information that identifies a transaction object, and a type table that records a transaction object type indicated by the identification information of the transaction database. The transaction table recorded in the transaction database based on the type recorded in the type table, wherein the type table is the transaction target number indicated by the first identification information. 1 type, and the second identification type of the transaction object previously indicated by the first identification information and the change timing of the type for the first identification information are recorded and recorded in the transaction database. Means for aggregating transaction contents whose transaction period is after the change period as transaction contents of the first type, and at the time of transaction recorded in the transaction database There the transaction contents is prior timing shift, characterized in that it comprises a means for aggregate as a transaction contents of the second type.

  A computer program according to a fourth invention causes a computer to read transaction contents from a transaction database that records transaction contents including transaction time in association with identification information for identifying a transaction object, and the transaction information indicated by the identification information of the transaction database In a computer program that refers to a type table that records the type of a target and totals the read transaction contents based on the type of the target of transaction, the computer has a first type of transaction target indicated by the first identification information, In addition, the first identification information is recorded in the transaction database with reference to the type table in which the second type of the transaction target previously indicated and the change time of the type with respect to the first identification information are recorded. A procedure for counting transaction contents whose transaction time is after the change time as the first type of transaction contents; The transaction content recorded in the transaction database before the change time is counted as a second type of transaction content with reference to the type table. And

  In the present invention, when the type associated with the identification information is changed, the type before and after the change and the change time are recorded in the type table, so that the total for each type before and after the change, the change of the transaction accompanying the type switching It is possible to cope with various tabulations such as tabulation for the purpose of analysis.

  A tabulation method, a tabulation device, and a computer program according to the present invention read transaction details from a transaction database that records transaction details including transaction time in association with identification information for identifying a transaction target, and the identification information of the transaction database indicates A totaling device is used that refers to a type table that records the type of transaction target and totals the read transaction contents based on the type of transaction target. Then, the counting device is configured to change the first type of the transaction target indicated by the first identification information, the second type of the transaction target previously indicated by the first identification information, and the type change timing for the first identification information. Are recorded in the type table, the transaction contents read from the transaction database after the change time are totaled as the first type of transaction contents, and the transaction time read from the transaction database is calculated from the change time The previous transaction content is totaled as the second type of transaction content.

  With this configuration, in the present invention, for a change in the type associated with the identification information during the counting period, for example, for a change from a normal television to a liquid crystal television, the transaction contents for each type before and after the change are changed and the type is switched. There are excellent effects such as being able to cope with various tabulations such as tabulation for the purpose of analyzing changes in accompanying transactions.

  Hereinafter, the present invention will be described in detail with reference to the drawings illustrating embodiments thereof. FIG. 1 is a block diagram showing a configuration example of a counting device according to the present invention. In FIG. 1, reference numeral 1 denotes a totaling device of the present invention using a computer such as a general-purpose computer. The totaling device 1 reads the transaction contents such as the sales situation related to a transaction target such as a television, and stores the read transaction contents. Support the implementation of measures such as sales management strategy for sales based on tabulation.

  The aggregation device 1 includes a control means 10 such as a CPU (Central Processing Unit) that controls the entire device, a computer program 2 for the aggregation device, and a CD-ROM (Compact Disc Read Only Memory) that records various information such as data. Auxiliary storage means 11 such as a CD-ROM drive for reading various information from the recording medium 3, a recording means 12 such as a hard disk for recording various information read by the auxiliary storage means 11, and a RAM (temporarily storing information) And a storage means 13 such as a random access memory. Then, the computer program 2 recorded in the recording means 12 is stored in the storage means 13 and executed by the control of the control means 10, whereby the computer operates as the counting device 1 of the present invention.

  Further, the counting device 1 includes input means 14 such as a mouse and a keyboard, and output means 15 such as a monitor and a printer.

  A part of the recording area of the recording means 12 is a transaction database (transaction DB) 12a that records transaction details that are the transaction results in association with identification information such as a product number that identifies a transaction object, and identification information of the transaction database 12a Is used as a type table (type TBL) 12b that is used as a product type master for recording the type of transaction target indicated by, and the tabulation device 1 reads and writes the recorded contents in the transaction database 12a and the type table 12b. Is possible.

  In the configuration example shown in FIG. 1, an example is shown in which one aggregation device 1 that operates as a stand-alone device is used. However, the present invention is not limited to this, and a server client system in which functions are distributed to a plurality of devices. You may make it implement | achieve the totaling device 1 of this invention with this system. In the configuration example shown in FIG. 1, the example in which the aggregation device 1 includes the transaction database 12a and the type table 12b is shown. However, the present invention is not limited thereto, and the aggregation device 1 includes the transaction database 12a and the type table 12b. If it is possible to read and write the recorded contents with respect to the data, another recording device such as a database server computer is connected to the counting device 1, and the transaction database 12a and / or the type table 12b is provided in another recording device. You may do it.

  FIG. 2 is an explanatory diagram conceptually showing an example of the recorded contents of the transaction database 12a provided in the tabulation apparatus 1 of the present invention. The transaction database 12a includes items such as a sales office, a supplier, a customer, a factory, a sales date, a sales quantity, a sales price, a sales unit price, and the like as a transaction content related to a transaction object associated with the identification information (product number). Is recorded in record units. The identification information is associated with the transaction target type recorded in the type table 12b. Sales offices, suppliers, customers, factories, sales dates, sales volumes, sales prices, and sales unit prices indicate the results of production and transactions subject to transactions. For example, sales dates indicate transactions as sales. Shows the time when

  FIG. 3 is an explanatory diagram conceptually showing an example of the recorded contents of the type table 12b provided in the counting device 1 of the present invention. The type table 12b of the present invention can change the type associated with the identification information during a predetermined counting period. FIG. 3A shows an example of the type table 12b when the type is not changed, and FIG. 3B shows an example of the type table 12b when the type is changed.

  In the type table 12b illustrated in FIG. 3A, data relating to items such as type 1 and type 2 is recorded in record units in association with identification information (product number). The item of identification information corresponds to the identification information in the transaction database 12a. As type 1, data indicating the type of transaction target is recorded, and as type 2, data indicating the type of transaction target obtained by subdividing type 1 is recorded. In the example of FIG. 3A, the type 1 of the identification information “1” is “TV” and the type 2 is “normal”. The type 1 of the identification information “2” is “TV”, and the type 2 is “Hi-Vision”. In the example shown in FIG. 3A, the transaction target is shown in two stages of type 1 and type 2, but may be one stage or three or more stages. Furthermore, in the type table 12b, items such as a change date and a pre-change type 2 are provided in association with the identification information. However, when the type is not changed, these items are blank.

  In the type table 12b illustrated in FIG. 3B, data relating to items such as type 1, type 2, change date, type 2 before change, and the like is recorded in record units in association with identification information. In the type table 12b shown in FIG. 3B, the type 2 of the identification information “1” is changed from “normal” to “liquid crystal”, and the type 2 of the identification information “2” is changed from “high vision” to “plasma”. Has been changed. For example, when considering the sales strategy of TV, it is not an example of whether it is a high-definition TV, but an example of a change when it is important to check the sales status for each type of liquid crystal TV, plasma TV, etc. . In the item of change date, the date (year / month in FIG. 3) when the content of type 2 is changed is shown. In the item of type 2 before change, type 2 before change, that is, “normal”, Data such as “Hi-Vision” is shown. In the example of FIG. 3B, the type 2 of the identification information “1” is changed from “normal” to “liquid crystal” in February 2004.

  If the type is changed twice or more, a new item indicating the previous type and date may be provided in the type table 12b. However, if the type of the type table 12b is fixed, a new type is displayed. The table 12b may be generated, and the previous type table 12b may be separately stored in the recording unit 12 as a referable reference indicating past changes.

  Next, processing of the counting device 1 of the present invention will be described. FIG. 4 is a flowchart showing an example of the counting process of the counting device 1 of the present invention. Here, a description will be given of a method of totaling transaction contents recorded in the transaction database 12a by specifying a total key in a situation where the type of recorded contents in the type table 12b is changed as shown in FIG. 3B. To do. An operator who operates the totaling apparatus 1 performs input specifying, for example, identification information “1” as a totaling key related to the totaling process. The tabulation device 1 tabulates records whose identification information data is “1” by tabulation processing. However, since the type 2 of the record whose identification information in the type table 12b is “1” is changed from “normal” to “liquid crystal” before and after the change date, the data of type 2 is changed in the first tabulation process. The records are “normal” and “liquid crystal”.

  The tabulation device 1 receives input of a tabulation key from the input unit 14 under the control of the control unit 10 that executes the computer program 2 (step S1), and whether or not the tabulation object is to be tabulated in the current process from the transaction database 12a. One record that has not been determined is read into the storage means 13 (step S2), and it is determined whether or not the data of the identification information of the read record is “1” to be counted (step S3). In step S2, a record that has not been determined whether or not to be counted is a record that has not been subjected to the determination process shown in step S3.

  In step S3, when it is determined that the data of the identification information is “1” to be aggregated (step S3: YES), the aggregation device 1 indicates the sales date of the read record as the change date of the type table 12b. To determine whether the sales date is after the change date (step S4).

  If it is determined in step S4 that the sales date is after the change date (step S4: YES), the counting device 1 determines the sales office, supplier, customer, factory, sales date indicated in the read record. The transaction contents such as the sales quantity, the sales amount, the sales unit price, etc. are tabulated as transaction contents related to the type 2 after the change date, that is, “liquid crystal” (step S5).

  If it is determined in step S4 that the sales date is before the change date (step S4: NO), the counting device 1 determines the sales office, supplier, customer, factory, sales year indicated in the read record. Transaction details such as month, sales quantity, sales price, and sales unit price are aggregated as transaction details related to type 2, that is, “normal” before the change date (step S6).

  The tabulation in step S5 and step S6 indicates tabulation for analyzing a tendency of sales performance such as integration of data for each item in record units.

  After the aggregation in step S5 or step S6, the aggregation device 1 determines whether or not a record that has not yet been determined whether or not to be an object of aggregation in the current process is recorded in the transaction database 12a (step S7). ).

  If it is determined in step S7 that an undetermined record is recorded (step S7: YES), the counting device 1 returns to step S2 and repeats the subsequent processing. That is, the process of step S3-step S6 is performed with respect to all the records currently recorded on the transaction database 12a.

  If it is determined in step S7 that an undetermined record has not been recorded (step S7: NO), the counting device 1 outputs the result of counting as “liquid crystal” and “normal” from the output means 15 (step S8). ).

  In step S3, when it is determined that the identification information data is not a target of aggregation (step S3: NO), the aggregation device 1 proceeds to step S7 and still determines whether or not it is a target of aggregation in the current process. It is determined whether an unrecorded record is recorded in the transaction database 12a (step S7).

  In the example described with reference to FIG. 4, in the recorded contents of the transaction database 12 a, the transaction target related to the specified identification information is totaled for each type. However, the identification information and the type are specified and totalized. You may do it. Specifically, by specifying the identification information “1” and the type 2 “liquid crystal”, the identification information is “1” and the type 2 determined based on the change date of the type table 12b is “liquid crystal”. It is possible to aggregate only the transaction contents that are. In addition, when the identification information and type are specified and aggregation is performed, not all information included in the record is read, but only the identification information and type 2 data are read, and the identification information and type 2 data match. By reading only the transaction content, it is possible to reduce the amount of data to be read and speed up the processing.

  In addition, when the type is changed over a plurality of times, a totaling process is performed according to the type determined based on each change time.

  FIG. 5 is an explanatory diagram conceptually showing an example of a totaling result of the totaling apparatus 1 of the present invention. FIG. 5 (a) conceptually shows an aggregation status based on the recorded contents of the transaction database 12a shown in FIG. 2, and the recorded contents of the first, third and fourth records from the top are type 2 “normal”. ”And the recorded contents of the fifth and sixth records from above are totaled as the transaction contents related to type 2“ liquid crystal ”.

  FIG. 5B shows the total result of “sales quantity” and “sales amount” for each type. The example shown in FIG. 5 (b) shows the result of accumulating numerical values as the aggregation results, and by comparing the “sales quantity” and “sales amount” of the aggregation results, the sales volume growth rate, etc. It is possible to compare and analyze the changes related to the transactions and analyze the sales situation, and thereby to plan and execute a sales management strategy related to sales. It should be noted that the present invention can be applied to various tabulation processes other than the comparison of integration results.

  In the said embodiment, although the form which totals the sales performance of a television was shown as a transaction performance of transaction object, this invention is not restricted to this, It is possible to make various goods and services into transaction object. For example, commodities such as personal computers and automobiles may be dealt with, and the present invention may be applied to aggregation of provision of services such as passenger transportation by aircraft.

It is a block diagram which shows the structural example of the totaling apparatus of this invention. It is explanatory drawing which shows notionally an example of the recording content of the transaction database with which the totaling device of this invention is provided. It is explanatory drawing which shows notionally an example of the recording content of the classification table with which the totaling device of this invention is provided. It is a flowchart which shows an example of the total process of the total apparatus of this invention. It is explanatory drawing which shows notionally an example of the total result of the total device of this invention.

Explanation of symbols

1 Aggregation device 12a Transaction database 12b Type table

Claims (4)

Read transaction contents from a transaction database that records transaction contents including transaction time in association with identification information for identifying transaction objects, and refer to a type table that records the types of transaction objects indicated by the identification information of the transaction database. In a counting method using a counting device that counts the transaction details based on the type of transaction target,
The type table is
The first type of the transaction target indicated by the first identification information, the second type of the transaction target previously indicated by the first identification information, and the change timing of the type for the first identification information are recorded. ,
The counting device is
The transaction content read from the transaction database is the transaction content after the change time, and is aggregated as the first type of transaction content,
Summarizing transaction contents whose transaction time read from the transaction database is earlier than the change time as a second type of transaction content. Read transaction contents from a transaction database that records transaction contents including transaction time in association with identification information for identifying transaction objects, and refer to a type table that records the types of transaction objects indicated by the identification information of the transaction database. In the aggregation device that aggregates the transaction details based on the type of transaction target,
The type table includes the first type of the transaction target indicated by the first identification information, the second type of the transaction target previously indicated by the first identification information, and the change timing of the type for the first identification information. Is configured to record,
Means for counting the transaction content read from the transaction database after the change time, as a first type of transaction content;
A tally device comprising: a means for tallying transaction contents read from the transaction database before a change time as a second type of transaction contents. A transaction database that records transaction details including transaction time in association with identification information that identifies a transaction target, and a type table that records the type of transaction target indicated by the identification information of the transaction database are recorded in the transaction database. In a counting device that counts the transaction details that have been made based on the type recorded in the type table,
The type table includes the first type of the transaction target indicated by the first identification information, the second type of the transaction target previously indicated by the first identification information, and the change timing of the type for the first identification information. Is configured to record,
Means for aggregating transaction contents recorded in the transaction database after the change period as transaction contents of the first type;
A counting device comprising: means for counting the transaction contents recorded in the transaction database before the change time as the second type of transaction contents. A type table for recording the type of transaction target indicated by the identification information of the transaction database, having the computer read the transaction content from the transaction database that records the transaction content including the transaction time in association with the identification information for identifying the transaction target With reference to the computer program that causes the read transaction content to be totaled based on the type of transaction target,
The computer records the first type of the transaction target indicated by the first identification information, the second type of the transaction target previously indicated by the first identification information, and the change timing of the type for the first identification information. The transaction table recorded in the transaction database is referred to as the transaction content of the first type, with reference to the type table,
And causing the computer to refer to the type table, and to cause the transaction content recorded in the transaction database to be aggregated as transaction content of the second type of transaction content before the change time. A computer program.

Images