Process database and establishment method therefor, machining method, related apparatus, and medium

Abstract

The present application is applicable to the field of intelligent manufacturing, and provides a process database and an establishment method therefor, a machining method, a related apparatus, and a medium. The establishment method for the process database comprises: determining historical machining data from a first database on the basis of a first machining target of a first workpiece, wherein the historical machining data is data obtained when machining parts of the similar type of the first workpiece; machining the first workpiece on the basis of the historical machining data; obtaining first real-time machining data for machining the first workpiece, wherein the first real-time machining data comprises second working condition data and second quality data; comparing the historical machining data with the first real-time machining data; and correcting or updating the first database on the basis of a comparison result. The solution can improve the referenceability of various data in the first database.

Description

Process database and its establishment method, processing method, related devices and media

[0001] The present invention claims priority to the Chinese patent application filed with the Patent Office of China on December 27, 2023, with application number 202311818739.9, entitled “Process database and its establishment method, processing method, related devices and medium”, the entire contents of which are incorporated herein by reference. Technical Field

[0002] The present application relates to the field of intelligent manufacturing, and in particular to a process database and its establishment method, processing method, related devices and media. Background Art

[0003] In recent years, with the development of automation technology, the application scenarios of CNC machine tools have become increasingly extensive. A CNC machine tool (NCM) is a machine tool that uses mathematical models and computer control systems to achieve automated processing. When using a CNC machine tool to process a workpiece, users need to set up a machining program. When setting up a machining program, it is important to consider the impact of machining conditions on the workpiece. Machining conditions can represent factors such as the machining environment and the state of the machining equipment. Machining conditions directly affect the quality and efficiency of the workpiece.

[0004] With the development of database technology, users can now use their past experience to process workpieces and upload these processing conditions to a database for reference by other users. However, when these processing conditions, set based on experience, are used to process other workpieces, they can lead to poor quality due to incomplete data collection. Furthermore, the accuracy of these processing conditions in the database is low, which affects the database's usefulness. Summary of the Invention

[0005] This application at least provides a process database and its establishment method, processing method, related devices and media.

[0006] The present application provides a method for establishing a process database, comprising the following steps: determining historical processing data from a first database based on a first processing target of a first workpiece, the historical processing data being data acquired when processing similar parts of the first workpiece, the historical processing data including first working condition data and first quality data associated with the first working condition data, the first working condition data including cross-correlated first workpiece data, first environmental data, first processing equipment data, and first processing load data; processing the first workpiece according to the historical processing data; acquiring first real-time processing data for processing the first workpiece, the first real-time processing data including second working condition data and second quality data; comparing the historical processing data with the first real-time processing data; and correcting or updating the first database based on the comparison result.

[0007] The present application provides a process database, which is established using the above-mentioned process database establishment method.

[0008] The present application provides a processing method, in which the process database used in the processing method is the process database as described above, and the processing method includes: determining historical processing data from the process database based on a first processing target of a workpiece to be processed, wherein the workpiece to be processed is a similar part to the first workpiece, and the historical processing data is data obtained when processing the similar part to the first workpiece, and the historical processing data includes first working condition data and first quality data associated with the first working condition data, and the first working condition data includes cross-correlated first workpiece data, first environment data, first processing equipment data, and first processing load data; and processing the workpiece to be processed according to the historical processing data.

[0009] The present application provides a device for establishing a process database, including: a determination module, a processing module, an acquisition module, a comparison module and a database processing module; the determination module is used to determine historical processing data from a first database based on a first processing target of a first workpiece, the historical processing data is data acquired when processing similar parts of the first workpiece, the historical processing data includes first working condition data and first quality data associated with the first working condition data, the first working condition data includes cross-correlated first workpiece data, first environmental data, first processing equipment data and first processing load data; the processing module is used to process the first workpiece according to the historical processing data; the acquisition module is used to acquire first real-time processing data for processing the first workpiece, the first real-time processing data includes second working condition data and second quality data; the comparison module is used to compare the historical processing data with the first real-time processing data; the database processing module is used to correct or update the first database based on the comparison result.

[0010] The present application provides a terminal device, including a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, the above-mentioned process database establishment method or the above-mentioned processing method is implemented.

[0011] The present application provides a computer-readable storage medium, which stores a computer program. When the computer program is executed by a processor, the above-mentioned process database establishment method or the above-mentioned processing method is implemented.

[0012] The above scheme determines the historical processing data obtained when processing similar parts of the first workpiece from the first database based on the first processing target of the first workpiece, processes the first workpiece according to the historical processing data, and obtains the first real-time processing data of the first workpiece, compares the historical processing data with the first real-time processing data, and corrects or updates the first database based on the comparison results. Compared with directly adding the processing conditions set according to experience into the database, the present application can improve the referenceability and accuracy of each data in the first database by correcting or updating the first database based on the comparison results.

[0013] It is to be understood that the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the present application. BRIEF DESCRIPTION OF THE DRAWINGS

[0014] The drawings herein are incorporated into and constitute a part of the specification. These drawings illustrate embodiments consistent with the present application and, together with the specification, are used to illustrate the technical solutions of the present application.

[0015] FIG1 is a flow chart of an embodiment of a method for establishing a process database provided by the present application;

[0016] FIG2 is a schematic diagram showing the effect of a first workpiece in an embodiment of the method for establishing a process database provided by the present application;

[0017] FIG3 is a schematic structural diagram of an embodiment of a process database 30 provided by the present application;

[0018] FIG4 is a schematic flow chart of an embodiment of a processing method provided by the present application;

[0019] FIG5 is a schematic structural diagram of an embodiment of a device for establishing a process database of the present application;

[0020] FIG6 is a schematic structural diagram of an embodiment of a terminal device of the present application;

[0021] FIG7 is a schematic structural diagram of an embodiment of a computer-readable storage medium of the present application. DETAILED DESCRIPTION

[0022] In the following description, for the purpose of explanation rather than limitation, specific details such as specific system structures, interfaces, and technologies are provided to facilitate a thorough understanding of the present application.

[0023] The term "and / or" in this article is simply a description of the association relationship of associated objects, indicating that three relationships can exist. For example, A and / or B can represent three situations: A exists alone, A and B exist at the same time, and B exists alone. In addition, the character " / " in this article generally indicates that the associated objects are in an "or" relationship. In addition, "many" in this article means two or more than two. In addition, the term "at least one" in this article means any combination of at least two of any one or more of a plurality of. For example, including at least one of A, B, and C can mean including any one or more elements selected from the set consisting of A, B, and C.

[0024] The method for establishing a process database of the present application can be applied to the following industrial Internet scenarios. In a possible system architecture of an industrial Internet scenario, a server, an edge device and a CNC machine tool are included, wherein the server and the CNC machine tool can communicate directly, and the server can also communicate indirectly with the CNC machine tool through an edge computer. In addition, the server can be an industrial cloud platform, a physical server or a device of a physical server, wherein the industrial cloud platform can be a public cloud platform or an enterprise's private cloud platform. The physical server can be built using a single physical server or using multiple servers to form a server group. The edge device is used to collect information and act as an intermediate medium to transmit communication between the server and the CNC machine tool, wherein a single edge device can correspond to multiple CNC machine tools, and multiple edge devices correspond one to one to a CNC machine tool associated with themselves.

[0025] The present application provides some methods and devices for establishing a process database. The execution subject of the method for establishing a process database can be a device for establishing a process database. For example, the device for establishing a process database can be a terminal device or a server or other processing device, wherein the terminal device can be a device for establishing a process database, a user equipment (UE), a mobile device, a user terminal, a terminal, a cellular phone, a cordless phone, a personal digital assistant (PDA), a handheld device, a computing device, a vehicle-mounted device, etc. In some possible implementations, the method for establishing a process database can be implemented by a processor calling computer-readable instructions stored in a memory.

[0026] Please refer to Figure 1, which is a flow chart of an embodiment of a method for establishing a process database provided by this application. Specifically, the method for establishing a process database of this embodiment may include the following steps:

[0027] Step S11 : determining historical processing data from a first database based on a first processing target of a first workpiece.

[0028] The historical processing data is the data obtained when processing similar parts of the first workpiece (hereinafter referred to as "similar parts"). The historical processing data includes first working condition data and first quality data associated with the first working condition data. The first working condition data includes cross-related first workpiece data, first environment data, first processing equipment data and first processing load data.

[0029] The first workpiece may be a workpiece to be machined that needs to be machined in a numerically controlled machine tool.

[0030] The first processing target may refer to a processing requirement that enables the workpiece to be processed to be processed into a final product. For example, the processing requirement may be a size requirement, quality requirement or processing speed requirement for the workpiece after processing. The CNC machine tool may process the workpiece to be processed using the processing parameters corresponding to the processing requirements so that the workpiece to be processed is processed into a final product. The first database may be a process database storing the processing parameters of the first workpiece. The processing parameters of the first workpiece may be the data originally stored in the first database before the first workpiece is processed. For example, the device for establishing the process database stores the data obtained when processing the same type of parts into the first database, that is, the original stored data in the first data before the first workpiece is processed. Similar parts may refer to parts that are basically the same as the workpiece in terms of function, shape, material, standard, etc. and can be replaced with each other.

