JP5204500B2 - Information processing apparatus, information processing method, and program - Google Patents

Description

  The present invention relates to an information processing apparatus or the like that outputs an intermediate table when an attribute value of a summary table configured from database search is specified.

2. Description of the Related Art Conventionally, there has been an information processing apparatus that performs personnel data management and approval / aggregation processing by connecting a customer computer system including a customer employee terminal and an approver terminal to a server system that performs data management agency through a computer network. (For example, see Patent Document 1).
JP 2002-352044 A (first page, FIG. 1 etc.)

  However, in the conventional information processing apparatus, the original information that is the basis of the numerical value in the box of the summary table that is output by summing up the information in the database cannot be easily output.

  The information processing apparatus according to the first invention includes a table storage unit that can store one or more tables having two or more attributes, and two or more attribute values of the first attribute among the table attributes. In which the horizontal axis value is two or more attribute values of the second attribute, and each box of the total table satisfies both the vertical axis value and the horizontal axis value. A summary table output unit that outputs a summary table in which the number of records is output, and information that is a source of the values that are output in the boxes of the summary table, the vertical axis value and the horizontal axis value of the summary table An instruction receiving unit that receives an original information output instruction that is an instruction to output original information that is information that can be acquired from the record of the table that satisfies both, and the summary table when the instruction receiving unit receives an original information output instruction, A source information acquisition unit for acquiring source information of the value output in the box, and outputting the source information An information processing apparatus having a source information output section for.

  With this configuration, the original information that is the basis of the numerical values in the boxes of the summary table can be easily output.

  In the information processing apparatus according to the second aspect of the present invention, in contrast to the first aspect, the instruction receiving unit also receives a totaling table output instruction that is an instruction to output a totaling table, and the instruction receiving unit When an output instruction is accepted, a tabulation table in which two or more attribute values of the first attribute among the attributes of the table are values on the vertical axis and two or more attribute values of the second attribute are values on the horizontal axis And each box of the summary table further comprises a summary table configuration unit that constitutes a summary table in which the number of records satisfying both the value on the vertical axis and the value on the horizontal axis is output, A summary table configured by the summary table configuration unit, wherein the summary table configuration unit acquires first attribute value acquisition means for acquiring each attribute value of a first attribute of the table attributes; and the table Second attribute value acquisition means for acquiring each attribute value of the second attribute of the attributes, and each attribute value of the first attribute For each combination of attribute values of the second attribute, original information search means for searching for original information, each attribute value of the first attribute, for each combination of attribute values of the second attribute, Original information calculation means for calculating the number of original information acquired by the original information search means, and original information storage means for storing the original information searched by the original information search means for each box of the summary table. The original information acquisition unit is original information corresponding to the number of original information output in the box of the summary table when the instruction receiving unit receives an original information output instruction, and the original information storage unit This is an information processing apparatus that reads accumulated original information.

  With this configuration, the original information that is the basis for the numerical values in the boxes of the summary table is stored in advance, so that the original information can be output at high speed.

  Further, in the information processing apparatus according to the third aspect of the present invention, in contrast to the first aspect, the instruction receiving unit also receives a totaling table output instruction that is an instruction to output a totaling table, and the instruction receiving unit When an output instruction is accepted, a tabulation table in which two or more attribute values of the first attribute among the attributes of the table are values on the vertical axis and two or more attribute values of the second attribute are values on the horizontal axis And each box of the summary table further comprises a summary table configuration unit that constitutes a summary table in which the number of records satisfying both the value on the vertical axis and the value on the horizontal axis is output, A summary table configured by the summary table configuration unit, wherein the summary table configuration unit acquires first attribute value acquisition means for acquiring each attribute value of a first attribute of the table attributes; and the table Second attribute value acquisition means for acquiring each attribute value of the second attribute of the attributes, and each attribute value of the first attribute For each combination of attribute values of the second attribute, search expression constructing means for configuring a search expression for searching the original information, each attribute value of the first attribute, each attribute of the second attribute For each combination of values, execute the search formula to search for original information, and for each combination of attribute values of the first attribute and attribute values of the second attribute, An original information calculation means for calculating the number of original information searched by the information search means; and a search expression storage means for storing the search expression constituted by the search expression construction means for each box of the summary table; The original information acquisition unit, when the instruction receiving unit receives an original information output instruction, reads a search formula corresponding to the number of original information output in the box of the summary table, executes the search formula, This is an information processing apparatus that acquires original information.

  With this configuration, only the search formula for acquiring the original information that is the basis of the numerical value in the box of the summary table is stored in advance, so that the original information can be output with only a small storage medium capacity.

  Further, in the information processing apparatus according to the fourth aspect of the present invention, in the first to third aspects of the invention, the original information output unit converts the original information to each attribute value of the first attribute, or second It is the information processing apparatus which classify | categorizes and outputs for every attribute value of an attribute.

  With this configuration, the original information can be output in a format that is easy for the user to understand.

  According to the information processing apparatus of the present invention, the original information that is the basis of the numerical value in the box of the summary table can be easily output.

  Hereinafter, embodiments of an information processing apparatus and the like will be described with reference to the drawings. In addition, since the component which attached | subjected the same code | symbol in embodiment performs the same operation | movement, description may be abbreviate | omitted again.

  (Embodiment 1)

  In the present embodiment, an information processing apparatus that searches a database (hereinafter referred to as “DB” as appropriate) and outputs the original information that is the basis of the attribute value if the attribute value of the configured summary table is indicated. explain. In the present embodiment, a description will be given of an aspect in which original information, which is information that is used to calculate a numerical value by aggregation, is stored in advance in association with the numerical value.

  FIG. 1 is a block diagram of an information processing apparatus 1 in the present embodiment.

  The information processing apparatus 1 includes a table storage unit 11, an instruction receiving unit 12, a tabulation table configuration unit 13, a tabulation table output unit 14, an original information acquisition unit 15, and an original information output unit 16.

  The tabulation table forming unit 13 includes a first attribute value acquisition unit 131, a second attribute value acquisition unit 132, an original information search unit 133, an original information calculation unit 134, and an original information storage unit 135.

  The table storage unit 11 can store one or more tables having two or more attributes. Here, the table is information that can constitute the table, and its structure is not limited. The table may be an RDB normal table or a non-normal table. Further, the table may be information on objects and classes of the object-oriented DB. The table may be CSV format data. The table storage unit 11 is preferably a non-volatile recording medium, but can also be realized by a volatile recording medium. The process of storing the table in the table storage unit 11 does not matter. For example, a table may be stored in the table storage unit 11 via a recording medium, or a table transmitted via a communication line or the like may be stored in the table storage unit 11. Alternatively, a table input via the input device may be stored in the table storage unit 11.

  The instruction receiving unit 12 receives an instruction. The instruction is, for example, an original information output instruction that is an instruction to output original information. The original information is information that is the origin of the values output in the boxes of the summary table, and is information that can be acquired from a table record that satisfies both the vertical axis value and the horizontal axis value of the summary table. The original information may be all attribute values of a table record or a part of attribute values. The original information output instruction is input by, for example, pressing one box (one value) of the tabulation table using an input device such as a mouse. The summary table output instruction includes, for example, a first attribute identifier that identifies the first attribute and a second attribute identifier that identifies the second attribute. The summary table output instruction is, for example, “OutputStatisticalTable table name department title”. Here, “OutputStatisticalTable” is an instruction identifier indicating a summary table output instruction, “Table name” is an identifier of a table to be aggregated, “Department” is a first attribute identifier, “Position” is a second attribute identifier, It is. Further, only an instruction identifier such as “OutputStatisticalTable” may be used. In this case, for example, it is assumed that the table, the first attribute, and the second attribute are determined in advance. The tabulation table is a table in which two or more attribute values of the first attribute among the table attributes are values on the vertical axis, and two or more attribute values of the second attribute are values on the horizontal axis, Each box of the summary table is a table in which the number of records in the table satisfying both the value on the vertical axis and the value on the horizontal axis is output. The summary table is a vertical and horizontal 2-axis table, and each box of the 2-axis table has both the first attribute value and the second attribute value corresponding to the two axes. This is a table that outputs the number of records in the table that satisfy it.

  Also, the above box is one cell of the summary table, and the summed numerical value (value) is output.

  The table that is the basis of the summary table is usually one table, but two or more tables may be the basis. The case where two or more tables are based includes, for example, the case where a view composed of two or more tables is based.

  In addition, the instruction receiving unit 12 may receive an aggregation table output instruction that is an instruction to output an aggregation table. The instruction input means may be anything such as a numeric keypad, a keyboard, a mouse, or a menu screen. The instruction receiving unit 12 can be realized by a device driver for input means such as a numeric keypad or a keyboard, control software for a menu screen, or the like.

  The summary table construction unit 13 constructs a summary table using the table stored in the table storage unit 11. For example, when the instruction accepting unit 12 accepts the summary table output instruction, the summary table forming unit 13 sets two or more attribute values of the first attribute among the table attributes as the values of the vertical axis, and sets the second attribute A summary table in which two or more attribute values of the horizontal axis are values on the horizontal axis, and each box of the summary table constitutes a summary table that outputs the number of records that satisfy both the values on the vertical axis and the values on the horizontal axis .

  The tabulation table construction unit 13 can usually be realized by an MPU, a memory, or the like. The processing procedure of the summary table construction unit 13 is usually realized by software, and the software is recorded in a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  The first attribute value acquisition unit 131 acquires each attribute value of the first attribute among the table attributes. The first attribute value acquisition unit 131 acquires all the attribute values of the first attribute from the table stored in the table storage unit 11, performs unique processing on all the attribute values, and acquires them. good. Further, the first attribute value acquisition unit 131 may acquire all attribute values of the first attribute stored in advance separately from the table stored in the table storage unit 11. In such a case, the first attribute value acquisition unit 131 has, for example, a master table that manages all attribute values of the first attribute. The first attribute value acquisition unit 131 can be usually realized by an MPU, a memory, or the like. The processing procedure of the first attribute value acquisition unit 131 is usually realized by software, and the software is recorded on a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  The second attribute value acquisition unit 132 acquires each attribute value of the second attribute among the table attributes. Since the processes of the second attribute value acquisition unit 132 and the first attribute value acquisition unit 131 are usually the same, description thereof will be omitted. The second attribute value acquisition unit 132 can be usually realized by an MPU, a memory, or the like. The processing procedure of the second attribute value acquisition unit 132 is usually realized by software, and the software is recorded on a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  The original information search unit 133 searches the original information for each combination of each attribute value of the first attribute and each attribute value of the second attribute. That is, the original information search unit 133 uses a search expression that satisfies both the attribute value of the first attribute and the attribute value of the second attribute (for example, “first attribute = attribute value of the first attribute” AND “Second attribute = attribute value of second attribute”) is executed on the table, and records satisfying the search expression are acquired from the table. In addition, acquisition of a record may acquire the substance data of a record, and may acquire record ID (identifier which identifies a record). Here, the original information is the above record here. Here, the search usually means reading the original information and acquiring it on the memory. The original information search unit 133 can be usually realized by an MPU, a memory, or the like. The processing procedure of the original information search means 133 is usually realized by software, and the software is recorded on a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  The original information calculation unit 134 calculates the number of pieces of original information acquired by the original information search unit 133 for each combination of the attribute values of the first attribute and the attribute values of the second attribute. The original information calculation unit 134 can be usually realized by an MPU, a memory, or the like. The processing procedure of the original information calculation unit 134 is usually realized by software, and the software is recorded in a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  The original information accumulating unit 135 accumulates the original information searched by the original information searching unit 133 for each number of original information calculated by the original information calculating unit 134 (for each box of the tabulation table). Note that the number of source information is one value in the tabulation table. In addition, the term “accumulation” usually means writing in a non-illustrated non-volatile recording medium, but it may be written in a volatile recording medium. The original information storage unit 135 can be usually realized by an MPU, a memory, or the like. The processing procedure of the original information storage unit 135 is usually realized by software, and the software is recorded on a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  The summary table output unit 14 outputs a summary table. The summary table output unit 14 normally outputs the summary table configured by the summary table configuration unit 13. However, the summary table output unit 14 may simply output a summary table stored in advance in a storage medium (not shown). In such a case, the summary table configuration unit 13 is not necessary.

  Here, output refers to display on a display, projection using a projector, printing on a printer, sound output, transmission to an external device, storage in a recording medium, other processing device or other program, etc. It is a concept including delivery of processing results.

  The summary table output unit 14 may or may not include an output device such as a display or a speaker. The summary table output unit 14 may be realized by output device driver software, or output device driver software and an output device.

  When the instruction receiving unit 12 receives the original information output instruction, the original information acquiring unit 15 acquires the original information constituting the value output in the box of the summary table. For example, when the instruction receiving unit 12 receives the original information output instruction, the original information acquisition unit 15 is the original information corresponding to the instructed box in the aggregation table, and the original information accumulated by the original information accumulation unit 135 is displayed. read out. The acquisition of the original information may be acquired by an algorithm described in the specific examples of the first and second embodiments, or the original information may be stored manually in advance. The original information acquisition unit 15 can usually be realized by an MPU, a memory, or the like. The processing procedure of the original information acquisition unit 15 is usually realized by software, and the software is recorded on a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  The original information output unit 16 outputs the original information acquired by the original information acquisition unit 15. It is preferable that the original information output unit 16 classifies and outputs the original information for each attribute value of the first attribute or each attribute value of the second attribute. Here, output refers to display on a display, projection using a projector, printing on a printer, sound output, transmission to an external device, storage in a recording medium, other processing device or other program, etc. It is a concept including delivery of processing results. The original information output unit 16 may or may not include an output device such as a display or a speaker. The original information output unit 16 can be realized by driver software of an output device or driver software of an output device and an output device.

  Next, the operation of the information processing apparatus 1 will be described using the flowchart of FIG.

  (Step S201) The instruction receiving unit 12 determines whether an aggregation table output instruction has been received. If a summary table output instruction is accepted, the process proceeds to step S202. If a summary table output instruction is not accepted, the process proceeds to step S216.

  (Step S202) The first attribute value acquisition unit 131 acquires the first attribute of the table attributes. The first attribute may be included in the summary table output instruction or may be determined in advance. When determined in advance, the first attribute is stored in a storage medium (not shown).

  (Step S203) The second attribute value acquisition unit 132 acquires a second attribute of the table attributes. The second attribute may be included in the summary table output instruction or may be determined in advance. If determined in advance, the second attribute is stored in a storage medium (not shown).

  (Step S204) The first attribute value acquisition unit 131 acquires all the attribute values of the first attribute acquired in step S202 (all types) from the table in the table storage unit 11. The table identifier for identifying the table in the table storage unit 11 is included, for example, in the total table output instruction. The first attribute value acquisition unit 131 acquires all the records of the first attribute value from the table of the table storage unit 11, and then performs a unique process to acquire all types of attribute values.

  (Step S205) The second attribute value acquisition unit 132 acquires all the attribute values of the second attribute acquired in Step S203 from the table of the table storage unit 11.

  (Step S206) The original information search means 133 substitutes 1 for the counter i.

  (Step S207) The original information search unit 133 determines whether or not there is a combination of the attribute value of the i-th first attribute and the attribute value of the second attribute. If the i-th combination exists, the process goes to step S208, and if not, the process goes to step S213. Note that the attribute value of the first attribute has been acquired in step S204. The attribute value of the second attribute is acquired in step S205.

  (Step S208) The original information search means 133 uses the combination of the attribute value of the i-th first attribute and the attribute value of the second attribute, and the attribute value of the first attribute and the attribute of the second attribute The original information which is information satisfying both values is searched from the table.

  (Step S209) The original information search means 133 acquires the original information which is the search result in step S208 from the table, and arranges it on the memory.

  (Step S210) The original information calculation means 134 calculates the number of original information acquired in step S209.

  (Step S211) The original information accumulating unit 135 accumulates the original information searched in step S209 for each number of original information calculated in step S210. Note that storing the original information for each number of the original information is equivalent to storing the original information for each box of the tabulation table.

  (Step S212) The original information search means 133 increments the counter i by 1. The process returns to step S207.

  (Step S213) The tabulation table construction unit 13 uses all or part of the attribute values of the first attribute acquired in step S204 and all or part of the attribute values of the second attribute acquired in step S205. The axis of the summary table (vertical axis, horizontal axis) is configured.

  (Step S214) The tabulation table construction unit 13 arranges the number of original information acquired in step S210 for each box of the tabulation table. In this step, the configuration of the summary table is completed.

  (Step S215) The summary table output unit 14 outputs the summary table configured in step S214. The process returns to step S201.

  (Step S216) The instruction receiving unit 12 determines whether or not an original information output instruction has been received. If an original information output instruction is accepted, the process proceeds to step S217. If an original information output instruction is not accepted, the process returns to step S201.

  (Step S217) The original information acquisition unit 15 reads the original information of the value output to the box of the tabulation table corresponding to the original information output instruction received in step S216.

  (Step S218) The original information output unit 16 configures the original information in an output mode. For example, the original information output unit 16 classifies the original information for each attribute value of the first attribute and configures the original information to be output.

  (Step S219) The original information output unit 16 outputs the original information configured in step S218. The process returns to step S201.

  In step S208 of the flowchart of FIG. 2, for example, as described in the second embodiment, the original information search unit 133 uses the combination of the attribute value of the i-th first attribute and the attribute value of the second attribute. May be used to construct a search expression and execute the search expression.

  In the flowchart of FIG. 2, the process is ended by power-off or a process end interrupt.

  Hereinafter, a specific operation of the information processing apparatus 1 in the present embodiment will be described. Now, the table storage unit 11 stores the personnel management table shown in FIG. The personnel management table has attributes such as “ID”, “employee number”, “name”, “position”, and “department”. “ID” is a record identifier for identifying a record in the table. In such a situation, for example, it is assumed that the user inputs an aggregation table output instruction “OutputSatisticalTable personnel management table department title” to the information processing apparatus 1.

  Next, the instruction receiving unit 12 receives a summary table output instruction “OutputSatisticalTable Personnel Management Table Department Title”. “OutputSatisticalTable” is an instruction identifier indicating a total table output instruction. The summary table output instruction “OutputSatisticalTable” uses a table identifier, a first attribute identifier, and a second attribute identifier as arguments.

  Next, the first attribute value acquisition unit 131 acquires the first attribute “department” among the attributes of the table. Then, the second attribute value acquisition unit 132 acquires the second attribute “position” of the table attributes.

  Next, the first attribute value acquisition unit 131 acquires all the attribute values of the first attribute “department” from the personnel management table of FIG. Although this attribute value is hierarchized, all hierarchized attributes are acquired. The first attribute values acquired here are “management department”, “management department—general affairs department”, “management department—general affairs department—secretary room”, “management department—accounting department”, and the like.

  Next, the second attribute value acquisition unit 132 acquires all the attribute values “title” of the second attribute from the personnel management table of FIG. The second attribute values acquired here are “Managing Director”, “Department Manager”, “Section Manager”, “Chief Manager”, and “Chief”.

  Next, the original information search means 133 acquires the first set of the attribute value “management unit” of the first attribute and the attribute value “management director” of the second attribute. Then, the original information search unit 133 searches the personnel management table in FIG. 3 for a record that satisfies both the attribute value “management unit” of the first attribute and the attribute value “management director” of the second attribute. Here, it is assumed that the original information retrieval unit 133 cannot retrieve such a record.

  Next, the original information calculation unit 134 calculates the number “0” of the acquired original information. The original information storage unit 135 does not store anything because there is no original information. The original information storage unit 135 uses the original information “NULL” as the calculated number of original information “0” (the attribute value “management unit” of the first attribute and the attribute value “management director” of the second attribute). May be accumulated for the box.

  Next, the original information search unit 133 acquires the second set of the attribute value “management unit” of the first attribute and the attribute value “department manager” of the second attribute. Then, the original information search unit 133 searches the personnel management table in FIG. 3 for a record that satisfies both the attribute value “management unit” of the first attribute and the attribute value “department manager” of the second attribute. Here, the original information search means 133 searches for the record of “ID = 2” in FIG.

  Next, the original information calculation unit 134 calculates the number “1” of the acquired original information. Then, the original information accumulation unit 135 accumulates the retrieved original information (the record of “ID = 2” in FIG. 3) in association with the calculated number of original information “1”. Here, it is assumed that the original information calculation unit 134 accumulates the record identifier “2” in association with “Department = Management Department” and “Position = Department Manager”. The original information to be accumulated may be the entity of the record “ID = 2” in FIG. 3 or a record identifier that is information for identifying the record “ID = 2” in FIG. 3. The record identifier is “2” which is an ID, for example.

  By repeating the above processing, the original information storage unit 135 of the summary table forming unit 13 stores the original information for each box of the summary table. The above process is performed for all pairs of the attribute value of the first attribute and the attribute value of the second attribute.

  Further, the above process outputs the summary table shown in FIG. 3, and the original information that is the basis of each box of the summary table is associated with the box (associated with the number of original information), Accumulated. FIG. 4 shows an example of the original information stored in association with the box (corresponding to the number of original information). The original information here is a set of record identifiers.

  Next, the summary table configuration unit 13 configures the axes (vertical axis and horizontal axis) of the summary table using all of the attribute values of the first attribute and all of the attribute values of the second attribute. Next, the summary table configuration unit 13 arranges the number of acquired original information for each box of the summary table. Here, the configured summary table is shown in FIG. Then, the summary table output unit 14 outputs the configured summary table of FIG. 5 to the display. In FIG. 5, there is also a box in which the values of each box in the tabulation table are further tabulated.

  Next, the user wants to confirm what kind of person is among the nine “leaders” who belong to the “sales department”, and the first attribute value “sales department” in FIG. , Move the focus to the box corresponding to the second attribute value “boss” (the box with “9” inside) (for example, use the mouse as an input means) and input the original information output instruction Suppose that

  Next, the instruction receiving unit 12 receives an original information output instruction. The original information acquisition unit 15 corresponds to the original information output instruction, and the original information of the values output in the tabulation table (the first attribute value “sales department”, the second attribute value “boss” box) (Here, a set of record identifiers) is read.

  And the original information output part 16 comprises original information in the aspect to output. Here, the original information output unit 16 classifies the original information (substance data of the record) for each attribute value of the first attribute, and configures the original information to be output. Next, the original information output unit 16 outputs the configured original information in a manner as shown in FIG.

  As described above, according to the present embodiment, if the DB is searched and the attribute value of the configured summary table is indicated, the original information that is the source of the attribute value can be output.

  Further, according to the present embodiment, the original information that is the basis of the numerical value in the box of the summary table is held in advance, so that the original information can be output at high speed.

  According to the present embodiment, the original information may be only the record identifier of the original table, or the entire contents of the record of the original table.

  Furthermore, the processing in the present embodiment may be realized by software. Then, this software may be distributed by software download or the like. Further, this software may be recorded and distributed on a recording medium such as a CD-ROM. This also applies to other embodiments in this specification. Note that the software that implements the information processing apparatus according to the present embodiment is the following program. In other words, this program causes the computer to set two or more attribute values of the first attribute among the table attributes stored in the storage medium as the values of the vertical axis and two or more attribute values of the second attribute. A tabulation table output unit that outputs a tabulation table with values on the horizontal axis, each box of the tabulation table outputting the number of records in the table that satisfies both the values on the vertical axis and the values on the horizontal axis And the information that is the source of the value that is output to the box of the summary table, and is the information that can be acquired from the record of the table that satisfies both the vertical axis value and the horizontal axis value of the summary table An instruction receiving unit that receives an original information output instruction that is an instruction to output information, and a source that acquires the original information of the value output in the box of the summary table when the instruction receiving unit receives the original information output instruction An information acquisition unit and an original information output unit for outputting the original information; Program to function, it is.

  In the above program, the instruction accepting unit also accepts a summary table output instruction that is an instruction to output a summary table, and when the instruction accepting unit accepts the summary table output instruction, A summary table in which two or more attribute values of the first attribute are values on the vertical axis and two or more attribute values of the second attribute are values on the horizontal axis, and each box of the summary table has a vertical It further functions as a summary table configuration unit that constitutes a summary table that outputs the number of records that satisfy both the axis value and the horizontal axis value, and the summary table output unit uses the summary table configured by the summary table configuration unit. Output, and the summary table configuration unit includes first attribute value acquisition means for acquiring each attribute value of the first attribute among the attributes of the table, and each attribute of the second attribute among the attributes of the table Second attribute value acquisition means for acquiring a value, each attribute value of the first attribute, For each combination of attribute values of the second attribute, original information search means for searching for original information, each attribute value of the first attribute, and each combination of attribute values of the second attribute, the original Source information calculation means for calculating the number of original information acquired by the information search means, and original information storage means for storing the original information searched by the original information search means for each box of the tabulation table, The original information acquisition unit is original information corresponding to the number of original information output in the box of the summary table when the instruction reception unit receives an original information output instruction, and the original information storage unit stores the original information A program for causing a computer to function as reading the original information.

  (Embodiment 2)

  In the present embodiment, a description will be given of an information processing apparatus that outputs the original information that is the origin of the attribute value when the attribute value of the summary table configured from the DB search is indicated. Further, in the present embodiment, an information processing apparatus that stores a search expression for searching for original information for obtaining the value of each box in a summary table in association with a box will be described.

  FIG. 7 is a block diagram of the information processing apparatus 2 in the present embodiment. The information processing apparatus 2 includes a table storage unit 11, an instruction receiving unit 12, a tabulation table configuration unit 23, a tabulation table output unit 14, an original information acquisition unit 25, and an original information output unit 16.

  The tabulation table construction unit 23 includes a first attribute value acquisition unit 131, a second attribute value acquisition unit 132, a search formula configuration unit 231, an original information search unit 232, an original information calculation unit 134, and a search formula storage unit 233.

  The search formula construction unit 231 constructs a search formula for searching the original information for each combination of the attribute values of the first attribute and the attribute values of the second attribute. This search expression is a search expression for searching the table for records satisfying both the attribute value of the first attribute and the attribute value of the second attribute. The search expression may be a standardized search expression such as SQL or information indicating a search condition unique to the system. The search formula description method does not matter. The search expression constructing unit 231 can usually be realized by an MPU, a memory, or the like. The processing procedure of the search formula constructing means 231 is usually realized by software, and the software is recorded on a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  The original information search means 232 searches the original information by executing the search formula constructed by the search formula construction means 231 for each combination of the attribute values of the first attribute and the attribute values of the second attribute. The original information search means 232 can usually be realized by an MPU, a memory, or the like. The processing procedure of the original information search means 232 is usually realized by software, and the software is recorded on a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  The search formula storage unit 233 stores the search formula configured by the search formula configuration unit 231 for each number of source information calculated by the source information calculation unit 134 (for each box of the summary table). Here, the accumulation is usually writing in a non-illustrated nonvolatile recording medium, but it may be written in a volatile recording medium. The search expression storage unit 233 can be usually realized by an MPU, a memory, or the like. The processing procedure of the search expression storage unit 233 is usually realized by software, and the software is recorded on a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  When the instruction receiving unit 12 receives the original information output instruction, the original information acquisition unit 25 acquires the original information of the value output in the box of the summary table. When the instruction receiving unit 12 receives the original information output instruction, the original information acquisition unit 25 reads a search expression corresponding to the number of original information (boxes) output in the box of the summary table and executes the search expression And get the original information. The original information acquisition unit 25 can usually be realized by an MPU, a memory, or the like. The processing procedure of the original information acquisition unit 25 is usually realized by software, and the software is recorded on a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  Next, the operation of the information processing apparatus 2 will be described using the flowchart of FIG. In the flowchart of FIG. 8, the description of the same processing as that of the flowchart of FIG. 2 is omitted.

  (Step S801) The search expression construction unit 231 constructs a search expression that satisfies both attribute values using the attribute value of the first attribute and the attribute value of the second attribute (two pieces of information of the i-th set). . The search expression constructing unit 231 follows, for example, the SQL of “select first attribute, second attribute from table identifier where first attribute = first attribute value AND second attribute = second attribute value”. A search expression. Further, the search formula constructing unit 231 may configure a system-specific search formula, for example, “first attribute = first attribute value AND second attribute = second attribute value”.

  (Step S802) The original information search unit 232 executes the search formula configured in step S801.

  (Step S803) The search formula storage unit 233 stores the search formula configured in step S801 in association with the box.

  (Step S804) The original information acquisition unit 25 reads a search expression stored corresponding to the box corresponding to the original information output instruction.

  (Step S805) The original information acquisition unit 25 executes the search formula read in step S804 and acquires the original information.

  In the flowchart of FIG. 8, the process ends when the power is turned off or the process is terminated.

  Hereinafter, a specific operation of the information processing apparatus 2 in the present embodiment will be described.

  Now, the table storage unit 11 stores the personnel management table shown in FIG. In such a situation, for example, it is assumed that the user inputs an aggregation table output instruction “OutputSatisticalTable personnel management table department title” to the information processing apparatus 1.

  Next, the instruction receiving unit 12 receives a summary table output instruction “OutputSatisticalTable Personnel Management Table Department Title”.

  Next, the first attribute value acquisition unit 131 acquires the first attribute “department” among the attributes of the table. Then, the second attribute value acquisition unit 132 acquires the second attribute “position” of the table attributes.

  Next, the first attribute value acquisition unit 131 acquires all the attribute values of the first attribute “department” from the personnel management table of FIG.

  Next, the second attribute value acquisition unit 132 acquires all the attribute values “title” of the second attribute from the personnel management table of FIG.

  Next, the original information search unit 133 acquires a set (first set) of the attribute value “management unit” of the first attribute and the attribute value “management director” of the second attribute. Then, the original information search unit 133 searches for a record that satisfies both the attribute value “management unit” of the first attribute and the attribute value “management director” of the second attribute “select department, job title”. from Personnel Management Table where Department = Management Department AND Title = Managing Director ”.

  Next, the original information search means 232 executes the configured search expression “select department, title from personnel management table where department = management section AND title = management director”. Here, it is assumed that the original information retrieval unit 133 cannot retrieve such a record.

  Next, the original information calculation unit 134 calculates the number “0” of the acquired original information. Then, the retrieval formula storage means 233 sets the retrieval formula “select department, title from personnel management table where department = management section AND title = management director” to the number of calculated original information “0” (attribute of the first attribute For the value “management department” and the attribute value “management director” of the second attribute). When the number of original information is “0”, the search formula storage unit 233 may not store the search formula.

  Next, the original information search unit 133 acquires a set (second set) of the attribute value “management unit” of the first attribute and the attribute value “department manager” of the second attribute. Then, the original information search unit 133 searches for a record satisfying both the attribute value “management unit” of the first attribute and the attribute value “department manager” of the second attribute “select department, title from. HR management table where department = administration department AND title = department manager ”.

  Next, the original information search means 232 executes the configured search expression “select department, position from personnel management table where department = management section AND position = department manager”. Here, the original information search means 133 searches for the record of “ID = 2” in FIG.

  Next, the original information calculation unit 134 calculates the number “1” of the acquired original information. Then, the retrieval formula storage means 233 uses the retrieval formula “select department, position from personnel management table where department = management section AND position = department manager” as the number of calculated original information “1” (the attribute value of the first attribute). For the “management section” and the attribute value “department” box of the second attribute).

  The above processing is repeated, and the search formula storage unit 233 of the total table configuration unit 23 stores the search formula for each box of the total table. The above process is performed for all pairs of the attribute value of the first attribute and the attribute value of the second attribute.

  Further, the above process outputs the summary table shown in FIG. 3, and the original information that is the basis of each box of the summary table is associated with the box (associated with the number of original information), Accumulated. FIG. 9 shows an example of a search expression stored in association with a box (corresponding to the number of original information).

  Next, the summary table configuration unit 23 configures the axes (vertical axis and horizontal axis) of the summary table using all of the attribute values of the first attribute and all of the attribute values of the second attribute. Next, the summary table configuration unit 23 arranges the number of acquired original information for each box of the summary table. Here, the configured summary table is shown in FIG. Then, the summary table output unit 14 outputs the configured summary table of FIG. 5 to the display.

  Next, the user wants to confirm what kind of person is among the nine “leaders” who belong to the “sales department”, and the first attribute value “sales department” in FIG. , Move the focus to the box corresponding to the second attribute value “boss” (the box with “9” inside) (for example, use the mouse as an input means) and input the original information output instruction Suppose that

  Next, the instruction receiving unit 12 receives an original information output instruction. The original information acquisition unit 25 corresponds to the original information output instruction, the search expression “select department,” corresponding to the box of the aggregation table (the first attribute value “sales department”, the second attribute value “boss” box). “From” Personnel management table “where department = sales department AND title = lead” is read.

  Next, the original information acquisition unit 25 executes the read search formula “select department, title from personnel management table where department = sales department AND title = boss” to acquire the original information.

  And the original information output part 16 comprises original information in the aspect to output. Here, the original information output unit 16 classifies the original information for each attribute value of the first attribute and configures the original information to be output. Next, the original information output unit 16 outputs the configured original information in a manner as shown in FIG.

  As described above, according to the present embodiment, if the DB is searched and the attribute value of the configured summary table is indicated, the original information that is the source of the attribute value can be output.

  In addition, according to the present embodiment, since only the search formula for acquiring the original information that is the basis of the numerical value in the box of the summary table is stored in advance, only by using a small storage medium capacity, Original information can be output.

  Note that the software that implements the information processing apparatus according to the present embodiment is the following program. In other words, this program causes the computer to set two or more attribute values of the first attribute among the table attributes stored in the storage medium as the values of the vertical axis and two or more attribute values of the second attribute. A tabulation table output unit that outputs a tabulation table with values on the horizontal axis, each box of the tabulation table outputting the number of records in the table that satisfies both the values on the vertical axis and the values on the horizontal axis And the information that is the source of the value that is output to the box of the summary table, and is the information that can be acquired from the record of the table that satisfies both the vertical axis value and the horizontal axis value of the summary table An instruction receiving unit that receives an original information output instruction that is an instruction to output information, and a source that acquires the original information of the value output in the box of the summary table when the instruction receiving unit receives the original information output instruction An information acquisition unit and an original information output unit for outputting the original information; Program to function, it is.

  In the above program, the instruction accepting unit also accepts a summary table output instruction that is an instruction to output a summary table, and when the instruction accepting unit accepts the summary table output instruction, A summary table in which two or more attribute values of the first attribute are values on the vertical axis and two or more attribute values of the second attribute are values on the horizontal axis, and each box of the summary table has a vertical It further functions as a summary table configuration unit that constitutes a summary table that outputs the number of records that satisfy both the axis value and the horizontal axis value, and the summary table output unit uses the summary table configured by the summary table configuration unit. Output, and the summary table configuration unit includes first attribute value acquisition means for acquiring each attribute value of the first attribute among the attributes of the table, and each attribute of the second attribute among the attributes of the table Second attribute value acquisition means for acquiring a value, each attribute value of the first attribute, For each combination of attribute values of the second attribute, search expression constructing means for configuring a search expression for searching the original information, each attribute value of the first attribute, each attribute value of the second attribute For each combination of the above, the original information search means for executing the search formula and searching for the original information, and for each combination of each attribute value of the first attribute and each attribute value of the second attribute, the original information Retrieval expression storage for storing, for each number of original information calculated by the original information calculation means, original information calculation means for calculating the number of original information searched by the search means, and a search expression constituted by the search expression construction means And when the instruction receiving unit receives the original information output instruction, the original information acquisition unit reads a search formula corresponding to the number of original information output in the box of the summary table, and Functions to execute search formulas and retrieve source information Because of the program, it is.

  FIG. 10 shows the external appearance of a computer that executes the program described in this specification to realize the information processing apparatus according to the above-described embodiment. The above-described embodiments can be realized by computer hardware and a computer program executed thereon. FIG. 10 is an overview of the computer system 340, and FIG. 11 is a block diagram of the computer system 340.

  10, a computer system 340 includes a computer 341 including an FD (Flexible Disk) drive and a CD-ROM (Compact Disk Read Only Memory) drive, a keyboard 342, a mouse 343, and a monitor 344.

  In FIG. 11, in addition to the FD drive 3411 and the CD-ROM drive 3412, the computer 341 includes a CPU (Central Processing Unit) 3413, a bus 3414 connected to the CPU 3413, the CD-ROM drive 3412, and the FD drive 3411, and a boot. A ROM (Read-Only Memory) 3415 for storing a program such as an up program, and a RAM (Random Access Memory) connected to the CPU 3413 for temporarily storing instructions of an application program and providing a temporary storage space 3416 and a hard disk 3417 for storing application programs, system programs, and data. Although not shown here, the computer 341 may further include a network card that provides connection to the LAN.

  A program that causes the computer system 340 to execute the functions of the information processing apparatus according to the above-described embodiment is stored in the CD-ROM 3501 or the FD 3502, inserted into the CD-ROM drive 3412 or the FD drive 3411, and further stored in the hard disk 3417. May be forwarded. Alternatively, the program may be transmitted to the computer 341 via a network (not shown) and stored in the hard disk 3417. The program is loaded into the RAM 3416 at the time of execution. The program may be loaded directly from the CD-ROM 3501, the FD 3502, or the network.

  The program does not necessarily include an operating system (OS) or a third-party program that causes the computer 341 to execute the functions of the information processing apparatus according to the above-described embodiment. The program only needs to include an instruction portion that calls an appropriate function (module) in a controlled manner and obtains a desired result. How the computer system 340 operates is well known and will not be described in detail.

  In the above program, in a transmission step for transmitting information, a reception step for receiving information, etc., processing performed by hardware, for example, processing performed by a modem or an interface card in the transmission step (only performed by hardware). Not included) is not included.

  Further, the computer that executes the program may be singular or plural. That is, centralized processing may be performed, or distributed processing may be performed.

  In each of the above embodiments, each process (each function) may be realized by centralized processing by a single device (system), or by distributed processing by a plurality of devices. May be.

  The present invention is not limited to the above-described embodiments, and various modifications are possible, and it goes without saying that these are also included in the scope of the present invention.

  As described above, the information processing apparatus according to the present invention has an effect that the original information that is the basis of the numerical value in the box of the summary table can be easily output, and is an information processing apparatus such as a personnel management system. Useful.

