JP5918368B2 - Data analysis support method and system - Google Patents

Description

  The present invention relates to a data analysis support method and system for supporting data analysis, and more particularly, to an analysis support technology when analysis target data and processing for data are not fixed.

  There is a method called business intelligence that stores, analyzes, and processes a large amount of corporate data accumulated from business systems, etc., and uses it for corporate decision making. This method can analyze a large amount of data at a high speed across a plurality of databases (DB). This method is highly resistant to routine analysis in which highly structured analysis target data needs to be constructed in advance according to the purpose of analysis in order to increase the speed, and analysis contents and necessary data are determined.

  On the other hand, when the analysis process and the visualization process for the analysis target data and data are not fixed, the analysis target data must be regenerated and the analysis process and the visualization process must be changed every time trial and error. As background art related to such data analysis, there are Patent Literature 1 and Patent Literature 2. Patent Document 1 describes that an analysis procedure detected on the computer side is recorded in a database of a management server, and the recorded analysis procedure is shared and reused by a third party. Further, Patent Document 2 provides an optimized process definition, in other words, reusing an existing process and creating a new process by using an existing process context and a new executable process. Presenting is disclosed.

JP 2008-140278 A JP 2005-285101 A

  As seen in the background art described above, the analysis procedure is recorded and can be reproduced by editing or reconstructing the past analysis procedure. In addition, by editing the past analysis procedure, it is possible to partially reuse and perform a new analysis. However, because the editing makes it impossible to reproduce the part after the edited part, the technology that automatically changes other processes or presents candidates for changing other processes, It has been demanded.

  An object of the present invention is to provide a data analysis support capable of solving the above-described problems, editing past analysis procedures, automatically changing other processes, or presenting candidates for changing other processes. It is to provide a method and system.

  In the present invention, in order to achieve the above object, a data analysis support method using a computer, wherein the computer performs input data creation processing on the extracted data to create analysis target data And a data analysis support method for performing data analysis support work by executing a data processing function for performing data processing on the data to generate processing result data and a data visualization function for performing visualization processing on the data for visualization.

  In the present invention, in order to achieve the above object, the data analysis support system includes a storage unit that stores a template database that accumulates a plurality of templates, and a processing unit that executes the templates. Is an input data creation function that creates data to be analyzed by applying input data creation processing to the data, a data processing function that performs data processing on the data and creates processing result data, and data that is visualized and visualized Provided is a data analysis support system configured to perform data analysis support work by executing a visualization function.

  According to the present invention, it is possible to reduce the labor required for the user's analysis work.

It is a block diagram of the analysis support system of a 1st Example. It is a flowchart which shows an example of the procedure of the operation | work 1 of a system based on a 1st Example. It is a figure which shows the example of a display display of a template list based on a 1st Example. It is a figure which shows an example of the data structure and template of a template based on a 1st Example, the data structure of a log, and a log. It is a figure which shows an example of the data structure of a log based on a 1st Example, and a log. It is a figure which shows an example of the data structure and template log of a template log based on a 1st Example. It is a figure which shows the example of a display display of a template list | wrist and a visualization result figure based on a 1st Example. It is a figure which shows an example of the dialog for a parameter change based on a 1st Example. It is a figure which shows the specific example of the operation | work 1 based on a 1st Example. It is a figure which shows the specific example of the operation | work 1 based on a 1st Example. It is a figure explaining in detail the process of S208 of FIG. 2 based on a 1st Example. It is a flowchart which shows an example of the procedure of the operation | work 2 based on a 1st Example. It is a figure which shows the specific example of the operation | work 2 based on a 1st Example. It is a figure which shows the specific example of the operation | work 2 based on a 1st Example. It is a figure explaining in detail the process of S607 of FIG. 6 based on a 1st Example. It is a flowchart which shows an example of the procedure of the operation | work 3 based on a 1st Example. It is a figure which shows the specific example of the operation | work 3 based on a 1st Example. It is a figure which shows the specific example of the operation | work 3 based on a 1st Example. FIG. 10 is a diagram illustrating in detail the contents of S907 of FIG. 9 according to the first embodiment, and is a flowchart illustrating an example of a procedure of operation 4. It is a figure explaining in detail the process of S1110 of FIG. 11 based on a 1st Example. It is a figure explaining in detail the process of S1116 of FIG. 11 based on a 1st Example. It is a figure which shows the specific example of the operation | work 4 based on a 1st Example. It is a figure which shows the specific example of the operation | work 4 based on a 1st Example. It is a figure which shows the specific example of the operation | work 4 based on a 1st Example. It is a figure which shows the specific example of the operation | work 4 based on a 1st Example. It is a figure which shows the specific example of the operation | work 4 based on a 1st Example. It is a figure which shows the specific example of the operation | work 4 based on a 1st Example. It is a flowchart which shows an example of the procedure of the operation | work 2 based on a 2nd Example. FIG. 16 is a diagram detailing the process of S1504 of FIG. 15 according to the second embodiment. It is a flowchart which shows an example of the procedure of the operation | work 1 based on a 2nd Example. It is a flowchart which shows an example of the procedure of the operation | work 3 based on a 2nd Example. FIG. 19 is a diagram illustrating in detail the contents of S1807 in FIG. 18 according to the second embodiment, and is a flowchart illustrating an example of a procedure of operation 4. FIG. 19 is a diagram illustrating in detail the contents of S1807 in FIG. 18 according to the second embodiment, and is a flowchart illustrating an example of a procedure of operation 4. FIG. 19 is a diagram illustrating in detail the contents of S1807 in FIG. 18 according to the second embodiment, and is a flowchart illustrating an example of a procedure of operation 4. It is a figure which shows the specific example of the operation | work 4 based on a 2nd Example. It is a figure which shows the specific example of the operation | work 4 based on a 2nd Example. It is a figure which shows the specific example of the operation | work 4 based on a 2nd Example. It is a figure which shows the specific example of the operation | work 4 based on a 2nd Example. It is a figure which shows the specific example of the operation | work 4 based on a 2nd Example. It is a figure which shows the specific example of the operation | work 4 based on a 2nd Example. It is a flowchart which shows an example of the procedure of the operation | work 3 based on a 3rd Example. FIG. 23 is a diagram detailing the process of S2204 of FIG. 22 according to a third embodiment. It is a flowchart which shows an example of the procedure of the operation | work 2 based on a 3rd Example. It is a flowchart which shows an example of the procedure of the operation | work 1 based on a 3rd Example. FIG. 26 is a diagram illustrating in detail the contents of S2512 of FIG. 25 according to the third embodiment, and is a flowchart showing an example of a procedure of operation 4. FIG. 26 is a diagram illustrating in detail the contents of S2512 of FIG. 25 according to the third embodiment, and is a flowchart showing an example of a procedure of operation 4. FIG. 26 is a diagram illustrating in detail the contents of S2512 of FIG. 25 according to the third embodiment, and is a flowchart showing an example of a procedure of operation 4. It is a figure which shows the specific example of the operation | work 4 based on a 3rd Example. It is a figure which shows the specific example of the operation | work 4 based on a 3rd Example. It is a figure which shows the procedure of the analysis operation | work based on a 4th Example. It is a figure which shows the procedure of the analysis operation | work based on a 4th Example. It is a figure which shows the procedure of the analysis operation | work based on a 5th Example. It is a figure which shows an example of the window for parameter editing based on a 5th Example.

  Hereinafter, various embodiments of a data analysis support method and apparatus according to the present invention will be described with reference to the drawings. In the present specification, various functions realized by a computer or the like may be referred to as operations or units. For example, a data creation function for creating analysis target data is a data creation work or data creation unit, a data processing function for performing data processing on analysis target data and creating process result data is a data processing work or data processing unit, A data visualization function that performs a visualization process on the processing result data may be referred to as a data visualization operation or a data visualization unit.

  FIG. 1 is a block diagram of a configuration example of the analysis support system according to the present embodiment. The system shown in FIG. 1 includes a computer 101, a display 102 that functions as a display unit, an input device 103, and a database (DB) 104. The computer 101 and the DB 104 are connected to each other via the network 105.

  The computer 101 is used when the user 100 performs analysis work. Furthermore, various functions related to the analysis work are provided, logs at the time of function execution are collected, and templates 100 are extracted and recommended according to the situation to support the user 100's analysis work.

  The computer 101 is assumed to be a general PC (Personal Computer). The computer 101 includes a processor that is a central processing unit (CPU) (not shown), a memory that is a storage unit, and an interface that is an interface unit. The processor executes various processes by processing a program stored in the memory. The memory stores a program and data for executing processing. Interfaces include those connected to the input device 103 such as a keyboard and mouse, those connected to the display 102, and those connected to the DB 104 etc. via the network 105.

  The DB 104 is a database that holds various data such as information related to companies, various statistical data, time-series data such as sensors, and Web access logs. As shown in FIG. 1, the DB 104 may be configured to be stored in an external storage device (not shown) and connected to the computer 101 via the network 105, or to be included in the computer 101. It may be configured.

  The computer 101 includes an input data creation unit 110, a data processing unit 120, a data visualization unit 130, a log recording unit 140, a log DB 141, a template execution unit 150, a template processing unit 160, a template recommendation unit 170, and a template DB 180. The input data creation unit 110, the data processing unit 120, the data visualization unit 130, the log recording unit 140, the log DB 141, the template execution unit 150, the template processing unit 160, the template recommendation unit 170, and the template DB 180 are, for example, programs that are stored in the memory. A functional block that is stored and executed by a processor. The log DB 141 and the template DB 180 indicate a template database of logs, respectively, and are accumulated in a memory that is a storage unit in the omitted PC.

  The input data creation unit 110 extracts necessary data from the DB 104 according to an instruction from the user 100 or the template execution unit 150, and creates analysis target data by performing input data creation processing on the extracted data.

  The data processing unit 120 performs data processing on the analysis target data created by the input data creation unit 110 according to an instruction from the user 100 or the template execution unit 150, and creates processing result data.

  The data visualization unit 130 performs visualization on the processing result data created by the data processing unit 120 in accordance with an instruction from the user 100 or the template execution unit 150 to visualize the data.

  The log recording unit 140 records each process of the input data creation unit 110, the data processing unit 120, and the data visualization unit 130 in the log DB 141.

  The template execution unit 150 extracts a template from the template DB 180 according to an instruction from the user 100, and instructs the input data creation unit 110, the data processing unit 120, and the data visualization unit 130 according to the contents of the template to execute analysis processing.

  The template processing unit 160 extracts information related to parameters from the template, and determines whether the template can be executed on the analysis target data created by the input data creation unit 110 and the processing result data created by the data processing unit 120. .

  The template recommendation unit 170 extracts a template from the template DB 180 based on a predetermined criterion and presents the template to the user 100. Also, the analysis target data created by the input data creation unit 110 and the processing result created by the data processing unit 120. A template applicable to the data is extracted from the template DB 180 and presented to the user 100.

  Next, processing in the computer 101 of the analysis support system of the first embodiment will be described with reference to a specific example. In this embodiment, the user 100 performs operation 1 “creates analysis target data by extracting necessary data from the DB and applies input data generation processing to the extracted data”, operation 2 “data processing on analysis target data. The process is performed in the order of “Create processing result data”, work 3 “visualize and visualize the processing result data”, and work 4 “restart from work 1”.