[0031] The historical processing data in the first database may be data acquired during the processing of a similar part before the first workpiece is processed. It is understood that the historical processing data for the first workpiece may be processing parameters corresponding to a first processing target for the first workpiece. Before processing the first workpiece, the process database establishment device may use the first processing target for the first workpiece to determine the historical processing data corresponding to the first workpiece in the first database, wherein the historical processing data corresponding to the first workpiece may be data acquired during the processing of a similar part.

[0032] The historical processing data in the first database may include: first operating condition data corresponding to similar parts and first quality data associated with the first operating condition data. The first quality data may be the quality results corresponding to similar parts. Specifically, the first quality data may refer to the measured data output by the quality inspection department for similar parts, and the assessment or determination of the part's quality based on inspection and testing of the output measured data. For example, the measured data output for similar parts may be the measured dimensions of the part.

[0033] The first working condition data may refer to the processing parameters obtained by the process database establishment device when the CNC machine tool processes the same type of parts under conditions determined by factors such as the processing environment, the state of the processing equipment and the processing load. In some application scenarios, the first working condition data may refer to the cutting parameters obtained by the process database establishment device when processing the first type of parts. In other application scenarios, the first working condition data may also refer to the actual parameters corresponding to the design parameters in the final product obtained by processing the same type of parts using the design parameters when processing the same type of parts. For example, the design parameters may refer to the geometric characteristic parameters or material characteristic parameters of the same type of parts in the final product.

[0034] The first working condition data may include multiple data types, and may include cross-correlated first workpiece data, first environment data, first processing equipment data, and first processing load data.

[0035] Specifically, the first workpiece data, the first environment data, the first processing equipment data, and the first processing load data are four data types in the first working condition data.

[0036] Cross-correlation can refer to the process of connecting and associating data in different data types in the first operating condition data through preset relationships or common attributes, or it can refer to the process of connecting and associating data in the same data type in the first operating condition data through preset relationships or common attributes.

[0037] It is understood that within each historical processing data corresponding to the same type of parts of the first workpiece, the first working condition data and the first quality data can be associated, and the association can be performed by treating the first working condition data and the first quality data as a single data group. In some application scenarios, the first workpiece data, the first environment data, the first processing equipment data, and the first processing load data in the first working condition data are cross-associated. In other application scenarios, for each data type in the first working condition data, the data within each data type are cross-associated.

[0038] The first workpiece data may include geometric characteristic parameters and material characteristic parameters corresponding to the same type of parts. Specifically, for each of the same type of parts, the data corresponding to the actual parameters may be different.

[0039] Geometric feature parameters may refer to the numerical values ​​corresponding to the overall shape, size, surface, and topological features of similar parts. Geometric feature parameters may include geometric feature data for each component within the same part. Different components within the same part may correspond to different geometric feature data.

[0040] In some application scenarios, geometric feature data may include characteristic geometric shapes and dimensional tolerances corresponding to different components of the same type of parts.

[0041] Dimensional tolerances may refer to the length, width, angle, and diameter of each component. They may also refer to the ratio or product of these parameters. For example, dimensional tolerances may include aspect ratios, depth-to-width ratios, and depth-to-diameter ratios. Material characteristic parameters may refer to the numerical values ​​corresponding to the material characteristics of the entire similar component of the first workpiece. Material characteristic parameters may include material characteristic data for each component of the similar component of the first workpiece.

[0042] Different components within the same type of parts may correspond to different material characteristic data. In some application scenarios, the material characteristic data may include data related to the materials used in the processing of similar parts. For example, the material characteristic data may include material cutting data corresponding to the material's machinability. It is understood that when similar parts from the same batch are processed, each part may correspond to different material characteristic data.

[0043] The first environmental data may refer to parameters corresponding to external environmental requirements that need to be met when processing similar parts. The first environmental data may refer to processing temperature data, processing humidity data, and cutting fluid data for processing similar parts of the first workpiece.

[0044] The first processing equipment data may refer to various parameters corresponding to the machine tool equipment requirements that a CNC machine tool or a processing machine tool needs to meet when processing the same type of parts.

[0045] For example, the first processing equipment data may include machine tool characteristic data, fixture characteristic data, and tool characteristic data corresponding to parts of the same type.

[0046] Machine tool characteristic data can refer to the precision level a machine tool can achieve during machining or its stiffness under different load conditions during machining. Machine tool characteristic data can include machine tool accuracy data, such as static stiffness data and dynamic stiffness data. It is understood that dynamic stiffness data can change as the machine tool wears after machining similar parts.

[0047] Fixture characteristic data can refer to the parameters of the fixture required for machining similar parts in a machine tool. A machine tool fixture is a device used to secure similar parts and maintain them in a desired position and orientation. This fixture characteristic data can include fixture accuracy data and fixture static stiffness data.

[0048] Tool characteristic data may refer to parameters corresponding to cutting tools required for machining similar parts in a machine tool. The tool characteristic data may include tool sharpness data reflecting the sharpness of the tool and tool wear data reflecting the degree of tool wear.

[0049] The first processing load data may be various processing parameters and control condition parameters that need to be set for various components of the machine tool when processing the same type of parts.

[0050] Exemplarily, the components of the machine tool may be a spindle drive component and a feed drive component. The spindle drive component may be a motor, an upper bearing seat, a lower bearing seat, etc. The feed drive component may be a guide rail, a ram, a motor, a proximal bearing seat, and a distal bearing seat. The first processing load data may include process parameter data and process response data of the processing system. The process parameter data may refer to processing parameter data related to the components of the machine tool. In some application scenarios, the process parameter data may include actual spindle speed data, actual feed rate data, actual cutting width data, and actual cutting depth data. The process parameter data may also include the ratio or product of each parameter data in the actual spindle speed data, actual feed rate data, actual cutting width data, and actual cutting depth data, such as feed per revolution data and material removal rate data. The process response data may include the actual spindle power signal and actual component vibration signal generated during the processing of similar parts.

[0051] In some application scenarios, the first workpiece data may include geometric feature data and material feature data.

[0052] Specifically, the geometric feature data in the first workpiece data may include: characteristic geometric shapes and dimensional tolerances corresponding to different components of the same type of parts in the first workpiece. The material feature data in the first workpiece data may include material cutting data corresponding to the same type of parts. The first environmental data may include processing temperature data, processing humidity data, and cutting fluid data for processing the same type of parts. The first processing equipment data may include machine tool characteristic data, fixture characteristic data, and tool characteristic data corresponding to the same type of parts.

[0053] Specifically, the machine tool characteristic data in the first processing equipment data may include: machine tool accuracy data, machine tool static stiffness data, and machine tool dynamic stiffness data corresponding to similar parts. The fixture characteristic data may include fixture accuracy data and fixture stiffness data corresponding to similar parts. The tool characteristic data may include tool sharpness data and tool wear data corresponding to similar parts. The first processing load data may include process parameter data corresponding to similar parts and process response data of the processing system.

[0054] Step S12: Processing the first workpiece according to the historical processing data.

[0055] The device for establishing a process database can process the first workpiece according to historical processing data.

[0056] In some application scenarios, after the process database establishment device determines the historical processing data, when processing the first workpiece, the process database establishment device may select at least part of the historical processing data to process the first workpiece.

[0057] It is understandable that, although the first workpiece and the similar part are parts of the same type, the workpiece data required by the first workpiece may be different from that of the first workpiece corresponding to the similar part.

[0058] For example, there may be differences in the geometric requirements corresponding to the size or shape of the geometric feature data required for the first workpiece. The cross-correlated processing load data corresponding to different geometric requirements may be different. Parts of different sizes or shapes may require different processing parameters such as cutting depth, cutting speed and feed speed to meet the size and geometric requirements. In other application scenarios, after the process database establishment device determines the historical processing data, when processing the first workpiece, if the workpiece data required for the first workpiece is the same as that required for similar parts, the process database establishment device can select all the historical processing data to process the first workpiece.

[0059] Step S13: Acquire first real-time processing data of processing the first workpiece, where the first real-time processing data includes second working condition data and second quality data.

[0060] The process database establishment device can obtain first real-time processing data for processing a first workpiece. The first real-time processing data can be real-time processing parameters included in a final product corresponding to the first workpiece after the first workpiece is processed using historical processing data corresponding to a similar part.

[0061] The first real-time processing data may include second working condition data and second quality data. The second quality data may refer to the quality results of the final product corresponding to the same type of parts of the first workpiece.

[0062] Specifically, the second quality data may refer to measured data output by the quality inspection department on the final product of the first workpiece, and an evaluation or determination result of the quality of the first workpiece made after inspection and testing of the output measured data.

[0063] The second working condition data may refer to real-time processing parameters acquired by the process database establishment device when the CNC machine tool processes the first workpiece under working conditions determined by factors such as the processing environment, processing equipment status and processing load.

[0064] The second working condition data may include multiple data types. For example, the second working condition data may include cross-correlated second workpiece data, second environment data, second processing equipment data, and second processing load data.

[0065] Step S14: Compare the historical processing data with the first real-time processing data.

