JP5090846B2 - Information processing apparatus, data analysis system, control method, and program - Google Patents

Description

  The present invention relates to an information processing apparatus, a data analysis system, a data analysis method, a program, and a recording medium that analyze data and graph it.

  In recent years, syndicated loans have become widespread as a new form of financing. Syndicated loans are a form of financing in which multiple participating investors, such as financial institutions, form a co-financing group and provide credit, such as lending with the same pledge, in response to borrowers' funding needs. Along with the increase in syndicated loan contracts, systems for contract work support and contract information management have been developed.

  Based on the information accumulated in these management systems, it is necessary to have a function to analyze the appropriateness of loans, such as whether loans with syndicated loans are being made at an appropriate interest rate and whether the loans are biased.

  2. Description of the Related Art Conventionally, in a data processing apparatus, a program that can analyze data and create various graphs has been created. Such a program is provided with a function for displaying the data analysis result in an easy-to-understand manner.

  Japanese Patent Application Laid-Open No. 2004-228561 describes a technique that allows associated data and graph elements to be referenced in association with each other.

  Patent Document 2 describes a technique for creating a graph by exchanging data rows and columns.

  In conventional syndicated loan systems, management is performed on a contract-by-contract basis, and the work of aggregating and analyzing what contracts and conditions are performed in the entire financial institution has been performed manually. .

  In addition, as the number of contracts increases, the burden of this aggregation / analysis work also increases.

  It was necessary to create a list of aggregation / analysis results and graph creation while changing the items to be aggregated / analyzed one by one.

The person in charge (user) in the syndicated loan had to perform the work of aggregation and analysis while combining the conditions of this item by himself.
JP 2005-4780 A JP 60-154294 A

However, for example, when performing a validity analysis of syndicated loans, as described above, a list of aggregate analysis results, when performing tasks such as creating graphs and the aggregate and analyzed each time the item to aggregate and analyze changes It is necessary to change the items one by one. Therefore, in the technologies disclosed in Patent Document 1 and Patent Document 2, in the creation of a list, a graph, etc. used when analyzing the validity of a syndicated loan, according to the change of the items to be aggregated and analyzed, In order to set items corresponding to the rows and columns of the list, and to set items corresponding to the axes of the graph, it is necessary to sequentially perform complicated work, which places a considerable burden on the operator .

The present invention has been made to solve the above-described problems, and an object of the present invention is to display a plurality of objects corresponding to combinations of items for performing aggregation, analysis, etc., which are considered necessary in advance, in a matrix. Display, set statistical processing for the displayed object , and display the processing result of statistical processing for the selected object on the screen as a graph. It is to provide a mechanism that can reduce the load.

The present invention provides an information processing apparatus that displays a result of statistical processing using data composed of a plurality of items, and displays a plurality of objects corresponding to a plurality of item sets obtained by combining the items in a matrix. Matrix display means, setting means for setting statistical processing on the objects displayed by the matrix display means, and selection of any object from a plurality of objects displayed in a matrix by the matrix display means Classification means, and statistical processing means for classifying each item constituting an item set corresponding to the object selected by the selection means, and performing statistical processing set on the object for each classification for the data the Ma objects selected by said selection means The items constituting the item set corresponding to the helix-shaped rows and columns to the axis, the processing results of the statistical processing by the statistical processing unit, characterized in that it and a graph display means for displaying a graph.

According to the present invention, when data is aggregated and analyzed, a plurality of objects corresponding to combinations of items to be aggregated and analyzed that are considered necessary in advance are displayed on the screen in a matrix and displayed. By setting statistical processing for an object and displaying the processing result of statistical processing for the object for which selection has been received on the screen, it is possible to reduce the work load on the operator required for aggregation, analysis, etc. The effects are as follows.

[First Embodiment]
Hereinafter, embodiments of the present invention will be described with reference to the drawings.

<Description of FIG. 1>
FIG. 1 is a system configuration diagram schematically showing the configuration of a system showing an embodiment of the present invention.

  As shown in FIG. 1, in the system according to this embodiment, a client terminal 102 and a data management server 101 are connected to each other via a network 103 such as a LAN (a network device HUB in FIG. 1) so as to communicate with each other. It has a configuration.

  The data management server 101 stores and manages data to be analyzed. Further, there may be a plurality of client terminals 102 and data management servers 101. Furthermore, a stand-alone configuration with only the client terminal 102 may be used. In this case, it is assumed that the function of the data management server 101 is provided in the client terminal 102.

<Description of FIG. 2>
FIG. 2 is a block diagram schematically showing an example of the hardware configuration of the client terminal 102 and the data management server 101 shown in FIG.

  In FIG. 2, the CPU 201 comprehensively controls each device and controller connected to the system bus 204.

  In the ROM 202 or the external memory 211, a BIOS (Basic Input / Output System) or an operating system program (hereinafter referred to as OS), which is a control program of the CPU 201, or a function to be executed by the server or each client, which will be described later. Various programs are stored.

  The RAM 203 functions as a main memory, work area, and the like for the CPU 201.

  The CPU 201 implements various operations by loading a program necessary for execution of processing into the RAM 203 and executing the program.

  An input controller (input C) 205 controls input from a pointing device such as a keyboard 209 or a mouse (not shown).

  A video controller (VC) 206 controls display on the display 210. The display 210 may be a CRT display or a liquid crystal display.

  The memory controller (MC) 207 is a hard disk (HD) or floppy (registered trademark) disk (FD) CD- that stores a boot program, browser software, various applications, font data, user files, editing files, various data, and the like. Controls access to an external memory 211 such as a compact flash (registered trademark) memory connected to the ROM or PCMCIA card slot via an adapter.

  A communication I / F controller (communication I / FC) 208 is connected to and communicates with an external device via the network 103, and executes communication control processing in the network. For example, Internet communication using TCP / IP is possible.

  Note that the CPU 201 enables display on the display 210 by executing outline font rasterization processing on a display information area in the RAM 203, for example.

  Further, the CPU 201 enables a user instruction with a mouse cursor (not shown) on the display 210.

  A program for realizing the present invention is recorded in the external memory 211, and is executed by the CPU 201 by being loaded into the RAM 203 as necessary.

  Furthermore, various data and various tables used by the program according to the present invention are stored in the external memory 211, and a detailed description thereof is shown in FIG.