FIG. 2 is a flowchart showing an example of the procedure of the operation 1 of the first embodiment.
First, the processor extracts a template that can be executed by the input data creation unit 110 from the template DB 180 according to the standard specified by the template recommendation unit 170, and registers it in the list Li (S201). Here, the standard is a template recently used by the user 100, a template frequently used by all users, a template frequently used by a specific user other than the user 100, a template frequently used by a department, or a template frequently used in the past. Means the recommended standard for templates such as

  Next, the extracted list Li is displayed on the display 102 which is a display unit (S202). A display example on the display 102 is shown in FIG. 3A. When the user 100 selects the template Ti, the template execution unit 150 executes the template Ti for the input data creation unit (S203, S204). FIG. 3B is a diagram illustrating an example of a template data structure and a template. The template shown here assumes the same structure for the input data creation unit, the data processing unit, and the data visualization unit, but may have a different structure as long as it can be executed by each unit. The upper part of the figure shows the data structure of the template, and the lower part of the figure shows an example of the template. As seen in the upper part of the figure, the data structure of the template is composed of parameters, process names, and arguments, as shown in the item name, and the data with the contents shown in the figure is described.

  When the user 100 does not select a template, the analysis work is not supported by the template, and a normal analysis work by a GUI (Graphical User Interface) operation or the like is performed (S205). When the input data creation process instructed in S204 or S205 and executed by the input data creation unit 110 is completed normally, the analysis target data created as a result is defined as Da. Further, the processing contents executed by the log recording unit 140 in the input data creation unit 110 are recorded and registered in the log DB 141 (S206, S207). When a template is selected in S204, a log regarding the executed template is also recorded and registered in the log DB 141 (S207).

  An example of the log data structure and log is shown in the upper and lower parts of FIG. 3C, respectively. As can be seen from the log structure in the figure, there are data string names, times, process names, and arguments as item names. 3D shows an example of the data structure of the template log and an example of the template log. As shown in the figure, the template log structure items include time, process type, template name, parameter value, input data string name, output data string name, and visualization result diagram. FIG. 3E shows a display example of the visualization result diagram on the display screen of the display 102, and FIG. 3F shows a display example of the parameter change dialog on the display screen. These FIG. 3E and FIG. Will be described in detail. Returning to the process flowchart of operation 1 in FIG. 2, if the process is not completed normally, the problem occurrence location is displayed on the display 102 and the process ends (S206, S220).

  Further, the template recommendation unit 170 extracts templates that can be applied to the analysis target data Da output as a result of the processing of the input data creation unit and can be executed by the data processing unit 120 from the template DB 180 and register them in the list Ld. (S208). The contents of S208 will be described later in detail with reference to FIG.

  4A and 4B are diagrams showing a specific example of the operation 1 of the first embodiment. As a specific example, when the content of the selection template Ti is “integrate the two specified tables with the specified column as the key column and change the key column name to the specified value”, the selection template Ti is An example of the analysis target data Da created as a result of the execution will be shown.

  FIG. 4A is an example of the template Ti. In this example, there are five Ti parameters, parameter 1 is type E (other) and value is “table 1”, parameter 2 is type E (other) and value is “table 2”, and parameter 3 is The type is N (column name), the value is “column A”, the parameter 4 is type N (column name), the value is “column X”, and the parameter 5 is type E (other) and the value is “KEY”. is there. The processing performed by Ti uses parameters 1 to 5 as an argument, “integrates the two specified tables (parameters 1 and 2) and the two specified columns (parameter 3 and parameter 4) as key columns, and specifies the specified value. “Change the key column name to (parameter 5)”. FIG. 4B is a diagram illustrating an image of “table integration”.

  The processing that can be executed by the input data creation unit 110 is not limited to the “table integration” shown in FIG. 4A and FIG. 4B, but a plurality of processing that can be implemented in SQL, programming language, etc. such as filtering and character string replacement. Targeting

FIG. 5 is a flowchart detailing the process of S208 shown in the flowchart of FIG.
First, all logs whose processing type is “for data processing” are extracted from the template log and registered in the list L2. An empty list Ld is prepared. The column name list of the analysis target data Da is set to C1 (S501). The number of elements of L2 is set to N2 and K2 = 0 (S502). The input data string name list C2 is acquired from the K2th log of L2, and if it is C2⊆C1, the K2th template of L2 is added to the list Ld. This process is executed for all elements of L2 (S503 to S507). The above is the description of the procedure of the operation 1 in the present embodiment.