[0066] The process database establishing device can compare the historical processing data with the first real-time processing data.

[0067] Specifically, the device for establishing the process database can compare the historical processing data corresponding to the same type of parts with the first real-time processing data corresponding to the first workpiece to obtain a comparison result.

[0068] The comparison result may be whether there is a difference between the historical processed data and the first real-time processed data, or a difference value between the historical processed data and the first real-time processed data.

[0069] In some application scenarios, the difference value may be 0, which may indicate that the comparison result indicates that there is no difference between the historical processed data and the first real-time processed data.

[0070] In other application scenarios, the process database establishment device may set a preset deviation threshold. For example, the preset deviation threshold may be 0.1. If the comparison result may be a difference value of 0.01, the difference value of 0.01 may indicate that the comparison result indicates that there is no difference between the historical processing data and the first real-time processing data.

[0071] Step S15: Modify or update the first database based on the comparison result.

[0072] The process database establishing device can correct or update the first database based on the comparison result.

[0073] Specifically, in response to a comparison result indicating a difference between the historical processing data and the first real-time processing data, the device for establishing the process database can use the first real-time processing data of the first workpiece to correct or update the historical processing data corresponding to the same part in the first database.

[0074] In some application scenarios, correcting the first database based on the comparison result may be modifying the historical processed data in the first database into the first real-time processed data.

[0075] In other application scenarios, updating the first database based on the comparison result may include adding the first real-time processing data to the historical processing data. It is understood that adding the first real-time processing data to the historical processing data generates updated historical processing data, which can be used as processing parameters for the next first workpiece processing.

[0076] In some application scenarios, after obtaining the comparison results, the process database establishment device periodically uploads the first real-time processing data to the first database in the cloud via a network transmission protocol in response to the comparison results satisfying a preset upload condition, thereby completing the correction or update of the first database. The preset upload condition may be that the comparison results satisfy a difference between the historical processing data and the first real-time processing data.

[0077] The above scheme determines the historical processing data obtained when processing similar parts from the first database based on the first processing target of the first workpiece, processes the first workpiece according to the historical processing data, and obtains the first real-time processing data for processing the first workpiece, compares the historical processing data with the first real-time processing data, and corrects or updates the first database based on the comparison results. Compared with directly adding the processing conditions set according to experience into the database, this application can improve the referenceability and accuracy of each data in the first database by correcting or updating the first database based on the comparison results.

[0078] In some embodiments, the above step S15 may include the following steps:

[0079] First, confirm that there is a difference between the second working condition data and the first working condition data, the second working condition data including the cross-correlated second workpiece data, second environment data, second processing equipment data and second processing load data. Secondly, if the second quality data meets the preset conditions.

[0080] Finally, the second quality data and the second operating condition data are associated and added to the first database.

[0081] The second working condition data includes cross-correlated second workpiece data, second environment data, second processing equipment data, and second processing load data.

[0082] It can be understood that the second workpiece data, second environment data, second processing equipment data and second processing load data cross-related in the second working condition data of the first workpiece are of the same data type as the first workpiece data, first environment data, first processing equipment data and first processing load data cross-related in the first working condition data corresponding to the same type of parts.

[0083] In some application scenarios, the data values ​​of the second workpiece data, second environment data, second processing equipment data and second processing load data cross-related in the second working condition data and the first workpiece data, first environment data, first processing equipment data and first processing load data cross-related in the first working condition data corresponding to the same type of parts may be different.

[0084] For the data types of the second working condition data and the second quality data in the first workpiece, please refer to the first working condition data and the first quality data corresponding to the same type of parts of the first workpiece, which will not be repeated here.

[0085] The device for establishing the process database includes a difference determination module.

[0086] The difference determination module is used to determine whether there is a difference between the input data. The process database establishment device inputs the first real-time data of the first workpiece and the historical processing data of the same type of parts into the difference determination module. The difference determination module can determine whether there is a difference between the second working condition data in the first real-time data and the first working condition data in the historical processing data. In response to the difference between the second working condition data and the first working condition data meeting the difference determination condition, the difference determination module outputs an output result that there is a difference between the second working condition data and the first working condition data. Among them, the difference determination condition can be whether the difference value between the data corresponding to the second working condition data and the data corresponding to the first working condition data exceeds a preset deviation threshold, and the preset deviation threshold can refer to the range of difference values ​​that the difference determination module can allow.

[0087] In some application scenarios, the difference determination module can confirm that there is a difference between part of the data in the second operating condition data and part of the data in the first operating condition data of the same data type. It is understandable that the device for establishing the process database can, according to demand, when the difference determination module performs a difference comparison between the second operating condition data and the first operating condition data, the difference determination module only needs to compare some data types with high attention in the demand. That is, the difference determination module can perform a partial difference comparison to confirm that there is a difference between the second operating condition data and the first operating condition data. It can be considered that performing a partial difference comparison on some data types with high attention in the demand can improve the efficiency of confirming that there is a difference between the second operating condition data and the first operating condition data.

[0088] In other application scenarios, the difference determination module can confirm one by one whether there is a difference between each data in the second working condition data and each data in the first working condition data of the same data type. It is understandable that the order of comparing the workpiece data, environmental data, processing equipment data and processing load data, and data of different data types between the second working condition data and the first working condition data is not limited here. Specifically, when the data of each data type between the second working condition data and the first working condition data are compared one by one, the order of the one-by-one difference comparison can be a preset fixed order, a random comparison order, or a weight comparison order corresponding to the data type weight set according to the requirements.

[0089] In some embodiments, the above-mentioned step of confirming that there are differences between the second working condition data and the first working condition data may include the following steps: confirming the differences between the second workpiece data and the first workpiece data, confirming the differences between the second environment data and the first environment data, confirming the differences between the second processing equipment data and the first processing equipment data, and confirming the differences between the second processing load data and the first processing load data.

[0090] The process of the difference determination module in the process database establishment device confirming that there is a difference between the second operating condition data and the first operating condition data can be to compare the data differences of each data type between the second operating condition data and the first operating condition data one by one.

[0091] It is understood that for each data type between the second working condition data and the first working condition data, the difference determination module may further compare the sub-type data under each data type one by one. For example, the sub-type data corresponding to the second workpiece data type in the second working condition data may be geometric feature data and material feature data. Specifically, the geometric feature data in the second workpiece data may include the characteristic geometric shapes and dimensional tolerances corresponding to different components in the first workpiece. The material feature data in the second workpiece data may include the material cutting data corresponding to the first workpiece.

[0092] For example, the sub-type data corresponding to the second environmental data type in the second working condition data may be processing temperature data, processing humidity data, and cutting fluid data for processing the first workpiece.

[0093] For example, the sub-type data corresponding to the second processing equipment data type in the second working condition data may be machine tool characteristic data, fixture characteristic data, and tool characteristic data corresponding to the first workpiece.

[0094] Specifically, the machine tool characteristic data in the second processing equipment data may include machine tool accuracy data, machine tool static stiffness data, and machine tool dynamic stiffness data corresponding to the first workpiece. The fixture characteristic data may include fixture accuracy data and fixture static stiffness data corresponding to the first workpiece. The tool characteristic data may include tool sharpness data and tool wear data corresponding to the first workpiece.

[0095] For example, the sub-type data corresponding to the second machining load data type in the second working condition data may include process parameter data corresponding to the first workpiece and process response data of the machining system. It is understood that the data types in the first working condition data corresponding to similar parts of the first workpiece and the sub-type data corresponding to the data types in the first working condition data can be referred to above and will not be further described here.

[0096] It is understood that when the difference determination module performs a one-by-one difference comparison between the second operating condition data and the first operating condition data, the data type of the second operating condition data and the first operating condition data are the same. The subtype data under each data type is the same between the second operating condition data and the first operating condition data. For example, when the difference determination module performs a one-by-one difference comparison between the second operating condition data and the first operating condition data, the difference determination module may determine the difference between the process response data in the second machining load data of the first workpiece and the process response data in the first machining load data corresponding to the same part of the first workpiece.

[0097] In some application scenarios, the one-to-one difference comparison in the difference determination module may be to confirm the difference between the second workpiece data and the first workpiece data.

[0098] For example, the one-to-one difference comparison in the difference determination module may be to confirm the difference in subtype data between the second workpiece data and the first workpiece data.

[0099] In some application scenarios, the one-to-one difference comparison in the difference determination module may be to confirm the difference between the second environment data and the first environment data.

[0100] Exemplarily, the one-to-one difference comparison in the difference determination module may be to confirm the difference in subtype data between the second environment data and the first environment data.

[0101] In some application scenarios, the one-to-one difference comparison in the difference determination module can be to confirm the difference between the second processing equipment data and the first processing equipment data.

[0102] For example, the one-to-one difference comparison in the difference determination module may be to confirm the difference in subtype data between the second processing equipment data and the first processing equipment data.

[0103] In some application scenarios, the one-to-one difference comparison in the difference determination module may be to confirm the difference between the second processing load data and the first processing load data.

[0104] For example, the one-to-one difference comparison in the difference determination module may be the difference in sub-type data between the second processing load data and the first processing load data. It is understood that the order of the one-to-one difference comparison is not limited here.

