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

Claim 0:
1. An Extract, Transform, Load (ETL) workflow recommendation device comprising:
a knowledge database for storing an overall knowledge graph including an ETL knowledge graph that at least indicates ETL information about a predetermined business domain in a graph format;
a processor coupled to memory that stores instructions that when executed by the processor configure the processor to:
receive a user input related to the predetermined business domain and convert the user input into a graph query for searching the overall knowledge graph;
search the overall knowledge graph using the graph query and generates ETL workflow candidates with respect to the user input; and
evaluate the ETL workflow candidates based on an overall score as a measure that quantitatively indicates the appropriateness of the ETL workflow with respect to the user input and output an ETL workflow report indicating a recommended ETL workflow having a highest overall score among the ETL workflow candidates as the recommended ETL workflow or a plurality of ETL workflows that satisfy a predetermined overall score criterion as recommended ETL workflows,
wherein the knowledge database stores, in addition to the ETL knowledge graph, 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,
wherein the knowledge database stores, in addition to the ETL knowledge graph, 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,
wherein the knowledge database stores, in addition to the ETL knowledge graph, a file knowledge graph that indicates, in a graph format, file information at least including information about a predetermined transaction in the business domain, and
wherein the processor is further configured to generate the overall knowledge graph by aggregating the ETL knowledge graph, the human resources knowledge graph, the organizational knowledge graph, and the file knowledge graph.