FIG. 6 is a flowchart illustrating an example of the procedure of the work 2 of the first embodiment.
First, the data processing template list Ld created in S208 is displayed on the display (S601). A display example on the display 102 is the same as that shown in FIG. 3A. When the user 100 selects a template, the template execution unit 150 executes the template Td for the data processing unit (S602, S603). FIG. 3B is a diagram illustrating an example of a template data structure and a template. The template shown here assumes the same structure for the input data creation unit, the data processing unit, and the data visualization unit, but may have a different structure as long as it can be executed by each unit.

  When the user 100 does not select the template, the analysis work is not supported by the template, and the normal analysis work by the GUI operation or the like is performed (S604). When the analysis process instructed in S603 or S604 and executed by the data processing unit 120 is completed normally, the process result data created as a result is defined as Dr. Further, the processing contents executed by the data processing unit 120 by the log recording unit 140 are recorded and registered in the log DB 141 (S605, S606). If a template is selected in S603, a log relating to the executed template is also recorded and registered in the log DB 141 (S606). FIG. 3C shows an example of the log data structure and log. FIG. 3D shows an example of the data structure of the template log and the template log. If the process has not been completed normally, the problem location is displayed on the display, and the process ends (S605, S220).

  Further, templates that can be applied to the processing result data Dr output from the template DB 180 by the template recommendation unit 170 as a result of the processing of the data processing unit and that can be executed by the data visualization unit 130 are extracted and registered in the list Lv (S607). ). The contents of S607 will be described in detail with reference to FIG.

  FIG. 7 is a diagram showing a specific example of the operation 2 of the first embodiment. As a specific example, an example of the processing result data Dr created as a result of executing the selection template Td when the content of the selection template Td is “count the number of occurrences of elements in the designated column” is shown.

  FIG. 7A is an example of the template Td. In this example, there is one parameter of Td, and parameter 1 has a type of N (column name) and a value of “KEY”. The process performed at Td is performed by “counting the number of occurrences of elements in the designated column (parameter 1)” with the parameter 1 as an argument. FIG. 7B is a diagram illustrating an image of “counting the number of appearances of elements”.

  The processing that can be executed by the data processing unit is not limited to “counting the number of occurrences of elements” shown in FIG. 7, but can be realized by SQL, programming language, etc. such as filtering, character string replacement, four arithmetic operations, and statistical operations. Targeting a combination of multiple processes.

FIG. 8 is a diagram illustrating in detail the processing of S607 in the flowchart of FIG.
First, all logs whose processing type is “for visualization” are extracted from the template log and registered in the list L2. An empty list Lv is prepared. The column name list of the processing result data Dr is set to C1 (S801). The number of elements of L2 is set to N2 and K2 = 0 (S802). The input data string name list C2 is acquired from the K2th log of L2, and when it is C2⊆C1, the K2th template of L2 is added to the list Lv. This process is executed for all elements of L2 (S803 to S807). The above is the description of the procedure of the work 2 in the present embodiment.

FIG. 9 is a flowchart showing an example of the procedure of the operation 3 in the first embodiment.
First, a visualization example of each template included in the data visualization template lists Lv and Lv created in S607 is displayed on the display (S901). Examples of display on the display 102 are shown in FIGS. 3A and 3E. In FIG. 3E, 310 indicates a list of Lvs, and 311 displays the visualization result of this data visualization template in the past when the template name displayed in 310 is selected.

  When the user 100 selects a template, the template execution unit 150 executes the template Tv for the data visualization unit (S902, S903). FIG. 3B is a diagram illustrating an example of a template data structure and a template. The template shown here assumes the same structure for the input data creation unit, the data processing unit, and the data visualization unit, but may have a different structure as long as it can be executed by each unit.

  When the user 100 does not select the template, the analysis work is not supported by the template, and the normal analysis work by the GUI operation or the like is performed (S904). When the analysis process instructed in S903 or S904 and executed by the data visualization unit 130 is completed normally, the visualization result is displayed on the display 102. In addition, the processing contents executed by the data visualization unit 130 by the log recording unit 140 are recorded and registered in the log DB 141 (S905, S906). When a template is selected in S903, a log regarding the executed template is also recorded and registered in the log DB 141 (S906). FIG. 3C shows an example of the log data structure and log. FIG. 3D shows an example of the data structure of the template log and the template log. If the process is not completed normally, the problem location is displayed on the display, and the process ends (S905, S220).

  Furthermore, when the visualization result is not what the user 100 desires, the user 100 modifies and re-executes the processes 1 to 3 (S907). The contents of S907 will be described in detail with reference to FIG.

  10A and 10B are diagrams showing a specific example of the operation 3 in the first embodiment. As a specific example, an example of visualization created as a result of executing the selection template Tv when the content of the selection template Tv is “display the specified column as a bar graph and use the specified column as an item name on the horizontal axis”. Indicates.

  FIG. 10A is an example of the template Tv. In this example, there are two parameters of Tv, parameter 1 has type N (column name) and value “number of occurrences of elements”, and parameter 2 has type N (column name) and value “KEY”. It is. The process performed in Tv is performed by using “parameters 1 and 2 as arguments” and “display the designated column (parameter 1) as a bar graph and designate the designated column (parameter 2) as the item name on the horizontal axis”. FIG. 10B is a diagram illustrating an image of a “bar graph”.

  The processing that can be executed by the data visualization unit is not limited to “display the specified column as a bar graph and use the specified column as the item name on the horizontal axis” shown in FIG. The target is a combination of multiple processes that can be implemented in a language or the like.