[0105] It can be understood that by comparing the differences between the second operating condition data and the first operating condition data one by one, the comparison result output by the difference determination module is more accurate, which can improve the accuracy of the process database establishment device in correcting or updating each data in the first database.

[0106] In some embodiments, the step of determining the difference between the second processing equipment data and the first processing equipment data may include the following steps: first, obtaining historical operation and maintenance data and current operation and maintenance data, wherein the historical operation and maintenance data is obtained from a first database and used to correspond to the first processing equipment data, and the current operation and maintenance data is obtained by performing a pre-maintenance action before processing the first workpiece, and the current operation and maintenance data is used to correspond to the second processing equipment data. Second, comparing the historical operation and maintenance data with the current operation and maintenance data to determine the difference between the second processing equipment data and the first processing equipment data.

[0107] The historical operation and maintenance data is obtained from the first database and used to correspond to the first processing equipment data.

[0108] It can be understood that the historical operation and maintenance data may refer to data obtained by performing pre-maintenance actions before processing similar parts, and the data is uploaded to the first database through the process database establishment device.

[0109] The current operation and maintenance data is the data obtained by performing pre-maintenance actions before processing the first workpiece. The current operation and maintenance data can be used to correspond to the second processing equipment data.

[0110] It is understood that the second processing equipment data may include operation and maintenance data. Pre-maintenance actions may refer to relatively simple standard machine tool actions designed by engineers. Pre-maintenance actions may be performed regularly by CNC machine tool users. For example, a pre-maintenance action may involve the spindle rotating at a certain speed for a fixed time, or the worktable reciprocating at a certain speed for a fixed time.

[0111] The current operation and maintenance data may be parameters of each component in the machine tool when processing the first workpiece.

[0112] For example, current operation and maintenance data can be user data plus sensor data collected from the machine tool after executing these actions. Current operation and maintenance data can include vibration and temperature data of the spindle drive assembly, vibration and temperature data of the feed drive assembly, power and current data of the spindle drive system, and power and current data of the feed drive system.

[0113] The difference determination module may compare the historical operation and maintenance data with the current operation and maintenance data to determine a difference between the second processing equipment data and the first processing equipment data. It is understood that if the difference determination module determines that there is a data difference between the historical operation and maintenance data and the current operation and maintenance data, the difference determination module uses the difference between the historical operation and maintenance data and the current operation and maintenance data as the difference between the second processing equipment data and the first processing equipment data.

[0114] In some application scenarios, the device for establishing a process database responds to the difference between the second processing equipment data and the first processing equipment data satisfying the above-mentioned difference determination conditions, and obtains the current precision data of each component of the machine tool by using the detection equipment to perform precision detection before processing the first workpiece. The device for establishing the process database uses the current precision data as the second processing equipment data for subsequent uploading to the first database.

[0115] Among them, precision detection can refer to making the machine tool perform a designed, relatively complex special machine tool action, and using the data collected by detection equipment (such as a laser interferometer, a hammer, etc.). The precision detection can be completed by the detection party. Exemplarily, the second processing equipment data of the first workpiece may include current precision data. Specifically, the current precision data can be the linear positioning error, straightness error, yaw and pitch angle error, vertical error between axes, etc. of the feed axis in each direction measured by the laser interferometer, and can also be the resonant frequency and vibration mode of each component measured by the hammer.

[0116] The process database establishing device can determine whether the second quality data meets a preset condition after confirming that there is a difference between the second operating condition data and the first operating condition data.

[0117] In some application scenarios, the second quality data may be an evaluation value obtained by the quality inspection department by evaluating the final product obtained after processing the first workpiece in accordance with the product standards. The preset condition may be that the second quality data is greater than or equal to the preset quality value. If the second quality data is greater than or equal to the preset quality value, the final product obtained after processing the first workpiece is a qualified product. If the second quality data is less than the preset quality value, the final product obtained after processing the first workpiece is an unqualified product. For example, the preset quality value may be 0.9. The second quality data may be 0.95, and the second quality data 0.95 may be used to characterize that the final product corresponding to the first workpiece at this time is a qualified product. At this time, the second quality data of the first workpiece meets the preset condition.

[0118] In response to the second quality data meeting the preset condition, the process database establishing device associates the second quality data with the second operating condition data and adds the second quality data to the first database.

[0119] In some application scenarios, the device for establishing the process database associates the second quality data with the second operating condition data, and may establish a cross-correlation relationship between the second quality data and the second operating condition data to obtain a cross-correlation relationship data group.

[0120] The process database establishment device performs an addition operation on the cross-correlation relationship data set, adding the cross-correlation relationship data set to the first database. The cross-correlation relationship may be established by establishing a data set corresponding to the second quality data and a data set corresponding to the second operating condition data, and then combining all possible data in the two data sets to obtain the cross-correlation relationship data set. It is understood that the cross-correlation relationship may be the result of the process database establishment device establishing a combination of each data set in the data set corresponding to the second quality data and each data set in the data set corresponding to the second operating condition data.

[0121] It can be considered that the process database establishment device associates the second quality data and the second operating condition data and adds them to the first database, which can make the data types in the first database more complete and the values ​​corresponding to the data types in the first database more referenceable.

[0122] In some embodiments, the workpiece data in the first working condition data and the second working condition data respectively include geometric feature data representing various components when processing the first workpiece or similar parts. The step of determining the difference between the second workpiece data and the first workpiece data may include the following steps:

[0123] First, for the geometric feature data of each component in the second working condition data, a relationship is established between the geometric feature data and other working condition data and / or second processing quality data corresponding to the geometric feature data, thereby obtaining a target associated data group corresponding to the geometric feature data, where the other working condition data is data in the second working condition data other than the geometric feature data;

[0124] Secondly, for each target association data set, the target association data set is compared with one or more corresponding historical association data sets to obtain differences between the target association data set and each historical association data set.

[0125] The geometric feature data in the first workpiece data of the first working condition data may refer to the geometric feature parameters of each component when machining a similar part of the first workpiece. The geometric feature data in the second workpiece data of the second working condition data may refer to the geometric feature parameters of each component when machining the first workpiece. It is understood that the data type of each piece of geometric feature data in each piece of workpiece data and the subtype data corresponding to that data type can be referred to above and will not be further described here.

[0126] Please refer to Figure 2, which is a schematic diagram of the effects of a first workpiece in one embodiment of the process database establishment method provided in this application. For example, the first workpiece shown in Figure 2 corresponds to a final product. In some application scenarios, the data types of the second working condition data and the second quality data in the first real-time processing data corresponding to the first workpiece shown in Figure 2 can be referred to in Table 1 below.

[0127] Table 1

[0128] It can be considered that the first real-time processing data corresponding to the first workpiece shown in Figure 2 can be the geometric feature data in the second workpiece data, the tool characteristic data in the second processing equipment data, the process parameter data in the second processing load data, the process response data in the second processing load data and the second quality data as shown in Table 1 above.

[0129] In some application scenarios, the machine tool characteristic data in the second processing equipment data corresponding to the first workpiece shown in Figure 2 can be the same set of data. Specifically, the machine tool characteristic data can be the X-axis linear positioning accuracy of the machine tool is M1, the Y-axis linear positioning accuracy is M2, the Z-axis linear positioning accuracy is M3, the X-axis straightness is M4, the Y-axis straightness is M5, and the Z-axis straightness is M6.

[0130] In other application scenarios, the material characteristic data in the second workpiece data corresponding to the first workpiece shown in Figure 2 can be the same set of data. Specifically, the material characteristic data can be the material brand parameters P1 and material cutting data P2 of all components of the first workpiece.

[0131] For the geometric characteristic data of each component in the second operating condition data, data other than the geometric characteristic data in the second operating condition data is other operating condition data. Specifically, the other operating condition data other than the geometric characteristic data of each component in the second operating condition data may be at least one of material characteristic data, second environmental data, second processing equipment data, and second processing load data in the second workpiece data corresponding to the component.

[0132] For example, as shown in FIG2 and the first workpiece in Table 1 above, for the geometric feature data of component one in the second working condition data, the sub-type data in the geometric feature data of component one can be the shape of cone 1, the first dimension of major diameter A1, and the second dimension of minor diameter B1. In addition to the geometric feature data of component one, the other working condition data in the second working condition data corresponding to component one can be specifically the tool characteristic data in the second processing equipment data (the wear degree data corresponding to turning tool two is G1), the process parameter data in the second processing load data (spindle speed is Z1; feed rate is J1; cutting depth is Q1), the process response data in the second processing load data (spindle power is W1), the machine tool characteristic data in the second processing equipment data (M1 to M6), and the material characteristic data in the second workpiece data (P1 and P2). The second quality data corresponding to component one is the roughness data (roughness is Y1).

[0133] In some application scenarios, the device for establishing a process database can establish cross-correlation relationships between each sub-type data in the geometric feature data of component one and other operating condition data in the second operating condition data corresponding to the above-mentioned component one except the geometric feature data of component one, to obtain a target correlation data group corresponding to the geometric feature data of component one.

[0134] In other application scenarios, the device for establishing a process database can use each sub-type data in the geometric feature data of component one as the same geometric feature label, or use some sub-type data in the geometric feature data of component one as the same geometric feature label.

