{"title":"面向增材制造产品质量跟踪的关系数据库到制造知识图谱的转换","authors":"Laiyi Li , Maolin Yang , Pingyu Jiang","doi":"10.1016/j.procir.2025.02.172","DOIUrl":null,"url":null,"abstract":"<div><div>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.</div></div>","PeriodicalId":20535,"journal":{"name":"Procedia CIRP","volume":"134 ","pages":"Pages 544-549"},"PeriodicalIF":0.0000,"publicationDate":"2025-01-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"Converting Relational Databases to Manufacturing Knowledge Graph for Product Quality Tracing in Additive Manufacturing\",\"authors\":\"Laiyi Li , Maolin Yang , Pingyu Jiang\",\"doi\":\"10.1016/j.procir.2025.02.172\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"<div><div>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.</div></div>\",\"PeriodicalId\":20535,\"journal\":{\"name\":\"Procedia CIRP\",\"volume\":\"134 \",\"pages\":\"Pages 544-549\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2025-01-01\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Procedia CIRP\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://www.sciencedirect.com/science/article/pii/S2212827125005414\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Procedia CIRP","FirstCategoryId":"1085","ListUrlMain":"https://www.sciencedirect.com/science/article/pii/S2212827125005414","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
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.