<Description of FIG. 3>
FIG. 3 is a block diagram schematically showing an example of the software configuration of the client terminal 102 and the data management server 101 in FIG. In addition, the same code | symbol is attached | subjected to the same thing as FIG.

  As shown in FIG. 3, the data management server 101 includes an operating system program (hereinafter referred to as OS) 101-4, an application 101-1 that realizes a function executed by the data management server 101, various data and tables that will be described later. DB101-2 etc. for storing are provided.

  The OS 101-4 and the application 101-1 are realized when the CPU 201 of the data management server 101 loads a program recorded in the external memory 211 to the RAM 203 and executes it.

  Further, the client terminal 102 includes an OS 102-3, an application 102-1 that realizes a function executed by the client terminal 102, a data analysis application 102-2 (an application for realizing the present invention), and the like.

  Note that the OS 102-3, the application 102-1, and the data analysis application 102-2 load the program recorded in the external memory 211 (or downloaded from the data management server 101) into the RAM 203 by the CPU 201 of the client terminal 102. It is realized by executing.

  In the case of a stand-alone configuration of the client terminal 102, the DB 101-2 and the like are mounted in the client terminal 102.

  FIG. 30 is a block diagram illustrating functions of the data analysis application 102-2 illustrated in FIG.

  Hereinafter, the function of the data analysis application 102-2 will be briefly described with reference to FIG.

  The data analysis application 102-2 includes a display unit 3001, a selection (acceptance) unit 3002, a statistical processing unit 3003, and a narrowing-down unit 3004.

  The display unit 3001 has a function of displaying a narrowed item display unit 1001, a matrix display unit 1002, a list display unit 1003, a graph display unit 1004, an execution button 1005, and the like.

  In other words, the display unit 3001 has a function of arranging and displaying a plurality of objects corresponding to a plurality of item sets obtained by combining items on the matrix display unit 1002 in a matrix.

  The selection (acceptance) unit 3002 has a function of accepting any selection from a plurality of objects displayed by the matrix display unit.

  Further, the statistical processing unit 3003 has a function of performing statistical processing on the data using each item constituting the item set corresponding to the object selected by the selection (acceptance) unit 3002 as a parameter, and outputting the statistical processing result.

  The narrowing-down unit 3004 has a function of narrowing down the data by the designated data value of the designated item. Further, the statistical processing unit has a function of performing statistical processing on the data narrowed down by the narrowing-down unit.

  Hereinafter, the features of this embodiment will be described using a definition example of the data analysis screen shown in FIG.

<Description of FIGS. 4 to 8>
FIG. 4 is a diagram showing a definition example of a data analysis screen (for example, portfolio analysis screen) in the present embodiment. This data analysis screen is displayed on the display 210 of the client terminal 102 by the data analysis application 102-2 shown in FIG.

  As shown in FIG. 4, the data analysis screen includes four areas (display units) of a narrowed item display unit 1001, a matrix display unit 1002, a list display unit 1003, and a graph display unit 1004, and an execution button for executing processing 1005 is defined. These definitions are made by the user or the like and will be described in detail later.

  Hereinafter, each region (display unit) will be described.

  The narrowed item display unit 1001 is for narrowing down the data to be analyzed by the value of a specific item (narrowing condition item). In the definition example of FIG. 4, the above-described narrowing condition item is defined (set) as “use work”. The user can select a filtering condition for data to be tabulated from a filtering condition menu set in the filtering item display unit 1001. For example, when the narrowing condition item is defined (set) as “business type” and the user selects “food business” in the narrowing item display unit 1001, data analysis is performed by narrowing down only to data related to the food business. be able to. Depending on the definition of the narrowing condition items, a plurality of narrowing item display units 1001 may be provided so that a plurality of narrowing conditions can be selected. The narrowing condition menu set will be described later with reference to FIG.

  The matrix display unit 1002 is for selecting a total item (combination of items (parameter set) used as a parameter for statistical processing) in one operation. In the matrix display unit 1002, the user selects a cell at a location where two items to be aggregated (to be used as a parameter for statistical processing) intersect. Thereby, it is possible to select the total item (combination of items (parameter set) used as a parameter for statistical processing) with one operation. Two items constituting the item set corresponding to the cell selected in the matrix display unit 1002 are an item to be a side label (1804 in FIG. 7 described later) of the list displayed on the list display unit 1003, and a top label. (1805 in FIG. 7 described later) is set as two items. Also, the above two items are two items: an item that becomes the X axis (X axis shown in FIG. 8 described later) of the graph displayed on the graph display unit 1004, and an item that becomes the Z axis (Z axis shown in FIG. 8 described later). Set as an item. Details of the matrix display unit 1002 will be described later with reference to FIG.

  Reference numeral 1005 denotes an execution button for reflecting the narrowing item selection result in the narrowing item display unit 1001 and the total item selection result in the matrix display unit 1002 in the list display unit 1003 and the graph display unit 1004.

  FIG. 5 is a diagram illustrating a definition example of the matrix display unit 1002 illustrated in FIG.

  As shown in FIG. 5, the matrix display unit 1002 displays cells (objects) corresponding to the items to be aggregated (combinations of items (parameter sets) used as statistical processing parameters) in a matrix format. By selecting a cell at a location where two items to be aggregated (statistical processing) intersect among these cells, it is possible to select aggregated items (combinations of items that are parameters for statistical processing) in a batch. Become. Note that the total item (cell) may not be selectable depending on the combination of items or the definition of the user. In the definition example of FIG. The definition procedure of the matrix display unit 1002 will be described later.

  By switching the selection of the cells in the matrix display unit 1002 and pressing the execute button 1005, the list and graph are changed (FIG. 6).

  FIG. 6 is a diagram showing how the list and graph are changed by switching the selection of cells in the matrix display unit 1002.

  Next, the list display unit 1003 and the graph display unit 1004 in FIG. 4 will be described with reference to FIGS.

<Explanation of FIG. 7>
FIG. 7 is a diagram showing in detail the list display unit 1003 shown in FIG. In FIG. 7, the list display unit 1003 is shown in an independent window format. This corresponds to a format displayed on the display 210 by the CPU 201 when the list display unit 1003 is double-clicked by a pointing device (not shown) of the client terminal 102.

  In FIG. 7, 1804 is a side label.

  1805 is a top label and 1806 is an auxiliary item of the top label.

  Reference numeral 1801 denotes an item selected as the side label 1804 (here, “spread range”). 1802 indicates an item selected as an auxiliary item of the top label 1805 and the top label (here, “listing category code”, “listed category”). Reference numeral 1803 denotes items counted in the list (here, “balance”).