[0135] The device for establishing the process database establishes a cross-correlation relationship between the geometric feature label corresponding to component one and the other working condition data except the geometric feature data of component one in the second working condition data corresponding to component one, to obtain the target associated data group corresponding to the geometric feature data of component one. Exemplarily, each data in the target associated data group corresponding to component one can be the first row in Table 1 above, and each data corresponding to component one. The form of the target associated data group can be a table as shown in Table 1 above. The form of the target associated data group can also be to use the geometric feature data of component one as the main node, and the other working condition data except the geometric feature data of component one in the second working condition data corresponding to component one and the second quality data corresponding to component one as the slave nodes. The device for establishing the process database connects each node, and the main node corresponding to component one is connected to the main nodes of other components of the first workpiece.

[0136] In some application scenarios, for the geometric feature data of each component in the second working condition data, a relationship between the geometric feature data and other working condition data corresponding to the geometric feature data is established to obtain a target association data group corresponding to the geometric feature data. For the geometric feature data of each component in the second working condition data, a relationship between the geometric feature data and the second processing quality data is established to obtain a target association data group corresponding to the geometric feature data. For the geometric feature data of each component in the second working condition data, a relationship between the geometric feature data and other working condition data corresponding to the geometric feature data and the second processing quality data is established to obtain a target association data group corresponding to the geometric feature data. It can be considered that by using target association data, it is possible to facilitate the user to display each data more clearly when using the first database, and improve the search efficiency of each data in the first database.

[0137] It will be appreciated that for each component of the first workpiece, the first database stores multiple historical association data sets corresponding to the target association data for that component. For example, for component 1 of the first workpiece, the first database stores multiple historical association data sets corresponding to the target association data for component 1. Specifically, the difference determination module can obtain the target association data set corresponding to the geometric feature data in the second workpiece data corresponding to component 1.

[0138] The difference determination module can search the first database for one or more historical association data groups corresponding to the target association data group for component one based on the geometric feature data in the second workpiece data corresponding to component one. The difference determination module compares each data group in the target association data group with each data group in the corresponding one or more historical association data groups to determine the differences between each data group and each historical association data group. In response to the differences between each data group satisfying the aforementioned difference determination conditions, the difference determination module outputs an output result indicating a difference between the second operating condition data and the first operating condition data.

[0139] It can be understood that by confirming whether there are differences between the target associated data group and each historical associated data group, and determining that the difference determination module outputs an output result with a difference between the second operating condition data and the first operating condition data, the efficiency of establishing and confirming differences in the process database can be improved. Compared with confirming differences without grouping, the present application can optimize the path of calculating differences.

[0140] In some embodiments, after the above-mentioned step of comparing the target association data group with one or more corresponding historical association data groups for each target association data group to obtain the difference between the target association data group and each historical association data group, the following steps are also included: using the target association data group to adjust the historical association data group corresponding to the target difference to obtain multiple current association data groups corresponding to each geometric feature data, and the difference between the target difference and the target association data group is greater than or equal to the preset difference.

[0141] The target difference may be a difference value exceeding a preset deviation threshold in the above-mentioned difference determination condition.

[0142] The difference between the target difference and the target associated data group is greater than or equal to a preset difference, wherein the preset difference may correspond to a preset deviation threshold in the above-mentioned difference determination condition.

[0143] After the difference determination module outputs an output result indicating that there is a difference between the second operating condition data and the first operating condition data, the process database establishment device can modify or update the first database based on the output result.

[0144] The process database establishment device receives the output result output by the difference determination module, which also includes the differences between the data groups of the same component.

[0145] If there is a difference between the target associated data set and the historical associated data set, the data difference between the target associated data set and the historical associated data set is used as the target difference.

[0146] The device for establishing the process database can find the historical associated data group corresponding to the difference comparison based on the target difference, and use the historical associated data group corresponding to the target difference as the associated data group to be adjusted.

[0147] The process of the process database establishment device using the target associated data group to adjust the historical associated data group corresponding to the target difference can be that for each geometric feature data, the process database establishment device can use the target associated data group to adjust the associated data group to be adjusted in the first database to obtain multiple current associated data groups corresponding to each geometric feature data.

[0148] In some application scenarios, adjusting the to-be-adjusted associated data group using the target associated data group may be to correct or update the to-be-adjusted associated data group in the first database using the target associated data group to obtain multiple current associated data groups corresponding to each geometric feature data in the first database.

[0149] In other application scenarios, adjusting the target association data group to be adjusted may involve replacing the target association data group in the first database with the target association data group to obtain multiple current association data groups corresponding to each geometric feature data in the first database. The multiple current association data groups corresponding to each geometric feature data may be stored in the first database.

[0150] It is understandable that using the target associated data group to adjust the historical associated data group corresponding to the target difference can improve the correction efficiency or update efficiency of the first database.

[0151] In some embodiments, after the above-mentioned step of using the target associated data group to adjust the historical associated data group corresponding to the target difference to obtain multiple current associated data groups corresponding to each geometric feature data, the method for establishing a process database also includes the following steps: first, for the geometric feature data of each component, select one group from the multiple current associated data corresponding to the geometric feature data of the component as the associated data group to be cleared, and the other groups as the baseline associated data groups; second, based on each baseline associated data group, determine the qualified range of at least one working condition data; finally, in response to the working condition data in the associated data group to be cleared being not within the qualified range, clear the data group to be cleared from the first database.

[0152] In some application scenarios, the first database can regularly filter out unqualified data. If the data collected by the first database reaches the upper limit, the oldest data will be regularly cleared to ensure that the data in the first database is up to date.

[0153] For each component's geometric feature data, one group is selected from a plurality of current associated data corresponding to the component's geometric feature data in the first database as the associated data group to be cleared, and the other groups are selected as reference associated data groups.

[0154] The to-be-cleared associated data group may refer to a current associated data group corresponding to geometric feature data of a component of the first workpiece that needs to be regularly screened. The process database establishment device uses other current associated data groups in the first database except the to-be-cleared associated data group as reference associated data groups.

[0155] The process database establishment device may determine a qualified range for at least one working condition data item based on each baseline associated data group. For example, the process database establishment device may determine a qualified range for processing load data based on the processing load data in each baseline associated data group, compared to the processing load data in the associated data group to be removed. The process database establishment device may compare the processing load data in the associated data group to be removed with the qualified range for processing load data. In response to the processing load data in the associated data group to be removed not being within the qualified range, the process database establishment device may remove the associated data group to be removed from the first database.

[0156] In other application scenarios, for example, the process database establishment device can determine the qualified range of the processing load data and the qualified range of the processing equipment data based on the processing load data and the processing equipment data in each reference associated data group, compared to the processing load data and the processing equipment data in the associated data group to be cleared. The process database establishment device can compare the processing load data in the associated data group to be cleared with the qualified range of the processing load data, and compare the processing equipment data in the associated data group to be cleared with the qualified range of the processing equipment data. In response to the processing load data in the associated data group to be cleared not being within the qualified range and the processing equipment data in the associated data group to be cleared being within the qualified range, the process database establishment device clears the processing load data in the data group to be cleared from the first database or clears the data group to be cleared from the first database.

[0157] It is understandable that the first database can improve the reference value of each data in the first database by clearing out unqualified data or the earliest data.

[0158] In some embodiments, the method for establishing a process database also includes the following steps: the first database also includes a first processing label, and the first processing label is used to mark the historical processing data obtained when processing the first workpiece or similar parts of the first workpiece under different processing optimization principles; the first processing target includes the processing optimization principle; the above step S11 may include the following steps: selecting the corresponding first processing label based on the processing optimization principle to obtain the historical processing data corresponding to the first processing label.

[0159] The processing optimization principles can be efficiency priority principle, cost priority principle, energy saving priority principle, quality priority principle and fixed beat principle.

[0160] Among them, the efficiency priority principle can mean that the optimization target is the processing time, and the corresponding optimization problem is to adjust the processing parameters to shorten the processing time.

[0161] The cost priority principle can mean that the optimization goal is the money consumed, and the optimization problem is to adjust the processing parameters to minimize the money consumed in processing.

[0162] The energy-saving priority principle can mean that the optimization target is the machine tool power, and the optimization problem adjusts the processing parameters to minimize the machine tool power.

[0163] The quality priority principle may mean selecting the safest parameters and adjusting the processing parameters to ensure the quality of the final product of the first workpiece.

[0164] Fixed cycle time may refer to adjusting processing parameters so that the processing time of the entire first workpiece is controlled within a given time.

[0165] The first database also includes a first processing tag, which is used to mark historical processing data obtained when the first workpiece or similar parts are processed under different processing optimization principles.

[0166] For example, if a cost-priority principle is used to process similar parts, the process database establishment device may associate the historical processing data with the cost-priority optimization principle in the process database using a first processing tag, or use the cost-priority principle as the first processing tag and the first processing tag as the grouping tag corresponding to the historical processing data. The process database establishment device may store the grouping tag and the historical processing data corresponding to the grouping tag in the first database.

