Knowledge Graph Construction for Entity Relationship Mapping

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Developers face inefficiencies in determining associative relationships between entities in industrial systems due to non-standardized table and column names in user data, relying on personal experience and technical files which are often limited and mismatched.

Innovation Solution

A method and apparatus for constructing a knowledge graph using training data to train a classification model, which identifies entity attributes and mapping relationships between columns, enabling the generation of a knowledge graph that visually represents associative relationships between entities.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If developers rely on personal experience and technical files to determine associative relationships between entities, then they can identify entity relationships, but the efficiency is low due to limited experience and missing or mismatched technical files

Engineering Contradiction:
Improveefficiency of determining associative relationshipsVSAvoidaccuracy of entity relationship identification
Core Design Contradiction:
ProductivityVSReliability

Solution Approach 1:

The patent introduces a knowledge graph as an intermediary structure that stores pre-established relationships between entities. Instead of relying on developers to manually determine relationships from technical files, the system queries the knowledge graph to automatically retrieve entity associations, thereby improving both efficiency and reliability.

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The system performs preliminary actions by pre-building the knowledge graph with entity relationships before the actual data structure identification process. This allows the system to leverage pre-computed entity associations rather than requiring developers to determine relationships on-demand, significantly improving productivity.

Inventive Principle:
Principle #10Preliminary action

2Loss of information

If developers manually determine entities and associative relationships from non-standardized table and column names, then they can understand the data structure, but the process is time-consuming and requires guessing based on limited information

Engineering Contradiction:
Improvecompleteness of entity and relationship informationVSAvoidtime required for data structure identification
Core Design Contradiction:
Loss of informationVSLoss of time

Solution Approach 1:

The patent uses the knowledge graph as a copy or representation of the underlying data relationships. Instead of directly analyzing non-standardized table and column names, the system creates a standardized knowledge graph copy that preserves entity relationships in a structured format, making it easier to extract complete information without time-consuming manual analysis.

Inventive Principle:
Principle #26Copying

Solution Approach 2:

The knowledge graph serves as an intermediary layer between the raw non-standardized data and the developers. It translates ambiguous table and column names into structured entity relationships, preserving information completeness while reducing the time required for interpretation.

Inventive Principle:
Principle #24Intermediary (Mediator)

3Manufacturing precision

If the system uses standardized entity attributes to represent data columns, then the knowledge graph can accurately represent data structures, but the process of mapping non-standardized column names to entity attributes is complex

Engineering Contradiction:
Improveaccuracy of data structure representationVSAvoidcomplexity of mapping process
Core Design Contradiction:
Manufacturing precisionVSDevice complexity

Solution Approach 1:

The system employs self-service mechanisms where the knowledge graph automatically performs the mapping between non-standardized column names and standardized entity attributes. The graph structure itself contains the mapping relationships, allowing the system to self-resolve the complexity rather than requiring external manual intervention.

Inventive Principle:
Principle #25Self-service

Data Source

PatentUS12066989B2Method and apparatus for constructing knowledge graph
Publication Date: 2024.08.20 SIEMENS (CHINA) CO LTD
  • US12066989B2 patent drawing
  • US12066989B2 patent drawing
  • US12066989B2 patent drawing

AI summary

Various embodiments of the teachings herein include a method for constructing a knowledge graph. The method may include: acquiring training data; using the training data to train a classification model; for each column of data providing each attribute value into the classification model, to obtain an entity attribute, and determining an entity attribute; subjecting to determine a mapping relationship between the columns of data; determining a mapping relationship between the entity attributes; determining a mapping relationship between entities corresponding to the entity attributes; and generating a knowledge graph comprising the entities and the mapping relationship between the entities.