<Description of FIG. 8>
FIG. 8 is a diagram showing in detail the graph display unit 1004 shown in FIG. In FIG. 8, the graph display unit 1004 is shown in an independent window format. This corresponds to a format displayed on the display 210 by the CPU 201 by double-clicking the graph display unit 1004 with a pointing device (not shown) of the client terminal 102.

  In FIG. 8, 1804 is a side label.

  1805 is a top label and 1806 is an auxiliary item of the top label.

  Reference numeral 1902 denotes an item corresponding to the Y axis of the graph (here, “balance”). Reference numeral 1903 denotes an item corresponding to the Z-axis of the graph (here, “corporate number”). Reference numeral 1904 denotes an item corresponding to the X axis of the graph (here, “last date (year / month)”). Reference numeral 1901 denotes a menu for setting a graph display format.

  The table used in this embodiment, FIGS. 9 to 20, and the definition of the script when the narrowed item display unit 1001, the matrix display unit 1002, and the execution button 1005 shown in FIG. 4 are pressed will be described.

<Description of FIGS. 9 to 11>
9 to 11 are diagrams illustrating examples of tables and data used in the DB 101-2 illustrated in FIG.

  In the present embodiment, the user selects and sets (defines) a total item (that is, an item displayed on the matrix display unit 1002) in advance from items registered in the table.

  In this embodiment, in the column of (1) Statistics master, (2) Lending balance table, CL statistics “Aggregation item” shown in FIGS. 9 to 11, items with “O” are aggregation items (statistical processing). Are selected and set (defined).

  In this embodiment, the user selects and sets (defines) a filtering condition item (that is, an item displayed on the filtering item display unit 1001) from items registered in the table. .

  In the narrowed-down item display unit 1001 in FIG. 4, an item described as “squeezed condition” in the “total item” column is selected and set (defined) as a narrowed-down condition item.

  Furthermore, in the present embodiment, the user selects and sets (defines) the Y axis (that is, the Y axis of the graph displayed on the graph display unit 1004 (FIG. 8)) in advance from the items registered in the table. It has a configuration.

  The item described as “Y-axis” in the “total item” column of FIG. 10 is selected and set (defined) as the Y-axis item.

  Hereinafter, setting (definition) of “total items”, that is, items to be used as statistical processing parameters will be described with reference to FIGS.

<Description of FIGS. 12 to 20>
FIG. 12 is a flowchart showing an example of a first control processing procedure in the present invention, and corresponds to the definition procedure of the matrix display unit 1002 shown in FIGS. Note that the processing of this flowchart is realized by the CPU 201 of the client terminal 102 loading the program stored in the external memory 211 (or downloaded from the data management server 101) into the RAM 203 and executing it.

  First, the CPU 201 of the client terminal 102 acquires items of tables (illustrated in FIGS. 9 to 11) used in the DB 101-2 of the data management server 101. Then, the CPU 201 of the client terminal 102 receives selection (designation) of items to be aggregated from the acquired table items from a selection screen (not shown) (S1101). At this time, for each selected item, input of display names to be displayed on the matrix display unit 1002, a list, and auxiliary items to be displayed on the graph are also accepted. The selection result of the total item is illustrated in FIG.

  FIG. 13 is a diagram illustrating an example of a correspondence between a display name (1201) in a cell and a DB item name (1202) when seven items are tabulated from the table.

  In FIG. 13, reference numeral 1202 corresponds to the DB item name selected as the total item from the table. 1201 corresponds to the display name on the matrix display unit 1002 set when the DB item name 1202 is selected.

  In addition, as shown by 1203, you may set the item for displaying an item name as a supplementary item.

  Note that the number of items to be aggregated can be determined according to the user's needs.

  Returning to the flowchart of FIG.

  In step S1101, when selection of a total item is input, the CPU 201 of the client terminal 102 advances the processing to step S1102.

  In step S1102, the CPU 201 of the client terminal 102 determines the number of cells that form a matrix, and generates a matrix display unit in which cells (objects) of the determined number of cells are arranged in a matrix.

  In selecting the total item, two items are selected from the items selected in step S1101. Accordingly, in the example illustrated in FIG. 13, there are 7 × 7 = 49 choices, and the CPU 201 of the client terminal 102 determines the number of cells as 49.

  FIG. 14 is a diagram exemplifying the arrangement of the total item names and cells displayed on the matrix display unit 1002.

  In FIG. 14, the total item names 1201 shown in FIG. In addition, the process when each cell is selected is defined for each cell of 1 to 49. The definition of this process will be described later.

  Returning to the flowchart of FIG.

  Next, the CPU 201 of the client terminal 102 executes a process of defining item information of each cell (each cell 1 to 49 illustrated in FIG. 14) generated in step S1102 (S1103). Details of this processing will be described later with reference to FIG.

  Next, the CPU 201 of the client terminal 102 determines whether or not the information of all cells generated in step S1102 has been defined (S1104). If it is determined that the information of all cells has not been defined yet, the process of step S1103 is performed. repeat.

  On the other hand, if the CPU 201 of the client terminal 102 determines in step S1104 that the information of all the cells generated in step S1102 has been defined, the process proceeds to step S1105.

  In step S1105, the CPU 201 of the client terminal 102 saves the matrix (the matrix generated in step S1102 and in which the item information of each cell is defined in S1103) in the DB 101-2 of the database management server 101, and the processing of this flowchart. Exit.

