JP5653250B2 - Data analysis support device, data analysis support method and program - Google Patents

Description

  The present invention relates to a data analysis support device, a data analysis support method, and a program.

  Along with the improvement in the performance of computers, a large amount of arithmetic processing is performed to apply data observed at an electric power station to arithmetic expressions. A certain calculation result is also applied to other calculation expressions, and the influence due to the change of the data or the change of the calculation expression has a wide range. When changing data or arithmetic expressions, a list of data used in the arithmetic expressions is output to check the range of influence of the data. There is a need to improve the visibility of such data.

  In order to improve the visibility of data, it is conceivable to display the data in a tree shape. For example, in Patent Document 1, when displaying tree-structured data in a tree, when a parent element cannot be displayed as a parent node, it is possible to determine that it is a parent element, while displaying it as a child node. The entire element can be displayed using as the root node.

JP 2007-26210 A

  However, the program of Patent Document 1 assumes data having a tree structure, and the data output as a list of data used in arithmetic expressions is not tree-structured data. It cannot be displayed in a tree shape.

  The present invention has been made in view of such a background, and an object thereof is to provide a data analysis support device, a data analysis support method, and a program capable of outputting data applied to an arithmetic expression in a tree shape. .

A main invention of the present invention for solving the above-described problem is an apparatus that supports data analysis, from an arithmetic apparatus that calculates a result by substituting data into an arithmetic expression including one or more first variables. The first data ID indicating the first variable, the second data ID indicating the second variable to which the result is substituted, and the location relating to the second variable are specified for each arithmetic expression. A definition data input unit that receives an input of definition data including a location ID, a definition data storage unit that stores the definition data, an input of a location ID, and the definition data that includes the received location ID Read from the definition data storage unit as a root node, and use the root node as a parent node and each of the first data IDs included in the parent node is identical to the first data ID. The definition data including the second data ID to be read from the definition data storage unit is used as a child node, each of the child nodes is used as the parent node, and reading of the child node is repeated, and the root node is used as a root. An analysis processing unit that outputs information based on the definition data in a tree shape.

  In the data analysis support device according to the present invention, the definition data further includes a result name for explaining the result data, and the analysis processing unit defines the result name included in the definition data as the definition. You may make it output in the said tree form as information based on data.

  In the data analysis support device of the present invention, the definition data further includes an operation code indicating the operation expression, and the data analysis support device further explains the operation expression in association with the operation code. An operation name storage unit that stores an operation name to be stored, and the analysis processing unit outputs the operation name corresponding to the operation code included in the definition data from the operation name storage unit when outputting the definition data. The operation name may be output after being read and associated with the result name.

The data analysis support device of the present invention further includes a place name storage unit that stores a place name that describes the place in association with the place ID, and the analysis processing unit outputs the definition data. The location name corresponding to the location ID included in the definition data may be read from the location name storage unit, and the location name may be output in association with the result name.

  The data analysis support apparatus according to the present invention further includes a code designating unit that accepts designation of the result code, and the analysis processing unit outputs information based on the definition data corresponding to the accepted result code. May be output so that information based on the definition data is emphasized.

  In the data analysis support device of the present invention, the analysis processing unit repeatedly reads out the child node with the definition data as the parent node for each of the definition data stored in the definition data storage unit. The information based on the definition data may be output in the form of a tree.

According to another aspect of the present invention, there is provided a method for supporting data analysis, wherein a computer substitutes data into an arithmetic expression including one or more first variables to calculate a result from the arithmetic device. The first data ID indicating the first variable, the second data ID indicating the second variable to which the result is substituted, and the location relating to the second variable are specified for each arithmetic expression. Receiving the definition data including the location ID , storing the definition data in the memory, receiving the input of the location ID , and reading the definition data including the received location ID from the definition data storage unit And the second data ID that matches the first data ID for each of the first data IDs included in the parent node with the root node as a parent node. Read the definition data from the definition data storage unit as child nodes, repeat the reading of the child nodes with each of the child nodes as the parent node, and information based on the definition data in a tree shape with the root node as a root It will output.