FIG. 11 is a diagram for explaining in detail the contents of S907 in the flowchart of FIG. 9, and is a flowchart showing an example of the procedure of the operation 4 in the first embodiment.
First, the parameter of the template Ti for the input data creation unit is changed, or the template Ti for the input data creation unit is selected again (S1101, S1102). When the template Ti for the input data creation unit is selected again, the process proceeds to S201. Since this process is as described above, it is omitted here.

  When changing the parameters of the template Ti for the input data creation unit, the template processing unit 160 extracts the parameters from Ti and displays the parameter list on the display (S1103). When a parameter to be changed is selected by the user 100, a parameter editing window is displayed on the display, the parameter changed by the user 100 and its value are acquired, and input data creation reflecting the changed parameter is created. The template Ti for part is executed (S1104 to S1107).

  An example of a parameter editing window is shown in FIG. 3F. In FIG. 3F, 301 is a parameter name, 302 is a value candidate, 303 is the value selected in 302, and the user 100 may adopt this value or edit this value. Also good. The value candidates displayed in 302 are automatically acquired. For example, when the parameter type is “T”, an accessible table name list is displayed in 302.

  When the input data creation process executed by the input data creation unit 110 ends normally, the analysis target data created as a result is set to Da. Further, the processing contents executed by the log recording unit 140 in the input data creation unit 110 are recorded and registered in the log DB 141 (S1108, S1109). Further, a log relating to the executed template Ti is also recorded and registered in the log DB 141 (S1109). FIG. 3C shows an example of the log data structure and log. FIG. 3D shows an example of the data structure of the template log and the template log. If the process has not been completed normally, the problem location is displayed on the display, and the process ends (S1108, S220).

  Further, the template processing unit 160 determines whether or not Td can be executed on the analysis target data Da, and when Td can be executed from the determination result, the template execution unit 150 executes Td (S1110, S1111, and S1113). The contents of S1110 will be described in detail with reference to FIG.

  When the data processing executed by the data processing unit 120 ends normally, the processing result data created as a result is set to Dr. The log recording unit 140 records the processing content executed by the data processing unit 120 and registers it in the log DB 141 (S1114, S1115). Further, a log related to the executed template Td is also recorded and registered in the log DB 141 (S1115). FIG. 3C shows an example of the log data structure and log. FIG. 3D shows an example of the data structure of the template log and the template log.

  If the execution is not possible in S1111, or if the process did not end normally in S1114, the template recommendation unit 170 extracts a template for the data processing unit applicable to the analysis target data Da and registers it in the list Ld (S1112). The process proceeds to S601.

  Furthermore, the template processing unit 160 determines whether or not Tv can be executed on the processing result data Dr. If Tv can be executed from the determination result, the template execution unit 150 executes Tv (S1116, S1117, S1119). The contents of S1116 will be described in detail with reference to FIG.

  When the visualization process executed by the data visualization unit 130 is completed normally, the visualization result is displayed on the display. In addition, the processing contents executed by the data recording unit 130 by the log recording unit 140 are recorded and registered in the log DB 141 (S1120, S1121). Further, a log related to the executed template Tv is also recorded and registered in the log DB 141 (S1121). FIG. 3C shows an example of the log data structure and log. FIG. 3D shows an example of the data structure of the template log and the template log.

  If execution is not possible in S1117, or if the process did not end normally in S1120, the template recommendation unit 170 extracts a template for the data visualization unit applicable to the processing result data Dr and registers it in the list Lv (S1118). , The process proceeds to S901.

  FIG. 12 is a diagram detailing the processing of S1110.

  First, the template processing unit 160 extracts all the logs that have executed the template Td for the data processing unit from the template log, and registers them in the list L2 (S1201). The column name list of the analysis target data Da, where the number of elements of L2 is N2 and K2 = 0 is C1 (S1202). The input data string name list C2 is acquired from the K2 log of L2, and if C2⊆C1, the determination result is “executable”, the parameter given to Td is set as the parameter value of the K2 log of L2, and the process ends. To do. This process is executed for all elements of L2 (S1203 to S1207), and if the determination result does not become “executable”, the determination result is determined to be “unexecutable” (S1203, S1208).

  FIG. 13 is a diagram illustrating in detail the processing of S1116.

  First, the template processing unit 160 extracts all the logs that execute the template Tv for the data visualization unit from the template log, and registers them in the list L2 (S1301). The number of elements in L2 is N2, and K2 = 0, and the column name list of the processing result data Dr is C1 (S1302). The input data string name list C2 is acquired from the K2 log of L2, and when it is C2１C1, the determination result is “executable”, the parameter given to Tv is set as the parameter value of the K2 log of L2, and the process ends. To do. This process is executed for all the elements of L2 (S1303 to S1307), and if the determination result does not become “executable”, the determination result is determined to be “unexecutable” (S1303, S1308).

  FIGS. 14A to 4F are diagrams showing specific examples of the operation 4 in the first embodiment. As a specific example, in the analysis processes of work 1 to work 3 in FIGS. 4, 7, and 10, input data creation processing was performed using “column A” and “column X” as key columns. In the example of 4F, the parameter 3 of the template Ti for the input data creation unit is changed to “column C” and the parameter 4 is changed to “column Z” in S1103 to S1105, and “column C” and “column Z” are key columns. Assuming that the input data creation processing is performed, the data processing and visualization processing are executed using the templates Td and Tv.

  In FIG. 14A, in S1103 to S1106, the parameter 3 of the template Ti for the input data creation unit is changed to “column C” and the parameter 4 is changed to “column Z”, respectively. Are integrated as two key columns (parameter 3, parameter 4) as a key column, and the key column name is changed to a specified value (parameter 5) ". FIG. 14B is a diagram showing an image of “table integration”.

  FIG. 14C is an example of the selection template Td. In this example, since the selected template Td can be applied to the analysis target data Da as a result of executing the template Ti, no parameter change or the like is performed. FIG. 14D is a diagram illustrating an image of “counting the number of appearances of elements”.

  FIG. 14E is an example of the template Tv. In this example, the template Tv can be applied to the processing result data Dr as a result of the execution of the template Td, so that no parameter change or the like is performed. FIG. 14F is a diagram illustrating an image of a “bar graph”.

  According to the first embodiment described above, it is possible to change the input data creation process of the analysis work, and also support the change of the data process and the visualization process accompanying the change of the input data creation process using the template. Therefore, it is possible to reduce the labor of analysis work of the user 100.

  In the first embodiment described above, as a specific example, as a specific example, the user 100 performs operation 1 “creates analysis target data by extracting necessary data from the DB 104 and performing input data creation processing on the extracted data”, Assuming a scenario where the analysis work is performed in the order of operation 2 “process data on analysis target data and create processing result data”, operation 3 “visualize processing result data by visualization”, operation 4 “restart from operation 1” However, the second embodiment is an embodiment of a data analysis support system that assumes a scene in which analysis work is performed in the order of work 2, work 1, work 3, and work 4.

FIG. 15 is a flowchart illustrating an example of the procedure of the work 2 according to the second embodiment.
First, a template that can be executed by the data processing unit 120 is extracted from the template DB 180 according to the specified standard by the template recommendation unit 170 and registered in the list Ld (S1501). The standard specified here is a template recently used by the user 100, a template frequently used by all users, a template frequently used by a specific user other than the user 100, a template frequently used by each department, and the past period It means a template that is often used for.

  Next, the extracted list Ld is displayed on the display 102 (S1502). A display example on the display 102 is shown in FIG. 3A. When the user 100 selects a template, an input data creation template that can create analysis target data necessary for execution of the data processing template Td for which the template recommendation unit has been selected is extracted and registered in the list Li (S1503, S1504). .

FIG. 16 is a diagram detailing the processing of S1504.
All the logs that executed Td are extracted from the template log and set to L1. All the logs whose processing type is “for input data creation” are extracted from the template log and are set as L2. Let the empty list be Li (S1601). The number of elements in L1 is N1, the number of elements in L2 is N2, K1 = 0, and K2 = 0 (S1602). The input data string name list C1 is acquired from the K1th log of L1 (S1603). The output data string name list C2 is acquired from the K2 log of L2, and if it is C2⊆C1, the K2 template of L2 is added to the list Li. This process is executed for all elements of L1 and L2 (S1603 to S1610).

FIG. 17 is a flowchart illustrating an example of the procedure of the operation 1 according to the second embodiment.
First, the input data creation template list Li created in S1504 is displayed on the display (S1701). A display example on the display 102 is the same as that shown in FIG. 3A. When the user 100 selects a template, the template execution unit 150 executes the template Ti for the input data creation unit (S1702, S1703). FIG. 3B is a diagram illustrating an example of a template data structure and a template. The template shown here assumes the same structure for the input data creation unit, the data processing unit, and the data visualization unit, but may have a different structure as long as it can be executed by each unit.

  When the user 100 does not select the template, the analysis work is not supported by the template, and the normal analysis work by the GUI operation or the like is performed (S1704). When the input data creation process instructed in S1703 or S1704 and executed by the input data creation unit 110 is completed normally, the analysis target data created as a result is defined as Da. In addition, the log recording unit 140 records the processing content executed by the input data creation unit 110 and registers it in the log DB 141 (S1705, S1706). If a template is selected in S1703, a log related to the executed template is also recorded and registered in the log DB 141 (S1706). FIG. 3C shows an example of the log data structure and log. FIG. 3D shows an example of the data structure of the template log and the template log. If the process is not completed normally, the problem location is displayed on the display, and the process ends (S1705, S220).

  Next, the template execution unit 150 executes the template Td for the data processing unit (S1707). FIG. 3B is a diagram illustrating an example of a template data structure and a template. The template shown here assumes the same structure for the input data creation unit, the data processing unit, and the data visualization unit, but may have a different structure as long as it can be executed by each unit.

  When the analysis process executed by the data processing unit 120 ends normally, the process result data created as a result is defined as Dr. The log recording unit 140 records the processing content executed by the data processing unit 120 and registers it in the log DB 141 (S1708, S1709). Further, a log relating to the executed template is also recorded and registered in the log DB 141 (S1709). FIG. 3C shows an example of the log data structure and log. FIG. 3D shows an example of the data structure of the template log and the template log. If the process has not been completed normally, the problem location is displayed on the display, and the process ends (S1708, S220).

  Further, templates that can be applied to the processing result data Dr output by the template recommendation unit 170 as a result of the processing of the data processing unit and can be executed by the data visualization unit 130 are extracted from the template DB 180 and registered in the list Lv (S1710). ). The contents of S1710 are the same as S607.

  FIG. 18 is a flowchart showing an example of the procedure of the operation 3 in the second embodiment.

  First, a visualization example of each template included in the visualization template lists Lv and Lv created in S1710 is displayed on the display (S1801). Display examples on the display 102 are the same as those shown in FIGS. 3A and 3E. When the user 100 selects a template, the template execution unit 150 executes the template Tv for the data visualization unit (S1802, S1803). FIG. 3B is a diagram illustrating an example of a template data structure and a template. The template shown here assumes the same structure for the input data creation unit, the data processing unit, and the data visualization unit, but may have a different structure as long as it can be executed by each unit.

  When the user 100 does not select the template, the analysis work is not supported by the template, and the normal analysis work by the GUI operation or the like is performed (S1804). When the analysis process instructed in S1803 or S1804 and executed by the data visualization unit 130 is completed normally, the visualization result is displayed on the display 102. In addition, the processing contents executed by the data recording unit 130 by the log recording unit 140 are recorded and registered in the log DB 141 (S1805, S1806). If a template is selected in S1803, a log regarding the executed template is also recorded and registered in the log DB 141 (S1806). FIG. 3C shows an example of the log data structure and log. FIG. 3D shows an example of the data structure of the template log and the template log. If the process has not been completed normally, the problem location is displayed on the display, and the process ends (S1805, S220).

  Furthermore, when the visualization result is not what the user 100 desires, the processes of the operations 1 to 3 are modified and re-executed (S1807). The contents of S1807 will be described in detail with reference to FIG.