<Description of FIG. 15>
FIG. 15 is a flowchart showing an example of a second control processing procedure according to the present invention, and corresponds to the processing procedure for defining item information of each cell shown in step S113 of FIG. Note that the processing of this flowchart is realized by the CPU 201 of the client terminal 102 loading the program stored in the external memory 211 (or downloaded from the data management server 101) into the RAM 203 and executing it.

  FIG. 16 is a diagram showing a property screen, and FIGS. 17 and 18 are diagrams showing a script screen. Each cell is defined on the property screen (FIG. 16) and the script screen (FIGS. 17 and 18). And

  First, the CPU 201 of the client terminal 102 displays the cell property screen shown in FIG. 16 on the display 210, and accepts the definition of the name of the cell to be defined from the name input field 1501 of the cell property screen (S1401). . When the cell name is input, the process proceeds to step S1402.

  Next, the CPU 201 of the client terminal 102 receives the definition of whether or not the cell is a selectable cell from the check box 1502 on the cell property screen shown in FIG. 16, and determines whether or not the check box 1502 is checked (see FIG. 16). S1402).

  If it is determined that the check box 1502 is checked, the CPU 201 of the client terminal 102 advances the processing to step S1403.

  In step S1403, the CPU 201 of the client terminal 102 displays the cell script screen shown in FIG. 17 on the display 210. On the cell script screen, as shown by 1601 in FIG. Is received (S1403). When the definition of the cell information is input, the process proceeds to step S1404.

  Next, in step S1404, when the CPU 201 of the client terminal 102 selects a corresponding cell on the cell script screen, as indicated by 1602 and 1604 in FIG. It accepts the definitions of the labels and the X-axis and Z-axis items of the graph. When the definitions of the items to be the X axis and Z axis are input, the process proceeds to step S1405.

  Next, in step S1405, the CPU 201 of the client terminal 102 determines whether there is an item that is a supplementary item for each item corresponding to the cell.

  If it is determined that there is a supplementary item, the CPU 201 of the client terminal 102 accepts the definition of the supplementary item as indicated by 1603 and 1604 in FIG. 17A (S1406). When the definition of the supplementary item is input, the process proceeds to step S1407.

  On the other hand, if it is determined in step S1405 that there is no item that is a supplementary item for each item corresponding to the cell, the CPU 201 of the client terminal 102 proceeds to step S1407 as it is.

  In step S1407, the CPU 201 of the client terminal 102 receives a definition of processing to be executed when a cell is selected on the cell script screen. Specifically, as illustrated in 1606 and 1607 in FIG. 17B, after the list is reset, the definition of processing for resetting the top label item and the side label item of the list is accepted. Also, as indicated by reference numerals 1608 and 1609 in FIG. 18 (3), after the graph is reset, the definition of processing for resetting the X-axis item and the Z-axis item of the graph is accepted. When the definition of the process to be executed when a cell is selected is input, the process proceeds to step S1409.

  On the other hand, if it is determined in step S1402 that the check box 1502 is not checked, the CPU 201 of the client terminal 102 advances the processing to step S1408.

  As described above, the cell includes a cell (1702 in FIG. 19) that cannot be selected without being checked in the check box 1502, and a cell (1701 in FIG. 19) that cannot be selected depending on the combination of items.

  FIG. 19 is a diagram illustrating setting of a non-selectable cell.

  In FIG. 19, the cell indicated by 1701 has the same items to be set on the top label, side label, graph X-axis, and Z-axis of the list, so the CPU 201 of the client terminal 102 cannot perform aggregation (selection). Impossible). A cell indicated by 1702 is a cell that cannot be aggregated according to the user's judgment.

  Note that the CPU 201 of the client terminal 102 does not select a check box 1502 in the cell property screen as shown in FIG. It shall be controlled by Returning to the flowchart of FIG.

  In step S1408, the CPU 201 of the client terminal 102 defines information that cannot be selected in the cell. As a result, the cell cannot be selected, and the display color is set to gray. Then, the CPU 201 of the client terminal 102 advances the processing to step S1409. Note that no script is defined for cells that cannot be selected.

  In step S1409, the CPU 201 of the client terminal 102 stores the cell definition made in steps S1401 to S1408 as definition information in the cell (object) generated in step S1102 of FIG. Then, the process of this flowchart is terminated, and the process returns to the flowchart of FIG.

<Description of FIG. 21>
FIG. 21 is a diagram showing a display example of the data analysis screen defined by the above series of definitions.

  Hereinafter, the flow of data analysis processing by the data analysis application 102-2 shown in FIG. 3 will be described with reference to FIGS.

<Description of FIG. 22>
FIG. 22 is a flowchart showing an example of a third control processing procedure according to the present invention, and corresponds to the main processing flow of the data analysis application 102-2 shown in FIG. Note that the processing of this flowchart is realized by the CPU 201 of the client terminal 102 loading the program stored in the external memory 211 (or downloaded from the data management server 101) into the RAM 203 and executing it.

  When the data analysis application 102-2 is activated, the CPU 201 of the client terminal 102 executes a data analysis screen display process (S301). The data analysis screen (FIG. 4) is displayed on the display 210 of the client terminal 102 by this data analysis screen display processing. Details of the data analysis screen display process in step S301 will be described later with reference to FIG.

  Note that at the end of step S301 in FIG. 22, the list and graphs are not yet displayed on the list display unit 1003 and the graph display unit 1004 shown in FIG.

  Next, the CPU 201 of the client terminal 102 accepts selection of the total items and selection conditions from the user on the data analysis screen (step S302).

  The selection of the total item is accepted from the matrix display unit 1002 shown in FIG. In the matrix display unit 1002, the user can select a total item by selecting a cell at a location where two items to be totaled (three items to be used as a parameter for statistical processing) intersect.

  The selection of the narrowing condition is accepted from the narrowing item display unit 1001 shown in FIG.

  The user can select a filtering condition for data to be tabulated from a filtering condition menu set in the filtering item display unit 1001. Depending on the definition of the narrowing condition items, a plurality of narrowing item display units 1001 may be provided so that a plurality of narrowing conditions can be selected. The narrowing condition menu set will be described later with reference to FIG.

  As described above, the total item may not be selectable depending on the combination of items and the definition of the user. For this reason, the CPU 201 of the client terminal 102 determines whether or not the selectable total item (cell of the selectable matrix display unit 1002) is selected (S303), and the selectable total item is selected. Until it becomes (until S303 becomes Yes), the process returns to step S302 to accept selection of the total item. Note that, when a cell of the matrix display portion 1002 that can be selected is selected, the display form (color, shape (shape that appears to be concave)) of the cell is changed.

  If the CPU 201 of the client terminal 102 determines that the selectable total item has been selected (Yes in S303), the CPU 201 accepts pressing of the execution button 1005 shown in FIG. 4 (Step S304).

  Then, the CPU 201 of the client terminal 102 determines whether or not the execution button 1005 has been pressed (S305). If it is determined that the execution button 1005 has not been pressed, the process returns to step S302, and the total item, Accept selection of narrowing conditions.

  On the other hand, if the CPU 201 of the client terminal 102 determines in step S305 that the execution button 1005 has been pressed, the process proceeds to step S306.

  Next, in step S306, the CPU 201 of the client terminal 102 determines whether or not a narrowing condition is selected, and if it is determined that the narrowing condition is selected, acquires the selected narrowing condition (S307). .

  Further, the CPU 201 of the client terminal 102 performs data narrowing according to the narrowing condition acquired in step S307 (S308). That is, the CPU 201 of the client terminal 102 extracts only data corresponding to the narrow-down condition acquired in step S307 from the data acquired from the DB 101-2 of the data management server 101 (acquired in S402 in FIG. 23 described later). Then, the process proceeds to step S310.

  On the other hand, if the CPU 201 of the client terminal 102 determines in step S306 that the narrow-down condition has not been selected, the process proceeds directly to step S309.

  Next, in step S309, the CPU 201 of the client terminal 102 executes processing (script) defined in the cell (total item) selected in step S302.

  With this script, the CPU 201 of the client terminal 102 executes processing for creating a list (S310) and displaying a graph (S311). The processing procedures for creating the list (S310) and displaying the graph (S311) will be described later with reference to FIGS. 25 and 26, respectively. The results of the list creation (S310) and graph display (S311) processes are displayed on the list display unit 1003 and the graph display unit 1004 shown in FIG.

  Next, in step S313, when the CPU 201 of the client terminal 102 determines whether or not to end the process (that is, whether or not an instruction to end the process is input by the user) and determines not to end the process. Returns the process to step S302. That is, the user can select cells from the matrix as necessary, and continuously perform the process of changing the aggregate items.

  On the other hand, if it is determined in step S313 that the process is to be terminated (the process termination instruction has been input by the user), the CPU 201 of the client terminal 102 executes the termination process in step S314 to execute the data analysis screen ( FIG. 4) ends. And the process of this flowchart is complete | finished.

