JP2005071085A - Information processing system, device and method - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide an information processing system that increases the speed of a process for determining the number of subjects to be counted from a detail data table in which the same subject of counting is duplicately recorded. <P>SOLUTION: The information processing system includes: a host computer which saves a plurality of detail data consisting of one set of data for a plurality of kinds of items including a different identification number for each subject of counting as one item; stores information on the subjects of counting including identification numbers and attributes; and, on receiving retrieval conditions for determining the detail data including data on the subjects of retrieval, extracts pieces of retrieved information on the subjects of counting, i.e., information on the subjects of counting specified by the identification numbers included in the retrieved detail data, i.e., the detail data including data on the subjects of retrieval; and a terminal device which, when the retrieval conditions and search attribute information serving as the subject of retrieval about the attributes are inputted, sends the retrieval conditions to the host computer and counts and outputs the number of pieces of information on the subjects of counting including the attribute that matches retrieval attribute information among the pieces of retrieved information on the subjects of counting received from the host computer. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

  The present invention relates to an information processing system, an information processing apparatus, and an information processing method for searching for information.

  In recent years, companies have expanded the functions of conventional databases and introduced data warehouses as integrated information systems for use as decision support for company management strategies. A data warehouse database is generally constructed based on the concept of a multi-dimensional database.

  A multi-dimensional database has a three-dimensional structure in which the units of column items in relational databases are grouped as dimensions, and data is searched and aggregated at high speed while switching the dimensioned column items one after another. Making it possible. As a tool for searching a multidimensional database in this data warehouse, there is online analysis processing (OLAP).

  In this OLAP, when there are a plurality of detailed data composed of a set of data for a plurality of types of column items, the summary processing for simply summing from the lower hierarchy to the upper hierarchy about the selected column item is generalized. (For example, refer to Patent Document 1).

  In the analysis by OLAP, when an identifier of a count target to be obtained is provided in one of the column items of the detail data, the count target can be specified from the identifier included in each detail data, and the count target is analyzed. It becomes possible to do. Hereinafter, the counted object is referred to as a pattern as a unit that cannot be divided.

  In the detail data table, the same pattern may be recorded in duplicate. Such pattern analysis for obtaining the number of patterns from the detail data table is an effective means for qualitatively analyzing the events indicated by the detail data table. Here, the pattern analysis will be described by taking a sales analysis system for analyzing product purchase information of a customer who visits a specific store as an example.

  In the sales analysis system, it is assumed that the customer A stores 100 yen purchases and 200 yen purchases on different days as detailed data. When the operator inputs a summary process for the purchase result of Mr. A, the number of purchases of Mr. A is calculated as two and the total purchase amount is 300 yen. In this detailed data example, if the customer is a pattern, even if the number of purchases is two, only Mr. A has made a purchase, so the number of patterns is one. Analyzing the number of visitors in a certain period and obtaining the number of patterns as in the example of the sales analysis system is effective in analyzing the trend of the number of customers.

In order to perform the pattern analysis using the OLAP, a conventional database uses a DISincct function in the JIS standard of SQL (Structured Query Language).
JP 2001-28005 A

  The above-described prior art has a problem that when the number of patterns is obtained, it is necessary to scan the detailed data table using the DISincct function in the SQL JIS standard, and the search process takes time.

  In conventional OLAP, in order to display detailed data as summary level data, it is possible to perform a drill-up process in which detailed data including data to be searched is extracted from the detailed data table and the total is obtained. This drill-up process corresponds to the above-described summary process. On the other hand, in order to display detailed data from the summary level data, it is possible to perform a drill-down process for dividing a plurality of detailed data corresponding to dividing the data in at least one item into a plurality of groups. However, tools for applying the drill-up process and the drill-down process to the number of patterns are not generalized. Hereinafter, the analysis by the drill-up process and the drill-down process is referred to as drilling analysis.

  The present invention has been made to solve the above-described problems of the prior art, and a process for obtaining the number of counted objects from a detailed data table in which the same counted objects are recorded in duplicate. An object of the present invention is to provide an information processing system, an information processing apparatus, and an information processing method that increase the processing speed.