19, 20A, and 20B are diagrams illustrating the details of S1807, and are a flowchart illustrating an example of the procedure of the operation 4 of the second embodiment.
First, it is selected whether or not to change the template Td for the data processing unit (S1901). When changing the template Td for the data processing unit, the template recommendation unit 170 extracts a template that can be executed by the data processing unit 120 from the template DB 180 according to the specified standard, presents it to the user 100, and selects the user 100. In response, the process proceeds to S1903 (S1902). The standard specified here is a template recently used by the user 100, a template frequently used by all users, a template frequently used by a specific user other than the user 100, a template frequently used by each department, and the past period It means a template that is often used for.

  Next, the template processing unit 160 extracts parameters from Td and displays a parameter list on the display (S1903). When the parameter is changed by the user 100, the parameter and the value changed by the user 100 are acquired, and the process proceeds to S2001 (S1904, S1905). An example of a parameter editing window is shown in FIG. 3F. The value candidates displayed in 302 of FIG. 3F are automatically obtained from data Da obtained as a result of the execution of Ti according to the selected parameter.

  Next, the column name list of the analysis target data Da is set to C0, and the parameter and argument values of the type “N” are extracted from the template Td for the data processing unit and registered in the column name list C2 (S2001, S2002). In the case of C2 の C0, the process proceeds to S1907 (S2003). If it is not C2０C0, the number of rows of Ti is set to R0 and K0 = 0 (S2004).

  Steps 1 to K0 of Ti are executed. If the column name list of the data created as a result is C0 ', and C2⊆C0', Ti is set to Ti until the K0th row, and the process proceeds to S1907. This process is continued until K0 = R0. When K0 = R0, the process proceeds to S2010 (S2005 to S2009).

  Next, all the logs whose processing type is “for creating input data” are extracted from the template log and registered in the list L1 (S2010). The number of elements of L1 is set to N1 and K1 = 0 (S2011). The output data string name list C1 is obtained from the K1 log of L1, and in the case of C2⊆C1, the K1 template of L1 is set to Ti, and the process proceeds to S1907. This process is continued until K1 = R1, and when K1 = R1, the process proceeds to S2017 (S2012 to S2016).

  Next, the number of elements in L1 is set to N1 and K1 = 0 (S2017). The K1th template of L1 is set as TK1. The number of rows of TK1 is R3 and K3 = 0. Steps 1 to K3 of TK1 are executed, and the column name list of the data created as a result is set as C3 '. In the case of C2⊆C3 ', Ti is set to Ti up to the K3rd row, and the process proceeds to S1907. This process is applied to all rows of TK1 and all elements of L1, and when K1 = N1, Ti is emptied and the process proceeds to S1907 (S2018 to S2025).

  Next, when Ti is empty, the analysis work is not supported by the template, and the normal analysis work by GUI operation or the like is performed (S1907, S1908). If Ti is not empty, the template execution unit 150 executes the template Ti for the input data creation unit (S1907, S1909). When the input data creation process instructed in S1908 or S1909 and executed by the input data creation unit 110 is completed normally, the log recording unit 140 records the processing content executed by the input data creation unit 110 and registers it in the log DB 141 (S1910, S1911). When the template Ti is executed in S1909, a log relating to the executed template is also recorded and registered in the log DB 141 (S1911). If the process is not completed normally, the problem location is displayed on the display, and the process ends (S1910, S220).

  The template execution unit 150 executes Td (S1912). When the data processing executed by the data processing unit 120 ends normally, the processing result data created as a result is set to Dr. Also, the processing contents executed by the data processing unit 120 by the log recording unit 140 are recorded and registered in the log DB 141 (S1913, S1914). Further, a log related to the executed template Td is also recorded and registered in the log DB 141 (S1914). If the process has not been completed normally, the problem location is displayed on the display, and the process ends (S1913, S220).

  Further, the template processing unit 160 determines whether or not Tv can be executed on the processing result data Dr. If Tv can be executed from the determination result, the template execution unit 150 executes Tv (S1915, S1916, S1917). The contents of S1915 are omitted here because they are already described in FIG.

  When the visualization process executed by the data visualization unit 130 is completed normally, the visualization result is displayed on the display. In addition, the processing contents executed by the log recording unit 140 in the data visualization unit 130 are recorded and registered in the log DB 141 (S1918, S1919). Further, a log related to the executed template Tv is also recorded and registered in the log DB 141 (S1919). If the process has not been completed normally, the problem location is displayed on the display, and the process ends (S1918, S220).

  If the execution is not possible in S1916, the template recommendation unit 170 extracts a template for the data visualization unit applicable to the processing result data Dr, registers it in the list Lv, and proceeds to S1801 (S1920).

  21A to 21F are diagrams illustrating specific examples of the operation 4 of the second embodiment. As a specific example, in the analysis process of work 1 to work 3 in FIGS. 4, 7, and 10, data processing was performed as “count the number of elements”, but in the example of FIG. 21, the data processing unit in S 1902 to S 1906 Select the template Td for “Cross tabulation of specified two columns”, set parameter 1 as “KEY”, parameter 2 as “column A”, and execute data processing and visualization processing using templates Ti and Tv Assume a scene to do.

  FIG. 21A is an example of the template Td. In this example, there are two parameters of Td, the parameter 1 has the type N (column name) and the value “KEY”, and the parameter 2 has the type N (column name) and the value “column A”. . The process performed at Td uses “parameters 1 and 2 as arguments” to perform “cross tabulation of specified two columns (parameter 1 and parameter 2)”. FIG. 21B is a diagram showing an image of “cross tabulation”.

  FIG. 21C is an example of the template Ti. The change of the template Td does not affect the template Ti, so the parameter is not changed. FIG. 21D is a diagram showing an image of “table integration”.

  FIG. 21E is an example of the template Tv. In this example, an applicable template Tv is extracted along with the change of the processing result data Dr. FIG. 21E shows a case where the extracted Tv content is “display two specified columns as a bar graph and use the specified columns as item names on the horizontal axis”, and FIG. 21F shows an image of the “bar graph”. is there.

  According to the second embodiment described above, it is possible to change the data processing of the analysis work, and it is possible to support the change of the input data creation processing and the visualization processing accompanying the change of the data processing using the template. Therefore, it is possible to reduce the labor of the analysis work of the user 100.

  In the first embodiment, the user 100 operates the operation 1 “extracts necessary data from the DB 104 and creates the analysis target data by performing input data generation processing on the extracted data”, operation 2 “data in the analysis target data. When processing “create processing result data”, operation 3 “visualize processing result data and visualize”, and operation 4 “restart from operation 1”, operation 3, operation 2, operation 1, and operation 4 It is the Example supposing the scene which performs the analysis work by.