<Description of FIG. 23>
FIG. 23 is a flowchart showing an example of a fourth control processing procedure in the present invention, and corresponds to the flow of the data analysis screen display processing shown in step S301 of FIG. Note that the processing of this flowchart is realized by the CPU 201 of the client terminal 102 loading the program stored in the external memory 211 (or downloaded from the data management server 101) into the RAM 203 and executing it.

  First, the CPU 201 of the client terminal 102 generates a data analysis screen (FIG. 4) on the RAM 203 (S400). At this time, the narrowed-down item display unit 1001 and the matrix display unit 1002 are not set yet.

  Next, the CPU 201 of the client terminal 102 connects to the DB 101-2 of the data management server 101 (S401), and acquires the data of the tables illustrated in FIGS. 9 to 11 (S402). The data acquired here includes the above-described various definitions (definition of narrowing items, definition of total items, definition of Y-axis items, etc.) stored in the DB 101-2.

  Next, the CPU 201 of the client terminal 102 acquires the conditions to be displayed on the narrowed item display unit 1001 from the table based on the data (particularly, the definition of the narrowing condition items) acquired in S402, and sets the acquired conditions. The narrowed item display unit 1001 is set on the data analysis screen (S403). Details of this processing will be described later with reference to FIG.

  Then, the CPU 201 of the client terminal 102 determines whether or not the selection menus for all defined narrowing-down condition items have been set (S404). If it is determined that the menu has not yet been set, the process returns to step S403. . That is, when a plurality of narrowing condition items are defined, a plurality of menus are generated.

  On the other hand, if the CPU 201 of the client terminal 102 determines that the selection menus for all defined narrowing-down condition items have been set, the process proceeds to step S405.

  Next, in step S405, the CPU 201 of the client terminal 102 sets the definition (generated matrix) of the aggregation items included in the data acquired in S402 on the data analysis screen as the matrix display unit 1002 illustrated in FIG.

  In step S406, the CPU 201 of the client terminal 102 displays the data analysis screen (including the refined item display unit 1001 and the matrix display unit 1002) on the display 210, and ends the process of this flowchart.

<Description of FIG. 24>
FIG. 24 is a flowchart showing an example of a fifth control processing procedure according to the present invention, and corresponds to the processing flow for setting the conditions to be displayed in the narrowing condition items on the analysis screen shown in step S403 of FIG. Note that the processing of this flowchart is realized by the CPU 201 of the client terminal 102 loading the program stored in the external memory 211 (or downloaded from the data management server 101) into the RAM 203 and executing it.

  First, in step S501, the CPU 201 of the client terminal 102 acquires the first data from the table based on the data (particularly the definition of the narrowing condition items) acquired in S402 in FIG. Further, the CPU 201 of the client terminal 102 sets the narrowed item display unit 1001 in which the first data is set as a selection menu (condition) on the data analysis screen.

  Next, the CPU 201 of the client terminal 102 acquires the next data from the table based on the definition of the narrowing condition items (S502).

  Next, the CPU 201 of the client terminal 102 determines whether the data acquired in step S502 is already set in the selection menu (condition) of the narrowed-down item display unit 1001 as a condition (S503).

  If it is determined in step S503 that the data acquired in step S502 has already been set as a condition in the selection menu of the narrowed item display unit 1001, the process returns to step S503 to acquire the next data. .

  On the other hand, if it is determined in step S503 that the data acquired in step S502 has not yet been set as a condition in the selection menu (condition) of the refined item display unit 1001, the process proceeds to step S504.

  In step S504, the CPU 201 of the client terminal 102 sets the data acquired in step S502 in the narrowed-down item display unit 1001 as a selection menu (condition).

  Then, the CPU 201 of the client terminal 102 determines whether all the data based on the definition of the above-described narrowing condition items has been set (S505). If it is determined that the data has not been set yet, the process returns to step S502. .

  On the other hand, when it is determined that all the data based on the definition of the narrowing-down condition items has been set, the CPU 201 of the client terminal 102 ends the process of this flowchart.

<Description of FIG. 25>
FIG. 25 is a flowchart showing an example of the sixth control processing procedure in the present invention, and corresponds to the flow of the list creation processing shown in step S311 of FIG. Note that the processing of this flowchart is realized by the CPU 201 of the client terminal 102 loading the program stored in the external memory 211 (or downloaded from the data management server 101) into the RAM 203 and executing it.

  First, the CPU 201 of the client terminal 102 resets the list currently displayed on the list display unit 1003 (S601).

  Next, the CPU 201 of the client terminal 102 sets, on the RAM 203, an item to be the top label (1805 in FIG. 7) defined in the cell of the summary item selected in the matrix display unit 1002 (1805 in FIG. 7). Set) (S602).

  Here, the CPU 201 of the client terminal 102 determines whether there is a supplementary item in the top label (S603). If it is determined that there is a supplementary item, the supplementary item (1806 in FIG. 7) is stored in the RAM 203. Set (set) (S604), the process proceeds to step S605.

  On the other hand, if it is determined in step S603 that there is no supplementary item in the top label, the CPU 201 of the client terminal 102 advances the process to step S605 as it is.

  In step S <b> 605, the CPU 201 of the client terminal 102 stores, in the RAM 203, an item that becomes the side label (1804 in FIG. 7) defined in the cell of the summary item selected in the matrix display unit 1002. Set (set) up.

  Here, the CPU 201 of the client terminal 102 determines whether there is a supplementary item in the side label (S606). If it is determined that there is a supplementary item, the CPU 201 sets (sets) the supplemental item in the side label on the RAM 203 ( S607), the process proceeds to step S608.

  On the other hand, if it is determined in step S606 that there are no supplementary items in the side label, the CPU 201 of the client terminal 102 proceeds to step S608 as it is.

  Next, in step S608, the CPU 201 of the client terminal 102 uses the data acquired from the DB 101-2 of the database management server 101 (data that has been narrowed down when the narrowing condition is set) as the top label and side Extract by the item set in the label.

  Next, the CPU 201 of the client terminal 102 totals the data extracted in step S608 with the items defined as Y-axis items, and creates a list of the total results on the RAM 203 (S609).

  Next, the CPU 201 of the client terminal 102 displays the list created on the RAM 203 on the list display unit 1003, and ends the process of this flowchart.

  That is, the CPU 201 of the client terminal 102 performs statistical processing (aggregation processing) on the data using each item constituting an item set (combination of items) corresponding to the cell selected in the matrix display unit 1002 as a parameter. The processing results are output as a list (a list display using each item constituting the item set corresponding to the selected cell) (S608 to S609).