Block diagram of information processing apparatus according to Embodiment 1 Flow chart for explaining the operation of the information processing apparatus Figure showing the personnel management table The figure which shows the example of the original information which is accumulated Figure showing the summary table The figure which shows the output mode of the same origin information Block diagram of an information processing apparatus according to Embodiment 2 Flow chart for explaining the operation of the information processing apparatus The figure which shows the example of the same retrieval formula which is accumulated Overview of the computer system Block diagram of the computer system

Explanation of symbols

DESCRIPTION OF SYMBOLS 1, 2 Information processing apparatus 11 Table storage part 12 Instruction reception part 13, 23 Total table structure part 14 Total table output part 15, 25 Original information acquisition part 16 Original information output part 131 1st attribute value acquisition means 132 2nd attribute value Acquisition means 133, 232 Original information search means 134 Original information calculation means 135 Original information storage means 231 Search formula construction means 233 Search formula storage means

Claims (7)

A table storage unit capable of storing one or more tables having two or more attributes;
An instruction receiving unit that receives a summary table output instruction that is an instruction to output a summary table;
When the first attribute or the second attribute among the attributes of the table constitutes a hierarchy of n (n is 2 or more), two or more for all combinations of attributes from 1 to n that constitute the hierarchy Is an aggregation table in which two or more attribute values are taken as vertical or horizontal axis values, and two or more attribute values of non-hierarchical attributes are taken as horizontal or vertical axis values. In each box of the summary table, a summary table component that forms a summary table that outputs the number of records that satisfy both the vertical axis value and the horizontal axis value,
A summary table output unit for outputting a summary table configured by the summary table configuration unit ;
The summary table component is
The attribute name on the vertical or horizontal axis of the summary table is composed of two or more attribute values of the attributes constituting the hierarchy, and the two or more attribute values of the non-hierarchical attributes are An information processing apparatus that configures attribute names on the horizontal axis or the vertical axis . The summary table output unit
When two or more attribute values for all combinations of attributes constituting the hierarchy are output as values on the vertical axis or horizontal axis, the two or more attribute values are indented in such a manner that the hierarchy can be visually grasped. The information processing apparatus according to claim 1, which outputs the information processing apparatus. The instruction receiving unit
The original information that is the information that is the source of the value that is output to the box of the summary table and that can be acquired from the record of the table that satisfies both the vertical axis value and the horizontal axis value of the summary table. Accept the original information output instruction that is the instruction to output,
When the instruction accepting unit accepts an original information output instruction, an original information obtaining unit that obtains original information of values output in the boxes of the summary table;
An original information output unit for outputting the original information;
The summary table component is
First attribute value acquisition means for acquiring each attribute value of the first attribute among the attributes of the table;
Second attribute value acquisition means for acquiring each attribute value of the second attribute among the attributes of the table;
Original information search means for searching for original information for each attribute value of the first attribute and each attribute value of the second attribute;
Original information calculation means for calculating the number of original information acquired by the original information search means for each attribute value of the first attribute and each attribute value of the second attribute;
The original information searched by the original information search means comprises original information accumulation means for accumulating for each box of the tabulation table,
The original information acquisition unit
The original information corresponding to the number of pieces of original information output in the box of the summary table and read out the original information accumulated by the original information accumulation unit when the instruction accepting unit accepts an original information output instruction. The information processing apparatus according to claim 1 or 2. The instruction receiving unit
The original information that is the information that is the source of the value that is output to the box of the summary table and that can be acquired from the record of the table that satisfies both the vertical axis value and the horizontal axis value of the summary table. Accept the original information output instruction that is the instruction to output,
When the instruction accepting unit accepts an original information output instruction, an original information obtaining unit that obtains original information of values output in the boxes of the summary table;
An original information output unit for outputting the original information;
The summary table component is
First attribute value acquisition means for acquiring each attribute value of the first attribute among the attributes of the table;
Second attribute value acquisition means for acquiring each attribute value of the second attribute among the attributes of the table;
A search expression constructing unit that configures a search expression for searching original information for each attribute value of the first attribute and each attribute value combination of the second attribute;
For each combination of each attribute value of the first attribute and each attribute value of the second attribute, original information search means for executing the search formula and searching for original information;
Original information calculation means for calculating the number of original information searched by the original information search means for each combination of attribute values of the first attribute and attribute values of the second attribute;
A search formula storage means for storing the search formula configured by the search formula configuration means for each box of the summary table;
The original information acquisition unit
When the instruction receiving unit receives an original information output instruction, a search expression corresponding to the number of original information output in the box of the aggregation table is read, the search expression is executed, and the original information is acquired. The information processing apparatus according to claim 1 or 2. The original information output unit
The information processing apparatus according to claim 1, wherein the original information is classified and output for each attribute value of the first attribute or for each attribute value of the second attribute. In the storage medium,
Contains one or more tables with two or more attributes,
An information processing method realized by an instruction receiving unit, a summary table configuration unit, and a summary table output unit,
An instruction receiving step in which the instruction receiving unit receives an aggregation table output instruction which is an instruction to output an aggregation table;
When the first or second attribute among the table attributes constitutes a hierarchy of n (where n is 2 or more), all of the 1 to n stages constituting the hierarchy 2 or more attribute values for a combination of attributes are obtained, the two or more attribute values are set as values on the vertical axis or the horizontal axis, and two or more attribute values of non-hierarchical attributes are set on the horizontal axis or the vertical axis A summary table that constitutes a summary table in which the number of records that satisfy both the value on the vertical axis and the value on the horizontal axis is output in each box of the summary table,
The summary table output unit comprises a summary table output step for outputting the summary table configured in the summary table configuration step ,
In the summary table configuration step,
The attribute name on the vertical or horizontal axis of the summary table is composed of two or more attribute values of the attributes constituting the hierarchy, and the two or more attribute values of the non-hierarchical attributes are An information processing method for configuring attribute names on the horizontal axis or the vertical axis . In the storage medium,
Contains one or more tables with two or more attributes,
Computer
An instruction receiving unit that receives a summary table output instruction that is an instruction to output a summary table;
When the first attribute or the second attribute among the attributes of the table constitutes a hierarchy of n (n is 2 or more), two or more for all combinations of attributes from 1 to n that constitute the hierarchy Is an aggregation table in which two or more attribute values are taken as vertical or horizontal axis values, and two or more attribute values of non-hierarchical attributes are taken as horizontal or vertical axis values. In each box of the summary table, a summary table component that forms a summary table that outputs the number of records that satisfy both the vertical axis value and the horizontal axis value,
A program for functioning as a summary table output unit for outputting a summary table configured by the summary table configuration unit ,
The summary table component is
The attribute name on the vertical or horizontal axis of the summary table is composed of two or more attribute values of the attributes constituting the hierarchy, and the two or more attribute values of the non-hierarchical attributes are A program that configures attribute names on the horizontal or vertical axis .

Images