FIG. 22 is a flowchart showing an example of the procedure of the operation 3 in the third embodiment.
First, the template recommendation unit 170 extracts a template that can be executed by the input data creation unit 110 from the template DB 180 according to the specified standard, and registers it in the list Lv (S2201). The standard specified here is a template recently used by the user 100, a template frequently used by all users, a template frequently used by a specific user other than the user 100, a template frequently used by each department, and the past period It means a template that is often used for.

  Next, a visualization example of each template included in the extracted lists Lv and Lv is displayed on the display 102 (S2202). Examples of display on the display 102 are shown in FIGS. 3A and 3E. When the user 100 selects a template, a data processing template that can create processing result data necessary for executing the visualization template Tv for which the template recommendation unit has been selected is extracted and registered in the list Ld (S2203, S2204).

FIG. 23 is a diagram detailing the processing of S2204.
All the logs in which the template processing unit has executed Tv from the template log are extracted as L1. All logs whose processing type is “for data processing” are extracted from the template log and are set as L2. Let Ld be an empty list (S2301). The number of elements in L1 is N1, the number of elements in L2 is N2, K1 = 0, and K2 = 0 (S2302). The input data string name list C1 is acquired from the K1th log of L1 (S2303). The output data string name list C2 is acquired from the K2 log of L2, and if it is C2⊆C1, the K2 template of L2 is added to the list Ld. This process is executed for all elements of L1 and L2 (S2303 to S2310).

FIG. 24 is a flowchart showing an example of the procedure of the work 2 in the third embodiment.
First, the data processing template list Ld created in S2204 is displayed on the display (S2401). A display example on the display 102 is the same as that shown in FIG. 3A. When the user 100 selects a template, the template recommendation unit extracts an input data creation template that can create analysis target data necessary for executing the data processing template Td for which the template recommendation unit has been selected, and registers it in the list Li ( S2403). The contents of S2403 are the same as S1504.

FIG. 25 is a flowchart illustrating an example of the procedure of the operation 1 according to the third embodiment.
First, the input data creation template list Li created in S2403 is displayed on the display (S2501). A display example on the display 102 is the same as that shown in FIG. 3A. When the user 100 selects a template, the template execution unit 150 executes the template Ti for the input data creation unit (S2502, S2503). FIG. 3B is a diagram illustrating an example of a template data structure and a template. The template shown here assumes the same structure for the input data creation unit, the data processing unit, and the data visualization unit, but may have a different structure as long as it can be executed by each unit.

  When the input data creation process executed by the input data creation unit 110 ends normally, the analysis target data created as a result is set to Da. Further, the processing contents executed by the log recording unit 140 in the input data creation unit 110 are recorded and registered in the log DB 141 (S2504, S2505). Further, a log relating to the executed template is also recorded and registered in the log DB 141 (S2505). FIG. 3C shows an example of the log data structure and log. FIG. 3D shows an example of the data structure of the template log and the template log. If the process has not been completed normally, the problem location is displayed on the display, and the process ends (S2504, S220).

  Next, the template execution unit 150 executes the template Td for the data processing unit (S2506). FIG. 3B is a diagram illustrating an example of a template data structure and a template. The template shown here assumes the same structure for the input data creation unit, the data processing unit, and the data visualization unit, but may have a different structure as long as it can be executed by each unit.

  When the analysis process executed by the data processing unit 120 ends normally, the process result data created as a result is defined as Dr. Further, the processing contents executed by the data processing unit 120 by the log recording unit 140 are recorded and registered in the log DB 141 (S2507, S2508). Further, a log relating to the executed template is also recorded and registered in the log DB 141 (S2508). FIG. 3C shows an example of the log data structure and log. FIG. 3D shows an example of the data structure of the template log and the template log. If the process has not been completed normally, the problem location is displayed on the display, and the process ends (S2507, S220).

  Next, the template execution unit 150 executes the template Tv for the data visualization unit (S2509). When the analysis process executed by the data visualization unit 130 is completed normally, the visualization result is displayed on the display 102. In addition, the processing contents executed by the data visualization unit 130 by the log recording unit 140 are recorded and registered in the log DB 141 (S2510, S2511). Further, a log relating to the executed template is also recorded and registered in the log DB 141 (S2511). If the process has not been completed normally, the problem location is displayed on the display, and the process ends (S2510, S220).

  Further, if the visualization result is not the one desired by the user 100, the processes 1 to 3 are modified and re-executed (S2512). The contents of S2512 will be described in detail with reference to FIGS. 26A to 26D.

FIGS. 26A to 26D are diagrams illustrating the details of S2512 and are flowcharts illustrating an example of the procedure of the operation 4 in the third embodiment.
First, it is selected whether or not to change the template Tv for the data visualization unit (S2601). When changing the template Tv for the data visualization unit, the template recommendation unit 170 extracts a template that can be executed by the data visualization unit 130 from the template DB 180 according to the specified standard, presents it to the user 100, and selects the user 100. In response, the process proceeds to S2603 (S2602). The standard specified here is a template recently used by the user 100, a template frequently used by all users, a template frequently used by a specific user other than the user 100, a template frequently used by each department, and the past period It means a template that is often used for.

  Next, the template processing unit 160 extracts parameters from Tv and displays a parameter list on the display (S2603). When a parameter is selected by the user 100, a parameter editing window is displayed on the display, the parameter and its value changed by the user 100 are acquired, and the process proceeds to S2701 (S2604, S2605). An example of a parameter editing window is shown in FIG. 3F. The candidate values displayed in 302 of FIG. 3F are automatically obtained from data Dr obtained as a result of the execution of Td according to the selected parameter.

  Next, the column name list of the processing result data Dr is set to C0, and the parameter and argument values of the type “N” are extracted from the template Tv for the data visualization unit and registered in the column name list C2 (S2701 and S2702). In the case of C2 の C0, the process proceeds to S2607 (S2703). If it is not C2⊆C0, the number of rows of Td is set to R0 and K0 = 0 (S2704).

  The first to K0th rows of Td are executed, and the column name list of the data created as a result is C0 '. If C2⊆C0', Td is taken to the K0th row of Td, and the process proceeds to S2607. This process is continued until K0 = R0, and if K0 = R0, the process proceeds to S2710 (S2705 to S2709).

  Next, all logs whose processing type is “for data processing” are extracted from the template log and registered in the list L1 (S2710). The number of elements of L1 is set to N1 and K1 = 0 (S2711). The output data string name list C1 is acquired from the K1 log of L1, and in the case of C2⊆C1, the K1 template of L1 is set to Ti, and the process proceeds to S2607. This process is continued until K1 = R1, and when K1 = R1, the process proceeds to S2717 (S2712 to S2716).

  Next, the number of elements of L1 is set to N1 and K1 = 0 (S2717). The K1th template of L1 is set as TK1. The number of rows of TK1 is R3 and K3 = 0. Steps 1 to K3 of TK1 are executed, and the column name list of the data created as a result is set as C3 '. In the case of C2⊆C3 ', Ti is set to Ti up to the K3rd row, and the process proceeds to S2607. This process is applied to all rows of TK1 and all elements of L1, and when K1 = N1, Td is emptied and the process proceeds to S2607 (S2718 to S2725).