<Description of FIG. 26>
FIG. 26 is a flowchart showing an example of the seventh control processing procedure in the present invention, and corresponds to the flow of the graph creation processing shown in step S312 of FIG. Note that the processing of this flowchart is realized by the CPU 201 of the client terminal 102 loading the program stored in the external memory 211 (or downloaded from the data management server 101) into the RAM 203 and executing it.

  First, the CPU 201 of the client terminal 102 resets the graph currently displayed on the graph display unit 1004 (S601).

  Next, the CPU 201 of the client terminal 102 sets (sets), on the RAM 203, the item that becomes the X axis of the graph, which is defined by the cell of the summary item that is selected in the matrix display unit 1002 (S702).

  Here, the CPU 201 of the client terminal 102 determines whether there is a supplementary item on the X axis (S703). If it is determined that there is a supplementary item, the CPU 201 sets (sets) the supplemental item on the X axis on the RAM 203 ( S704), the process proceeds to step S705.

  On the other hand, if it is determined in step S703 that there is no supplementary item in the top label, the CPU 201 of the client terminal 102 advances the process to step S605 as it is.

  Next, in step S <b> 705, the CPU 201 of the client terminal 102 sets (sets) on the RAM 203 the item that becomes the Z axis of the graph, which is defined by the cell of the aggregate item that is selected in the matrix display unit 1002. .

  Here, the CPU 201 of the client terminal 102 determines whether there is a supplementary item on the Z axis (S706). If it is determined that there is a supplementary item, the CPU 201 sets (sets) the supplementary item on the Z axis on the RAM 203 ( S707), the process proceeds to step S708.

  On the other hand, if it is determined in step S706 that there are no supplementary items on the Z-axis, the CPU 201 of the client terminal 102 advances the process to step S708 as it is.

  Next, in step S708, the CPU 201 of the client terminal 102 uses the data acquired from the DB 101-2 of the database management server 101 (the data that has been narrowed down when the narrowing condition is set) as the X axis and Z Extract by the item set in the axis.

  Next, the CPU 201 of the client terminal 102 aggregates the data extracted in step S708 with the items defined as the Y-axis items, and creates a graph of the aggregation results on the RAM 203 (S709).

  Next, the CPU 201 of the client terminal 102 displays the graph created on the RAM 203 on the graph display unit 1004 and ends the processing of this flowchart.

  That is, the CPU 201 of the client terminal 102 performs statistical processing (aggregation processing) on the data using each item constituting an item set (combination of items) corresponding to the cell selected in the matrix display unit 1002 as a parameter. The processing result is output as a graph (a graph in which each item constituting the item set corresponding to the selected cell is an X axis and a Z axis) (S608 to S609).

  With the configuration described above, it is possible to provide a mechanism that allows selection of items to be tabulated in a list or graph by selecting the cells of the matrix indicating the tabulated items once.

  As described above, conventionally, it has been necessary to separately select items corresponding to each of the top label, the side label, or the X-axis and the Z-axis. Can be selected. Thus, the user can select the aggregate item (statistical processing parameter) and analyze the data with few procedures.

[Second Embodiment]
In the first embodiment, as shown in S1101 of FIG. 12, items to be aggregated (aggregated items defined in the matrix display unit 1002) among the items of the table used in the DB 101-2 of the data management server 101 are displayed. The configuration for accepting selection from a selection screen (not shown) has been described.

  However, the total items defined in the matrix display unit 1002 may be obtained from a file in CSV format or text format created in advance. The embodiment will be described below.

<Description of FIG. 27>
FIG. 27 is a diagram illustrating an example of data indicating aggregation items defined in the matrix display unit 1002 created in advance in a CSV format, a text format, or the like.