According to another aspect of the present invention, there is provided a program for supporting data analysis, wherein an arithmetic device that calculates a result by substituting data into an arithmetic expression including one or more first variables in a computer The first data ID indicating the first variable, the second data ID indicating the second variable to which the result is substituted, and the location relating to the second variable are output for each arithmetic expression from a step of accepting an input of a definition data including a location ID for identifying, and storing the definition data in memory, accepts the input of the location ID, the definition data store the definition data including the location ID of the accepted Each of the first data IDs included in the parent node with the root node as a parent node. The definition data including the second data ID to be read from the definition data storage unit is used as a child node, each of the child nodes is used as the parent node, and reading of the child node is repeated, and the root node is used as a root. And outputting information based on the definition data in a tree shape.

  Other problems and solutions to be disclosed by the present application will be made clear by the embodiments of the invention and the drawings.

  According to the present invention, data applied to an arithmetic expression can be output in a tree shape.

It is a figure for demonstrating the computer system containing the analysis assistance apparatus 20 which concerns on this embodiment. 2 is a diagram illustrating a hardware configuration of a computing device 10. FIG. 3 is a diagram illustrating a software configuration of the arithmetic device 10. FIG. It is a figure which shows the screen 12 which is an example of the user interface for the calculation model definition part 111 to receive the input of the data from a user. 2 is a diagram illustrating a hardware configuration of an analysis support apparatus 20. FIG. 3 is a diagram illustrating a software configuration of an analysis support apparatus 20. FIG. 6 is a diagram illustrating a configuration example of definition data registered in a definition data storage unit 231. FIG. 3 is a diagram illustrating a configuration example of a name storage unit 232. FIG. It is a figure which shows an example of the screen 40 which the analysis assistance apparatus 20 displays. It is a figure which shows the flow of a process by the analysis process part. It is a figure which shows the flow of a node display process. It is a figure which shows an example of the screen 41 which the analysis process part 212 displays. It is a figure which shows the modification of the screen 41 which the analysis process part 212 displays.

  FIG. 1 is a diagram for explaining a computer system including an analysis support apparatus 20 according to the present embodiment. The computer system includes an arithmetic device 10 and an analysis support device 20.

  The arithmetic device 10 accumulates various data (hereinafter, data accumulated in the arithmetic device 10 is referred to as “accumulated data”), and performs various operations on the accumulated data. The calculation is performed using an arithmetic expression. The arithmetic expression includes one or more variables (hereinafter referred to as “parameters”), and the stored data is substituted into the parameters of the arithmetic expression, and the evaluation value of the arithmetic expression (hereinafter referred to as “result data”). Ask. A variable for substituting result data is simply referred to as “result”.

  The computing device 10 is, for example, a computer such as a personal computer or a workstation. The arithmetic unit 10 receives an arithmetic expression and its parameter designation from the user, and identifies information (hereinafter referred to as “calculation ID”) for identifying the arithmetic expression and identification information (hereinafter referred to as “parameter ID”) for identifying the parameter. ) And information (hereinafter referred to as “calculation model”). The arithmetic device 10 calculates the result data by applying the accumulated data indicated by the parameter ID included in the arithmetic model to the parameter of the arithmetic expression included in the arithmetic model. Result data is accumulated as accumulated data. The arithmetic device 10 can output information representing an arithmetic model (hereinafter referred to as “definition data”).

  The analysis support device 20 is a computer such as a personal computer, a workstation, a PDA (Personal Digital Assistant), or a mobile phone that analyzes the definition data output from the arithmetic device 10 and outputs the analysis result.

  The computing device 10 includes a connector 11, and the analysis support device 20 includes a connector 21. The connector 11 and the connector 21 are, for example, an adapter for performing serial communication such as USB (Universal Serial Bus) or RS232C, an adapter for performing communication by Ethernet (registered trademark), infrared, wireless, or the like. In the present embodiment, it is assumed that the connector 11 and the connector 21 are adapters for performing serial communication compliant with USB.

  By inserting the portable memory 30 into the connector 11, the arithmetic device 10 can write definition data into the memory 30. The portable memory 30 is, for example, a flash memory or a hard disk drive. By inserting the memory 30 in which the definition data is written into the connector 21, the analysis support apparatus 20 can read, analyze, and output the definition data.

  The analysis support apparatus 20 of the present embodiment is intended to output the dependency relationship of the parameter data based on the definition data.