In order to achieve the above object, an information processing system of the present invention provides detailed data consisting of a set of data for a plurality of types of items including a different identification number as one of the items to be counted. An information processing system comprising a plurality of stored host computers and a terminal device communicably connected to the host computers via a communication line,
The host computer
The counting target information including the identification number and the attribute of the counting target of the identification number is stored, and when a search condition for obtaining detailed data including search target data is received from the terminal device, the search target information Search detail data that is detail data including data is extracted from the plurality of detail data, and the search target information that is the count target information including the identification number that matches the identification number included in the search detail data is the target data. Extracted from the count target information and sent to the terminal device,
The terminal device
When the search condition and search attribute information to be searched for the attribute are input, the search condition is transmitted to the host computer, and the search target information received from the host computer is stored, The number of pieces of counted target information including attributes that match the searched attribute information among the searched counted target information is output.

  In the present invention, the terminal device stores the search detail data received from the host computer and the search count target information, and the number of search count target information including an attribute that matches the search attribute information in the search count target information. Is calculated as the number of objects to be counted. Since the search target object information received from the host computer is referred to, the number of target objects can be obtained at a higher speed than when the host computer is accessed and the target object information is searched.

In the information processing system of the present invention, the host computer is
When the search condition is received from the terminal device, the search specification data is transmitted to the terminal device,
The terminal device
The search specification data received from the host computer is stored, and when a signal to divide the data in at least one of the items into a plurality of groups is input, the search is performed corresponding to the plurality of groups. Dividing the detailed data, extracting the count target information having an identification number matching the identification number included in the search detail data of the plurality of groups from the search count target information, and among the extracted search count target information The number of count target information including attributes matching the search attribute information may be output for each group.

  In the present invention, when there is an input to divide a single item of data into a plurality of groups, the terminal device count information for each group from the search detail data received from the host computer and the search count target information. Find the number of. For this reason, it is not necessary to access the host computer again to search the counting target information, so that the counting target number for each group can be obtained at higher speed.

On the other hand, the information processing apparatus of the present invention for achieving the above object is a specification comprising a set of data for a plurality of types of items including an identification number that is different for each counting target for which the number is to be calculated as one of the items. A storage unit for storing a plurality of data and storing counting target information including the identification number and the attribute of the counting target of the identification number;
When a search condition for obtaining detailed data including data to be searched and search attribute information to be searched for the attribute are input, the plurality of search detailed data as detailed data including the data to be searched The search target object information, which is the target object information including the identification number that matches the identification number included in the search detail data, is extracted from the target object information, and the search target object information is extracted. A data processing unit that outputs to the output unit the number of counted target information including an attribute that matches the search attribute information,
It is the structure which has.

In the information processing apparatus of the present invention, the data processing unit is
When a signal to divide the data in at least one of the items into a plurality of groups is input, the search specification data is divided corresponding to the plurality of groups, and the search specification data of the plurality of groups Counted target information having an identification number that matches the identification number included in the search target count information is extracted from the searched count target target information, and includes the attribute that matches the search attribute information in the extracted search target count information It is good also as making it output to the said output part by counting the number of every group.

In addition, the information processing method of the present invention for achieving the above object is a specification comprising a set of data for a plurality of types of items including an identification number that is different for each counting target for which a number is to be obtained as one of the items. An information processing method by an information processing apparatus storing a plurality of data,
Stored counting target information including the identification number and the counting target attribute of the identification number;
When a search condition for obtaining detailed data including data to be searched and search attribute information to be searched for the attribute are input, the plurality of search detailed data as detailed data including the data to be searched Extracted from line item data,
Extracting the search target information that is the target object information including the identification number that matches the identification number included in the search specification data from the target object information,
The number of pieces of count target information including an attribute that matches the search attribute information in the search count target information is counted and output.