[0167] It is understandable that the first processing tag is a single tag, and the historical processing data of the same type of parts in the first database can be divided into groups corresponding to different first processing tags according to the first processing tags.

[0168] The process database establishment device selects the corresponding first processing tag based on the processing optimization principle to obtain the historical processing data corresponding to the first processing tag.

[0169] For example, when processing a first workpiece, the process database establishment device may prioritize the cost of the first workpiece. The process database establishment device may prioritize cost as a first processing objective and use this first processing objective as a first processing tag. The process database establishment device searches the first database for first processing tags corresponding to similar parts and obtains historical processing data corresponding to the first processing tags.

[0170] It is understandable that obtaining the historical processing data corresponding to the same type of parts through the first processing tag can reduce the time for searching the historical processing data.

[0171] In some embodiments, the first database further includes a second processing tag, which is used to annotate historical processing data obtained when processing the first workpiece or a similar part of the first workpiece under different multi-factor optimization principles. The multi-factor optimization principle includes multiple different processing optimization principles, each of which has the same or different weights. Step S11 above may include the following steps: selecting a corresponding second processing tag based on the multi-factor optimization principle to obtain historical processing data corresponding to the second processing tag.

[0172] In some application scenarios, if the weights of the optimization principles in the multi-factor optimization principle are the same, the second processing label can be a label group obtained by combining multiple optimization principles.

[0173] For example, the efficiency priority principle, cost priority principle, energy conservation priority principle, quality priority principle, and fixed cycle principle in the processing optimization principles can be represented as R1, R2, R3, R4, and R5, respectively. The second processing label corresponding to the efficiency priority principle and the cost priority principle can be represented as R1+R2.

[0174] In other application scenarios, if the weights of the various optimization principles in a multi-factor optimization principle differ, the second processing label can be a label group obtained by combining multiple optimization principles and their weights. For example, if the weight of the efficiency priority principle is 0.3 and the weight of the cost priority principle is 0.7, the second processing labels corresponding to the efficiency priority principle and the cost priority principle can be expressed as 0.3×R1+0.7×R2.

[0175] The process database establishment device selects the corresponding second processing label based on the multi-factor optimization principle to obtain the historical processing data corresponding to the second processing label.

[0176] For example, when processing a first workpiece, the process database establishment device needs to prioritize the cost and efficiency of the first workpiece. The process database establishment device can prioritize the cost and efficiency as the second processing objective, and use this second processing objective as the second processing label. The second processing label can be expressed as the weight of the efficiency priority principle × R1 + the weight of the cost priority principle × R2. The process database establishment device searches the first database for the second processing label corresponding to the same part as the first workpiece, and obtains the historical processing data corresponding to the second processing label.

[0177] It is understandable that, by using the second processing tag to obtain the historical processing data corresponding to the same type of parts of the first workpiece, the time for searching the historical processing data can be reduced.

[0178] In some embodiments, the step of selecting the corresponding second processing label based on the multi-factor optimization principle to obtain historical processing data corresponding to the second processing label may include the following steps: obtaining weights for each optimization principle of the multi-factor optimization principle; determining candidate processing data corresponding to each optimization principle based on the optimization algorithm corresponding to each optimization principle; and obtaining historical processing data corresponding to the second processing label based on the weights for each optimization principle and the candidate processing data corresponding to each optimization principle.

[0179] The device for establishing the process database can obtain the weight of each optimization principle of the multi-factor optimization principle.

[0180] The weights of each optimization principle within the multi-factor optimization principle can be preset in the first database or adjusted based on user needs. Different optimization principles correspond to different optimization objectives and algorithms, including but not limited to genetic algorithms, gradient descent methods, ant colony algorithms, and Pareto optimization algorithms. The process database establishment device can determine candidate processing data corresponding to each optimization principle based on the optimization algorithm corresponding to each optimization principle required for the first processing objective of the acquired first workpiece.

[0181] For example, the process database establishment device may obtain that the required optimization principles for the first processing objective of the first workpiece are the efficiency priority principle and the cost priority principle, respectively, and the weight of the efficiency priority principle is 0.2, and the weight of the cost priority principle is 0.8. Based on the different optimization algorithms corresponding to the efficiency priority principle and the cost priority principle, the process database establishment device determines, in the first database, candidate processing data corresponding to the efficiency priority principle and candidate processing data corresponding to the cost priority principle, respectively.

[0182] The candidate processing data corresponding to the efficiency priority principle is the first candidate processing data, and the first candidate processing data may include a value of one corresponding to the first processing load data. The candidate processing data corresponding to the cost priority principle is the second candidate processing data, and the second candidate processing data may include a value of two corresponding to the first processing load data. The process database establishment device can obtain historical processing data corresponding to the second processing label based on the weights of each optimization principle and the candidate processing data corresponding to each optimization principle. For each candidate processing data, the process database establishment device calculates the product of the candidate processing data and the weight of the optimization principle corresponding to the candidate processing data to obtain a candidate product. The process database establishment device sums all candidate products to obtain a sum value of all candidate products, and uses this sum value as the historical processing data corresponding to the second processing label. Exemplarily, the process database establishment device multiplies the weight of the efficiency priority principle by the first candidate processing data to obtain a first product, and multiplies the weight of the cost priority principle by the second candidate processing data to obtain a second product. The device for establishing the process database calculates a sum of the first product and the second product, and uses the sum as historical processing data corresponding to the efficiency priority principle and the cost priority principle.

[0183] It is understandable that by using the multi-factor optimization principle as the second processing label, the historical processing data corresponding to the second processing label obtained is more accurate and meets the expectations when processing the first workpiece.

[0184] In some embodiments, the method for establishing a process database further includes the following steps: associating a processing tag used when processing the first workpiece with a first real-time processing data of the first workpiece, and then adding the tag to the first database. The processing tag may be a first processing tag or a second processing tag, wherein the first processing tag is used to annotate historical processing data obtained when processing the first workpiece or similar parts under different processing optimization principles, and the second processing tag is used to annotate historical processing data obtained when processing the first workpiece or similar parts under different multi-factor optimization principles.

[0185] The processing tag used when processing the first workpiece can refer to the first processing tag or the second processing tag corresponding to the optimization principle required for processing the first workpiece. After obtaining the first real-time processing data of the first workpiece, the process database establishment device can associate the processing tag used when processing the first workpiece with the first real-time processing data of the first workpiece to obtain the first real-time processing data carrying the processing tag. In some application scenarios, the process database establishment device can directly add the first real-time processing data carrying the processing tag to the first database. In other application scenarios, after the above step S15, the process database establishment device adds the first real-time processing data carrying the processing tag to the first database.

[0186] It can be understood that by adding the first real-time processing data carrying the processing tag to the first database, the efficiency of storing or reading the first real-time processing data in the first database can be improved.

[0187] In some embodiments, the method for establishing a process database further includes the steps of: displaying an information entry interface, the information entry interface including a first area for a user to input an optimization principle, a second area for a user to input a first processing label, and a third area for a user to input a second processing label; receiving information input in the first area, the second area, and the third area of ​​the information entry interface to obtain a first processing target.

[0188] The information entry interface can be a user interface displayed to the user by the process database establishment device. The information entry interface can be a user interface for the user to confirm the first processing target of the first workpiece. The information entry interface can include multiple display areas. The first area of ​​the information entry interface can be a display area for the user to enter an optimization principle. The first area can include multiple first sub-areas. It is understood that each first sub-area within the first area can correspond to a different optimization principle. The second area of ​​the information entry interface can be a display area for the user to enter a first processing label. The third area of ​​the information entry interface can be a display area for the user to enter a second processing label. It is understood that the third area can include multiple third sub-areas. Some of the third sub-areas can be used for the user to enter weights corresponding to different optimization principles. The process database establishment device can receive information entered in the first, second, and third areas of the information entry interface to obtain the first processing target. In some application scenarios, in response to receiving the information entered in each area of ​​the information entry interface, the process database establishment device can determine the first processing target to facilitate the execution of step S11 above.

[0189] In some embodiments, step S13 may include the following steps: first, obtaining second working condition data uploaded from the edge side of the first workpiece during machining. Then, receiving second machining quality data uploaded by a quality inspection and entry system, which is a system associated with the first database for entering quality data of each workpiece.

[0190] Edge-side uploading can refer to the data collected by the process database establishment device using sensors or communicating with the CNC system, and saved as a file through the edge-side computer connected to the machine tool.

[0191] In some application scenarios, the file saved in the edge-side computer connected to the machine tool may be the second working condition data of the first workpiece. The device for establishing the process database obtains the second working condition data uploaded by the edge side when the first workpiece is processed. The quality inspection entry system is a system associated with the first database for entering the quality data of each workpiece. The quality inspection entry system may be a system capable of entering the second processing quality data of the first workpiece. The device for establishing the process database receives the second processing quality data uploaded by the quality inspection entry system corresponding to the quality inspection department. After obtaining the second working condition data and the second quality data, the device for establishing the process database sequentially executes the above steps S14 and S15.

[0192] It is understandable that by correcting or updating the first database through the second operating condition data and the second quality data, the data types of the first database can be enriched, making the first database more referenceable.