== Calculator 10 ==
FIG. 2 is a diagram illustrating a hardware configuration of the arithmetic device 10. The arithmetic device 10 includes a connector 11, a CPU 101, a memory 102, a storage device 103, an input device 105, and an output device 106. The storage device 103 stores various data and programs, such as a hard disk drive and a flash memory. The CPU 101 implements various functions by reading a program stored in the storage device 103 into the memory 102 and executing it. The input device 105 is a keyboard, mouse, touch panel, microphone, or the like that accepts data input. The output device 106 is, for example, a display, a printer, or a speaker that outputs data.

  FIG. 3 is a diagram illustrating a software configuration of the arithmetic device 10. The arithmetic device 10 includes an arithmetic model definition unit 111, an arithmetic processing unit 112, a definition data output unit 113, a data storage unit 131, a data name storage unit 132, and an arithmetic model storage unit 133. The calculation model definition unit 111, the calculation processing unit 112, and the definition data output unit 113 are realized by the CPU 101 reading out the program stored in the storage device 103 to the memory 102 and executing it, and the data storage unit 131, the data The name storage unit 132 and the calculation model storage unit 133 are realized as part of a storage area provided by the memory 102 or the storage device 103.

  The data storage unit 131 stores accumulated data. The accumulated data may be a single scalar value, a data string in which a plurality of scalar values are arranged, a vector value, or the like. The accumulated data can be recorded as, for example, a file. In this case, the data storage unit 131 is implemented as a file system. It is assumed that accumulated data is stored in the data storage unit 131 in advance.

  The accumulated data includes identification information for identifying a parameter or a result (hereinafter referred to as “data ID”. A data ID indicating a parameter is a parameter ID, and a data ID indicating a result is referred to as a “result ID”), a parameter or a result A data name representing the result is assigned. The data name storage unit 132 stores a data name in association with the data ID. In the present embodiment, the stored data is assumed to be data for each electric station, and the data ID includes identification information (hereinafter referred to as “electric station ID”) of the electric station related to the stored data. It is assumed that the upper three digits of the data ID are the electric station ID.

  The calculation model storage unit 133 stores a calculation model. The calculation model includes a result ID indicating the result of evaluating the calculation expression, a calculation ID indicating the calculation expression, and a parameter ID indicating a parameter included in the calculation expression. The calculation model includes parameter IDs as many as the number of parameters. For example, for y = x1-x2 which is a subtraction having two variables, the calculation ID of the calculation expression x1-x2 is “0001”, the result ID of the result y is “0002”, the parameter ID of the parameter x1 is “0003”, When the parameter ID of the parameter x2 is “0004”, the calculation model can be expressed as “0001 (0002, 0003, 0004)”, for example. In addition, although the preservation | saving form of a general arithmetic expression can be employ | adopted for an arithmetic model, as mentioned later, in this embodiment, an arithmetic model is a result ID, a result name, arithmetic ID, parameter ID1, ... ..., And a format having an item of parameter IDn. In addition, the arithmetic expression is not limited to the four arithmetic operations but can be an expression for performing data operations such as various statistical operations.

  The calculation model definition unit 111 creates a calculation model and registers it in the calculation model storage unit 133. The calculation model definition unit 111 receives an input such as a calculation formula or parameter ID from the user and creates a calculation model.

  FIG. 4 is a diagram illustrating a screen 12 which is an example of a user interface for the calculation model definition unit 111 to accept input of data from the user. The screen 12 includes a pull-down list 121 for selecting an electric station, an input field 122 for inputting a name representing a result (hereinafter referred to as “result name”), a pull-down list 123 for specifying an arithmetic expression, A parameter ID input field 123 and a parameter data data name (hereinafter referred to as “parameter name”) display field 125 are provided. In the pull-down list 121, the names of available electric stations (hereinafter referred to as “electric station names”) are registered in advance, and in the pull-down list 123, usable arithmetic expressions are registered.

  When the result name is input to the input field 122, the operation model definition unit 111 searches the data name storage unit 132 for the result name input to the input field 122. If the result name is not registered, the calculation model definition unit 111 acquires a new ID, combines the electric station ID indicating the electric station selected in the pull-down list 121 and the acquired ID. A data ID is generated, and the result name is registered in the data name storage unit 132 in association with the generated data ID. When the result name is registered, the calculation model definition unit 111 acquires the corresponding data ID from the data name storage unit 132, and pulls down the electric station indicated by the upper three-digit electric station ID of the acquired data ID. Select from list 121.

  When the parameter ID is input to the input field 124, the operation model definition unit 111 reads the data name corresponding to the parameter ID from the data name storage unit 132 and displays it on the display field 125.

  The calculation model definition unit 111 sets the data ID corresponding to the result name input in the input field 122 as the result ID, the calculation ID indicating the calculation expression selected in the pull-down list 123, and the parameter ID input in the input field 124. The calculation model 13 including the calculation model 13 is created, and the created calculation model 13 is registered in the calculation model storage unit 133.

  The arithmetic processing unit 112 calculates the result by applying the parameter data indicated by the data name included in the arithmetic model to the arithmetic expression included in the arithmetic model, and stores the calculated result in the accumulated data storage unit 131. For example, the arithmetic processing unit 112 detects that new data has been registered in the accumulated data storage unit 131, and sets the parameter ID included in the arithmetic model for each arithmetic model registered in the arithmetic model storage unit 133. Corresponding accumulated data is read from the accumulated data storage unit 131 as parameter data, and the read parameter data is applied to the arithmetic expression indicated by the arithmetic ID included in the arithmetic model to calculate the arithmetic result, and the calculated arithmetic result is calculated The data is registered in the accumulated data storage unit 131 as data indicated by the result ID included in the model.

  The definition data output unit 113 writes definition data to the memory 30 based on the calculation model. In the present embodiment, the definition data output unit 113 writes the computation model stored in the computation model storage unit 133 as definition data into the memory 30 as it is. For example, the computation model includes a result ID, a computation ID, Instead of the parameter ID, include the result name, arithmetic expression, parameter name, etc., and write the result name, arithmetic expression, result ID corresponding to the parameter name, arithmetic ID, parameter ID included in the definition data. Also good. The calculation model can include various types of information necessary for calculation processing, but the definition data output unit 113 extracts only the result ID, calculation ID, and parameter ID included in the calculation model. It is also possible to export it by including it in the definition data. The definition data output unit 113 may write the definition data to the memory 30 in accordance with an instruction from the user, or may detect and write that the memory 30 is inserted into the connector 11.

  As described above, definition data is written from the arithmetic unit 10 to the memory 30. The user removes the memory 30 from the connector 11 of the arithmetic device 10 and connects it to the connector 21 of the analysis support device 20, thereby enabling the analysis support device 20 to analyze the definition data.

  FIG. 5 is a diagram illustrating a hardware configuration of the analysis support apparatus 20. The analysis support apparatus 20 includes a connector 21, a CPU 201, a memory 202, a storage device 203, an input device 205, and an output device 206. The storage device 203 stores various data and programs, for example, a hard disk drive or a flash memory. The CPU 201 implements various functions by reading a program stored in the storage device 203 into the memory 202 and executing it. The input device 205 is a keyboard, mouse, touch panel, microphone, or the like that accepts data input. The output device 206 is, for example, a display, a printer, or a speaker that outputs data.

  FIG. 6 is a diagram illustrating a software configuration of the analysis support apparatus 20. The analysis support apparatus 20 includes a definition data acquisition unit 211, an analysis processing unit 212, a definition data storage unit 231, and a name storage unit 232. The definition data acquisition unit 211 and the analysis processing unit 212 are realized by the CPU 201 included in the analysis support apparatus 20 reading out the program stored in the storage device 203 to the memory 202 and executing the program, and the definition data storage unit 231. The name storage unit 232 is realized as a part of a storage area provided by the memory 202 or the storage device 203.

  The definition data storage unit 231 stores definition data. FIG. 7 is a diagram illustrating a configuration example of definition data registered in the definition data storage unit 231. In the present embodiment, the definition data has the same configuration as the operation model 13 shown in FIG. 4 described above, and the result ID, result name, and operation ID, and parameter data necessary to calculate the data indicated by the result ID and the result name. The number of parameter IDs is included.

  The definition data acquisition unit 211 reads definition data from the memory 30. The definition data acquisition unit 211 reads the definition data in response to an instruction from the user. For example, the definition data acquisition unit 211 may detect and read out that the memory 30 is inserted into the connector 21. The definition data acquisition unit 211 registers the read definition data in the definition data storage unit 231.

  The name storage unit 232 manages the electric station name and the operation name. FIG. 8 is a diagram illustrating a configuration example of the name storage unit 232. The name storage unit 232 stores the electric station name in association with the electric station ID, and stores information (hereinafter referred to as “calculation name”) for explaining the arithmetic expression in association with the calculation ID.

  The analysis processing unit 212 analyzes and outputs data relevance. As will be described later, the analysis processing unit 212 displays data relevance in a tree format.

  FIG. 9 is a diagram illustrating an example of a screen 40 displayed by the analysis support apparatus 20. On the screen 40, buttons 401 to 404, an electric field ID input field 405, and a data ID input field 406 are displayed. When the button 401 is pressed, the definition data acquisition unit 211 reads definition data from the memory 30. When one of the buttons 401 to 404 is pressed, data relevance display processing is performed.