In the information processing method of the present invention, when a signal indicating that the data in at least one of the items is divided into a plurality of groups is input, the search specification data corresponding to the plurality of groups is stored. Split and
Extracting counted object information having an identification number that matches an identification number included in the search details data of the plurality of groups from the retrieved counted object information,
Of the extracted search target information, the number of count target information including an attribute that matches the search attribute information may be output for each group.

  In the present invention, since the number of counted objects is obtained by referring to the searched counted object information, the process for obtaining the counted object speed is accelerated, and an output for the search operation of the operator is performed during drilling analysis. Response is improved.

  An information processing system according to the present invention includes a detail data table having a plurality of detail data including different identification numbers for each counting target, and a table having a plurality of counting target information including identification numbers. After obtaining the detailed data, the number of objects to be counted is obtained from the identification number included in the obtained detailed data.

  The configuration of the information processing system of the present invention will be described. Hereinafter, the counting target is referred to as a pattern.

  FIG. 1 is a block diagram showing a configuration example of an information processing system according to the present invention.

  As shown in FIG. 1, the information processing system of the present invention includes a host computer 10 for storing a detailed data table composed of a plurality of detailed data, and a terminal device 30 connected to the host computer 10 via a communication line 40. It is the structure which has.

  The host computer 10 stores the search target information 24 including a detail data table having a plurality of detail data and dimension information as column items, and a terminal device 30 for the detail data table of the search target information 24. And a data processing unit 13 for obtaining detailed data that matches the search condition received from.

  The terminal device 30 is an information processing device such as a workstation and a personal computer. An input unit 32 for an operator to input search conditions, a memory unit 34 for storing information such as detailed data received from the host computer 10, and the number of patterns from the detailed data stored in the memory unit 34. A control calculation unit 36 to be obtained and an output unit 38 for outputting a calculation result are provided.

  Next, the configuration of the host computer 10 will be described in detail.

  FIG. 2 is a block diagram showing a configuration example of the host computer shown in FIG.

  As shown in FIG. 2, the search target information 24 in the storage unit 14 includes a dimension table 241 including a dimension type and a dimension Key serving as an identifier thereof, a detail data table 242, and pattern information including attributes relating to patterns. A pattern information table 243 is stored.

  The data processing unit 13 includes a drill search unit 232 that obtains search specification data that is detailed data that matches the search conditions received from the terminal device 30 from the specification data table, and a search pattern that is pattern information of a pattern related to the search specification data Pattern information searching means 233 for obtaining information and search information answering means 234 for transmitting a search result to the terminal device 30 are provided. The drill search unit 232, the pattern information search unit 233, and the search information answer unit 234 operate every time a search condition is received from the terminal device 30. The pattern information is the counting target information of the present invention, and the search pattern information is the searching count target information of the present invention.

  The control calculation unit 36 of the terminal device 30 illustrated in FIG. 1 stores the search detail data and search pattern information received from the host computer 10 in the memory unit 34. In addition, the number of pieces of search pattern information including an attribute that matches the search attribute information to be searched for the attribute relating to the pattern, which is input from the input unit 32 by the operator, is obtained.

  Next, a specific example of the search target information 24 will be described. In the present embodiment, the customer visits to each branch of a dealer who has branches all over the country are detailed data, and the customer is a pattern.

  FIG. 3 is a diagram illustrating a configuration example of search target information.

  As shown in FIG. 3, the dimension table 241 includes, as the types of dimensions, a “region” of dimension 1 indicating the location of the store, a “period” of dimension 2 indicating the visit time of the customer, and the organization of the store. There is an “Organization” of dimension 3 indicating the configuration. In addition, for each dimension, a dimension Key serving as an identifier and a level indicating a hierarchy are described. For example, in “Region” in dimension 1, the highest hierarchy is level 1 nationwide, and the lowest hierarchy is level 3 prefectures. Level 2 between Level 1 and Level 3 is a hierarchy of districts divided into 8 areas such as Hokkaido, Tohoku and Kanto.

  In the detail data table 242, a plurality of detail data is described by using each dimension shown in the dimension table 241 and a pattern Key that is different for each pattern as column items. This detailed data table 242 is data of the lowest hierarchy of each dimension. The pattern key is a pattern identification number.

  The pattern information table 243 describes customer attributes for each pattern key. Attribute 0 indicates a customer name, attribute 1 indicates a residence location, attribute 2 indicates gender, and attribute 3 indicates age.

  Next, the detailed data table 242 and the pattern information table 243 will be described in detail.

  4 and 5 are tables for explaining an example of the detail data table and the pattern information table.

  In the detail data table shown in FIG. 4, column items are placed in the horizontal column, and detail data is placed in the vertical column. For example, the detailed data in the first row indicates that the customer of the pattern key “P2” visited “A branch” in “Tokyo” in “May”. The detail data on the second and subsequent lines also indicate the customer's visit to the store as in the first line.

  In the pattern information table shown in FIG. 5, the pattern key and attribute are in the horizontal column, and the pattern information for each customer is in the vertical column. For example, the pattern information on the first line indicates that the customer of the pattern Key “P1” has the name “M”, the residence address “Tokyo”, the gender “female”, and the age “30s”. ing. Similarly to the first line, the pattern information on and after the second line also indicates the customer's name, residence address, gender, and age specified by the pattern key. The pattern information including the pattern Key that matches the pattern Key included in the search detail data is the search pattern information.

  Next, an operation procedure in the case of obtaining the number of patterns of customers in their thirties who visited a branch in Tokyo in each period of the first half and the second half by the information processing system having the above configuration will be described. Here, the initial hierarchy is set for each dimension.

  FIG. 6 is a flowchart showing an operation procedure of the information processing system.

  The operator operates the input unit 32 of the terminal device 30 to input “Tokyo” as the search condition and “half-year” as the period. Subsequently, when the customer age “30's” is input as the search attribute information and the request for obtaining the number of patterns is input, the control calculation unit 36 of the terminal device 30 transmits the search condition to the host computer 10 via the communication line 40. (Step S101).

  When the data processing unit 13 of the host computer 10 receives the search condition from the terminal device 30, the drill search means 232 includes detailed data including “Tokyo” in the column item region from the detailed data table of the search target information 24 in the storage unit 14. Is searched (step S102). There are seven search detail data retrieved from the detail data table shown in FIG.

  Subsequently, the pattern information search unit 233 reads the pattern key of the search detail data, and searches the pattern information table 243 for pattern information regarding the read pattern key (step S103). From the pattern information table shown in FIG. 5, there are two pieces of search pattern information, “P1” and “P2”. Thereafter, the search information answering means 234 transmits the search detail data and the search pattern information to the terminal device 30 via the communication line 40 (step S104).

  FIG. 7A is a table showing search detail data, and FIG. 7B is a table showing search pattern information.

  As shown in FIG. 7 (a), the search detail data is seven cases searched from the table shown in FIG. Further, as shown in FIG. 7B, the search pattern information is two cases searched from the table shown in FIG.

  When receiving the search detail data and the search pattern information from the host computer 10, the control calculation unit 36 of the terminal device 30 stores these data in the memory unit 34 (step S105). Next, the search detail data shown in FIG. 7A is divided into four “first half” and three “second half” for the period, and the pattern key of the search detail data is read for the four “first half”. Search pattern information is searched for a pattern key that matches the read pattern key. If there is a matching pattern key, it is counted as one case, and is not counted when the same pattern key appears for the second time. In this way, the number of patterns is found to be one “P2” from the search detail data of the “first half”. Similarly, the number of patterns is found to be two cases “P2” and “P1” from the search detail data of “second half” (step S106).

  Thereafter, the control calculation unit 36 checks whether or not the customers of the patterns Key “P1” and “P2” are in their thirties with the search pattern information. From the table shown in FIG. 7B, it can be seen that the customer ages of the patterns Key “P1” and “P2” are in their 30s. For this reason, the control calculation unit 36 determines that the number of patterns is “1” for “first half” and 2 for “second half” (step S107). Subsequently, a table indicating the number of patterns for the region “Tokyo” and the period “half-year” is created and output to the output unit 38 (step S108).

  FIG. 8 is a table showing the number of patterns in the initial hierarchy.

  In the table of FIG. 8, the area is divided by the area “Tokyo” shown in the left column and the periods “first half” and “second half” shown in the upper column. The table of FIG. 8 indicates that the number of patterns is “1” in the case of “first half” and “2” in the case of “second half” for the region “Tokyo”.

  As described above, the control calculation unit 36 searches the search pattern information stored in the memory unit 34 for a pattern that matches the search attribute information, and outputs the number to the output unit 38. Therefore, it is possible to search in the information stored in the memory unit 34 without accessing the pattern information stored in the host computer 10, and the information processing becomes faster.

  Further, the memory unit 34 of the terminal device 30 only needs to store the search detail data in the detail data table and the search pattern information in the pattern information, thereby reducing the memory load.

  Next, an operation procedure when a drill-down process is performed with the dimension “organization” as an axis from the result of the initial hierarchy will be described with reference to the flowchart shown in FIG.

  When the operator operates the input unit 32 of the terminal device 30 to input that drill down processing is performed with the dimension “organization” as an axis, the control calculation unit 36 reads the search details data illustrated in FIG. “First half” is divided into two “A branch” and two “B branch”. When the pattern key is read for two cases of “A branch”, if there is a matching pattern key as in the case of the initial hierarchy, it is counted as one case, and when the same pattern key appears for the second time. Do not count. In this way, it can be understood that two cases of “A branch” are one case where the number of patterns is “P2”.

  Subsequently, in the same manner as in the case of “A branch” in the “first half”, the control calculation unit 36 “B branch” in the “first half”, “A branch” in the “second half”, and “B branch” in the “second half”. For each, the number of patterns is obtained. For “B branch” in the “first half” and “A branch” in the “second half”, the number of patterns is obtained as one case of “P2.” In addition, regarding “B branch” of “second half”, the number of patterns is obtained as two cases “P2” and “P1” (step S106).

  Thereafter, the control calculation unit 36 checks whether or not the customers of the patterns Key “P1” and “P2” are in their thirties with the search pattern information. From the table shown in FIG. 7B, it can be seen that the customer ages of the patterns Key “P1” and “P2” are in their 30s. Therefore, the control calculation unit 36 has one pattern for “A branch” in the first half, “B branch” in the “first half”, and “A branch” in the “second half” as the number of patterns, and “B branch” in the “second half”. "Is calculated as 2 cases (step S107). Subsequently, a table indicating the number of patterns for the organizations “A branch” and “B branch” and the period “half year” is created and output to the output unit 38 (step S108).

  FIG. 9 is a table showing an example of drill-down processing from the initial hierarchy with the dimension “organization” as an axis.

  In the table of FIG. 9, the area is divided by the area “Tokyo” shown in the left column and the periods “first half” and “second half” shown in the upper column. The left column shows the organizations “A branch” and “B branch”, and the table is divided vertically. The table of FIG. 9 indicates that the number of patterns in the case of “A branch” for “first half” is “1” and the number of patterns in the case of “B branch” is “1”. Further, for “second half”, the number of patterns for “A branch” is “1”, and the number of patterns for “B branch” is “2”.

  Next, an operation procedure when a drill-up process is performed from the result of the initial hierarchy will be described. Here, it is assumed that the number of patterns is obtained for the “Kanto district” around the region. This will be described with reference to the flowchart shown in FIG.

  When the operator operates the input unit 32 of the terminal device 30 and inputs the region “Kanto district” and the fact that drill-up processing is performed as a search condition, the control calculation unit 36 of the terminal device 30 stores the information in the memory unit 34. When the area information of the search details data is read and it is determined that the number of patterns cannot be obtained, a search condition for the area “Kanto district” and a signal for drill-up processing are transmitted to the host computer 10 via the communication line 40. (Step S101).

  When the data processing unit 13 of the host computer 10 receives a search condition and a signal indicating that a drill-up process is performed from the terminal device 30, the drill search unit 232 reads the column item from the detailed data table of the search target information 24 in the storage unit 14. Detailed data including the city and prefecture of “Kanto district” in the area is searched (step S102). In the detailed data table shown in FIG. 4, “Kanto district” is Tokyo and Kanagawa, and the search detailed data is 10 items.

  Subsequently, the pattern information search unit 233 reads the pattern key of the search detail data, and searches the pattern information table 243 for pattern information regarding the read pattern key (step S103). There are 5 cases of “P1” to “P5” as the pattern key in 10 cases of the above-mentioned search specification data. Therefore, the pattern information search means 233 sends the search pattern information obtained by reading the pattern information of the patterns Key “P1” to “P5” from the pattern information table 243 to the search information answer means 234. The search information answering means 234 transmits the search pattern information and the search detail data to the terminal device 30 via the communication line 40 (step S104).

  FIG. 10A is a table showing search detail data, and FIG. 10B is a table showing search pattern information.

  As shown in FIG. 10 (a), the search detail data is 10 cases searched from the table shown in FIG. Further, as shown in FIG. 10B, the search pattern information is five cases searched from the table shown in FIG.

  When receiving the search detail data and the search pattern information from the host computer 10, the control calculation unit 36 of the terminal device 30 stores these data in the memory unit 34 (step S105). Subsequently, the search detail data shown in FIG. 10A is divided into four cases of “first half” and six cases of “second half” for the period, and the pattern key of the search detail data is read for the four cases of “first half”. When the pattern key is read for the “first half” cases, it is counted as one when there is a matching pattern key as in the case of the initial hierarchy, and is counted when the same pattern key appears for the second time. do not do. In this way, the number of patterns is found to be one “P2” from the search detail data of the “first half”. Similarly, the number of patterns is found to be five from “P1” to “P5” from the search detail data of “second half” (step S106).

  After that, the control calculation unit 36 checks whether or not the customer's age in the patterns Key “P1” to “P5” is in his / her thirties with the search pattern information. Among the patterns Key “P1” to “P5”, the pattern Key whose customer age is in his thirties is known as “P1”, “P2” and “P4” from the table shown in FIG. Therefore, the control calculation unit 36 determines that the number of patterns is “1” for “first half” and 3 for “second half” (step S107). Subsequently, a table indicating the number of patterns for the region “Kanto district” and the period “half year” is created and output to the output unit 38 (step S108).

  FIG. 11 is a table showing an example of drill-up processing from the initial hierarchy with the dimension “region” as an axis.

  In the table of FIG. 11, the table is divided by the area “Kanto district” shown in the left column and the periods “first half” and “second half” shown in the top column. The table of FIG. 11 indicates that the number of patterns is “1” in the case of “first half” and “3” in the case of “second half” for the region “Kanto district”.

  In the above-described embodiment, the case of one terminal device 30 has been described. However, a plurality of terminal devices 30 may be provided. If the terminal device 30 is provided for each employee who is engaged in data analysis in the company, the detailed data is managed by the host computer 10 and the terminal device 30 is accessed by the operation of the employee, the detailed data table and The pattern information table can be shared by multiple employees.

  Further, the host computer 10 may be provided with the input unit 32 and the output unit 38 of the terminal device 30, and the data processing unit 13 may perform the processing executed by the control arithmetic circuit 36. Accordingly, when the operator operates the host computer 10 and inputs the search condition and the search attribute information, the host computer 10 obtains the number of patterns according to the search condition and the search attribute information.

  The communication line 40 may be wired or wireless, but is a communication medium such as a LAN (Local Area Network) that ensures the confidentiality of information transmitted and received via the communication line 40. Is desirable.