Next, when Td is empty, the problem location is displayed on the display, and the process ends (S2507, S220). If Td is not empty, the process proceeds to S2001 (S2507).
The column name list of the analysis target data Da is set to C0, and the parameter and argument values of the type “N” are extracted from the template Td for the data processing unit and registered in the column name list C2 (S2001, S2002). In the case of C2 の C0, the process proceeds to S2608 (S2003). If it is not C2０C0, the number of rows of Ti is set to R0 and K0 = 0 (S2004).

  Steps 1 to K0 of Ti are executed. If the column name list of the data created as a result is C0 ', and C2⊆C0', Ti is set to Ti until the K0th row, and the process proceeds to S1907. This process is continued until K0 = R0. When K0 = R0, the process proceeds to S2010 (S2005 to S2009).

  Next, all the logs whose processing type is “for creating input data” are extracted from the template log and registered in the list L1 (S2010). The number of elements of L1 is set to N1 and K1 = 0 (S2011). The output data string name list C1 is acquired from the K1 log of L1, and in the case of C2⊆C1, the K1 template of L1 is set to Ti, and the process proceeds to S2608. This process is continued until K1 = R1, and when K1 = R1, the process proceeds to S2017 (S2012 to S2016).

  Next, the number of elements in L1 is set to N1 and K1 = 0 (S2017). The K1th template of L1 is set as TK1. The number of rows of TK1 is R3 and K3 = 0. Steps 1 to K3 of TK1 are executed, and the column name list of the data created as a result is set as C3 '. In the case of C2⊆C3 ', Ti is set to Ti up to the K3rd row, and the process proceeds to S2608. This process is applied to all rows of TK1 and all elements of L1, and when K1 = N1, Ti is emptied and the process proceeds to S2608 (S2018 to S2025).

  Next, when Ti is empty, the analysis work is not supported by the template, and the normal analysis work by GUI operation or the like is performed (S2608, S2609). If Ti is not empty, the template execution unit 150 executes the template Ti for the input data creation unit (S2608, S2610). When the input data creation processing instructed in S2609 or S2610 and executed by the input data creation unit 110 is completed normally, the log recording unit 140 records the processing content executed by the input data creation unit 110 and registers it in the log DB 141 (S2611, S2612). When the template Ti is executed in S2610, a log related to the executed template is also recorded and registered in the log DB 141 (S2612). If the process is not completed normally, the problem location is displayed on the display, and the process ends (S2611, S220).

  Next, the template execution unit 150 executes Td (S2613). When the data processing executed by the data processing unit 120 ends normally, the log recording unit 140 records the processing content executed by the data processing unit 120 and registers it in the log DB 141 (S2614, S2615). Further, a log related to the executed template Td is also recorded and registered in the log DB 141 (S2615). If the process has not been completed normally, the problem location is displayed on the display, and the process ends (S2614, S220).

  Next, the template execution unit 150 executes Tv (S2616). When the visualization process executed by the data visualization unit 130 is completed normally, the visualization result is displayed on the display. In addition, the processing content executed by the data recording unit 130 by the log recording unit 140 is recorded and registered in the log DB 141 (S2617, S2618). Further, a log related to the executed template Tv is also recorded and registered in the log DB 141 (S2618). If the process has not been completed normally, the problem location is displayed on the display, and the process ends (S2617, S220).

  27A and 27B are diagrams showing a specific example of the operation 4 in the third embodiment. As a specific example, in the analysis process of work 1 to work 3 in FIGS. 4, 7, and 10, visualization is performed as “display a specified column as a bar graph and use the specified column as an item name on the horizontal axis”. However, in the examples of FIGS. 27A and 27B, in step S2602 to S2606, the template Tv for the data visualization unit is selected by selecting “display the designated column as a pie chart and use the designated column as the item name” and set parameter 1 It is assumed that “number of occurrences of elements”, parameter 2 is “KEY”, and input data creation processing and data processing are executed using templates Ti and Td.

FIG. 27A is an example of the template Tv. In this example, there are two parameters of Tv, parameter 1 has type N (column name) and value “number of occurrences of elements”, and parameter 2 has type N (column name) and value “KEY”. It is. The process performed in Tv is “display the designated column (parameter 1) as a pie chart and use the designated column (parameter 2) as an item name” with parameters 1 and 2 as arguments. FIG. 21B is a diagram showing an image of a “pie graph”. Since the processes using the templates Ti and Td are the same as those shown in FIGS. 4 and 7, they are omitted here.

  According to the third embodiment, the analysis process visualization process can be changed, and the input data creation process and the data process change accompanying the change in the visualization process can be supported using the template. Thus, it is possible to reduce the labor of analysis of the user 100.

  In the fourth embodiment, the user 100 operates the work 1 “extracts necessary data from the DB 104 and creates the analysis target data by performing the input data creation processing on the extracted data”, the work 2 “data in the analysis target data. When processing “create processing result data”, work 3 “visualize processing result data and visualize”, and work 4 “redo from work 1”, work 3, work 1, work 2, and work 4 It is the Example supposing the scene which performs the analysis work by.

28A and 28B are flowcharts showing an example of the procedure of the fourth embodiment.
First, a template that can be executed by the data visualization unit 130 is extracted from the template DB 180 in accordance with the specified standard by the template recommendation unit 170 and registered in the list Lv (S2801). The standard specified here is a template recently used by the user 100, a template frequently used by all users, a template frequently used by a specific user other than the user 100, a template frequently used by each department, and the past period It means a template that is often used for.

  Next, a visualization example of each template included in the extracted lists Lv and Lv is displayed on the display 102 (S2802). Examples of display on the display 102 are shown in FIGS. 3A and 3E. When the user 100 selects a template, the template recommendation unit extracts all input data creation templates executed immediately before the visualization template Tv selected from the template log, registers them in the list Li, and displays Li on the display ( S2803-S2805). When the input data creation template Ti is selected, Ti is executed (S2806, S2807). The template recommendation unit 170 extracts all data processing templates between Ti and Tv from the template log, registers them in the list Ld, and displays Ld on the display (S2808, S2809).

  When the data processing template Td is selected, it is selected whether to change the Td parameter (S2810, S2811). When changing the parameter, the template processing unit 170 extracts the parameter from Td and displays the parameter list on the display (S2812). When a parameter is selected, a parameter editing window is displayed on the display (S2813, S2814). When parameter editing is completed, Td is executed (S2815, S2816). If the parameter is not changed, Td is executed (S2816). An example of a parameter editing window is shown in FIG. 3F. The candidate values displayed at 302 in FIG. 3F are automatically obtained from data obtained as a result of the execution of Ti according to the selected parameter.

  Next, the Tv parameter is changed in order to change the Td parameter or change the element for visualization. The template processing unit 170 extracts parameters from Tv and displays a parameter list on the display (S2817). If a parameter is selected, a parameter editing window is displayed on the display (S2818). An example of a parameter editing window is shown in FIG. 3F. The value candidates displayed in 302 of FIG. 3F are automatically obtained from data obtained as a result of the execution of Td according to the selected parameter.

  When the parameter editing is completed, Tv is executed, the visualization result is displayed on the display, and the log recording unit 140 records the processing contents respectively executed by the input data creation unit 110, the data processing unit 120, and the data visualization unit 130, and logs Register in the DB 141 (S2820 to S2822).

  In S2804 to S2806, the input data creation template is selected. However, as in S205 of FIG. 2, the analysis work is not supported by the template, and a normal analysis work by a GUI operation or the like may be performed. .

  After selecting the input data creation template Ti in step S2806, the Ti parameter can be changed. In this case, the subsequent processing is the same as in the first embodiment.

  In S2807 to S2809, the data processing template is selected. However, as in S604 of FIG. 6, the analysis work is not supported by the template, and a normal analysis work by a GUI operation or the like may be performed.

  According to the fourth embodiment, the analysis work can be started from the visualization result of the analysis work. That is, input data creation processing necessary for realizing the visualization result and construction of the data processing can be supported using the template, so that it is possible to reduce the labor of analysis of the user 100. .

  In the fifth embodiment, the user 100 operates the work 1 “extracts necessary data from the DB 104 and creates the analysis target data by performing the input data creation processing on the extracted data”, the work 2 “data in the analysis target data. Create processing result data by performing processing ”, operation 3“ visualize processing result data by visualization ”, and operation 4“ restart from operation 1 ”in the order of operation 1, operation 3, operation 2, and operation 4. It is the Example supposing the scene which performs analysis work.