[0193] The above scheme determines the historical processing data obtained when processing similar parts of the first workpiece from the first database based on the first processing target of the first workpiece, processes the first workpiece according to the historical processing data, and obtains the first real-time processing data of the first workpiece, compares the historical processing data with the first real-time processing data, and corrects or updates the first database based on the comparison results. Compared with directly adding the processing conditions set according to experience into the database, the present application can improve the referenceability and accuracy of each data in the first database by correcting or updating the first database based on the comparison results.

[0194] Please refer to FIG3 . The present application provides a process database 30 . The process database 30 is established by using any of the above-mentioned process database establishment methods.

[0195] The process database 30 may be the first database described above. The process database 30 may store historical processing data 301. Of course, in other embodiments, other data may also be stored. The data that may be stored in the process database 30 can be found in the description of the process database establishment method described above and will not be described in detail here. The specific content of the historical processing data 301 can be found in the description of the process database establishment method described above and will not be described in detail here.

[0196] In some embodiments, the process database is established using the process database establishment method described above. It is understood that after step S15 corresponding to the process database establishment method described above, the process database establishment device modifies or updates the first database based on the comparison results to obtain a new first database, and the process database establishment device may use the new first database as the process database.

[0197] The above scheme determines the historical processing data obtained when processing similar parts of the first workpiece from the first database based on the first processing target of the first workpiece, processes the first workpiece according to the historical processing data, and obtains the first real-time processing data of the first workpiece, compares the historical processing data with the first real-time processing data, and corrects or updates the first database based on the comparison results. Compared with directly adding the processing conditions set according to experience into the database, the present application can improve the referenceability and accuracy of each data in the first database by correcting or updating the first database based on the comparison results.

[0198] Please refer to FIG4 , which is a flow chart of an embodiment of the processing method provided by the present application. Specifically, the processing method is applied to the process database as described above. The processing method of this embodiment may include the following steps:

[0199] Step S41: determining historical processing data from a process database based on a first processing target of a workpiece to be processed.

[0200] The workpiece to be processed is one of the same type of parts as the first workpiece, and the historical processing data is data obtained when processing the same type of parts. The historical processing data includes first working condition data and first quality data associated with the first working condition data. The first working condition data includes cross-related first workpiece data, first environment data, first processing equipment data and first processing load data.

[0201] The above step S41 may refer to the process of step S11 in the method for establishing the process database, and will not be repeated here.

[0202] Step S42: Processing the workpiece to be processed according to the historical processing data.

[0203] The above step S42 can refer to the process of step S12 in the method for establishing the process database, and will not be repeated here.

[0204] It is understandable that, because the workpiece to be processed is one of the same type of parts, the processes of the above steps S41 and S42 are the same as the processes of steps S11 and S12 in the method for establishing the process database.

[0205] The above scheme determines the historical processing data obtained when processing similar parts of the first workpiece from the first database based on the first processing target of the first workpiece, processes the first workpiece according to the historical processing data, and obtains the first real-time processing data of the first workpiece, compares the historical processing data with the first real-time processing data, and corrects or updates the first database based on the comparison results. Compared with directly adding the processing conditions set according to experience into the database, the present application can improve the referenceability and accuracy of each data in the first database by correcting or updating the first database based on the comparison results.

[0206] In some embodiments, the processing method further comprises the following steps: monitoring real-time working condition data of the workpiece to be processed. If the real-time working condition data differs from any of the first workpiece data, the first environmental data, the first processing equipment data, and the first processing load data, selecting data with the highest similarity threshold from the process database based on the real-time working condition data, and processing the workpiece to be processed using the data set.

[0207] The workpiece to be processed in the processing method may refer to the first workpiece or a similar part thereof. The real-time working condition data monitored for processing the workpiece to be processed may refer to the second working condition data in the first real-time processing data corresponding to the first workpiece. Among them, the process database may refer to the first database. In addition, in the process of processing the first workpiece, since the first database includes a large amount of real-time processing data, when the real-time working condition data is monitored to be different from a certain item of the first working condition data in the historical processing data, the current parameter is used as a label, and a processing parameter with a higher similarity threshold with the current label can be selected in the process database, and processing can be performed with this processing parameter, thereby achieving the purpose of real-time parameter correction during the processing process.

[0208] For example, consider the following historical processing data: ambient temperature A1, tool wear B1, and machining quality C1. When machining the first workpiece, the real-time ambient temperature is A2 and tool wear B2. Using the original cutting parameters at this point might result in subpar quality. Therefore, parameters with a higher similarity threshold than the actual parameters are selected from the process database for correction. This allows for in-process parameter correction and significantly improves machining accuracy.

[0209] The above scheme determines the historical processing data obtained when processing similar parts of the first workpiece from the first database based on the first processing target of the first workpiece, processes the first workpiece according to the historical processing data, and obtains the first real-time processing data of the first workpiece, compares the historical processing data with the first real-time processing data, and corrects or updates the first database based on the comparison results. Compared with directly adding the processing conditions set according to experience into the database, the present application can improve the referenceability and accuracy of each data in the first database by correcting or updating the first database based on the comparison results.

[0210] Please refer to Figure 5, which is a schematic diagram of the structure of an embodiment of a process database establishment device of the present application. The process database establishment device 50 includes a determination module 51, a processing module 52, an acquisition module 53, a comparison module 54, and a database processing module 55. The determination module 51 is used to determine historical processing data from a first database based on a first processing target of a first workpiece. The historical processing data is data acquired when processing similar parts of the first workpiece. The historical processing data includes first working condition data and first quality data associated with the first working condition data. The first working condition data includes cross-correlated first workpiece data, first environmental data, first processing equipment data, and first processing load data. The processing module 52 is used to process the first workpiece according to the historical processing data. The acquisition module 53 is used to acquire first real-time processing data for processing the first workpiece. The first real-time processing data includes second working condition data and second quality data. The comparison module 54 is used to compare the historical processing data with the first real-time processing data. The database processing module 55 is used to modify or update the first database based on the comparison result.

[0211] The above scheme determines the historical processing data obtained when processing similar parts of the first workpiece from the first database based on the first processing target of the first workpiece, processes the first workpiece according to the historical processing data, and obtains the first real-time processing data of the first workpiece, compares the historical processing data with the first real-time processing data, and corrects or updates the first database based on the comparison results. Compared with directly adding the processing conditions set according to experience into the database, the present application can improve the referenceability and accuracy of each data in the first database by correcting or updating the first database based on the comparison results.

[0212] For the functions performed by each module, please refer to the method of establishing the process database, which will not be repeated here.

[0213] Please refer to Figure 6, which is a schematic diagram of the structure of an embodiment of a terminal device of the present application. Terminal device 60 includes memory 61 and processor 62. Processor 62 is configured to execute a computer program stored in memory 61 to implement the steps of the aforementioned process database establishment method embodiment or the aforementioned processing method embodiment. In a specific implementation scenario, terminal device 60 may include, but is not limited to, a microcomputer and a server. In addition, terminal device 60 may also include mobile devices such as laptops and tablet computers, which are not limited here.

[0214] Specifically, the processor 62 is used to control itself and the memory 61 to implement the steps in the embodiment of the method for establishing the above-mentioned process database. The processor 62 can also be called a CPU (Central Processing Unit). The processor 62 may be an integrated circuit chip with signal processing capabilities. The processor 62 can also be a general-purpose processor, a digital signal processor (DSP), an application-specific integrated circuit (ASIC), a field-programmable gate array (FPGA) or other programmable logic devices, discrete gates or transistor logic devices, discrete hardware components. The general-purpose processor can be a microprocessor or the processor can also be any conventional processor, etc. In addition, the processor 62 can be implemented by an integrated circuit chip.

[0215] The above scheme determines the historical processing data obtained when processing similar parts of the first workpiece from the first database based on the first processing target of the first workpiece, processes the first workpiece according to the historical processing data, and obtains the first real-time processing data of the first workpiece, compares the historical processing data with the first real-time processing data, and corrects or updates the first database based on the comparison results. Compared with directly adding the processing conditions set according to experience into the database, the present application can improve the referenceability and accuracy of each data in the first database by correcting or updating the first database based on the comparison results.

[0216] Please refer to Figure 7, which is a schematic diagram of the structure of an embodiment of a computer-readable storage medium of the present application. Computer-readable storage medium 70 stores a computer program 701 thereon. When executed by a processor, computer program 701 implements the steps of any of the aforementioned process database establishment method embodiments or the aforementioned processing method embodiments.

[0217] The above scheme determines the historical processing data obtained when processing similar parts of the first workpiece from the first database based on the first processing target of the first workpiece, processes the first workpiece according to the historical processing data, and obtains the first real-time processing data of the first workpiece, compares the historical processing data with the first real-time processing data, and corrects or updates the first database based on the comparison results. Compared with directly adding the processing conditions set according to experience into the database, the present application can improve the referenceability and accuracy of each data in the first database by correcting or updating the first database based on the comparison results.

[0218] In some embodiments, the functions or modules included in the device provided by the embodiments of the present disclosure can be used to execute the method described in the above method embodiments. The specific implementation can refer to the description of the above method embodiments. For the sake of brevity, it will not be repeated here.

