Patent ID: 11921737
Assignee: HITACHI, LTD.
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 5:
6. An ETL workflow recommendation method comprising:
generating an overall knowledge graph by aggregating an ETL knowledge graph that indicates ETL information about a predetermined business domain in a graph format, a human resources knowledge graph that indicates, in a graph format, human resources information at least including identification information, role information, work location information, department information, and field-of-expertise information regarding a predetermined human resource, an organizational knowledge graph that indicates, in a graph format, organizational information at least including definitions of terms used in a predetermined organization in the business domain, and a file knowledge graph that indicates, in a graph format, file information at least including information about a predetermined transaction in the business domain;
receiving a user input related to the predetermined business domain and converting the user input into a graph query for searching the overall knowledge graph;
searching the overall knowledge graph using the graph query and determining whether or not an ETL workflow with respect to the user input exists;
generating, in a case that an existing ETL workflow that achieves a predetermined similarity criterion with respect to the graph query exists in the overall knowledge graph, the existing ETL workflow as an ETL workflow candidate; extracting a data file that achieves a predetermined relevance criterion with respect to the graph query from the overall knowledge graph, and generating, based on the extracted data file, a logical plan that concatenates multiple processes as a new ETL workflow candidate;
determining whether or not the ETL workflow candidates satisfy a predetermined access condition and a policy condition;
deleting an ETL workflow that does not satisfy either the access condition or the policy condition from the ETL workflow candidates; and
evaluating the ETL workflow candidates and outputting an ETL workflow report indicating a recommended ETL workflow.