Data analysis assistance device, data analysis assistance method, and data analysis assistance program

A data analysis assisting system comprising:

• an analysis process receiving unit having a plurality of lines of instructions that configure a processor of the data analysis system to create an analysis process including a series of processing operations for analyzing a plurality of pieces of data in a particular table, wherein the analysis process is associated with a schema for the particular table;
• a schema/analysis process storing unit having a plurality of lines of instructions that configure the processor to store a plurality of schemas including the schema for the particular table, wherein the schema for the particular table includes a column name and a data type associated with the analysis process;
• an analysis process retrieval unit having a plurality of lines of instructions that configure the processor to receive a table, extract a schema for the received table, and output a list including a plurality of analysis processes that are associated with the extracted schema and can be applied to the received table, wherein the extracted schema is extracted based on a piece of information stored in a table/schema storing unit, and wherein the list is output based on a piece of information stored in the schema/analysis process storing unit that describes one or more analysis processes associated with at least one schema included in the plurality of schemas having one or more attributes in common with the extracted schema;
• and
• an analysis process executing unit having a plurality of lines of instructions that configure the processor to receive a selection of an analysis process from the list and execute the selected analysis process on the received table.

A data analysis assisting method comprising:

• creating, by an analysis process receiving unit, an analysis process including a series of processing operations for analyzing a plurality of pieces of data included in a particular table;
• wherein the analysis process is associated with a schema for the particular table;
• storing, in a schema/analysis process storing unit, a plurality of schemas including the schema for the particular table, wherein the schema for the particular table includes a column name and a data type associated with the analysis process;
• receiving, by an analysis process retrieval unit, a table included in a tabular dataset comprising a plurality of tables, wherein each table included in the plurality of tables includes a plurality of columns and fields for storing a plurality of pieces of information;
• extracting, by the analysis process retrieval unit, a schema for the table and outputting a list including a plurality of analysis processes that are associated with the extracted schema and can be applied to the received table, wherein the extracted schema is extracted based on a piece of information stored in a table/schema storing unit, and wherein the list is output based on a piece of information stored in the schema/analysis process storing unit that describes one or more analysis processes associated with at least one schema included in the plurality of schemas having one or more attributes in common with the extracted schema;
• receiving, by an analysis process executing unit, a selection of an analysis process from the list;
• and
• executing, by the analysis process executing unit, the selected analysis process on the received table.

A data analysis assisting device program that causes a processor to be configured to:

• create, by an analysis process receiving unit, an analysis process including a series of processing operations for analyzing a plurality of pieces of data included in a particular table;
• wherein the analysis process is associated with a schema for the particular table;
• store, in a schema/analysis process storing unit, a plurality of schemas including the schema for the particular table, wherein the schema for the particular table includes a column name and a data type associated with the analysis process;
• receive, by an analysis process retrieval unit, a table included in a tabular dataset comprising a plurality of tables, wherein each table included in the plurality of tables includes a plurality of columns and fields for storing a plurality of pieces of information;
• extract, by the analysis process retrieval unit, a schema for the table and output a list of analysis processes associated with the extracted schema, wherein the extracted schema is extracted based on a piece of information stored in a table/schema storing unit, and wherein the list is output based on a piece of information stored in the schema/analysis process storing unit that describes one or more analysis processes associated with at least one schema included in the plurality of schemas having one or more attributes in common with the extracted schema;
• receive, by an analysis process executing unit, a selection of an analysis process from the list;
• and
• execute, by the analysis process executing unit, the selected analysis process on the received table.