金属切削加工知识图谱构建及应用

doi:10.13229/j.cnki.jdxbgxb20190948

摘要/Abstract

摘要：

针对制造型企业普遍存在无法深度利用散布在各应用系统中的金属切削加工数据资源问题，提出了通过建立金属切削加工知识图谱的途径，实现切削加工数据全面融合，提升数据的价值密度。首先，将金属切削加工知识归纳为事实性知识和过程性知识两类，采用自顶向下的方法，用OWL语言建立了完整的金属切削加工本体模型。然后，构建了多源数据集成框架，确定了适于切削加工数据等价实体判别的数据融合算法。最后，开发了知识图谱的可视化系统，在国内某航空发动机维修公司获得初步应用。本文研究结果可为构建基于数据驱动的智能化金属切削加工提供参考。

关键词: 金属切削加工, 知识图谱, 智能制造, 数据融合

Abstract:

To solve the problem that manufacturing enterprises generally can't make full use of the data resources of metal cutting scattered in various application systems， an approach of building metal cutting knowledge graph is proposed to realize cutting data integration and enhance data value density. Firstly， metal cutting knowledge is classified into factual type and procedural type. A complete ontology model is established by using OWL language and top-down method. Then， a multi-source data integration framework is constructed， and a data fusion algorithm suitable for identifying the equivalent entity of cutting data is determined as well. Finally， a visualization system of knowledge graph is developed， which has been applied to an aero-engine maintenance company in China. The research results of this paper provide strong support for the construction of data-driven based and intelligent metal cutting.

Key words: metal cutting, knowledge graph, intelligent manufacturing, data fusion

中图分类号:

TH166

段阳,侯力,冷松. 金属切削加工知识图谱构建及应用[J]. 吉林大学学报(工学版), 2021, 51(1): 122-133.

Yang DUAN,Li HOU,Song LENG. Building and application of metal cutting knowledge graph[J]. Journal of Jilin University(Engineering and Technology Edition), 2021, 51(1): 122-133.

图/表 17

表1

图1

图2

表2

图3

图4

图5

图6

图7

表3

部分oracle视图数据"

id	Equipmenttype	Compid	work_type_name
1	MAZAK510	KZ?D5.6MY	异形
2	HEM1000	MZL?D3.25L10R0Z3	实心材料钻孔
$?$	$?$	$?$	$?$

表3

表4

表5

表6

图8

图9

表7

图10

参考文献 22

1	刘战强, 黄传真, 万熠, 等. 切削数据库的研究现状与发展[J]. 计算机集成制造系统, 2003, 9(11): 937-943.
	Liu Zhan-qiang, Huang Chuan-zhen, Wan Yi, et al. Research state and development directions of cutting database[J]. Computer Integrated Manufacturing Systems, 2003, 9(11): 937-943.
2	Walter GPS.[EB/OL]. [2019-10-08]..
3	ToolLibrary CoroPlus.[EB/OL]. [2019-10-08]..
4	谭方浩. 基于特征的智能型车削数据库系统研究与开发[D]. 北京: 北京理工大学机械与车辆学院, 2015.
	Tan Fang-hao. Research and development of intelligent turning database system based on machining features[D]. Beijing: School of Machinery and Vehicle, Beijing University of Technology, 2015.
5	任莹晖, 纪会敏, 杜勇, 等. 切削刀具综合管理系统的数据采集和存储设计研究[J].计算机应用研究, 2016, 33(10): 3031-3035.
	Ren Ying-hui,Ji Hui-min,Du Yong,et al. Study on design of data acquisition and storage for comprehensive tool management system[J]. Application Research of Computers, 2016, 33(10): 3031-3035.
6	海源, 张松, 李剑峰, 等. 基于射频识别技术的车间级刀具管理系统[J]. 计算机集成制造系统, 2016, 22(8): 1907-1918.
	Hai Yuan, Zhang Song, Li Jian-feng, et al. Workshop-level tool management system based on radio frequency identification technology[J]. Computer Integrated Manufacturing Systems, 2016, 22(8): 1907-1918.
7	廖生辉, 王建军, 卓勇, 等. 在线智能刀具管理系统的开发与研究[J]. 锻压技术, 2018, 43(9): 189-195.
	Liao Sheng-hui,Wang Jian-jun,Zhuo Yong, et al. Development and research on online intelligent tool management system[J]. Forging & Stamping Technology, 2018, 43(9): 189-195.
8	白雪, 鄢萍. 齿轮加工数字化车间刀夹具管理系统的设计[J]. 计算机集成制造系统, 2020, 26(5): 1233-1245.
	Bai Xue, Yan Ping. Design of cutting tools and fixtures management system for digital workshop of gear machining[J]. Computer Integrated Manufacturing Systems, 2020, 26(5): 1233-1245.
9	Peng C, Du H, Warren Liao T. A research on the cutting database system based on machining features and TOPSIS[J]. Robotics and Computer-Integrated Manufacturing, 2017, 43: 96-104.
10	张丹丹. 基于特征的航空结构件工艺知识库建立和数据挖掘研究[D]. 山东:山东大学机械工程学院, 2018.
	Zhang Dan-dan. Feature-based knowledge base building and data mining for aeronautical structural parts[D]. Shandong: School of Mechanical Engineering, Shandong University, 2018.