It is a block diagram which shows the example of 1 structure of the information processing system of this invention. FIG. 2 is a block diagram illustrating a configuration example of a host computer illustrated in FIG. 1. It is a block diagram which shows one structural example of search object information. It is a table | surface which shows an example of a detailed data table. It is a table | surface which shows an example of a pattern information table. It is a flowchart which shows the operation | movement procedure of an information processing system. It is a table | surface which shows search detailed data and search pattern information. It is a table | surface which shows the result of an initial hierarchy. It is a table | surface which shows the result of having drilled down from the initial hierarchy. It is a table | surface which shows search detailed data and search pattern information. It is a table | surface which shows the result of drill-up processing from the initial hierarchy.

Explanation of symbols

DESCRIPTION OF SYMBOLS 10 Host computer 13 Data processing part 14 Storage part 24 Search object information 30 Terminal device 32 Input part 34 Memory part 36 Control operation part 38 Output part 40 Communication line 232 Drill search means 233 Pattern information search means 234 Search information answer means 241 Dimension table 242 Detail data table 243 Pattern information table

Claims (6)

A host computer that stores a plurality of detailed data consisting of a set of data for a plurality of types of items including different identification numbers as one of the items to be counted, and a communication line with the host computer And an information processing system including a terminal device connected to be communicable,
The host computer
The counting target information including the identification number and the attribute of the counting target of the identification number is stored, and when a search condition for obtaining detailed data including the search target data is received from the terminal device, the search target information Search detail data that is detail data including data is extracted from the plurality of detail data, and the search target information that is the count target information including the identification number that matches the identification number included in the search detail data is the target data. Extracted from the count target information and sent to the terminal device,
The terminal device
When the search condition and search attribute information to be searched for the attribute are input, the search condition is transmitted to the host computer, and the search target information received from the host computer is stored, An information processing system that counts and outputs the number of counted target information including an attribute that matches the searched attribute information among the searched counted target information. The host computer
When the search condition is received from the terminal device, the search specification data is transmitted to the terminal device,
The terminal device
The search specification data received from the host computer is stored, and when a signal to divide the data in at least one of the items into a plurality of groups is input, the search is performed corresponding to the plurality of groups. Dividing the detailed data, extracting the count target information having an identification number matching the identification number included in the search detail data of the plurality of groups from the search count target information, and among the extracted search count target information The information processing system according to claim 1, wherein the number of pieces of count target information including an attribute that matches the search attribute information is output for each group. A plurality of detailed data consisting of a set of data is stored for a plurality of types of items including different identification numbers as one of the items for which the number is to be counted, and the identification number and the number to be counted A storage unit for storing the counting target information including the attributes of
When a search condition for obtaining detailed data including data to be searched and search attribute information to be searched for the attribute are input, the plurality of search detailed data as detailed data including the data to be searched The search target object information, which is the target object information including the identification number that matches the identification number included in the search detail data, is extracted from the target object information, and the search target object information is extracted. A data processing unit that outputs to the output unit the number of counted target information including an attribute that matches the search attribute information,
An information processing apparatus. The data processing unit
When a signal to divide the data in at least one of the items into a plurality of groups is input, the search specification data is divided corresponding to the plurality of groups, and the search specification data of the plurality of groups Counted target information having an identification number that matches the identification number included in the search target count information is extracted from the searched count target target information, and includes the attribute that matches the search attribute information in the extracted search target count information The information processing apparatus according to claim 3, wherein the output unit is configured to output the output number for each group. An information processing method by an information processing apparatus that stores a plurality of detailed data composed of a set of data for a plurality of types of items that include different identification numbers as one of the items to be counted.
Stored counting target information including the identification number and the attribute of the counting target of the identification number,
When a search condition for obtaining detailed data including data to be searched and search attribute information to be searched for the attribute are input, the plurality of search detailed data as detailed data including the data to be searched Extracted from line item data,
Extracting search target information, which is target object information including an identification number that matches an identification number included in the search specification data, from the target object information,
An information processing method for counting and outputting the number of counted target information including an attribute that matches the searched attribute information among the searched counted target information. When a signal indicating that the data in at least one of the items is divided into a plurality of groups is input, the search specification data is divided corresponding to the plurality of groups,
Extracting counted object information having an identification number that matches an identification number included in the search details data of the plurality of groups from the retrieved counted object information,
6. The information processing method according to claim 5, wherein the number of pieces of counted target information including an attribute that matches the searched attribute information among the extracted searched count target information is output for each group.

Images