[0219] The above description of the various embodiments tends to emphasize the differences between the various embodiments. The same or similar aspects can be referenced with each other and will not be repeated herein for the sake of brevity.

[0220] In the several embodiments provided in this application, it should be understood that the disclosed methods and devices can be implemented in other ways. For example, the device implementation methods described above are only schematic. For example, the division of modules or units is only a logical function division. There may be other division methods in actual implementation. For example, units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, and the indirect coupling or communication connection of devices or units can be electrical, mechanical or other forms.

[0221] In addition, the functional units in the various embodiments of the present application may be integrated into a single processing unit, or each unit may exist physically separately, or two or more units may be integrated into a single unit. The aforementioned integrated units may be implemented in the form of hardware or software functional units.

[0222] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application, or the part that contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for enabling a computer device (which can be a personal computer, server, or network device, etc.) or a processor to execute all or part of the steps of each embodiment method of the present application. The aforementioned storage medium includes: various media that can store program codes, such as a USB flash drive, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk.

Claims

1. A method for establishing a process database, characterized in that It includes the following steps: Determine historical processing data from a first database based on a first processing objective of a first workpiece, where the historical processing data is data obtained during the processing of similar parts of the first workpiece, and the historical processing data includes first working condition data and first quality data associated with the first working condition data. The first working condition data includes cross-correlated first workpiece data, first environmental data, first processing equipment data, and first processing load data; Process the first workpiece according to the historical processing data; Obtain first real-time processing data for processing the first workpiece, where the first real-time processing data includes second working condition data and second quality data; Compare the historical processing data with the first real-time processing data; Modify or update the first database based on the comparison result.

2. The method for establishing a process database according to claim 1, wherein: The step of modifying or updating the first database based on the comparison result includes: Confirm that there is a difference between the second working condition data and the first working condition data. The second working condition data includes cross-correlated second workpiece data, second environmental data, second processing equipment data, and second processing load data; If the second quality data meets a preset condition; After associating the second quality data and the second working condition data, add them to the first database.

3. The method for establishing a process database according to claim 2, wherein: The step of confirming that there is a difference between the second working condition data and the first working condition data includes: Confirm the difference between the second workpiece data and the first workpiece data; Confirm the difference between the second environmental data and the first environmental data; Confirm the difference between the second processing equipment data and the first processing equipment data; and Confirm the difference between the second processing load data and the first processing load data.

4. The method for establishing a process database according to claim 3, wherein: The step of confirming the difference between the second processing equipment data and the first processing equipment data includes: Obtain historical operation and maintenance data and current operation and maintenance data. Among them, the historical operation and maintenance data is obtained from the first database and used to correspond to the first processing equipment data, and the current operation and maintenance data is data obtained by performing pre-maintenance actions before processing the first workpiece and is used to correspond to the second processing equipment data; Compare the historical operation and maintenance data and the current operation and maintenance data to obtain the difference between the second processing equipment data and the first processing equipment data.

5. The method for establishing a process database according to claim 3, wherein: The workpiece data in the first working condition data and the second working condition data respectively includes geometric feature data of each component when processing the first workpiece or similar parts of the first workpiece; The step of confirming the difference between the second workpiece data and the first workpiece data includes: For the geometric feature data of each of the components in the second working condition data, establish the relationship between the geometric feature data and other working condition data and / or second processing quality data corresponding to the geometric feature data, to obtain the target associated data group corresponding to the geometric feature data, where the other working condition data is the data in the second working condition data other than the geometric feature data; For each of the target associated data groups, compare the target associated data group with one or more corresponding historical associated data groups to obtain the differences from each of the historical associated data groups.

6. The method for establishing a process database according to claim 5, wherein: The steps after comparing the target associated data group with one or more corresponding historical associated data groups for each of the target associated data groups to obtain the differences from each of the historical associated data groups further include: Adjust the historical associated data groups corresponding to the target differences by using the target associated data group to obtain multiple current associated data groups corresponding to each of the geometric feature data, where the difference between the target difference and the target associated data group is greater than or equal to a preset difference.

7. The method for establishing a process database according to claim 6, wherein: After adjusting the historical associated data groups corresponding to the target differences by using the target associated data group to obtain multiple current associated data groups corresponding to each of the geometric feature data, the method further includes: For the geometric feature data of each of the components, select one group from the multiple current associated data corresponding to the geometric feature data of the component as the associated data group to be cleared, and the other groups as the reference associated data groups; Based on each of the reference associated data groups, determine the qualified range of at least one working condition data; In response to the working condition data in the associated data group to be cleared not being within the qualified range, clear the associated data group to be cleared from the first database.

8. The method for establishing a process database according to claim 1, wherein: The first database further includes a first processing label, which is used to label the historical processing data obtained when processing the first workpiece or the same type of parts of the first workpiece under different processing optimization principles; The first processing objective includes a processing optimization principle; The step of determining historical processing data from the first database based on the first processing objective of the first workpiece includes: Select the corresponding first processing label based on the processing optimization principle to obtain the historical processing data corresponding to the first processing label.

9. The method for establishing a process database according to any one of claims 1 to 8, wherein: The first database further includes a second processing label, which is used to label the historical processing data obtained when processing the first workpiece or the same type of parts of the first workpiece under different multi-factor optimization principles, the multi-factor optimization principle includes multiple different processing optimization principles, and the weights of each of the processing optimization principles are the same or different; The step of determining historical processing data from the first database based on the first processing objective of the first workpiece includes: Select the corresponding second processing label based on the multi-factor optimization principle to obtain the historical processing data corresponding to the second processing label.

10. The method for establishing a process database according to claim 9, wherein: The step of selecting the corresponding second processing label based on the multi-factor optimization principle to obtain the historical processing data corresponding to the second processing label includes: Obtain the weights of the respective optimization principles of the multi-factor optimization principle; Respectively determine the candidate processing data corresponding to each optimization principle according to the optimization algorithm corresponding to each optimization principle; Based on the weights of the respective optimization principles and the candidate processing data corresponding to the respective optimization principles, obtain the historical processing data corresponding to the second processing label.

11. The method for establishing a process database according to claim 10, wherein The method further includes the following steps: After associating the processing label used when processing the first workpiece with the first real-time processing data for processing the first workpiece, add it to the first database; Wherein, the processing label is a first processing label or a second processing label, the first processing label is used to label the historical processing data obtained when processing the first workpiece or the same-type parts of the first workpiece under different processing optimization principles, and the second processing label is used to label the historical processing data obtained when processing the first workpiece or the same-type parts of the first workpiece under different multi-factor optimization principles.

12. The method for establishing a process database according to claim 1, wherein The method further includes the following steps: Display an information input interface, the information input interface includes a first area for the user to input optimization principles, a second area for the user to input the first processing label, and a third area for the user to input the second processing label; Receive the information input in the first area, the second area, and the third area in the information input interface to obtain the first processing target.

13. The method for establishing a process database according to claim 1, wherein The step of obtaining the first real-time processing data for processing the first workpiece includes: Obtain the second working condition data uploaded from the edge side during the processing of the first workpiece; Receive the second processing quality data uploaded by the quality inspection input system, and the quality inspection input system is a system associated with the first database for inputting the quality data of each workpiece.

14. A process database, characterized in that, The process database is established by using the method for establishing a process database according to any one of claims 1 to 13.

15. A processing method, characterized in that, The process database applied in the processing method is the process database according to claim 14, including: Determine historical processing data from the process database based on the first processing target of the workpiece to be processed, the workpiece to be processed is a same-type part of the first workpiece, the historical processing data is the data obtained when processing the same-type parts of the first workpiece, the historical processing data includes first working condition data and first quality data associated with the first working condition data, and the first working condition data includes cross-associated first workpiece data, first environmental data, first processing equipment data, and first processing load data; Process the workpiece to be processed according to the historical processing data.

16. The processing method according to claim 15, characterized in that, The method further includes: Monitor the real-time working condition data of the workpiece to be processed; If there is a difference between the real-time working condition data and any one of the first workpiece data, the first environmental data, the first processing equipment data, and the first processing load data; Select the data group with the highest similarity threshold from the process database based on the real-time working condition data; Process the workpiece to be processed with the data group.

17. An apparatus for establishing a process database, characterized in that, It includes: A determination module, configured to determine historical processing data from a first database based on a first processing target of a first workpiece, where the historical processing data is data obtained during the processing of similar parts of the first workpiece, and the historical processing data includes first working condition data and first quality data associated with the first working condition data, and the first working condition data includes cross-correlated first workpiece data, first environmental data, first processing equipment data, and first processing load data; A processing module, configured to process the first workpiece according to the historical processing data; An acquisition module, configured to acquire first real-time processing data for processing the first workpiece, where the first real-time processing data includes second working condition data and second quality data; A comparison module, configured to compare the historical processing data with the first real-time processing data; A database processing module, configured to correct or update the first database based on the comparison result.

18. A terminal device, characterized in that, It includes a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, it implements the method according to any one of claims 1 to 13 or implements the method according to any one of claims 15 to 16.

19. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, it implements the method according to any one of claims 1 to 13 or implements the method according to any one of claims 15 to 16.

Images