FIG. 29 is a flowchart showing an example of the procedure of the fifth embodiment.
First, a template that can be executed by the input data creation unit 110 is extracted from the template DB 180 according to the specified standard by the template recommendation unit 170 and registered in the list Li. Further, all data visualization templates executed immediately after the input data creation template included in Li are extracted from the template log and registered in the list Le (S2901). The standard specified here is a template recently used by the user 100, a template frequently used by all users, a template frequently used by a specific user other than the user 100, a template frequently used by each department, and the past period It means a template that is often used for.

  Next, the extracted list Li is displayed on the display 102. At this time, when a template is selected from Li by the user's operation, the visualization result diagram of the data visualization template corresponding to the selected template is extracted from Le and displayed on the display (S2902). A display example on the display 102 is shown in FIG. When a template name displayed in 3001 is selected, 3001 is a list of Li, and 3002 displays a visualization result of a data visualization template executed immediately after executing this input data creation template in the past.

When the user 100 selects a template, the selected template Ti is executed (S2903, S2904). The template recommendation unit extracts all the data visualization templates executed immediately after the input data creation template Ti selected from the template log, registers it in the list Lv, and displays Lv on the display (S2905, S2906). When the data visualization template Tv is selected, the template recommendation unit 170 extracts all data processing templates between Ti and Tv from the template log, registers them in the list Ld, and displays Ld on the display (S2907, FIG. 28B). S2808, S2809).
Since the subsequent processing procedures have already been described with reference to FIG. 28B, they are omitted.

  According to the fifth embodiment, when starting the analysis work, the analysis result that realizes the user's analysis result image by presenting the data to be analyzed and the figure that can be visualized using the data is presented. Implementation becomes possible. That is, input data creation processing necessary for realizing the visualization result and construction of the data processing can be supported using the template, so that it is possible to reduce the labor of analysis of the user 100. .

  In addition, this invention is not limited to an above-described Example, Various modifications are included. For example, the above-described embodiments have been described in detail for better understanding of the present invention, and are not necessarily limited to those having all the configurations described.

  Further, a part of the configuration of one embodiment can be replaced with the configuration of another embodiment, and the configuration of another embodiment can be added to the configuration of one embodiment. Further, it is possible to add, delete, and replace other configurations for a part of the configuration of each embodiment.

  Further, each of the above-described configurations, functions, processing units, and the like may be realized by hardware, for example, by designing them with an integrated circuit, or a program that realizes part or all of them. It goes without saying that it may be realized by software by creating the above.

100 User 101 Computer 102 Display 103 Input Device 104 Database (DB)
110 Input data creation unit 120 Data processing unit 130 Data visualization unit 140 Log recording unit 141 Log DB
150 Template Execution Unit 160 Template Processing Unit 170 Template Recommendation Unit 180 Template DB
301 Parameter name 302 Value candidate 303 Selected value 310, 3001 Template list 311 and 3002 Visualization result

Claims (13)

A data analysis support method using a computer,
The calculator is
An input data creation function that creates data to be analyzed by applying input data creation processing to data, a data processing function that performs data processing on data and creates processing result data, and a data visualization function that visualizes and visualizes data There line the work of data analysis support by the execution,
Using a template database that stores templates for executing the input data creation function, the data processing function, or the data visualization function,
Execute a template recommendation function that recommends a template for the next work for the user and a template execution function that executes the template,
Input data creation obtained by extracting the input data creation template executed immediately before the selected data visualization template from the data visualization template list obtained by executing the template recommendation function according to the specified standard A data analysis support method , wherein the input data creation template selected from a template list is executed by the template execution function . A data analysis support method using a computer,
The calculator is
An input data creation function that creates data to be analyzed by applying input data creation processing to data, a data processing function that performs data processing on data and creates processing result data, and a data visualization function that visualizes and visualizes data Execute data analysis support work by executing
Using a template database that stores templates for executing the input data creation function, the data processing function, or the data visualization function,
Execute a template recommendation function that recommends a template for the next work for the user and a template execution function that executes the template ,
A data visualization template obtained by extracting a data visualization template executed immediately after the selected input data creation template from the input data creation template list extracted by executing the template recommendation function according to the specified standard The data processing template selected from the data processing template list obtained by extracting the data processing template executed between the selected data visualization template and the selected input data creation template from the list. The data analysis support method is executed by the template execution function . The data analysis support method according to claim 1 or 2,
The computer recommends an applicable template from the templates stored in the template database using the template recommendation function for the template partially changed by a user. Analysis support method. The data analysis support method according to claim 1 or 2,
The calculator is
The template execution function executes the template using the input data creation function, the data processing function, and the data visualization function. The data analysis support method according to claim 1 or 2,
The calculator is
Data analysis support characterized in that the input data creation template selected from the list of input data creation templates obtained by executing the template recommendation function is executed by the template execution function according to a specified standard. Method. The data analysis support method according to claim 1 or 2,
The calculator is
The input data creation template capable of creating the analysis target data necessary for the execution of the selected data processing template from the list of data processing templates obtained by executing the template recommendation function according to the specified standard. A data analysis support method characterized by extraction. The data analysis support method according to claim 1 or 2,
The calculator is
Extracted according the specified criteria, the data visualization template list obtained by performing the template recommended features, that can create the process result data necessary for the execution of said selected data visualization template, the data processing template A data analysis support method characterized by A data analysis support system comprising a computer having a processing unit and a storage unit,
The processor is
An input data creation function that creates data to be analyzed by applying input data creation processing to data, a data processing function that performs data processing on data and creates processing result data, and a data visualization function that visualizes and visualizes data Execute data analysis support work by executing
  The storage unit
Storing a template database for storing templates for executing the input data creation function, the data processing function, or the data visualization function;
  The processor is
  Execute a template recommendation function that recommends a template for the next work for the user and a template execution function that executes the template,
  The processor is
Input data creation obtained by extracting the input data creation template executed immediately before the selected data visualization template from the data visualization template list obtained by executing the template recommendation function according to the specified standard The input data creation template selected from the template list is executed by the template execution function.
A data analysis support system characterized by this. A data analysis support system comprising a computer having a processing unit and a storage unit,
The processor is
An input data creation function that creates data to be analyzed by applying input data creation processing to data, a data processing function that performs data processing on data and creates processing result data, and a data visualization function that visualizes and visualizes data Execute data analysis support work by executing
  The storage unit
Storing a template database for storing templates for executing the input data creation function, the data processing function, or the data visualization function;
  The processor is
Execute a template recommendation function that recommends a template for the next work for the user and a template execution function that executes the template,
  The processor is
A data visualization template obtained by extracting a data visualization template executed immediately after the selected input data creation template from the input data creation template list extracted by executing the template recommendation function according to the specified standard The data processing template selected from the data processing template list obtained by extracting the data processing template executed between the selected data visualization template and the selected input data creation template from the list. Execute by the template execution function
A data analysis support system characterized by this. The data analysis support system according to claim 8 or 9,
The processing unit
For the template partially changed by the user, the template recommendation function recommends an applicable template from the templates stored in the template database.
A data analysis support system characterized by this. The data analysis support system according to claim 8 or 9,
The processor is
Executing the selected template using the input data creation function, the data processing function, and the data visualization function
A data analysis support system characterized by this. The data analysis support system according to claim 8 or 9,
A display unit;
The processor is
The template obtained by executing the template recommendation function is displayed on the display unit according to a specified standard.
A data analysis support system characterized by this. A data analysis support system according to claim 12, comprising:
The processor is
An example of a diagram obtained by executing the selected template from the template displayed on the display unit with the data visualization function is simultaneously displayed on the display unit.
A data analysis support system characterized by this.

Images