<Description of FIG. 28>
FIG. 28 is a flowchart showing an example of the eighth control processing procedure in the present invention, and corresponds to the definition procedure of the matrix display unit 1002 in the second embodiment of the present invention. Note that the processing of this flowchart is realized by the CPU 201 of the client terminal 102 loading the program stored in the external memory 211 (or downloaded from the data management server 101) into the RAM 203 and executing it.

  First, in step S2101, the CPU 201 of the client terminal 102 acquires definition data as shown in FIG. 27 from the external memory 211 or the like.

  Note that S2102 to S2104 are the same steps as S1102 to S1104 in FIG.

  In the present embodiment, the matrix displayed on the matrix display unit 1002 is a two-dimensional matrix. However, a three-dimensional matrix may be configured so that a combination of three items can be selected at once.

  It should be noted that the configuration and contents of the various data described above are not limited to this, and it goes without saying that the various data and configurations are configured according to the application and purpose.

  Although one embodiment has been described above, the present invention can take an embodiment as, for example, a system, apparatus, method, program, or recording medium, and specifically includes a plurality of devices. The present invention may be applied to a system including a single device.

  As described above, in the present invention, cells (objects) corresponding to aggregation / analysis item combinations (item combinations that become statistical processing parameters (item sets)) considered to be necessary in advance on a screen are displayed in a matrix format. By displaying with, it is possible to reduce the work of combining conditions of items by the operator.

  Since the operator can select and input in the matrix format as described above, the aggregation / analysis conditions (statistical processing parameters) can be changed easily and without error.

  Moreover, since the list and graph are created simultaneously on the screen, the result can be confirmed on the spot.

  As described above, it is possible to select a combination of multiple items as statistical processing parameters in one operation and graph the data statistical processing results (listing), making it easy to analyze complex data Can do. Therefore, it is possible to easily determine whether there is a profit corresponding to the investment in the portfolio analysis.

  The configuration of a data processing program that can be read by the information processing apparatus (CPU 201 of the client terminal 102) according to the present invention will be described below with reference to the memory map shown in FIG.

  FIG. 29 is a diagram illustrating a memory map of a recording medium (storage medium) that stores various data processing programs readable by the information processing apparatus (CPU 201 of the client terminal 102) according to the present invention.

  Although not specifically shown, information for managing a program group stored in the recording medium, for example, version information, creator, etc. is also stored, and information depending on the OS on the program reading side, for example, a program is identified and displayed. Icons may also be stored.

  Further, data depending on various programs is also managed in the directory. In addition, when a program or data to be installed is compressed, a program to be decompressed may be stored.

  The functions shown in FIGS. 12, 15, 22, 23, 24, 25, 26, and 28 in this embodiment may be performed by a host computer by a program installed from the outside. In this case, the present invention is applied even when an information group including a program is supplied to the output device from a recording medium such as a CD-ROM, a flash memory, or an FD, or from an external recording medium via a network. Is.

  As described above, a recording medium recording software program codes for realizing the functions of the above-described embodiments is supplied to a system or apparatus, and the computer (or CPU or MPU) of the system or apparatus stores the recording medium in the recording medium. It goes without saying that the object of the present invention can also be achieved by reading and executing the programmed program code.

  In this case, the program code itself read from the recording medium realizes the novel function of the present invention, and the recording medium storing the program code constitutes the present invention.

  As a recording medium for supplying the program code, for example, a flexible disk, hard disk, optical disk, magneto-optical disk, CD-ROM, CD-R, DVD-ROM, magnetic tape, nonvolatile memory card, ROM, EEPROM, A silicon disk or the like can be used.

  Further, by executing the program code read by the computer, not only the functions of the above-described embodiments are realized, but also an OS (operating system) or the like running on the computer based on the instruction of the program code. It goes without saying that a case where the function of the above-described embodiment is realized by performing part or all of the actual processing and the processing is included.

  Furthermore, after the program code read from the recording medium is written in a memory provided in a function expansion board inserted in the computer or a function expansion unit connected to the computer, the function expansion is performed based on the instruction of the program code. It goes without saying that the CPU or the like provided in the board or the function expansion unit performs part or all of the actual processing and the functions of the above-described embodiments are realized by the processing.

  Further, the present invention may be applied to a system composed of a plurality of devices or an apparatus composed of a single device. Needless to say, the present invention can be applied to a case where the present invention is achieved by supplying a program to a system or apparatus. In this case, by reading the recording medium storing the program represented by the software for achieving the present invention into the system or apparatus, the system or apparatus can enjoy the effects of the present invention. .

  Furthermore, by downloading and reading out a program represented by software for achieving the present invention from a server, database, etc. on a network using a communication program, the system or apparatus can enjoy the effects of the present invention. It becomes.

  In addition, all the structures which combined each embodiment mentioned above and its modification are also included in this invention.

  Data analysis by the information processing apparatus of the present invention is not limited to portfolio analysis, and can be applied to analysis of any data as long as it consists of a plurality of items.

1 is a system configuration diagram schematically showing a configuration of a system showing an embodiment of the present invention. FIG. 2 is a block diagram schematically illustrating an example of a hardware configuration of a client terminal 102 and a data management server 101 illustrated in FIG. 1. FIG. 2 is a block diagram schematically illustrating an example of a software configuration of a client terminal 102 and a data management server 101 in FIG. 1. It is a figure which shows the example of a definition of the data analysis screen (portfolio analysis screen) in this embodiment. FIG. 5 is a diagram illustrating a definition example of a matrix display unit 1002 illustrated in FIG. 4. It is a list and a graph by switching the selection of cells in the matrix display unit 1002. It is a figure which shows the list display part 1003 shown in FIG. 4 in detail. It is a figure which shows the graph display part 1004 shown in FIG. 4 in detail. It is a figure which shows an example of the table and data which are used by DB101-2 shown in FIG. It is a figure which shows an example of the table and data which are used by DB101-2 shown in FIG. It is a figure which shows an example of the table and data which are used by DB101-2 shown in FIG. It is a flowchart which shows an example of the 1st control processing procedure in this invention. It is a figure which shows an example of a response | compatibility with the display name to a cell (1201) and DB item name (1202) at the time of making 7 items into a total item from a table. It is the figure which illustrated arrangement | positioning of the total item name displayed on the matrix display part 1002, and a cell. It is a flowchart which shows an example of the 2nd control processing procedure in this invention. It is a figure which shows a property screen. It is a figure which shows a script screen. It is a figure which shows a script screen. It is the figure which illustrated the setting of the non-selectable cell. It is a figure which shows a property screen. It is a figure which shows the example of a display of the data analysis screen defined by the said series of definitions. It is a flowchart which shows an example of the 3rd control processing procedure in this invention. It is a flowchart which shows an example of the 4th control processing procedure in this invention. It is a flowchart which shows an example of the 5th control processing procedure in this invention. It is a flowchart which shows an example of the 6th control processing procedure in this invention. It is a flowchart which shows an example of the 7th control processing procedure in this invention. It is a figure which shows an example of the data which show the total item defined in the matrix display part 1002 produced in CSV format or text format beforehand. It is a flowchart which shows an example of the 8th control processing procedure in this invention. It is a figure explaining the memory map of the recording medium (storage medium) which stores the various data processing program which can be read by the information processing apparatus which concerns on this invention. It is a block diagram which shows the function of the data analysis application 102-2 based on this invention.

Explanation of symbols

101 data management server 102 client terminal 103 network 201 CPU
202 ROM
203 RAM
209 KB
210 Display 211 External Memory 102-2 Data Analysis Application 1001 Refinement Item Display Unit 1002 Matrix Display Unit 1003 List Display Unit 1004 Graph Display Unit 1005 Execution Button

Claims (15)