FIG. 10 is a diagram showing a flow of processing by the analysis processing unit 212.
When the button 402 is pressed on the screen 40 (S501: YES), the analysis processing unit 212 is a result of setting the electric station ID in the upper three digits for each electric station ID registered in the name storage unit 232. The ID is read from the definition data storage unit 231 (S502), and for each of the read result IDs, a node display process described later is performed with the result ID as the first argument, the result name as the second argument, and 1 as the third and third parameters. Called as four arguments (S503).

  When the button 403 is pressed on the screen 40 (S504: YES), the analysis processing unit 212 reads from the definition data storage unit 231 the result ID in which the electric station ID input in the input field 405 is set to the upper three digits. (S505) For each of the read result IDs, a node display process described later is called with the result ID as the first argument, the result name as the second argument, and 1 as the third and fourth arguments (S506).

  When the button 404 is pressed on the screen 40 (S504: NO), the analysis processing unit 212 sets the data ID input in the input field 406 as an ID (S507), performs a node display process described later, and sets the ID as the first argument. And the result name is called as the second argument, 1 is called as the third and fourth arguments (S508).

FIG. 11 is a diagram showing the flow of the node display process.
The analysis processing unit 212 sets the first argument as an ID (S521), sets the second argument as a parent (S522), sets the third argument as X (S523), and sets the fourth argument as Y (S524). The analysis processing unit 212 reads definition data whose result ID matches the ID from the definition data storage unit 231 (S525). The analysis processing unit 212 reads from the name storage unit 232232 the name of the electric station corresponding to the electric station ID that is the upper three digits of the ID (S526), and stores the name of the operation corresponding to the operation ID included in the definition data. The data is read from the unit 232 (S527). The analysis processing unit 212 outputs the definition data at a position corresponding to the depth X and the height Y (S528).

  FIG. 12 is a diagram illustrating an example of the screen 41 displayed by the analysis processing unit 212. In the screen 41 of FIG. 12, the definition data is displayed such that the display position moves to the right as the depth X increases, and the display position moves to the lower direction as the height Y increases. On the screen 41, the electric station name 411 is displayed above the result name 412, the result ID 413 is displayed below the result name 412, and the operation name 414 is displayed to the right of the result name 412.

  The analysis processing unit 212 sets 1 to the variable n (S529), and if the definition data includes the nth parameter ID (S530: YES), the analysis processing unit 212 sets the nth parameter ID included in the definition data. The node display process is recursively called with ID (S531), ID as the first argument, result name as the second argument, X + 1 as the third argument, and Y as the fourth argument (S532). Note that the ID of the first argument may be an object ID for specifying the object having the result name displayed on the screen 41. The analysis processing unit 212 increments n (S533), increments Y (S534), draws a connecting line from the result name of the definition data to the parent (S535), and repeats the processing from step S530. In the example of FIG. 41, a result name 412 displayed at depth X = 1 and height Y = 1 and a result name 415 displayed at depth X = 2 and height Y = 1 are connected lines 416. It is connected.

  When the nth parameter ID is not included in the definition data (S530: NO), the analysis processing unit 212 ends the process.

  As described above, when the button 402 is pressed on the screen 40, the relevance of the definition data having the definition data as the root for each of the definition data including the electric station ID for all electric stations is the result name. A tree is displayed on the screen 41 as a tree. When the button 403 is pressed, a tree of result names having the definition data as the root is displayed on the screen 41 for each definition data including the electric station ID input in the input field 405, and the button 404 is pressed. Then, a tree of result names is displayed on the screen 41 with the definition data corresponding to the data ID input in the input field 406 as a root. Therefore, when viewing the screen 41, the user can easily grasp the relevance of the definition data. In particular, the tree displayed on the screen 41 requires all the parameters indicated by the result name displayed on the nodes other than the root included in the tree in order to calculate the result indicated by the result name of the route. Therefore, the user can easily confirm the data necessary for calculating the route result by looking at the tree on the screen 41. For example, if a defect is found in the contents of a certain result name data, check the parameters necessary to calculate the result name data from the tree rooted in the result name, and check the parameters. Since it is possible to check the presence or absence of a defect for each of the above, it is possible to reliably and easily investigate the defect without omission.

  In addition, even when the data is modified due to changes in equipment specifications, etc., the parameters necessary for calculating the modified data can be easily confirmed, so these parameters can also be modified. It becomes easy. Thereby, work mistakes, such as omission of correction, can be prevented.

  In addition, since the operation name is also output on the screen 41, it is possible to easily grasp the range of influence even when the arithmetic expression is corrected.

  In addition, by referring to each node included in the tree, when a certain parameter is modified, the result affected by the modification, that is, the result data calculated using the modified data as parameter data It can be easily grasped. Here, for example, as illustrated in FIG. 13, a result ID input field 421 is provided on the screen 41, and the analysis support apparatus 20 receives a result ID designation from the input field 421 (a result node designation unit). Be prepared. The analysis processing unit 212 may highlight the electric station name, the result name, the result ID, and the like in step S528 of FIG. 11 in which the node corresponding to the result ID input in the input field 421 is displayed. In the example of FIG. 13, the electric field name 422, the result name 423, and the result ID 424 at the depth X = 2 corresponding to the result ID input in the input field 421 are highlighted. By such highlighting, the user can easily grasp a result influenced by a certain parameter.

  Although the present embodiment has been described above, the above embodiment is intended to facilitate understanding of the present invention and is not intended to limit the present invention. The present invention can be changed and improved without departing from the gist thereof, and the present invention includes equivalents thereof.

  For example, in the present embodiment, it is assumed that the arithmetic device 10 and the analysis support device 20 are separate computers, but the arithmetic device 10 and the analysis support device 20 are realized by a single computer. Also good. In this case, the memory 30 may be realized not as a portable memory but as a memory built in a computer, a secondary storage device, or the like.

  In this embodiment, the definition data output from the arithmetic device 10 is provided to the analysis support device 20 via the portable memory 30. However, the arithmetic device 10 and the analysis support device 20 communicate with each other. The definition data may be transmitted from the arithmetic device 10 to the analysis support device 20 via a communication network by connecting via a network. In this case, for example, the analysis support apparatus 20 may transmit a request for acquiring definition data, and the calculation apparatus 10 may transmit the definition data to the analysis support apparatus 20 in response to this request. The definition data may be transmitted to the analysis support apparatus 20 at the timing when the arithmetic processing is performed in 10 or the accumulated data is updated or periodically.

  Further, in this embodiment, the definition data is drawn so that the upper left of the screen 41 is the root and the deeper the hierarchy is as it goes to the right. You may do it. Moreover, you may draw so that a tree may spread from right to left or from bottom to top.

  In this embodiment, the analysis processing unit 212 directly displays the definition data as a tree based on the definition data. However, after the definition data acquisition unit 211 reads the definition data from the memory 30, the analysis processing unit 212. However, tree-structured data may be created based on the definition data, and the created tree-structured data may be registered in the definition data storage unit 231. In this case, the analysis processing unit 212 performs the processing of steps S502 to S503 in FIG. 10, and instead of displaying the definition data on the screen 41 in step S528 in FIG. It can be registered in the part 231. In addition, the analysis processing unit 212 can display the definition data on the screen 41 as a tree by a general process for displaying the tree structure data in a tree shape for the tree structure definition data.

  In the present embodiment, the number of the arithmetic devices 10 is one. However, a plurality of arithmetic devices 10 may be used. In this case, the definition data acquisition unit 211 of the analysis support apparatus 20 collectively registers the definition data output from the plurality of arithmetic devices 10 in the definition data storage unit 231. Thereby, it is possible to cope with arithmetic processing performed by a plurality of arithmetic devices 10. In addition, even when definition data is output for each group of a plurality of arithmetic expression groups from the arithmetic unit 10, by registering them together in the definition data storage unit 231, definition data of different groups can be obtained. Can respond.

