Converting Relational Databases to Manufacturing Knowledge Graph for Product Quality Tracing in Additive Manufacturing

Product quality tracing (PQT) in additive manufacturing (AM) is a significant and complex challenge crucial for fully understanding the processes, tracing quality issues, and optimizing process technologies. Typically, tracing relies on production data from historical relational databases, but these data lack semantic information and integration with the service context of manufacturing processes. A manufacturing knowledge graph (MKG) offers a solution by adding manufacturing semantic information to production data. This paper constructed a PQT model and an MKG database for AM. The PQT model and the schema layer of the MKG originate from the swimlane flowchart. Subsequently, a relational database was mapped to instantiate the MKG, and the natural language model was used to complete it. This integration constructs a PQT model and an MKG database centered on manufacturing resources, events, data, and states. The tracing subgraphs extracted from the MKG database demonstrate that this method effectively traces manufacturing process issues and anomalies. The proposed method provides a viable database and method for PQT in AM, enabling comprehensive tracing of manufacturing processes, identifying quality anomalies, and providing potential cause references for AM experts.

Authors

Institutions

Publication Details

Journal
Procedia CIRP
Published
2025-01-01
DOI
https://doi.org/10.1016/j.procir.2025.02.172
Primary Topic
Food Supply Chain Traceability
Type
article
Field-Weighted Citation Impact
0.00

Funders

Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
article

Converting Relational Databases to Manufacturing Knowledge Graph for Product Quality Tracing in Additive Manufacturing

Laiyi Li, Pingyu Jiang, Maolin Yang
Procedia CIRP
Food Supply Chain Traceability
article

Converting Relational Databases to Manufacturing Knowledge Graph for Product Quality Tracing in Additive Manufacturing

Laiyi Li, Pingyu Jiang, Maolin Yang
article en

Abstract

Product quality tracing (PQT) in additive manufacturing (AM) is a significant and complex challenge crucial for fully understanding the processes, tracing quality issues, and optimizing process technologies. Typically, tracing relies on production data from historical relational databases, but these data lack semantic information and integration with the service context of manufacturing processes. A manufacturing knowledge graph (MKG) offers a solution by adding manufacturing semantic information to production data. This paper constructed a PQT model and an MKG database for AM. The PQT model and the schema layer of the MKG originate from the swimlane flowchart. Subsequently, a relational database was mapped to instantiate the MKG, and the natural language model was used to complete it. This integration constructs a PQT model and an MKG database centered on manufacturing resources, events, data, and states. The tracing subgraphs extracted from the MKG database demonstrate that this method effectively traces manufacturing process issues and anomalies. The proposed method provides a viable database and method for PQT in AM, enabling comprehensive tracing of manufacturing processes, identifying quality anomalies, and providing potential cause references for AM experts.

Procedia CIRPVol. 134
Xi'an Jiaotong University (CN)
National Natural Science Foundation of China
Openalex Percentile: Top 84%
Food Supply Chain Traceability
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.