In an information processing apparatus that displays a result of statistical processing using data consisting of a plurality of items,
Matrix display means for arranging and displaying a plurality of objects respectively corresponding to a plurality of item sets obtained by combining the items;
Setting means for setting statistical processing for an object displayed by the matrix display means;
Selection means for accepting selection of any object from a plurality of objects displayed in a matrix by the matrix display means;
Statistical processing means for classifying each item constituting an item set corresponding to the object selected by the selection means, and performing statistical processing set for the object for each classification on the data,
Graph display means for displaying the processing result of the statistical processing by the statistical processing means as a graph, with each item constituting the item set corresponding to the matrix-like row and column as the object selected by the selection means When,
An information processing apparatus comprising: The matrix display means arranges and displays a plurality of objects respectively corresponding to a plurality of item sets obtained by combining the items, and the objects corresponding to the same item set are changed in the matrix-like rows and columns. The information processing apparatus according to claim 1, wherein the information processing apparatus is arranged and displayed. The graph display means sets the items constituting the item set corresponding to the matrix-like rows and columns to the object selected by the selection means as rows and columns, and displays the processing result of the statistical processing by the statistical processing means. the information processing apparatus according to claim 1 or 2, characterized in that display as a list. The graph display means graphs the processing result of the statistical processing by the statistical processing means , with each item constituting an item set corresponding to the matrix-like row and column as the object selected by the selection means. And the results of the statistical processing by the statistical processing means , with each item constituting the item set corresponding to the matrix-like rows and columns in the object selected by the selection means as rows and columns, the information processing apparatus according to claim 1 or 2 to display as a list.   5. The matrix display unit according to claim 1, wherein the matrix display unit displays a plurality of objects corresponding to a plurality of item sets obtained by combining any of the plurality of items specified in advance in a matrix. The information processing apparatus according to any one of claims.   6. The matrix display means according to claim 1, wherein a plurality of objects respectively corresponding to a plurality of item sets obtained by combining the plurality of items by two items are arranged and displayed in a two-dimensional matrix. The information processing apparatus according to any one of claims. A means for narrowing down the data by the data value of the specified item is provided,
The information processing apparatus according to claim 1, wherein the statistical processing unit performs statistical processing on the data narrowed down by the narrowing-down unit. Comprising an item selection means for selecting an item for use in creating the graph;
The matrix display means sets the items selected by the item selection means as rows, the same items as the selected items as columns, and a plurality of objects respectively corresponding to a plurality of item sets obtained by combining the items of the rows and columns. The information processing apparatus according to any one of claims 1 to 7, wherein the information processing apparatus is arranged and displayed in a shape. The information processing apparatus according to claim 8, wherein the selection unit disables selection of an object corresponding to the item set when the items in the row and the column configuring the item set are the same item. 9. The matrix display means for identifying and displaying that an object corresponding to the item set cannot be selected when the items in the row and column constituting the item set are the same item. 9. The information processing apparatus according to 9. In a data analysis system having a server device having storage means for storing data consisting of a plurality of items and an information processing device for displaying a result of statistical processing using data stored in the storage means of the server device,
The information processing apparatus includes:
Matrix display means for arranging and displaying a plurality of objects respectively corresponding to a plurality of item sets obtained by combining the items;
Setting means for setting statistical processing for an object displayed by the matrix display means;
Selection means for accepting selection of any object from a plurality of objects displayed in a matrix by the matrix display means;
Graph display means for displaying, as a graph, the processing result of statistical processing by the statistical processing means , with each item constituting an item set corresponding to the matrix-like row and column as an object selected by the selection means; ,
With
The server device
Statistical processing means for classifying each item constituting an item set corresponding to the object selected by the selection means, and performing statistical processing set for the object for each classification on the data,
A data analysis system comprising: A method of controlling an information processing apparatus that displays a result of statistical processing using data consisting of a plurality of items,
A matrix display step for displaying a plurality of objects respectively corresponding to a plurality of item sets obtained by combining the items in a matrix;
A setting step for setting statistical processing for the object displayed by the matrix display step;
A selection step of accepting selection of any object from a plurality of objects displayed in a matrix by the matrix display step;
A statistical processing step for classifying each item constituting an item set corresponding to the object selected by the selection step, and performing statistical processing set for the object for each classification on the data;
A graph display step for displaying the processing result of the statistical processing in the statistical processing step as a graph, with each item constituting the item set corresponding to the matrix-like row and column as the object selected in the selection step; ,
A method of controlling an information processing apparatus, characterized by the execution. A program that is read and executed by an information processing apparatus that displays a result of statistical processing using data consisting of a plurality of items,
A matrix display unit for displaying a plurality of objects corresponding to a plurality of items set that combines the items arranged in a matrix,
A selection unit for receiving a selection of one of the objects from a plurality of objects displayed in a matrix by the matrix display unit,
Setting means for setting statistical processing for an object displayed by the matrix display means;
Statistical processing means for classifying each item constituting an item set corresponding to the object selected by the selection means, and performing statistical processing set for the object for each classification on the data,
Graph display means for displaying the processing result of the statistical processing by the statistical processing means as a graph, with each item constituting the item set corresponding to the matrix-like row and column as the object selected by the selection means And
Program to make it function. A control method for a data analysis system having a server device having storage means for storing data consisting of a plurality of items, and an information processing device for displaying a result of statistical processing using data stored in the storage means of the server device Because
The information processing apparatus includes:
A matrix display step for arranging and displaying a plurality of objects respectively corresponding to a plurality of item sets obtained by combining the items;
A setting step for setting statistical processing for the object displayed by the matrix display step;
A selection step of accepting selection of any object from a plurality of objects displayed in a matrix by the matrix display step;
A graph display step for displaying the processing result of the statistical processing by the statistical processing step as a graph, with each item constituting the item set corresponding to the matrix-like row and column as the object selected in the selection step; ,
Run
The server device
A statistical processing step for classifying each item constituting an item set corresponding to the object selected by the selection step, and performing statistical processing set for the object for each classification on the data;
A method for controlling a data analysis system, characterized in that: Executed in a data analysis system having a server device having storage means for storing data consisting of a plurality of items and an information processing device for displaying a result of statistical processing using data stored in the storage means of the server device A program
The information processing apparatus;
Matrix display means for arranging and displaying a plurality of objects respectively corresponding to a plurality of item sets obtained by combining the items;
Setting means for setting statistical processing for an object displayed by the matrix display means;
Selection means for accepting selection of any object from a plurality of objects displayed in a matrix by the matrix display means;
Graph display means for displaying, as a graph, the processing result of statistical processing by the statistical processing means, with each item constituting an item set corresponding to the matrix-like row and column as an object selected by the selection means; ,
To function,
The server device,
Statistical processing means for classifying each item constituting an item set corresponding to the object selected by the selection means, and performing statistical processing set for the object for each classification on the data,
A program characterized by making it function.

Images