10 arithmetic unit 11 connector 101 CPU
DESCRIPTION OF SYMBOLS 102 Memory 103 Storage device 105 Input device 106 Output device 111 Operation model definition part 112 Operation processing part 113 Definition data output part 131 Data storage part 132 Data name storage part 133 Operation model storage part 20 Analysis support apparatus 21 Connector 201 CPU
202 Memory 203 Storage Device 205 Input Device 206 Output Device 211 Definition Data Acquisition Unit 212 Analysis Processing Unit 231 Definition Data Storage Unit 232 Name Storage Unit 30 Memory 40 Screen 41 Screen

Claims (8)

A device that supports data analysis,
A first data ID indicating the first variable, which is output for each of the arithmetic expressions, from an arithmetic unit that calculates a result by substituting data into an arithmetic expression including one or more first variables; and the result A definition data input unit that accepts input of definition data including a second data ID indicating a second variable for substituting , and a location ID that specifies a location related to the second variable ;
A definition data storage unit for storing the definition data;
An input of a location ID is received, the definition data including the received location ID is read from the definition data storage unit as a root node, and the root node is a parent node of the first data ID included in the parent node. For each, the definition data including the second data ID that matches the first data ID is read from the definition data storage unit as a child node, and each of the child nodes is set as the parent node of the child node. An analysis processing unit that repeats reading and outputs information based on the definition data in a tree shape having the root node as a root;
A data analysis support apparatus comprising: The data analysis support device according to claim 1,
The definition data further includes a result name describing the second variable,
The analysis processing unit outputs the result name included in the definition data in the form of a tree as information based on the definition data;
A data analysis support device characterized by the above. The data analysis support device according to claim 2,
The definition data further includes a calculation ID indicating the calculation formula,
The data analysis support apparatus further includes a calculation name storage unit that stores a calculation name that explains the calculation formula in association with the calculation ID.
The analysis processing unit, when outputting the definition data, reads the operation name corresponding to the operation ID included in the definition data from the operation name storage unit, and associates the operation name with the result name. Output,
A data analysis support device characterized by the above. The data analysis support device according to any one of claims 1 to 3,
Further comprising a location name storage unit for storing the location name describing the location in association with the location ID,
The analysis processing unit, when outputting the definition data, reads the location name corresponding to the location ID included in the definition data from the location name storage unit, and associates the location name with the result name. Output,
A data analysis support device characterized by the above. The data analysis support device according to any one of claims 1 to 4,
An emphasis node designation unit that accepts designation of the second data ID;
The analysis processing unit, when outputting information based on the definition data including the received second data ID, outputs so that the information based on the definition data is emphasized,
A data analysis support device characterized by the above. The data analysis support device according to any one of claims 1 to 5,
The analysis processing unit, for each of the definition data stored in the definition data storage unit, output the information based on the definition data in the form of a tree with the definition data as the root node;
A data analysis support apparatus comprising: A method for supporting data analysis,
Computer
A first data ID indicating the first variable, which is output for each of the arithmetic expressions, from an arithmetic unit that calculates a result by substituting data into an arithmetic expression including one or more first variables; and the result Receiving definition data including a second data ID indicating a second variable for substituting and a location ID for specifying a location related to the second variable ;
Storing the definition data in a memory;
An input of a location ID is received, the definition data including the received location ID is read from the definition data storage unit as a root node, and the root node is a parent node of the first data ID included in the parent node. For each, the definition data including the second data ID that matches the first data ID is read from the definition data storage unit as a child node, and each of the child nodes is set as the parent node of the child node. Repeating reading and outputting information based on the definition data in a tree shape with the root node as a root;
A data analysis support method characterized by A program for supporting data analysis,
On the computer,
A first data ID indicating the first variable, which is output for each of the arithmetic expressions, from an arithmetic unit that calculates a result by substituting data into an arithmetic expression including one or more first variables; and the result Accepting input of definition data including a second data ID indicating a second variable for substituting and a location ID for specifying a location related to the second variable ;
Storing the definition data in a memory;
An input of a location ID is received, the definition data including the received location ID is read from the definition data storage unit as a root node, and the root node is a parent node of the first data ID included in the parent node. For each, the definition data including the second data ID that matches the first data ID is read from the definition data storage unit as a child node, and each of the child nodes is set as the parent node of the child node. Repeating reading and outputting information based on the definition data in a tree shape with the root node as a root;
A program for running

Images