11	Zhang Y Z, Luo X F, Zhang H. A knowledge representation for unit manufacturing processes[J]. International Journal of Advanced Manufacturing Technology, 2014, 73: 1011-1031.
12	王晶, 张定华, 吴宝海, 等. 基于临界约束的四轴数控加工刀轴优化方法[J]. 机械工程学报, 2012, 48(17): 114-120.
	Wang Jing, Zhang Ding-hua, Wu Bao-hai, et al. Tool orientation optimization method in four-axis CNC machining based on critical constraints[J]. Journal of Mechanical Engineering, 2012, 48(17): 114-120.
13	吴宝海, 梁满仓, 张莹, 等. 复杂曲面通道多轴加工的刀具选择方法[J]. 机械工程学报, 2018, 54(3): 117-124.
	Wu Bao-hai, Liang Man-cang, Zhang Ying, et al. Tool selection of multi-axis machining for channel parts with sculptured surface[J]. Journal of Mechanical Engineering, 2018, 54(3): 117-124.
14	陈行政, 李聪波, 吴磊, 等. 面向能耗的多刀具孔加工刀具直径及工艺参数集成优化模型[J]. 机械工程学报, 2018, 54(15): 221-231.
	Chen Xing-zheng, Li Cong-bo, Wu Lei, et al. Integrating optimization of cutter diameter and cutting parameters for energy-aware multi-tool hole machining[J]. Journal of Mechanical Engineering, 2018, 54(15): 221-231.
15	An Q, Chen J, Tao Z, et al. Experimental investigation on tool wear characteristics of PVD and CVD coatings during face milling of Ti-6242S and Ti-555 titanium alloys[J]. International Journal of Refractory Metals and Hard Materials, 2020, 86: 105091.
16	Sun J, Huang S, Ding H, et al. Cutting performance and wear mechanism of Sialon ceramic tools in highspeed face milling GH4099[J]. Ceramics International, 2020, 46(2): 1621-1630.
17	黄恒琪, 于娟, 廖晓, 等. 知识图谱研究综述[J]. 计算机系统应用, 2019, 28(6): 1-12.
	Huang Heng-qi, Yu Juan, Liao Xiao, et al. Review on knowledge graphs[J]. Computer Systems & Applications, 2019, 28(6): 1-12.
18	YAGO. [EB/OL]. [2019-10-08]. .
19	GeoNames.[EB/OL]. [2019-10-08]. .
20	中国中医科学院中医药信息研究所. 中医药知识图谱[EB/OL]. [2019-10-08]. .
21	Calvanese D, Cogrel B, Komla-Ebri S, et al. Ontop: answering SPARQL queries over relational databases[J]. Semantic Web, 2016, 8(3): 471-487.
22	Barrasa Jesús.[EB/OL]. [2019-10-08]. .

Metrics

Viewed

Full text

Abstract

Cited

Shared

Discussed

主要词汇	举例
rdfs:subClassOf	切断刀片?刀片
rdfs:sameClassAs	数控设备≡数控车∪数控铣∪数控磨
rdfs:subPropertyOf	用外圆刀片?用刀具
rdfs:domain	?有加工.T?工件
rdfs:range	T??有加工.加工
owl:disjointWith	工件??刀具
owl:inverseOf	生产刀具≡供应商是^—
owl:symmetricProperty	相似度
owl:hasValue	切断刀片≡刀具类型编码 value "002"

Subject	Predicate	Object
前角	发生变化	_change1
_change1	变化结果是	增大
_change1	导致变化	剪切角
_change1	导致结果是	增大

映射	公理	示例
Ⅰ	mappingId	M：工序
	source	:工序?{id} a :工序 .
	target	select id from v_tool_dc
Ⅱ	mappingId	OP：加工结构
	source	:工序?{id} :加工结构 :{work_type_name}.
	target	select id,work_type_name from v_tool_dc where work_type_name is not null
Ⅲ	mappingId	OP：在机床
	source	:工序?{id} :在机床 :{equipmenttype} .
	target	select id,equipmenttype from v_tool_dc
Ⅳ	mappingId	OP：用刀具
	source	:工序?{id} :用刀具 :刀具?{compid} .
	target	select id,compid from v_tool_dc

Subject	Predicate	Object
<http://scu.edu.cn/tooling#工序-1>	rdf:type	<http://scu.edu.cn/tooling#工序>
<http://scu.edu.cn/tooling#工序-1>	<http://scu.edu.cn/tooling#加工结构>	<http://scu.edu.cn/tooling#异形>
<http://scu.edu.cn/tooling#工序-1>	<http://scu.edu.cn/tooling#在机床>	<http://scu.edu.cn/tooling# MAZAK510>
<http://scu.edu.cn/tooling#工序-1>	<http://scu.edu.cn/tooling#用刀具>	<http://scu.edu.cn/tooling# KZ-D5.6MY >

Oracle	SQL Server	Jaccard 相似度	Levenshtein 相似度
数车	数控车	0.66	0.8
车工	普车	0.33	0.5
数控外磨圆	数控外圆磨	1	0.8
车铣	车铣中心	0.5	0.66
三通管	衬套管	0.2	0.33
吊挂支架	悬臂支架	0.333	0.5