CN114969466A - ISO 13399-based collaborative design and manufacturing data integration system and metal processing design method - Google Patents

ISO 13399-based collaborative design and manufacturing data integration system and metal processing design method Download PDF

Info

Publication number
CN114969466A
CN114969466A CN202210390135.8A CN202210390135A CN114969466A CN 114969466 A CN114969466 A CN 114969466A CN 202210390135 A CN202210390135 A CN 202210390135A CN 114969466 A CN114969466 A CN 114969466A
Authority
CN
China
Prior art keywords
data
cutting
identifier
layer
tool
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202210390135.8A
Other languages
Chinese (zh)
Inventor
胡贤金
邱易
杨冰
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
CHENGDU TOOL RESEARCH INSTITUTE CO LTD
Original Assignee
CHENGDU TOOL RESEARCH INSTITUTE CO LTD
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by CHENGDU TOOL RESEARCH INSTITUTE CO LTD filed Critical CHENGDU TOOL RESEARCH INSTITUTE CO LTD
Priority to CN202210390135.8A priority Critical patent/CN114969466A/en
Publication of CN114969466A publication Critical patent/CN114969466A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/906Clustering; Classification
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2228Indexing structures
    • G06F16/2246Trees, e.g. B+trees
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/242Query formulation
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/258Data format conversion from or to a database
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • G06F16/278Data partitioning, e.g. horizontal or vertical partitioning
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/40Information retrieval; Database structures therefor; File system structures therefor of multimedia data, e.g. slideshows comprising image and additional audio data
    • G06F16/43Querying
    • G06F16/432Query formulation
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/40Information retrieval; Database structures therefor; File system structures therefor of multimedia data, e.g. slideshows comprising image and additional audio data
    • G06F16/44Browsing; Visualisation therefor
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/40Information retrieval; Database structures therefor; File system structures therefor of multimedia data, e.g. slideshows comprising image and additional audio data
    • G06F16/45Clustering; Classification
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/904Browsing; Visualisation therefor
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/93Document management systems
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F30/00Computer-aided design [CAD]
    • G06F30/10Geometric CAD
    • G06F30/17Mechanical parametric or variational design
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F30/00Computer-aided design [CAD]
    • G06F30/20Design optimisation, verification or simulation
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00Arrangements for program control, e.g. control units
    • G06F9/06Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44Arrangements for executing specific programs
    • G06F9/451Execution arrangements for user interfaces
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02PCLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30Computing systems specially adapted for manufacturing

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • General Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Software Systems (AREA)
  • Geometry (AREA)
  • Multimedia (AREA)
  • Evolutionary Computation (AREA)
  • Computer Hardware Design (AREA)
  • Mathematical Physics (AREA)
  • Pure & Applied Mathematics (AREA)
  • Mathematical Optimization (AREA)
  • Computing Systems (AREA)
  • Business, Economics & Management (AREA)
  • General Business, Economics & Management (AREA)
  • Human Computer Interaction (AREA)
  • Mathematical Analysis (AREA)
  • Computational Linguistics (AREA)
  • Computational Mathematics (AREA)
  • General Factory Administration (AREA)

Abstract

The invention discloses a collaborative design manufacturing data integration system based on ISO13399 and a metal processing design method applying the same, wherein data are classified and hierarchically stored in the system, and each data is identified by an identifier, so that subsequent calling and display are facilitated; the system comprises a multi-layer structure which is connected up and down, wherein the lowest layer in the multi-layer structure is a resource object layer which is used for storing specific data, and other layers in the multi-layer structure are resource assembly layers which are used for storing the classification name or the vacancy of the specific data.

Description

ISO 13399-based collaborative design and manufacturing data integration system and metal processing design method
Technical Field
The invention relates to the field of cutting tool data expression and exchange, in particular to an ISO 13399-based collaborative design and manufacturing data integration system and a metal processing design method applying the same.
Background
In the intelligent manufacturing, data can not be exchanged between the intelligent numerical control equipment and different information systems, and the intelligent numerical control equipment is a road barricade for realizing data-driven manufacturing. It is now the case that when a new tool is used in a machining center, the user must manually enter the information of the new tool from a product sample into the machine tool and into the machining program. At this point, the supplier and tool manufacturing business professionals are required to give the necessary technical support on site. Often, the user needs to purchase various tools from different suppliers, and when a new machining center needs to be commissioned, several professionals from each supplier or tool manufacturer are usually involved. This situation fully accounts for the need for tool information standardization, i.e., the uniform format is used to accurately describe the number of tools, such as geometric parameters, cutting parameters, and solid models, of the tool.
For ISO10303 series of standards of expression and exchange of product data, China has also successively converted the product into the same name national standard GB/T16656, and currently 45 series of standards are established and released. The international standard ISO13399 series of cutting tool data expression and exchange, which is a pulse-bearing, has been developed and matured day by day 20 years of establishment and revision. At present, 32 series of standards are established and released, and 5 standards are in the process of being established, but the method is not convenient enough in the actual working process.
Specifically, network co-design manufacturing requires a large amount of data as support, while co-design manufacturing covers a large amount of cutting tool data. The ISO13399 "cutting tool data expression and standard" is always included throughout the cutting tool data, including but not limited to geometric and dimensional data, identification name data, data of various workpieces such as workpiece material, cutting tool material data, part connections such as tool system data, etc., and the types of these data are often various, such as datatable data table type, html (htm) web page type, WORD document type, JPG (BMP, PNG) picture type, PDF type, ppt (pptx) slide type, and mpeg (avi) (mpeg) video file type, etc. At present, no operating scheme for integrating and reasonably utilizing these various and dispersed data to avoid too many dispersed files exists.
For the above reasons, the present inventors have proposed an ISO 13399-based collaborative design and manufacturing data integration system and a metal fabrication design method using the same, which improve the work efficiency of network collaborative design and manufacturing operations and the industrial design and manufacturing level by storing various types of data in a unified manner.
Disclosure of Invention
In order to overcome the problems, the inventor of the present invention has made intensive studies to design a collaborative design and manufacturing data integration system based on ISO13399 and a metal working design method using the same, in which data is classified and hierarchically stored, and each data is identified by an identifier, thereby facilitating subsequent retrieval and display, and data in the system is classified according to data content, and classified names and specific data are hierarchically stored; the system comprises a multilayer structure which is connected up and down, wherein the lowest layer in the multilayer structure is a resource object layer which is used for storing specific data, and other layers in the multilayer structure are resource assembly layers which are used for storing the classification name or the vacancy of the specific data, so that the invention is completed.
Specifically, an object of the present invention is to provide an ISO 13399-based collaborative design and manufacturing data integration system in which data is classified, stored hierarchically, and each data is identified with an identifier.
The data in the collaborative design and manufacturing data integration system based on ISO13399 are classified according to data content, and classification names and specific data are stored in a layered mode;
preferably, the ISO 13399-based collaborative design and manufacturing data integration system comprises a multi-layer structure connected up and down, wherein the lowest layer in the multi-layer structure is a resource object layer for storing specific data,
other layers in the multi-layer structure are resource aggregation layers, and are used for storing the classification names or the vacancy of the specific data.
Each resource assembly layer and each resource object layer where the data are located are provided with a corresponding decimal code, and long codes obtained by sequentially splicing the decimal codes are identifiers for identifying the data.
Wherein the resource integration layer is provided with 5 layers, i.e. the long code consists of 6 decimal codes.
Wherein, in each layer of the multilayer structure, a plurality of subspaces are arranged, and the subspaces in different layers can be connected with each other in data;
the subspace is used for storing specific data, or storing the classification name of the specific data, or being vacant;
preferably, the name "advanced cutting technique" is stored in the subspace of the first layer of the resource assembly layer;
the subspace of the second layer of the resource assembly layer stores the names of the advanced cutting technologies classified according to contents: "metal cutting principle", "workpiece material", "cutting machine tool", "cutting process", "latest dynamic state of cutting technique", "typical advanced cutting technique", "typical application", "cutting technical paper";
in the third layer of the resource assembly layer, a subspace connected with a subspace where the metal cutting principle is located stores a name: "cutting motion", "cutting surface", "three elements of cutting dosage", "cutting force and cutting power", "cutting heat and cutting temperature", "basic term for metal cutting", "metal cutting tool reamer term", "metal cutting tool milling cutter term", "metal cutting tool round die term", "metal cutting tool twist drill term";
in the third layer of the resource assembly layer, a subspace connected with a subspace where the workpiece material is located stores a name: "common material", "Chinese and foreign material contrast", "machinability of workpiece material", "machinability of common material";
in the third layer of the resource assembly layer, a subspace connected with a subspace where the 'cutting machine tool' is located stores a name: "machining center", "numerical control lathe", "numerical control milling machine", "lathes", "milling machines", "drilling machines", "boring machines", "threading machine", "broaching machine", "electric machine tool", "saws", "gear machine tool", "numerical control series functional parts and machine tool electric appliance", "machine tool technical parameters", "machine tool usage and Chinese and English contrast";
in the third layer of the resource assembly layer, a subspace connected with a subspace where the 'cutting tool' is located stores a name: "tool base material", "tool construction parameters", "tool surface modification", "tool type", "tool system";
in the third layer of the resource assembly layer, a subspace connected with a subspace where the 'cutting process' is located stores a name: "cutting aid", "cutting amount", "cutting medium", "cutting reference process";
in the third layer of the resource assembly layer, a subspace connected with a subspace where the latest dynamic state of the cutting technology is located stores a name: "related results", "paper refinement", "meeting information", "development dynamics";
in the third layer of the resource assembly layer, a subspace connected with a subspace where the "typical advanced cutting technology" is located stores a name: "high-speed cutting processing technique", "dry cutting processing technique", "hard cutting processing technique", "precision and ultra-precision cutting processing technique", "virtual cutting processing technique";
in the third layer of the resource assembly layer, a subspace connected with a subspace in which the "typical application" is located stores a name: the machining method comprises the steps of automobile part machining, mould machining, aerospace part machining and efficient cutting.
Wherein the data type format types stored in the ISO 13399-based collaborative design and manufacturing data integration system include: data table type, web page type, WORD document type, picture type, PDF type, slide type, video file type;
wherein, the Data form type Data information is stored in the Data _ tableList Data form, and a field is used to store the actual Data form format Data form name,
for data of a web page type, a WORD document type, a picture type, a PDF type, a slide show type and a video file type, in the storage process, the data is firstly converted into long binary data and then stored into a database.
The data consulting and calling method in the system comprises the following steps:
step 1, searching and locking concrete data in a resource integration layer through an identifier, locking a classification name of the concrete data,
step 2, listing the content stored in the layer and the next layer for the classification name in each resource integration layer, and listing the specific content for the resource object layer, all presenting in the data display area; preferably, the presentation is via a tree-like multi-level menu.
Wherein, in the step 2, the data of the web page type, the WORD document type, the PDF type and the slide type are displayed by adopting a WebBrowser control for browsing the homepage,
wherein, the WORD document data is converted into a webpage file and then presented,
the webpage type, PDF type and slide type data are directly presented through a navigator function of the webBrowser control;
preferably, in the presentation process of the data in the form of the data table, when the number of rows of the data table is too large or the number of columns of the data table is too large, a temporary web page file is generated first, then the temporary web page file temp. htm is called, and then the data presentation is performed by using the navigator attribute of the webBrowser1. navigator of the webBrowser control;
and when the number of rows of the data table is not large and the number of columns of the data table is not large, directly generating a webpage character string sText, and presenting data by using a documentText attribute webBrower 1 of the webBrowser control.
The invention also provides a method for designing metal processing by using the cooperative design and manufacturing data integration system based on ISO13399, which comprises the following steps:
step a, designing a machining procedure of a part according to the size and the technological requirements of the part to be machined;
step b, designing a machining process step of the part based on the machining process;
in step b, specific values of cutting parameters, including cutting width, feed amount and rpm, involved in the machining step are obtained by calling data in an ISO 13399-based collaborative design and manufacturing data integrated system through a query module.
The query module is provided with 5 query modules, namely a query module of cutting data based on a cutting test, a query module of general cutting data, a query module of heavy cutting data, a query module of domestic manufacturer cutting data and a query module of foreign manufacturer cutting data, and in the step b, one or more query modules can be optionally selected for query.
The invention has the advantages that:
according to the ISO 13399-based collaborative design and manufacturing data integration system and the application method thereof, the system can store a large amount of multiple types of collaborative design and manufacturing data, due to the limitation of the storage mode of the traditional database, the content and page number of WORD documents and PDF documents are often large, the storage is not suitable for centralized management when the documents are stored outside the database, and the copied documents are easy to miss, so that the various types of data are uniformly stored and used through the integration system, and the data are conveniently copied together and also can be stored with a certain degree of confidentiality. In addition, on the basis, single-machine version software and network version software can be developed to inquire and use various data, and important data sources are provided for network collaborative design and manufacturing operation.
Drawings
FIG. 1 illustrates a preferred embodiment according to the present invention;
FIG. 2 is a diagram showing a table Data _ Info in the present invention;
FIG. 3 shows the contents of the data table "2070110010001-workpiece surface in the present invention;
FIG. 4 shows the contents of an example of high speed hard turning of 2070804040020_ CBN100 inserts in the present invention;
FIG. 5 is a diagram illustrating a tree menu pop-up interface in accordance with the present invention;
FIG. 6 shows Table 1 of data table sjb of the database in the present invention;
FIG. 7 shows Table 2 of data table sjb of the database in the present invention;
FIG. 8 illustrates a query interface for the metal cutting principle of the present invention;
FIG. 9 illustrates a query interface in an embodiment of the invention.
Detailed Description
The invention is explained in more detail below with reference to the figures and examples. The features and advantages of the present invention will become more apparent from the description.
The word "exemplary" is used exclusively herein to mean "serving as an example, embodiment, or illustration. Any embodiment described herein as "exemplary" is not necessarily to be construed as preferred or advantageous over other embodiments. While the various aspects of the embodiments are presented in drawings, the drawings are not necessarily drawn to scale unless specifically indicated.
According to the collaborative design and manufacturing data integration system based on ISO13399 provided by the invention, as shown in FIG. 1, data are classified and stored hierarchically, and each data is identified by an identifier, so that the data storage space is reasonably distributed, and the display and the retrieval are convenient.
In a preferred embodiment, the data in the ISO 13399-based collaborative design and manufacturing data integration system is classified according to data content, and classification names and specific data are stored hierarchically;
preferably, the ISO 13399-based collaborative design and manufacturing data integration system includes a plurality of layers of virtual storage space structures connected one above the other, and the lowest layer in the plurality of layers is a resource object layer for storing specific data, and the specific data has a variety of formats, and may be any one or combination of a table, a web page, a WORD document, a picture, a PDF, a slide, a video file, and the like.
Other layers in the multi-layer structure are resource aggregation layers, and are used for storing the classification names or the vacancy of the specific data.
Preferably, each resource assembly layer and resource object layer where the data is located correspond to a decimal code, and the long codes obtained by sequentially splicing the decimal codes are identifiers for identifying the data.
The resource integration layer is provided with 5 layers, i.e. the long code consists of 6 decimal codes.
For example, the top layer "advanced cutting technique" of the general class level 1, i.e., the resource integration layer, is defined as "207", the second top layer "metal cutting principle" of the level 2, i.e., the resource integration layer, is "01", and the "cutting technique paper" is "09". The "cutting motion" is the 3 rd level under the 2 nd level "metal cutting principle" and is defined as "01", and the "primary motion (one)" is the 4 th level under the 3 rd level "cutting motion", and there is no next level in the resource assembly layer, so the 5 th level after the "primary motion (one)" is empty, the corresponding storage location is empty, the resource object layer is also "01", and the identifier of the specific data stored in the resource object layer is "2070101010001".
In a preferred embodiment, in each layer of the multi-layer structure, a plurality of subspaces are provided, and the subspaces located in different layers can be data-connected to each other;
the subspace is used for storing specific data, or storing the classification name of the specific data, or being vacant;
preferably, the name "advanced cutting technique" is stored in the subspace of the first layer of the resource aggregation layer;
the subspace of the second layer of the resource assembly layer is stored with the names of the advanced cutting technologies after the advanced cutting technologies are classified according to the volumes: "metal cutting principle", "workpiece material", "cutting machine", "cutting tool", "cutting process", "latest dynamics of cutting technique", "typical advanced cutting technique", "typical application", "cutting technical paper";
in the third layer of the resource assembly layer, a subspace connected with a subspace where the metal cutting principle is located stores a name: "cutting motion", "cutting surface", "three elements of cutting dosage", "cutting force and cutting power", "cutting heat and cutting temperature", "basic term for metal cutting tool reamer term", "term for metal cutting tool milling cutter", "term for metal cutting tool round die", "term for metal cutting tool twist drill;
in the resource object layer, the subspace connected with the subspace where the cutting motion is stored with specific data: "primary motion", "feed motion", and "resultant cutting motion".
In the resource object layer, the subspace connected with the subspace where the 'cutting surface' is located stores specific data: "surface to be machined", "transition surface", "machined surface".
In the resource object layer, specific data are stored in a subspace connected with a subspace where the three cutting consumption elements are located: "cutting speed", "feed amount", "back bite amount".
In the resource object layer, the subspace connected with the subspace where the cutting force and the cutting power are stored with specific data: "cutting force and cutting power".
In the resource object layer, specific data are stored in a subspace connected with a subspace where the cutting heat and the cutting temperature are located: "generation and conduction of cutting heat".
In the fourth layer of the resource assembly layer, a subspace connected with the subspace where the basic term of metal cutting is stored has a name: "workpiece surface", "geometry of the active part of the tool", "motion of the tool and the workpiece", "reference system", "tool angle and working angle", "chip breaker table (groove)", "geometrical quantity and motion quantity in cutting", "force, energy, power".
In the resource object layer, specific data are stored in a subspace connected with a subspace where the workpiece surface is located: "workpiece surface", "surface to be machined", "machined surface", "transition surface".
In the application, the metal cutting principle data set mainly includes the characteristics of the cutting process, the definition, the calculation method and the formula of cutting basic elements, and the classical measurement method and the example of some cutting elements. The data of the part is in many text forms, mainly refers to the common sense introduction of cutting knowledge, and is suitable for teachers and students in various colleges and universities to know and master the cutting basic knowledge.
Preferably, in the third layer of the resource assembly layer, a subspace connected to a subspace in which the "workpiece material" is located stores a name: "common material", "Chinese and foreign material control", "machinability of workpiece material", and "machinability of common material".
In the present application, data such as types, codes, mechanical performance parameters, main characteristics and uses, and machinability codes of various common materials are mainly collected in a workpiece material data set. The method is suitable for reference in the cutting processing and design manufacturing processes of various departments, institutes and enterprises.
Preferably, in the third layer of the resource assembly layer, a subspace connected to a subspace in which the "cutting machine" is located stores a name: "machining center", "numerical control lathe", "numerical control milling machine", "lathes", "milling machines", "drilling machines", "boring machines", "threading machine", "broaching machine", "electric machine tool", "saws", "gear machine tool", "numerical control series functional parts and machine tool electric appliance", "machine tool technical parameters", "machine tool usage and Chinese and English contrast";
in the application, the relevant parameter information of the machine tool of each main numerical control machine tool and machining center manufacturer in China is mainly collected in the data set of the cutting machine tool, and the data is more in a text form. The method is suitable for reference in the selection, design and manufacturing processes of processing equipment of various departments, institutes and enterprises.
Preferably, in the third layer of the resource assembly layer, a subspace connected to the subspace where the "cutting tool" is located stores a name: "tool base material", "tool construction parameters", "tool surface modification", "tool type", "tool system";
in the fourth layer of the resource assembly layer, a subspace connected with a subspace where the 'cutter base material' is located stores a name: "high-speed steel tool material", "hard alloy tool material", "ceramic tool material", "diamond tool material", "cubic boron nitride tool material", "ISO hard alloy material".
In the fifth layer of the resource integration layer, the subspaces of the "high-speed steel tool material", "hard alloy tool material", "ceramic tool material", "diamond tool material", "cubic boron nitride tool material" and "ISO hard alloy material" are all stored with the names: the subspaces of the "material classes" and "manufacturers" are connected. I.e. in this layer at least 12 subspaces are provided for storing 6 "material class" names and 6 "manufacturer" names.
In the resource object layer connected to the fifth layer, the subspace where the resource object layer is connected to the subspace where the "material class" is located stores specific data: the identifier of the steel number is 207040101 (01-06) 01, the identifier of the steel number is 207040101 (01-06) 02, the identifier of the steel number is 207040101 (01-06) 03, the identifier of the steel number is 3925 (01-06) 04, the identifier of the steel number is 207040101 (01-06) 05, the identifier of the steel number is 207040101 (01-06) 06, and the identifier of the steel number is mechanical property, and the identifier of the steel number is 207040101 (01-06) 04 and the identifier of the steel number is 207040101 (01-06).
In the resource object layer connected to the fifth layer, the subspace where the resource object layer is connected to the subspace of the "manufacturer" stores specific data: "manufacturer" whose identifier is 207040102 (01-06) 01, "current brand", its identifier is 207040102 (01-06) 02, "former brand", its identifier is 207040102 (01-06) 03, "equivalent to ISO", its identifier is 207040102 (01-06) 04, "density minimum", its identifier is 207040102 (01-06) 05, "density maximum", its identifier is 207040102 (01-06) 06, "strength MPa", its identifier is 207040102 (01-06) 07, "hardness HRa", its identifier is 207040102 (01-06) 08, "use", its identifier is 207040102 (01-06) 09.
In the fifth layer of the resource assembly layer, the subspace connected with the hard alloy cutter material and the ceramic cutter material stores the name: "domestic" and "foreign".
In the resource object layer, specific data are stored in subspaces connected with subspaces where the ceramic cutter material is located and subspaces where the ceramic cutter material is located: "blade grade" with identifier 2070401030101, "composition" with identifier 2070401030102, "average grain size" with identifier 2070401030103, "manufacturing method" with identifier 2070401030104 "density" with identifier 2070401030105, "hardness HRA (HRN 15)", with identifier 2070401030106, "bending strength (MPa)", with identifier 2070401030107, "fracture toughness (MN/m ^3/2) (impact toughness KJ/m ^ 2)", with identifier 2070401030108, "development unit" with identifier 2070401030109.
In the resource object layer, specific data are stored in subspaces connected with subspaces where the ceramic cutter material is located and subspaces where the foreign materials are located: "country", its identifier 2070401030201, "manufacturing company", its identifier 2070401030202, "brand", its identifier 2070401030203, "principal component", its identifier 2070401030204 "manufacturing method", its identifier 2070401030205.
In the resource object layer, specific data are stored in a subspace connected with a subspace where the diamond cutter material is located: "blade grade" with identifier 2070401040001, "vickers hardness", with identifier 2070401040002, "Knoop HK hardness", with identifier 2070401040003, "flexural strength", with identifier 2070401040004, "compressive strength", with identifier 2070401040005, "modulus of elasticity", with identifier 2070401040006, "density", with identifier 2070401040007, "coefficient of thermal expansion", with identifier 2070401040008, "coefficient of thermal conductivity", with identifier 2070401040009, "thermal stability", with identifier 2070401040010, "notes", with identifier 2070401040011.
In the resource object layer, specific data are stored in a subspace connected with a subspace where the cubic boron nitride cutter material is located: "blade grade" with identifier 2070401050001, "vickers hardness", with identifier 2070401050002, "Knoop HK hardness", with identifier 2070401050003, "flexural strength", with identifier 2070401050004, "compressive strength", with identifier 2070401050005, "modulus of elasticity", with identifier 2070401050006, "density", with identifier 2070401050007, "coefficient of thermal expansion", with identifier 2070401050008, "coefficient of thermal conductivity", with identifier 2070401050009, "thermal stability", with identifier 2070401050010, "notes", with identifier 2070401050011.
In the resource object layer, the subspace connected with the subspace where the 'ISO hard alloy material' is located stores specific data: "classification number" whose identifier is 2070401060001, "class of material being processed", whose identifier is 2070401060002, "identification color", whose identifier is 2070401060003, "material being processed", whose identifier is 2070401060004 "use and working condition", and whose identifier is 2070401060005.
In the application, parameters such as the brand, the code, the physical and chemical properties, the application range and the like of various cutter materials are mainly collected in the cutter material data set. The method is suitable for reference in the selection and design and manufacturing processes of the cutter in various research institutes and enterprises.
And the name is stored in the subspace of the fourth layer of the resource assembly layer, which is connected with the subspace where the 'cutter structure parameter' is located: the geometrical angle of a turning and boring single-edge cutter, the geometrical angle of a hard alloy boring cutter, the geometrical angle of a high-speed steel twist drill, the geometrical angle of a high-speed steel reamer, the geometrical angle of a hard alloy reamer, the geometrical angle of a face milling cutter, the geometrical angle of a three-edge milling cutter and the geometrical angle of a high-speed steel end milling cutter.
In the resource object layer, specific data are stored in a subspace connected with a subspace where the "boring single-edged tool geometric angle" is located: "workpiece material machinability code", identifier 2070402010001, "class of workpiece material machinability code", identifier 2070402010002, "subclass of workpiece material machinability code", identifier 2070402010003, "hardness standard", identifier 2070402010004, "hardness range low value", identifier 2070402010005, "hardness range high value", identifier 2070402010006, "high speed steel tool edge rake angle", identifier 2070402010007, "high speed steel tool primary rake angle", identifier 2070402010008, "high speed steel tool secondary relief angle", identifier 2070402010009, "high speed steel tool primary relief angle", identifier 2070402010010, "cemented carbide uncoated braze tool edge rake angle", identifier 2070402010011, "cemented carbide uncoated braze tool primary rake angle", identifier 2070402010012, "cemented carbide uncoated braze tool relief angle", identifier 2070402010013, "cemented carbide indexable tool edge rake angle", its identifier is 2070402010014, "carbide indexable tool main rake angle", its identifier is 2070402010015, "carbide indexable tool relief angle", its identifier is 2070402010016.
In the resource object layer, specific data are stored in a subspace connected with a subspace where the 'geometric angle of the hard alloy boring cutter' is located: "workpiece material machinability code", identifier 2070402020001, category "workpiece material machinability code, identifier 2070402020002, category" workpiece material machinability code ", identifier 2070402020003," hardness standard ", identifier 2070402020004," hardness range low value ", identifier 2070402020005," hardness range high value ", identifier 2070402020006," back rake angle or radial rake angle ", identifier 2070402020007," side rake angle or axial rake angle ", identifier 2070402020008," radial relief angle ", identifier 2070402020009," side relief angle ", identifier 2070402020010.
In the resource object layer, specific data are stored in a subspace connected with a subspace where the 'high-speed steel twist drill geometric angle' is located: "workpiece material machinability code", identifier 2070402020001, category "workpiece material machinability code, identifier 2070402030002, category" workpiece material machinability code ", identifier 2070402030003," hardness standard ", identifier 2070402030004," hardness range low value ", identifier 2070402030005," hardness range high value ", identifier 2070402030006," bit pattern ", identifier 2070402030007," top angle ", identifier 2070402030008," clearance angle ", identifier 2070402030009," helix angle ", identifier 2070402030010," sharpening shape ", identifier 2070402030011.
In the resource object layer, specific data are stored in a subspace connected with a subspace where the 'geometric angle of the high-speed steel reamer' is located: "tool diameter range" identified by 2070402040001, "land width" identified by 2070402040002, "first radial relief angle" identified by 2070402040003, "cone cutting angle" identified by 2070402040004, "cone cutting relief angle" identified by 2070402040005.
In the resource object layer, specific data are stored in a subspace connected with a subspace where the 'geometrical angle of the cemented carbide reamer' is located: "tool diameter range", identified by 2070402050001, "land or circular land", identified by 2070402050002, "first radial relief angle", identified by 2070402050003, "second relief angle", identified by 2070402050004, "lead angle length", identified by 2070402050005, "cutting cone first relief angle", identified by 2070402050006, "cutting cone second relief angle", identified by 2070402050007.
In the resource object layer, specific data are stored in a subspace connected with a subspace where the 'face milling cutter geometric angle' is located: "workpiece material machinability code", identifier 2070402060001, category of "workpiece material machinability code", identifier 2070402060002, category of "workpiece material machinability code", identifier 2070402060003, "hardness standard", identifier 2070402060004, "hardness range low value", identifier 2070402060005, "hardness range high value", identifier 2070402060006, "high speed face cutter axial rake", identifier 2070402060007, "high speed face cutter radial rake", identifier 2070402060008, "indexable carbide face cutter axial rake", identifier 2070402060009, "indexable carbide face cutter radial rake", identifier 2070402060010, "welded carbide face cutter axial rake", identifier 2070402060011, "welded carbide face cutter radial rake", identifier 2070402060012, "lead", identifier 2070402060013, "side slip angle" identified by 20704020600134, "axial relief angle" identified by 2070402060015, "radial relief angle 2070402060016.
In the resource object layer, concrete data are stored in a subspace connected with a subspace where the geometric angle of the three-edge milling cutter is located: "workpiece material machinability code", identifier 2070402070001, "class of workpiece material machinability code", identifier 2070402070002, "subclass of workpiece material machinability code", identifier 2070402070003, "hardness standard", identifier 2070402070004, "hardness range low value", identifier 2070402070005, "hardness range high value", identifier 2070402070006, "high speed steel mill axial rake", identifier 2070402070007, "high speed steel mill radial rake", identifier 2070402070008, "high speed steel mill axial relief", identifier 2070402070009, "high speed steel mill radial relief", identifier 2070402070010, "carbide mill axial rake", identifier 2070402070011, "carbide mill radial rake", identifier 2070402070012, "carbide mill axial relief", identifier 2070402070013, "carbide mill radial relief", its identifier is 2070402070014.
In the resource object layer, specific data are stored in a subspace connected with a subspace of the geometric angle of the high-speed steel end mill: "nominal tool diameter", identifier 2070402080001, "radial first relief angle for general use 30 to 35 degrees helix angle", identifier 2070402080002, "main land width for general use 30 to 35 degrees helix angle", identifier 2070402080003, "radial second relief angle for general use 30 to 35 degrees helix angle", identifier 2070402080004, "radial first relief angle for 35 to 45 degrees helix angle", identifier 2070402080005, "main land width for 35 to 45 degrees helix angle", identifier 2070402080006, "radial second relief angle for 35 to 45 degrees helix angle", identifier 2070402080007.
Preferably, in the third layer of the resource assembly layer, a subspace connected with the subspace where the "cutting process" is located stores a name: "cutting aid", "cutting amount", "cutting medium" and "cutting process".
In the fourth layer of the resource assembly layer, a subspace connected with the subspace where the cutting consumption is stored is named as: "single-edge and indexable tool turning", with identifier 2070502020100, "cut and form tool turning", with identifier 2070502020200, "boring", with identifier 2070502020300, "general drilling", with identifier 2070502020400, "deep hole drilling", with identifier 2070502020500, "reaming", with identifier 2070502020600, "face milling", with identifier 2070502020700, "three-edge milling", with identifier 2070502020800, "end milling (peripheral milling)", with identifier 2070502020900, "end milling (slot milling)", with identifier 2070502021000, "artificial polycrystalline diamond", with identifier 2070502021100, "average unit power consumption in turning, drilling and milling", with identifier 2070502021200.
In the resource object layer, a subspace connected with a subspace where the single edge and the indexable tool turning are located stores specific data: "workpiece material machinability code broad", with an identifier of 2070502020101, "workpiece material machinability code subclass", with an identifier of 2070502020102, "workpiece material hardness range", with an identifier of 2070502020103, "depth of cut", with an identifier of 2070502020104, "high speed steel tool cutting speed recommendation", with an identifier of 2070502020105, "high speed steel tool feed recommendation", with an identifier of 2070502020106, "high speed steel tool material ISO code", with an identifier of 2070502020107, "cemented carbide uncoated braze tool cutting speed recommendation", with an identifier of 2070502020108, "cemented carbide uncoated indexable tool cutting speed recommendation", with an identifier of 2070502020109, "cemented carbide uncoated tool feed recommendation", with an identifier of 2070502020110, "cemented carbide uncoated tool material ISO code", with an identifier of 2070502020111, "cemented carbide coated tool cutting speed recommendation", its identifier is 2070502020112, "carbide coated tool feed recommendation", its identifier is 2070502020113, "carbide coated tool material ISO code", its identifier is 2070502020114.
In the resource object layer, specific data are stored in a subspace connected with a subspace where the cutting and forming tool turning is located: "workpiece material machinability code class", whose identifier is 2070502020201, "workpiece material machinability code subclass", whose identifier is 2070502020202, "workpiece material hardness range", whose identifier is 2070502020203, "tool cutting speed recommendation", whose identifier is 2070502020204, "feed amount at cutting blade width of 1.5 mm", whose identifier is 2070502020205, "feed amount at cutting blade width of 3 mm", whose identifier is 2070502020206, "feed amount at cutting blade width of 6 mm", whose identifier is 2070502020207, "feed amount at forming blade width of 12 mm", whose identifier is 2070502020208, "feed amount at forming blade width of 18 mm", whose identifier is 2070502020209, "feed amount at forming blade width of 25 mm", whose identifier is 2070502020210, "feed amount at forming blade width of 35 mm", whose identifier is 2070502020211, "feed amount at forming blade width of 50 mm", and whose identifier is 2070502020212, "tool material ISO code", its identifier is 2070502020213.
In the resource object layer, the subspace connected with the subspace where the boring is located stores specific data: "workpiece material machinability code broad", with an identifier of 2070502020301, "workpiece material machinability code subclass", with an identifier of 2070502020302, "workpiece material hardness range", with an identifier of 2070502020303, "depth of cut", with an identifier of 2070502020304, "high speed steel tool cutting speed recommendation", with an identifier of 2070502020305, "high speed steel tool feed recommendation", with an identifier of 2070502020306, "high speed steel tool material ISO code", with an identifier of 2070502020307, "cemented carbide uncoated braze tool cutting speed recommendation", with an identifier of 2070502020308, "cemented carbide uncoated indexable tool cutting speed recommendation", with an identifier of 2070502020309, "cemented carbide uncoated tool feed recommendation", with an identifier of 2070502020310, "cemented carbide uncoated tool material ISO code", with an identifier of 2070502020311, "cemented carbide coated tool cutting speed recommendation", its identifier is 2070502020312, "carbide coated tool feed recommendation", its identifier is 2070502020313, "carbide coated tool material ISO code", its identifier is 2070502020314.
In the resource object layer, specific data are stored in a subspace connected with a subspace where the 'common drilling' is located: "workpiece material machinability code large class", whose identifier is 2070502020401, "workpiece material machinability code small class", whose identifier is 2070502020402, "workpiece material hardness range", whose identifier is 2070502020403, "recommended cutting speed", whose identifier is 2070502020404, "feed amount when nominal diameter of hole is 1.5 mm", whose identifier is 2070502020405, "feed amount when nominal diameter of hole is 3 mm", whose identifier is 2070502020406, "feed amount when nominal diameter of hole is 6 mm", whose identifier is 2070502020407, "feed amount when nominal diameter of hole is 12 mm", whose identifier is 2070502020408, "feed amount when nominal diameter of hole is 18 mm", whose identifier is 2070502020409, "feed amount when nominal diameter of hole is 25 mm", whose identifier is 2070502020410, "feed amount when nominal diameter of hole is 35 mm", whose identifier is 2070502020411, "feed amount when nominal diameter of hole is 50 mm", its identifier is 2070502020412, "tool material ISO code", its identifier is 2070502020413.
In the resource object layer, specific data are stored in a subspace connected with a subspace where the deep hole drilling is located: "workpiece material machinability code large class", whose identifier is 2070502020501, "workpiece material machinability code small class", whose identifier is 2070502020502, "workpiece material hardness range", whose identifier is 2070502020503, "recommended cutting speed", whose identifier is 2070502020504, "feed amount low value when nominal diameter of hole is 2 to 4 mm", whose identifier is 2070502020505, "feed amount high value when nominal diameter of hole is 2 to 4 mm", whose identifier is 2070502020506, "feed amount low value when nominal diameter of hole is 4 to 6 mm", whose identifier is 2070502020507, "feed amount high value when nominal diameter of hole is 4 to 6 mm", whose identifier is 2070502020508, "feed amount low value when nominal diameter of hole is 6 to 12 mm", whose identifier is 2070502020509, "feed amount high value when nominal diameter of hole is 6 to 12 mm", and whose identifier is 2070502020510, "feed amount low value when nominal diameter of hole is 12 to 18 mm", the identifier is 2070502020511, the identifier is 2070502020512, the identifier is 2070502020513, the identifier is 2070502020514, the identifier is 2070502020515, and the identifier is 2070502020516, wherein the identifier is "feed amount high value when the nominal diameter of the hole is 12-18 mm", the identifier is 2070502020512, the identifier is 2070502020513, the identifier is "feed amount high value when the nominal diameter of the hole is 18-25 mm", the identifier is 2070502020515, and the identifier is "cutter material ISO code".
In the resource object layer, the subspace connected with the subspace where the "reaming" is located stores specific data: "large class of workpiece material machinability code", whose identifier is 2070502020601, "small class of workpiece material machinability code", whose identifier is 2070502020602, "range of workpiece material hardness", whose identifier is 2070502020603, "recommended value of rough reaming speed of high-speed steel reamer", whose identifier is 2070502020604, "rough reaming feed amount when diameter of high-speed steel reamer is 3 mm", whose identifier is 2070502020605, "rough reaming feed amount when diameter of high-speed steel reamer is 6 mm", whose identifier is 2070502020606, "rough reaming feed amount when diameter of high-speed steel reamer is 12 mm", whose identifier is 2070502020607, "rough reaming feed amount when diameter of high-speed steel reamer is 25 mm", whose identifier is 2070502020608, "rough reaming feed amount when diameter of high-speed steel reamer is 35 mm", whose identifier is 2070502020609, "rough reaming feed amount when diameter of high-speed steel reamer is 50 mm", whose identifier is 2070502020610, "recommended value of finish reaming speed of high-speed steel reamer", the identifier is 2070502020611, the identifier is 2070502020612, the identifier is finish reaming feed amount when the diameter of the high-speed steel reamer is 6mm, the identifier is 2070502020613, the identifier is finish reaming feed amount when the diameter of the high-speed steel reamer is 12mm, the identifier is 2070502020614, the identifier is finish reaming feed amount when the diameter of the high-speed steel reamer is 25mm, the identifier is 2070502020615, the identifier is finish reaming feed amount when the diameter of the high-speed steel reamer is 35mm, the identifier is 2070502020616, the identifier is finish reaming feed amount when the diameter of the high-speed steel reamer is 35mm, the identifier is 2070502020617, the identifier is finish reaming feed amount when the diameter of the high-speed steel reamer is 50mm, the identifier is 2070502020618, the recommended value of the rough reaming speed of the cemented carbide reamer, the identifier is 2070502020619, the rough reaming feed amount when the diameter of the cemented carbide reamer is 3mm, the identifier is 2070502020620, the identifier is 2070502020621, the identifier is 2070502020622, the identifier is coarse reamer feed when the diameter of the cemented carbide reamer is 25mm, the identifier is 2070502020623, the identifier is coarse reamer feed when the diameter of the cemented carbide reamer is 35mm, the identifier is 2070502020624, the identifier is coarse reamer feed when the diameter of the cemented carbide reamer is 50mm, the identifier is 2070502020625, the identifier is a recommended value of finish reaming cutting speed of the cemented carbide reamer, the identifier is 2070502020626, the identifier is finish reamer feed when the diameter of the cemented carbide reamer is 3mm, the identifier is 2070502020627, the identifier is finish reamer feed when the diameter of the cemented carbide reamer is 6mm, the identifier is 2070502020628, the identifier is finish reamer feed when the diameter of the cemented carbide reamer is 12mm, the identifier is 2070502020629, the identifier is finish reamer feed when the diameter of the cemented carbide reamer is 25mm, the identifier is 2070502020630, and the identifier is finish reamer feed when the diameter of the cemented carbide reamer is 35mm, the identifier of the reamer is 2070502020631, the identifier of the finish reaming feed when the diameter of the cemented carbide reamer is 50mm is 2070502020632, and the identifier of the reamer is 2070502020633.
In the resource object layer, specific data are stored in a subspace connected with a subspace where the plane milling is located: "workpiece material machinability code broad", with an identifier of 2070502020701, "workpiece material machinability code subclass", with an identifier of 2070502020702, "workpiece material hardness range", with an identifier of 2070502020703, "depth of cut", with an identifier of 2070502020704, "high speed steel tool cutting speed recommendation", with an identifier of 2070502020705, "high speed steel tool feed recommendation", with an identifier of 2070502020706, "high speed steel tool material ISO code", with an identifier of 2070502020707, "cemented carbide uncoated braze tool cutting speed recommendation", with an identifier of 2070502020708, "cemented carbide uncoated indexable tool cutting speed recommendation", with an identifier of 2070502020709, "cemented carbide uncoated tool feed recommendation", with an identifier of 2070502020710, "cemented carbide uncoated tool material ISO code", with an identifier of 2070502020711, "cemented carbide coated tool cutting speed recommendation", its identifier is 2070502020712, "carbide coated tool feed recommendation", its identifier is 2070502020713, "carbide coated tool material ISO code", its identifier is 2070502020714.
In the resource object layer, concrete data are stored in a subspace connected with a subspace where the three-edge milling is located: "workpiece material machinability code broad", with an identifier of 2070502020801, "workpiece material machinability code subclass", with an identifier of 2070502020802, "workpiece material hardness range", with an identifier of 2070502020803, "depth of cut", with an identifier of 2070502020804, "high speed steel tool cutting speed recommendation", with an identifier of 2070502020805, "high speed steel tool feed recommendation", with an identifier of 2070502020806, "high speed steel tool material ISO code", with an identifier of 2070502020807, "cemented carbide uncoated braze tool cutting speed recommendation", with an identifier of 2070502020808, "cemented carbide uncoated indexable tool cutting speed recommendation", with an identifier of 2070502020809, "cemented carbide uncoated tool feed recommendation", with an identifier of 2070502020810, "cemented carbide uncoated tool material ISO code", with an identifier of 2070502020811, "cemented carbide coated tool cutting speed recommendation", its identifier is 2070502020812, "carbide coated tool feed recommendation", its identifier is 2070502020813, "carbide coated tool material ISO code", its identifier is 2070502020814.
In the resource object layer, specific data are stored in a subspace connected with a subspace where an end mill (peripheral mill) is located: "workpiece material machinability code large class" with an identifier of 2070502020901, "workpiece material machinability code subclass" with an identifier of 2070502020902, "workpiece material hardness range", with an identifier of 2070502020903, "radial depth of cut", with an identifier of 2070502020904, "high speed steel mill cutting speed recommendation", with an identifier of 2070502020905, "feed amount at 10mm diameter of high speed steel mill", with an identifier of 2070502020906, "feed amount at 12mm diameter of high speed steel mill", with an identifier of 2070502020907, "feed amount at 18mm diameter of high speed steel mill", with an identifier of 2070502020908, "feed amount at 25 to 50mm diameter of high speed steel mill", with an identifier of 2070502020909, "high speed steel tool material recommendation ISO code", with an identifier of 2070502020910, "cemented carbide cutting speed recommendation", with an identifier of 2070502020911, "feed amount at 10mm diameter of cemented carbide", the identifier is 2070502020912, the identifier is 2070502020913, the identifier is 2070502020914, the identifier is 2070502020915, and the identifier is 2070502020916, which is a recommended ISO code for cemented carbide cutting tool materials.
In the resource object layer, specific data are stored in a subspace connected with a subspace where an end mill (slot milling) is located: "workpiece material machinability code class", whose identifier is 2070502021001, "workpiece material machinability code subclass", whose identifier is 2070502021002, "workpiece material hardness range", whose identifier is 2070502021003, "axial depth of cut", whose identifier is 2070502021004, "cutting speed recommendation", whose identifier is 2070502021005, "feed amount when groove width is 10 mm", whose identifier is 2070502021006, "feed amount when groove width is 12 mm", whose identifier is 2070502021007, "feed amount when groove width is 18 mm", whose identifier is 2070502021008, "feed amount when groove width is 25 to 50 mm", whose identifier is 2070502021009, "tool material recommended ISO code", whose identifier is 2070502021010.
In the resource object layer, specific data are stored in a subspace connected with a subspace where the artificial polycrystalline diamond is located: "machined part and material" has identifier 2070502021101, "process", identifier 2070502021102, "cutting speed", identifier 2070502021103, "feed", identifier 2070502021104, "backdraft", identifier 2070502021105, "nose arc half", identifier 2070502021106, "blade inclination", identifier 2070502021107, "rake", identifier 2070502021108, "relief", identifier 2070502021109, "relative performance", identifier 2070502021110.
In the fourth layer of the resource assembly layer, a subspace connected with the subspace where the 'cutting medium' is located stores a name: "black (colored) metal turning" with the identifier 20705020403(4)00, "superalloy turning" with the identifier 2070502040500, "bead weld spray turning" with the identifier 2070502040600, "face milling" with the identifier 2070502040700, "end mill milling" with the identifier 2070502040800, "ISO base data" with the identifier 2070502040900.
In the resource object layer, the subspace connected with the subspace where the "black (colored) metal turning" is located stores specific data: "the processed material" has an identifier of 20705020403(4), (01), "the recommended tool brand", and has an identifier of 20705020403(4), "the minimum of the cutting depth one", and has an identifier of 20705020403(4), "the minimum of the feed one", and has an identifier of 20705020403(4), "the minimum of the cutting speed one", and has an identifier of 20705020403(4), "the maximum of the cutting depth one", and has an identifier of 20705020403(4), "the maximum of the feed one", and has an identifier of 2070502044), "the minimum of the cutting depth two", and has an identifier of 20705020403(4), "the minimum of the feed two", and has an identifier of 20720403 (4), "the minimum of the cutting speed two", and has an identifier of 20720403 (4), "the maximum of the cutting depth two", and has an identifier of the maximum of the cutting depth two of the 05020403(4), "the maximum of the feed two of the 12)," the feed two "(0502044)," the maximum of the 05020403 ", (20720403), (0502044)", the identifiers are 20705020403(4)13, maximum cutting speed two, 20705020403(4)14, minimum cutting depth three, 20705020403(4)15, minimum feed three, 20705020403(4)16, minimum cutting speed three, 20705020403(4)17, maximum cutting depth three, 20720405020403 (4)18, maximum feed three, 20705020403(4)19, maximum cutting speed three, and 20705020403(4) 20.
In the resource object layer, the subspace connected with the subspace where the high-temperature alloy turning is located stores specific data: "strength of material being worked", identifier 2070502040501, "recommended tool number", identifier 2070502040502, "working property", identifier 2070502040503, "depth of cut", identifier 2070502040504, "minimum feed", identifier 2070502040505, "maximum feed", identifier 2070502040506, "minimum cut speed", identifier 2070502040507, "maximum cut speed", identifier 2070502040508.
In the resource object layer, concrete data are stored in a subspace connected with a subspace where the surfacing spraying turning is located: "work material and rockwell hardness", identifier 2070502040601, "recommended tool designation", identifier 2070502040602, "depth of cut minimum", identifier 2070502040603, "depth of cut maximum", identifier 2070502040604, "feed minimum", identifier 2070502040605, "feed maximum", identifier 2070502040606, "cut speed minimum", identifier 2070502040607, "cut speed maximum", identifier 2070502040608.
In the resource object layer, specific data are stored in a subspace connected with a subspace where the end face milling is located: "workpiece material and brinell hardness", whose identifier is 2070502040701, "recommended tool number one", whose identifier is 2070502040702, "feed amount per tooth range one", whose identifier is 2070502040703, "cutting speed range one", whose identifier is 2070502040704, "recommended tool number two", whose identifier is 2070502040705, "feed amount per tooth range two", whose identifier is 2070502040706, "cutting speed range two", whose identifier is 2070502040707, "recommended tool number three", whose identifier is 2070502040708, "feed amount per tooth range three", whose identifier is 2070502040709, "cutting speed range three", and whose identifier is 2070502040710.
In the resource object layer, specific data are stored in a subspace connected with a subspace where the end mill is located: "mill diameter" with an identifier of 2070502040801, "recommended tool material one", with an identifier of 2070502040802, "milling speed one", with an identifier of 2070502040803, "one feed per tooth", with an identifier of 2070502040804, "recommended tool material two", with an identifier of 2070502040805, "milling speed two", with an identifier of 2070502040806, "two feed per tooth", with an identifier of 2070502040807, "milling depth", with an identifier of 2070502040808.
In the resource object layer, the subspace connected to the subspace where the "ISO base data" is located stores specific data: "workpiece material and hardness", identifier 2070502040901, "rough turning recommended tool ISO application classification number", identifier 2070502040902, "rough turning depth of cut", identifier 2070502040903, "rough turning feed", identifier 2070502040904, "rough turning cutting speed", identifier 2070502040905, "finish turning recommended tool ISO application classification number", identifier 2070502040906, "finish turning depth of cut", identifier 2070502040907, "finish turning feed", identifier 2070502040908, "finish turning speed", identifier 2070502040909, "face milling recommended tool ISO application classification number", identifier 2070502040910, "face milling depth of cut", identifier 2070502040911, "face milling feed", identifier 2070502040912, "face milling speed", identifier 2070502040913, "planing recommended tool ISO application classification number", identifier 2070502040914, "planing depth of cut", its identifier is 2070502040915, "gouging pass", its identifier is 2070502040916, "gouging cut speed", its identifier is 2070502040917.
In the present application, data such as the model, composition, characteristics, and applicability of various cutting media are mainly collected in a cutting media data set, and data such as the supply mode of various cutting media, the effect that can be obtained, and the influence on the surface are given. The cutting fluid selection method is suitable for reference of selection of the cutting fluid in scientific research and production processes of research institutes and enterprises of various departments.
Preferably, in the third layer of the resource assembly layer, a subspace connected with the subspace where the "cutting process" is located stores a name: the "box representative reference process" has an identifier of 207050401000 and the "hub and sleeve representative reference process" has an identifier of 2070504020000.
In the resource object layer, the subspace connected with the subspace where the box typical reference process is located stores specific data: the identifier of the "bracket 3A cutting process" is 2070504010001, the identifier of the "bracket U1 cutting process" is 2070504010002, the identifier of the "bracket HCD cutting process" is 2070504010003, the identifier of the "transmission case it cutting process" is 2070504010004, the identifier of the "bracket it cutting process" is 2070504010005, the identifier of the "stand th cutting process", the identifier of the "valve body as cutting process" is 2070504010007, the "engine cutting process", the identifier of the "reduction gearbox upper cover cutting process", the identifier of the "reduction gearbox case cutting process", the identifier of the "2070504010010, the" head of the "box cutting process", and the identifier of the "2070504010011".
In the resource object layer, a subspace connected with a subspace where the shaft disc sleeve typical part reference process is located stores specific data: "cutting process of lead screw (thread type)" with identifier 2070504020001, "cutting process of a main shaft a 2-8", with identifier 2070504020002, "cutting process of shaft bevel gear", with identifier 2070504020003, "cutting process of crankshaft", with identifier 2070504020004, "cutting process of elastomer", with identifier 2070504020005, "cutting process of drive shaft", with identifier 2070504020006, "cutting process of bearing cover (disc type)", with identifier 2070504020007, "cutting process of dust cover", with identifier 2070504020008, "cutting process of outer ring", with identifier 2070504020009, "cutting process of front flange", with identifier 2070504020010, "cutting process of water pump impeller", with identifier 2070504020011, "cutting process of drive gear", with identifier 2070504020012, "cutting process of thrust sleeve", with identifier 2070504020013, "cutting process of ring", with identifier 2070504020014, "cutting process of end cover", the identifier is 2070504020015, the identifier is 2070504020016, the identifier is 2070504020017, the identifier is 2070504020018, the identifier is 2070504020019, and the identifier is 2070504020020.
In the present application, the data collection of the machining process mainly collects 11 cases of typical parts and 20 cases of typical parts of the process parameters of the shaft, disc and sleeve. The method is suitable for reference in the process aspect when various production enterprises manufacture products and design machine tools and cutters.
Preferably, in the third layer of the resource integration layer, a subspace connected to a subspace in which the "latest dynamic state of the cutting technology" is located stores a name: "related results", "paper refinement", "meeting information", "development dynamics";
preferably, in the third layer of the resource assembly layer, a subspace connected to the subspace in which the "typical advanced cutting technology" is located stores a name: "high-speed cutting processing technique", "dry cutting processing technique", "hard cutting processing technique", "precision and ultra-precision cutting processing technique", "virtual cutting processing technique";
preferably, in the third layer of the resource integration layer, a subspace connected to the subspace in which the "typical application" is located stores a name: the method comprises the steps of automobile part machining, mould machining, aerospace part machining and efficient cutting.
In a preferred embodiment, the data type format types stored in the ISO 13399-based co-design and manufacturing data integration system include: data table type, web page type, WORD document type, picture type, PDF type, slide type, video file type; the type of Data is stored using the table Data _ Info, containing the identifier (bsf) and the type of Data (datatype), as shown in fig. 2; in fig. 2, html represents web page type data, and datatable represents a data table type.
The unique identifier is stored as an important query condition in each judgment type data table of the database, such as: HTML format Data (. HTML) are put together and stored in a Data _ WebMl Data table;
the Data table type Data information is stored in the Data _ TableList Data table, and then a field is used to store the actual Data table format Data table name, which can be in a mode of carrying a character string behind the identifier. As identifier 2070106010001, the data table name is 2070110010001_ workpiece surface, and the contents of the data table "2070110010001 _ workpiece surface" are shown in fig. 3.
Other data tables the contents of the data table such as "2070804040020 _ CBN100 insert high speed hard turning example" are shown in figure 4.
The picture format Data (. jpg) is stored in a Data _ Image Data table, and the WORD document (. doc) and the PDF document (. PDF) are stored in a Data _ Application Data table; the resource set data information and the resource object data information are also stored in data tables zyjysj and ZYDXYSJ, respectively.
Preferably, the data table type data can be directly stored in a table of a special database. And wherein the web page form presents the available web page code and stores in the data table together; after the data tables are stored and called together, the required display effect can be quickly obtained without conversion because the data tables are presented through the web control.
Preferably, for data of a web page type, a WORD document type, a picture type, a PDF type, a slide type, and a video file type, in the storing process, the data is first converted into long binary data and then stored in the database. When in use, the file is called out and then stored in a temporary file for other processing. The implementation process comprises the following steps:
step a, converting the byte array into byte [ ] by using C #, and storing the byte array into a database, wherein the byte array column in the database defines the data type as an "OLE object";
b, reading the binary byte array from the database through the C # and storing the binary byte array in a temporary file;
and c, reading the binary byte array from the database through JAVA and storing the binary byte array in a temporary file.
In a preferred embodiment, the method for consulting and calling data in the system comprises the following steps:
step 1, searching and locking concrete data in a resource assembly layer through an identifier, locking a classification name of the concrete data,
step 2, listing the content stored in the layer and the next layer for the classification name in each resource integration layer, and listing the specific content for the resource object layer, all presenting in the data display area; preferably, the presentation is via a tree-like multi-level menu.
In the step 2, a tree menu is constructed by adopting a treeView control, a resource assembly layer and a resource object layer are put into a tree multilevel menu for application, and the method mainly comprises the steps of storing data in the tree control into an SQL data table, dynamically loading data in the data table into the treeView control, and deleting data in a control node and the data table. For example, treeView1.Nodes [ jsp [ i ] -1]. Nodes [ js1p [ i ] -1]. nodes.Add (cdm [ dxhm [ i, k ] ]) is to add a resource integration layer js1p [ i ] -1 and then a resource object layer cdm [ dxhm [ i, k ] ] to the resource integration layer jsp [ i ] -1 in tree control treeView1. The tree menu pop-up interface is shown in fig. 5.
And setting the image attribute by adopting a pictureBox control to execute picture display. The picture file is obtained by reading long binary data from a database and performing the conversion method.
Adopting a WebBrowser control for browsing a homepage to display data of a webpage type, a WORD document type, a PDF type and a slide type,
the WORD document type data is converted into a webpage file and then displayed, and data in formats such as WORD documents, PDF documents, PPT slides and the like are obtained by reading long binary data from a database and using the conversion method.
The WORD document is first converted into a web page file and then displayed.
The webpage type, PDF type and slide type data are directly presented through a navigator function of the webBrowser control;
data table type data of a datatable type can be displayed by adopting a DataGridView control.
Preferably, in the process of presenting data in the form of a datatable data table, when the number of rows of the data table is too large or the number of columns of the data table is too large, a temporary webpage file is generated first, then the temporary webpage file temp. htm is called in, and then data presentation is performed by using the navigator attribute of the webBrowser1. navigator of the webBrowser control;
and when the number of rows of the data table is not large and the number of columns of the data table is not large, directly generating a webpage character string sText, and presenting data by using a documentText attribute webBrower 1 of the webBrowser control. In the application, when the rows and columns of the data table can be completely displayed in the display interface, the rows and columns are considered to be not many, if the rows cannot be completely displayed, the rows are considered to be too many, and if the columns cannot be completely displayed, the columns are considered to be too many.
In a preferred embodiment, when data in the collaborative design and manufacturing data integration system based on ISO13399 is queried, two query schemes are generally included, namely query based on various data types of ISO13399 presented by web pages or comprehensive query based on collaborative design and manufacturing data of ISO 13399;
in the process of inquiring based on various data types of ISO13399 presented by a webpage, as for data in html or html format of the webpage, the data is in a file form integrating characters, graphs and tables, and can be directly read and then presented to the webpage by an out command;
as for the data in the form of a picture, since it is a file stored in a computer in the format of BMP, JPG, PNG, etc., it is generally converted into long binary data and stored in a database, then it is converted into a Blob type by store [ i ] ═ Blob (Blob) rss2.getblob (3), and then it is converted into a picture file sl1.JPG, and finally the picture is displayed on a web page by using a code < img./>.
As for document-form data, since it is a file form stored on a computer in the form of WORD document, it is generally converted into long binary data and stored in a database, and then (Blob) is used to forcibly convert symbols into binary data, i.e., store [ i ] ═ (Blob) rss2.getblob (3); converting the document file into a Blob type, then converting the Blob type into a Word document file sl1.doc, and finally converting the WORD document file into an HTML file by using the following JAVA code and then displaying the HTML file on a webpage.
For the data in the form of PDF, the data is in a portable document format and an electronic file format, and the file format is independent of an operating system platform. Generally, the data is converted into long binary data and stored in a database, then (Blob) is used for forcibly converting a symbol into binary data, namely, store [ i ] ═ (Blob) rss2.getblob (3) is converted into a Blob type, then the Blob type is converted into a PDF document file sl1.PDF, and finally, the PDF document file is converted into a picture file by using JAVA codes and then is displayed on a webpage.
For the metal cutting principle type tabular form data with only 1 column, since it is a data form composed of data of one column and multiple rows, when it is presented on a webpage, the column number columnCount therein is taken to be 1.
For tabular form data containing multiple columns, because the tabular form data is a data form consisting of a series of multiple rows and multiple columns of data, when the tabular form data is presented on a webpage, the number of columns columnCount in the tabular form data is greater than 1.
In the process of the integrated query of the co-design manufacturing data based on ISO13399, table 1 of the data table sjb of the database stores the numbers and names of the collection layer or the object layer of the data resources as shown in fig. 6, where js1, js2, js3, js4 and js5 are the digital representations of the collection layer or the object layer of the data resources, and str is the name thereof. If the value of a certain column (js1- - -js5) of a certain row is greater than 0 and the next column is equal to 0 or str, the row is a resource object layer, the number of the column in front of the column is the position of each resource set, the js value of the column is changed to '00', the last column (js5) is set as the value of the column (if less than 10, the column is replaced by '0X'), so that the identification symbol of the resource object can be obtained (see the 'sjbm' column of the table 2, such as '2070101000001', which is the name of a data table, the table of the name of the data table stores corresponding data, and the table 2 is shown in figure 7) and the str column value of the row is the name of the resource object; otherwise, the row is a resource assembly layer, the number of the column in front of the column is the position of each resource assembly, and the str column value of the row is the name of the resource assembly layer. Therefore, the database has large storage capacity, high calling speed and convenient and accurate query.
Further, the query is carried out according to the method for manufacturing the classified data hierarchy based on the collaborative design of ISO13399, wherein the first layer is the advanced cutting technology according to the classified name: the "metal cutting principle", "workpiece material", "cutting machine tool", "cutting process", "latest dynamic state of cutting technology", "typical advanced cutting technology", "typical application" and "cutting technology paper" are then queried in a manner of downward searching layer by layer in a manner that 9 types of the above-mentioned second layer, third layer and fourth layer are respectively developed downwards, and at most five layers can be provided.
For example, the interface queried according to the "metal-cutting principle" is shown in fig. 8, where the blue string is the name of the resource assembly layer and the red string is the name of the resource object layer. For the resource object layer, the type of the data is given, i.e., ". html" is web page type, ". doc" is WORD document type, ". jpg" is picture type, ". PDF" is PDF document type, and "datatable" is data table type.
The present invention also provides a design method for metal working using an ISO 13399-based collaborative design manufacturing data integration system,
the method comprises the following steps:
step a, designing a machining procedure of a part according to the size and the technological requirements of the part to be machined; the machining process comprises turning, drilling, milling, heat treatment, scribing, grinding and the like, wherein the turning, drilling, milling and the like can be divided into rough processing and fine processing, and the setting is selected according to the requirements of the part.
Preferably, since there are many design solutions, in the case where the parts to be machined can be obtained in a plurality of design solutions, the best solution among them is the one that can be performed the fastest, easiest, lowest cost; in addition, in step a, the machining process needs to be selected and designed based on the type of the existing machine tool and the type of the tool; the existing machine tool is a machine tool which can be used for executing the processing task in a processing place and comprises a common machine tool, a numerical control machine tool and a processing center; the existing tool refers to a tool carried or capable of being carried on a general machine tool, a numerical control machine tool or a machining center for performing a machining task of the part to be machined.
Further preferably, when the step a is executed, the cutting machine tool data and the cutting tool data of the resource integration layer in the collaborative design and manufacturing data integration system based on ISO13399 are called, and the tool types in the existing machine tool and the existing tool information are known, so that the design scheme can be directly executed, time waste caused by repeatedly modifying the design scheme is avoided, and the risk of unstable workpiece performance caused by the fact that a processing person adjusts the design scheme according to local conditions can also be avoided.
Step b, designing a machining process step of the part based on the machining process; the machining steps comprise the type of a cutter used for executing each procedure and specific parameters in the execution process, wherein the specific parameters comprise cutting width, feeding amount and spindle rotating speed, and in the special material machining procedure, the corresponding machining steps further comprise the type and flow of cooling liquid; for the heat treatment process, the corresponding process steps include temperature and duration.
In the step b, when the working step of each cutting procedure is designed, firstly, the cutting tool data of the resource assembly layer in the collaborative design and manufacturing data integration system based on ISO13399 is called to obtain the model of the existing tool, and then the specific cutting width, the feeding amount and the spindle rotating speed are obtained through the query module by combining the machining method or the workpiece material information.
In step b, the specific cutting width, feed amount and spindle rotating speed data are called from an ISO 13399-based collaborative design and manufacturing data integration system through the query module; the specific data are all data in accordance with ISO13399 standard, and the processing steps obtained by design completely conform to the ISO13399 standard through the step b, so that monitoring and management of the processing process are facilitated, consistency in quality and performance of the processed workpieces can be ensured, high consistency among the same type of workpieces processed in different factories and at different time can be particularly ensured, and the performance of the product manufactured by network collaborative design can be further ensured.
In addition, the method uniformly calls specific data through the query module, so that the rapidness and the accuracy of the process step design can be improved, the design efficiency is improved, the design difficulty is reduced, and the requirements on the experience of designers are reduced.
Furthermore, the query module is provided with 5 query modules, namely a query module of cutting data based on a cutting test, a query module of general cutting data, a query module of heavy cutting data, a query module of domestic manufacturer cutting data and a query module of foreign manufacturer cutting data.
In a preferred embodiment, each specific data obtained by the query module corresponds to an identifier for identifying the data, and the identifier can represent a storage location of the data and can also represent a storage location of a higher concept of the data, so as to obtain other data information related to the data, so that a designer can refer to the data for reference; preferably, the specific data may be presented through a tree-like multi-level menu.
In a preferred embodiment, in the co-design manufacturing data integration system based on ISO13399, in the query module of "cutting data based on cutting test", a cutting amount database name is set: mdb, which is used for receiving input parameters of cutting data to be queried, which are input through a dialog box, and defining the connection relation between the cutting data, the resource assembly layer and the resource object layer, which are queried from the cutting usage database, as a form of a query function so as to be called when querying. All query functions are put into a dynamic link library dll file, and the format of the query functions is as follows:
Figure BDA0003596529920000141
in the query module, the data table name: 20705020101+ ix (ix <10 with 0 added in advance; if ix equals 8, the data table name is 2070502010108); the function format is double [ ] tlgs (int ix, double t, double vb, double ap, double f)
ix is 1-64, is the combination of 64 kinds of workpiece materials and cutter materials, and the specific combination relationship is as follows:
1: 20/YT5, 2:20/YT15, 3:35/YC30, 4:35/YT5, 5:35/YT15, 6:45/YT5, 7:45/YT14, 8:45/YT15, 9:45/YB03, 10:50/YT5, 11:50/YT 5, 12:20Cr/YT5, 13:20 Cr/YT5, 14:40Cr/YT5, 15:40 Cr/YT5, 16:40 Cr/YT5, 17:40Cr/YC 5, 18:15 CrMo/YT5, 19:20CrMo/YT5, 20:20 CrMo/YT5, 21:35 Mo/YT5, 22:35 Mo/YT5, 3: 35/YT 3623: 24/YT 3642, 3: 35/YT 3638/MnT 5, 8: 20/YT 3638/YT 5, 3:20 Cr/YT5, 28/YT 5, 3: 35/YT5, 3: MnT 5, 3/YT 3638/YT 5, and MnT 5, 3: 35/YT5, and MnT 3638/YT 5 31:38CrMoAl/YB, 32:45MnB/YT, 33:45MnB/YT, 34: GCr/YT, 35: GCr/YC, 36: GCr15SiMn/YT, 37: GCr15SiMn/YC, 38: T10/YT, 39: T10/YT, 40: T10/YB, 41: T10/YC, 42:9CrSi/YT, 43:9CrSi/YT, 44:9CrSi/YT, 45: CrWMn/YT, 46: CrWMn/YT, 47: CrWMn/YT, 48:1Cr18Ni 9/YC, 49:1Cr18Ni 9/YC, 50:1Cr18Ni 9/YW, 51:3 Cr/YC, 52:3 Cr/YW, 53:65Mn/YT, 54: HT150/YG, 150: YG 55/YG, 50:1Cr18Ni 9/YW, 51:3 Cr/YG HT 60, 250: YG/HT 60, YG, 250: YG/HT 60, YG/HT 5/HT 60, YG, 250/HT 5, YG, HT 5/HT 60, YG, HT 60, HT 5/HT 5, HT 60, HT 5/HT 60, HT 5, HT 60, HT 5, and HT 5/YT5, HT 60, YG, HT 5, HT 60, HT 5, YG, HT 5, HT 60, YG, HT 60, and HT 60, YG, HT 60, YG, HT 60, and HT 60, and HT 60, and HT 60, HT250/YG8, NO. 52 wear-resistant cast iron/N5, Cr15Mo3 quenched cast iron/FD _ W64.
The t in the function format represents that the cutter durability min is 15,30,45,60,90 or is optionally set through a drop-down box ComboBox 2;
vb in the function format represents a rear cutter grinding standard VB (mm), which takes a value of 0.3 and 0.5 or is optionally set by a pulldown box ComboBox 3;
ap in the function format indicates a cut depth (mm) which is 0.3,0.5,1,1.2,1.5,1.6,2,2.5,2.8,3,3.2,4 or optionally set by a drop-down box Combo Box 4;
f in the function format represents a feed amount (mm/r) which is 0.2,0.25,0.315,0.4,0.5,0.63 or is optionally set by a drop-down box ComboBox 5;
the output parameters of the query module include: cutting speed v (mm/min), cutting force Fc (N), cutting power P (Kw), and metal removal rate Vol (cm ^ 3/min).
Wherein the cutting speed query result is: textbox36.text ═ cc.tlgs (ix, convert. todouble (combobox2. selectedltem), convert. todouble (combobox3. selectedltem), convert. todouble (combobox4. selectedltem), convert. todouble (combobox5. selectedltem)) [1] tostig ();
wherein ix contains a resource assembly layer and a resource object layer, the query result is an array, wherein [1] represents the first element of the array, namely the cutting speed;
the feed amount query result textbox35.text (convert. Todouble (comboBox5.selectedItem)). ToString ();
the recommended cutter material query result is: textbox34.text ═ combobox6. text;
preferably, in the ISO 13399-based collaborative design and manufacturing data integration system, in the query module of "general cutting data", the data specifically include turning of single-edge and indexable tools, turning of cutting and forming tools, boring, general drilling, deep hole drilling, reaming, face milling, three-edge milling, end milling (peripheral milling with an end mill), end milling (milling a groove with an end mill);
wherein, in the data of the single edge and the indexable turning cutting amount, the data is named as: 2070502020101_ Table 2;
the function format is: string [ ] drkzwcx (int dl, int xl, int ydz, double ap);
the input parameters are: dl: a serial number indicating a major class of workpiece material machinability codes, xl: a serial number indicating a minor class of workpiece material machinability codes, ydz: a workpiece material hardness value, and ap: a depth of cut (mm) (with 0.13,0.25,0.4,0.5,0.65,0.8,1,1.5,2.5,3.2,4,5,6,8,13,16,25 alternatives).
The number of the output parameters is 10, and the method specifically comprises the following steps: a recommended value of cutting speed of a high-speed steel tool (m/min), a recommended value of feed rate of a high-speed steel tool (mm/r), a recommended value of material of a high-speed steel tool ISO, a recommended value of cutting speed of a hard alloy uncoated brazing tool (m/min), a recommended value of cutting speed of a hard alloy uncoated indexable tool (m/min), a recommended value of feed rate of a hard alloy uncoated tool (mm/r), a recommended value of material of a hard alloy uncoated tool ISO, a recommended value of cutting speed of a hard alloy coated tool (m/min), a recommended value of feed rate of a hard alloy coated tool (mm/r), and a recommended value of material of a hard alloy coated tool ISO.
In the cutting amount data of the cutting groove, the data table name is: 2070502020201_ Table 3;
the function format is: string [ ] qdqc (int dl, int xl, int ydz, int djcl);
the input parameters are: dl, serial number for indicating the large class of machineability codes of workpiece materials, xl: a subclass number of a code for workability of a workpiece material ydz, a hardness value of the workpiece material, djcl, a tool material (1- - -high speed steel; 2- - -cemented carbide);
the number of the output parameters is 10, and the method specifically comprises the following steps: a recommended value (m/min) of cutting speed of the tool, a feed amount (mm/r) when the width of the cutting blade is 1.5mm, a feed amount (mm/r) when the width of the cutting blade is 3mm, a feed amount (mm/r) when the width of the cutting blade is 6mm, a feed amount (mm/r) when the width of the forming blade is 12mm, a feed amount (mm/r) when the width of the forming blade is 18mm, a feed amount (mm/r) when the width of the forming blade is 25mm, a feed amount (mm/r) when the width of the forming blade is 35mm, a feed amount (mm/r) when the width of the forming blade is 50mm, and a recommended ISO of a tool material.
In the cutting consumption data of boring, the data table is as follows: 2070502020301_ Table 4;
the function format is: string [ ] tx (int dl, int xl, int ydz, double ap);
the input parameters are: dl: a serial number indicating a major class of workpiece material machinability codes, xl: a serial number indicating a minor class of workpiece material machinability codes, ydz: a workpiece material hardness value, and ap: a depth of cut (mm) (with alternatives of 0.13,0.25,0.4,0.5,1,1.25, 2.5).
The number of the output parameters is 10, and the method specifically comprises the following steps: a recommended value of cutting speed of a high-speed steel tool (m/min), a recommended value of feed rate of a high-speed steel tool (mm/r), a recommended value of material of a high-speed steel tool ISO, a recommended value of cutting speed of a hard alloy uncoated brazing tool (m/min), a recommended value of cutting speed of a hard alloy uncoated indexable tool (m/min), a recommended value of feed rate of a hard alloy uncoated tool (mm/r), a recommended value of material of a hard alloy uncoated tool ISO, a recommended value of cutting speed of a hard alloy coated tool (m/min), a recommended value of feed rate of a hard alloy coated tool (mm/r), and a recommended value of material of a hard alloy coated tool ISO.
In the cutting amount data of common drilling, the data is named as: 2070502020401_ Table 5;
the function format is: string [ ] ptzx (int dl, int xl, int ydz);
the input parameters are: dl, a serial number for indicating the large class of the machinable codes of the workpiece materials, xl, a serial number for indicating the small class of the machinable codes of the workpiece materials, ydz, and a hardness value of the workpiece materials;
the number of the output parameters is 10, and the method specifically comprises the following steps: a tool cutting speed recommended value (m/min), a feed amount (mm/r) when the nominal diameter of the hole is 1.5mm, a feed amount (mm/r) when the nominal diameter of the hole is 3mm, a feed amount (mm/r) when the nominal diameter of the hole is 6mm, a feed amount (mm/r) when the nominal diameter of the hole is 12mm, a feed amount (mm/r) when the nominal diameter of the hole is 18mm, a feed amount (mm/r) when the nominal diameter of the hole is 25mm, a feed amount (mm/r) when the nominal diameter of the hole is 35mm, a feed amount (mm/r) when the nominal diameter of the hole is 50mm, and a tool material recommended ISO.
In the cutting consumption data of deep hole drilling, the data table name is as follows: 2070502020501_ Table 6;
the function format is string [ ] skzx (int dl, int xl, int ydz);
the input parameters are: dl, a serial number for indicating the large class of the machinable codes of the workpiece materials, xl, a serial number for indicating the small class of the machinable codes of the workpiece materials, ydz, and a hardness value of the workpiece materials;
the number of the output parameters is 14, and the output parameters specifically comprise: a recommended value (m/min) of cutting speed of a tool, a low value (mm/r) of a feed amount range when a nominal diameter of a hole is 2 to 4mm, a high value (mm/r) of a feed amount range when a nominal diameter of a hole is 2 to 4mm, a low value (mm/r) of a feed amount range when a nominal diameter of a hole is 4 to 6mm, a high value (mm/r) of a feed amount range when a nominal diameter of a hole is 4 to 6mm, a low value (mm/r) of a feed amount range when a nominal diameter of a hole is 6 to 12mm, a high value (mm/r) of a feed amount range when a nominal diameter of a hole is 6 to 12mm, a low value (mm/r) of a feed amount range when a nominal diameter of a hole is 12 to 18mm, a high value (mm/r) of a feed amount range when a nominal diameter of a hole is 12 to 18mm, and a low value (mm/r) of a feed amount range when a nominal diameter of a hole is 18 to 25mm, A high value (mm/r) in the feed amount range when the nominal diameter of the hole is 18 to 25mm, a low value (mm/r) in the feed amount range when the nominal diameter of the hole is 25 to 50mm, a high value (mm/r) in the feed amount range when the nominal diameter of the hole is 25 to 50mm, and a recommended ISO for a tool material.
In the cut amount data of reaming, the data are named as follows: 2070502020601_ Table 7;
the function format is string [ ] jx (int dl, int xl, int ydz);
the input parameters are: dl, serial number indicating the major class of workpiece material machinability codes, xl, serial number indicating the minor class of workpiece material machinability codes, ydz: representing a workpiece material hardness value;
the number of the output parameters is 29, and the method specifically comprises the following steps: the method comprises the following steps of (1) recommending the coarse reaming speed of the high-speed steel reamer (m/min), the coarse reaming feed (mm/r) when the diameter of the high-speed steel reamer is 3mm, the coarse reaming feed (mm/r) when the diameter of the high-speed steel reamer is 6mm, the coarse reaming feed (mm/r) when the diameter of the high-speed steel reamer is 12mm, the coarse reaming feed (mm/r) when the diameter of the high-speed steel reamer is 25mm, the coarse reaming feed (mm/r) when the diameter of the high-speed steel reamer is 35mm, the coarse reaming feed (mm/r) when the diameter of the high-speed steel reamer is 50mm, the fine reaming cutting speed recommending value (m/min) of the high-speed steel reamer, the fine reaming feed (mm/r) when the diameter of the high-speed steel reamer is 3mm, the fine reaming feed (mm/r) when the diameter of the high-speed steel reamer is 6mm, and the fine reaming feed (mm/r) when the diameter of the high-speed steel reamer is 12mm, The method comprises the following steps of finish reaming feed (mm/r) when the diameter of the high-speed steel reamer is 25mm, finish reaming feed (mm/r) when the diameter of the high-speed steel reamer is 35mm, finish reaming feed (mm/r) when the diameter of the high-speed steel reamer is 50mm, coarse reaming cutting speed recommended value (m/min) of the hard alloy reamer, coarse reaming feed (mm/r) when the diameter of the hard alloy reamer is 3mm, coarse reaming feed (mm/r) when the diameter of the hard alloy reamer is 6mm, coarse reaming feed (mm/r) when the diameter of the hard alloy reamer is 12mm, coarse reaming feed (mm/r) when the diameter of the hard alloy reamer is 25mm, coarse reaming feed (mm/r) when the diameter of the hard alloy reamer is 35mm, coarse reaming feed (mm/r) when the diameter of the hard alloy reamer is 50mm, fine reaming cutting speed recommended value (m/min) of the hard alloy reamer, The feed rate of finish reaming when the diameter of the hard alloy reamer is 3mm (mm/r), the feed rate of finish reaming when the diameter of the hard alloy reamer is 6mm (mm/r), the feed rate of finish reaming when the diameter of the hard alloy reamer is 12mm (mm/r), the feed rate of finish reaming when the diameter of the hard alloy reamer is 25mm (mm/r), the feed rate of finish reaming when the diameter of the hard alloy reamer is 35mm (mm/r), the feed rate of finish reaming when the diameter of the hard alloy reamer is 50mm (mm/r), and the recommended ISO of cutter materials.
In the cutting dosage data of the plane milling, the data is named as: 2070502020701_ Table 8;
the function format is string [ ] pmxx (int dl, int xl, int ydz, double ap);
the input parameters are: dl: a serial number for the major class of workpiece material machinability codes, xl: a serial number for the minor class of workpiece material machinability codes, ydz: a workpiece material hardness value, and ap: a depth of cut (mm) (with alternatives of 0.13,0.25,0.4,0.6,1,1.3,2.5,4, 8).
The number of the output parameters is 10, and the method specifically comprises the following steps: a recommended value of cutting speed of a high-speed steel tool (m/min), a recommended value of feed rate of a high-speed steel tool (mm/r), a recommended value of material of a high-speed steel tool ISO, a recommended value of cutting speed of a hard alloy uncoated brazing tool (m/min), a recommended value of cutting speed of a hard alloy uncoated indexable tool (m/min), a recommended value of feed rate of a hard alloy uncoated tool (mm/r), a recommended value of material of a hard alloy uncoated tool ISO, a recommended value of cutting speed of a hard alloy coated tool (m/min), a recommended value of feed rate of a hard alloy coated tool (mm/r), and a recommended value of material of a hard alloy coated tool ISO.
In the cutting amount data of the three-edge milling, the data is named as follows: 2070502020801_ Table 9;
the function format is string [ ] smrxx (int dl, int xl, int ydz, double ap);
the input parameters are: dl: a serial number for the major class of workpiece material machinability codes, xl: a serial number for the minor class of workpiece material machinability codes, ydz: a workpiece material hardness value, and ap: a depth of cut (mm) (with alternatives of 0.13,0.25,0.4,0.65,1,1.25,2.5,4, 8).
The number of the output parameters is 10, and the method specifically comprises the following steps: a recommended value of cutting speed of a high-speed steel tool (m/min), a recommended value of feed rate of a high-speed steel tool (mm/r), a recommended value of material of a high-speed steel tool ISO, a recommended value of cutting speed of a hard alloy uncoated brazing tool (m/min), a recommended value of cutting speed of a hard alloy uncoated indexable tool (m/min), a recommended value of feed rate of a hard alloy uncoated tool (mm/r), a recommended value of material of a hard alloy uncoated tool ISO, a recommended value of cutting speed of a hard alloy coated tool (m/min), a recommended value of feed rate of a hard alloy coated tool (mm/r), and a recommended value of material of a hard alloy coated tool ISO.
In the cutting consumption data of end milling (peripheral milling by an end mill), the data are named as follows: 2070502020901_ Table 10;
the function format is string [ ] dxzx (int dl, int xl, int ydz, double ap);
the input parameters are: dl: a serial number of a large class of workpiece material machinability codes, xl: a serial number of a small class of workpiece material machinability codes, ydz: a hardness value of the workpiece material, ap: a radial depth of cut (mm) (with four values of 0.5,1.5,2.5,5 being selected).
The output parameters are 12 in number, and specifically include: a recommended value (m/min) of cutting speed of the high-speed steel milling cutter, a feed amount (mm/r) of the high-speed steel milling cutter with the diameter of 10mm, a feed amount (mm/r) of the high-speed steel milling cutter with the diameter of 12mm, a feed amount (mm/r) of the high-speed steel milling cutter with the diameter of 18mm, a feed amount (mm/r) of the high-speed steel milling cutter with the diameter of 25-50 mm, and a recommended ISO of a material of the high-speed steel cutter, the cutting speed recommendation value (m/min) of the hard alloy milling cutter, the feed rate (mm/r) when the diameter of the hard alloy milling cutter is 10mm, the feed rate (mm/r) when the diameter of the hard alloy milling cutter is 12mm, the feed rate (mm/r) when the diameter of the hard alloy milling cutter is 18mm, the feed rate (mm/r) when the diameter of the hard alloy milling cutter is 25-50 mm, and the recommendation ISO of hard alloy cutter materials.
In the cutting consumption data of the end mill (milling a groove by using an end mill), the data table name is as follows: 2070502021001_ Table 11;
the function format is string [ ] dxxc (int dl, int xl, int ydz, double ap);
the input parameters are: dl: a serial number indicating a major class of workpiece material machinability codes, xl: a serial number indicating a minor class of workpiece material machinability codes, ydz: a workpiece material hardness value, and ap: an axial depth of cut (mm) (four values of 0.75,3,5, and 10 are selected).
The output parameters are 6 in number, and specifically include: a recommended value of cutting speed (m/min), a feed amount (mm/r) when the groove width is 10mm, a feed amount (mm/r) when the groove width is 12mm, a feed amount (mm/r) when the groove width is 18mm, a feed amount (mm/r) when the groove width is 25 to 50mm, and a recommended ISO for a tool material.
When the universal cutting data query module is used for querying, the processing method, the part material, the hardness and the cutting depth are sequentially input, and the result can be output by calling a query function.
Preferably, in the ISO 13399-based collaborative design and manufacturing data integration system, the query module of the "heavy cutting data" specifically includes data of cutting amount of a ceramic turning tool, cutting amount of a diamond turning tool, cutting amount of a cubic boron nitride turning tool, cutting amount of a planer tool, cutting amount of a carbide milling cutter, feed per tooth of a carbide face milling cutter, milling amount of a coated carbide milling cutter, cutting amount of a diamond milling cutter, milling plane of a carbide end milling cutter and cutting amount of a boss.
Wherein, in the cutting consumption data of the ceramic turning tool, the data is named as: 2070502060216_ Sheet 1;
the function format is string [ ] tccd (string clph, int ydz, double ap);
the input parameters are: clph represents the grade of a workpiece material, ydz represents the hardness value of the workpiece material, and ap represents the back bite (mm);
the output parameters are 7 in total, and specifically include: cutting speed (m/min), feed rate (mm/r), ceramic material type, workpiece material state, low workpiece material hardness range and high workpiece material hardness range.
In the diamond turning tool cutting amount data, the data is named as: 2070502060217_ Sheet 1; the function format is string [ ] jgscd (int clph, int ydz, double ap);
the input parameters are: clph denotes a workpiece material grade, wherein 1: the major categories are: forged and rolled aluminum alloy, subclass: -; 2: the major categories are: sand or permanent mold casting of aluminum alloys, subclass: -; 3: the major categories are: die casting, subclass: -; 4: the major categories are: forging and rolling magnesium alloy, subclass: -; 5: the major classes are: casting magnesium alloys, subclass: -; 6: the major categories are: forging and rolling copper alloy, subclass: -; 7: the major categories are: carbon and graphite, subclass: machinery; 8: the major categories are: carbon and graphite, subclass: brush-like carbon; 9: the major categories are: glass and ceramic, subclass: -; 10: the major categories are: mica, subclass: -; 11: the major categories are: plastic: thermoplastics, thermosets, subclasses: -; 12: the major categories are: kaylar49, subclass: -; 13: the major categories are: graphite epoxy, subclass: -; 14: the major categories are: glass fiber epoxy E glass S glass, subclass: -; 15: the major categories are: noble metals, subclass: gold; 16: the major categories are: noble metals, subclass: platinum; 17: the major categories are: noble metals, subclass: silver; 18: the major categories are: rubber hard, subclass: -; ydz, representing hardness value of workpiece material; ap represents back bite (mm);
the output parameters are 7 in number, and specifically include: large material type, small material type, Hardness (HBS), state, back bite ap (mm), cutting speed vc (m/min), and feed f (mm/r).
In the cubic boron nitride lathe tool cutting consumption data, the data is named as: 2070502060218_ Sheet 1;
the function format is string [ ] cbncd (int clph);
the input parameters are: clph denotes a workpiece material grade, wherein 1: the major categories are: structural steel, alloy steel, bearing steel, carbon tool steel 45 ~ 68HRC, subclass: -; 2: the major categories are: 45-68 HRC alloy tool steel, subclass: -; 3: the major categories are: chilled cast iron rolls, malleable cast iron, cast and forged steel, etc., in subclasses: 50-75 HS; 4: the major categories are: chilled cast iron rolls, malleable cast iron, cast and forged steel, etc., in subclasses: 75-85 HS; 5: the major categories are: 45-68 HRC of high-speed steel, subclass: -; 6: the major categories are: heat resistant alloys, subclass: a nickel base; 7: the major categories are: heat-resistant alloys, subclass: cobalt-based; 8: the major categories are: heat resistant alloys, subclass: iron base; 9: the major categories are: heat resistant alloys, subclass: others; 10: the major categories are: cemented carbide, subclass: -; 11: the major categories are: iron-based sintered alloys, subclass: -.
The output parameters are 7 in total, and specifically include: material group, large class of processing material, small class of processing material, cutting speed (m/min), back cutting amount (mm), feed amount (mm/r) and remarks.
In the cutting amount data of the planing tool, the data table name is as follows: 2070502060220_ Sheet 1;
the function format is string [ ] bd (int clph);
the input parameters are: clph represents the type of planing tool and the processing mode, wherein, 1: the major categories are: machine presss from both sides drop-down planer tool, subclass: rough machining; 2: the major classes are: machine presss from both sides drop-down planer tool, subclass: semi-finishing; 3: the major categories are: machine presss from both sides drop-down planer tool, subclass: finish machining steel and alloy steel; 4: the major categories are: machine presss from both sides pull-down type can gyration smooth planer tool, subclass: finish machining steel and alloy steel; 5: the major classes are: machine presss from both sides pull-down type can gyration smooth planer tool, subclass: carrying out finish machining on cast iron; 6: the major categories are: machine presss from both sides tapered wedge formula grooving planer tool, subclass: rough machining; 7: the major categories are: machine presss from both sides tapered wedge formula grooving planer tool, subclass: semi-finishing; 8: the major categories are: heavy machine presss from both sides cascaded planer tool, subclass: rough machining; 9: the major classes are: machine presss from both sides longmen point planer tool, subclass: rough machining of cast iron; 10: the major categories are: machine presss from both sides longmen point planer tool, subclass: roughly processing cast steel; 11: the major categories are: machine presss from both sides powerful planer tool, subclass: rough machining; 12: the major categories are: machine presss from both sides accurate flat planer tool, subclass: roughly machining a cutting groove and performing offset cutting; 13: the major classes are: machine presss from both sides accurate flat planer tool, subclass: finish machining; 14: the major categories are: machine presss from both sides circle planer tool, subclass: rough machining; 15: the major categories are: machine presss from both sides circle planer tool, subclass: and (6) finishing.
The number of the output parameters is 5, and the method specifically comprises the following steps: the name of the tool, the type of machining, the cutting speed vc (m/min), the feed amount f (mm/double stroke), and the back bite amount ap (mm).
In the cutting consumption data of the hard alloy milling cutter, the data table name is as follows: 2070502060302_ Sheet 1;
the format of the function is string [ ] yzhjxd (int clph);
the input parameters are: clph represents the type of workpiece material, wherein 1: the major categories are: low carbon steel, subclass: -; 2: the major categories are: medium carbon steel, subclass: -; 3: the major categories are: high carbon steel, subclass: -; 4: the major categories are: alloy steel, subclass: not heat-treated; 5: the major categories are: alloy steel, subclass: tempering 1; 6: the major categories are: alloy steel, subclass: tempering 2; 7: the major categories are: alloy steel, subclass: quenching; 8: the major categories are: cast steel, subclass: -; 9: the major categories are: high manganese steels, subclass: -; 10: the major categories are: high speed steel, subclass: -; 11: the major categories are: die steel, subclass: -; 12: the major categories are: tool steel, subclass: -; 13: the major categories are: stainless steel, subclass: ferrite; 14: the major categories are: stainless steel, subclass: austenite; 15: the major categories are: stainless steel, subclass: martensite; 16: the major categories are: cast iron, subclass: -; 17: the major categories are: chilled cast iron, subclass: -; 18: the major classes are: cast bronzes, subclass: -; 19: the major categories are: cast aluminum alloys, subclass: -;
the output parameters are 7 in total, and specifically include: workpiece material, heat treatment, tensile strength delta b (MPa), hard alloy grade ISO, hard alloy domestic manufacturer grade, cutter front angle (+/-1 degree), and cutting speed vc (m/min).
In the feed amount data of each tooth of the hard alloy face milling cutter, the data are listed as follows: 2070502060303_ Sheet 1;
the function format is string [ ] xdmcjgl (int clph);
the input parameters are: clph represents the type of workpiece material and the hardness range, wherein, 1: the major categories are: low carbon steel, subclass: 150 parts by weight; 2: the major categories are: low carbon steel, subclass: 150 to 200 parts; 3: the major categories are: medium and high carbon steel, subclass: 120-180; 4: the major categories are: gray cast iron, subclass: 150 to 180 parts; 5: the major classes are: gray cast iron, subclass: 180-220 parts by weight; 6: the major categories are: gray cast iron, subclass: 220 to 300 parts by weight; 7: the major categories are: malleable cast iron, subclass: 110 to 160; 8: the major categories are: malleable cast iron, subclass: 160-200; 9: the major categories are: malleable cast iron, subclass: 200 to 240 parts by weight; 10: the major categories are: malleable cast iron, subclass: 240 to 280 parts; 11: the major classes are: c < 0.3% alloy steel, subclass: 125-170; 12: the major categories are: c < 0.3% alloy steel, subclass: 170-220; 13: the major classes are: alloy steel containing less than 0.3 percent of C, minor class: 220 to 280 parts of; 14: the major categories are: medium and high carbon steel, subclass: 180-220 parts by weight; 15: the major categories are: medium and high carbon steel, subclass: 220 to 300 parts by weight; 16: the major categories are: alloy steel containing less than 0.3 percent of C, minor class: 280-320 parts; 17: the major categories are: alloy steel containing C more than 0.3 percent, subclass: 170-220; 18: the major categories are: c > 0.3% alloy steel, subclass: 220 to 280 parts of; 19: the major categories are: c > 0.3% alloy steel, subclass: 280-320 parts; 20: the major categories are: c > 0.3% alloy steel, subclass: 320-380 parts; 21: the major categories are: tool steel, subclass: an annealed state; 22: the major categories are: tool steel, subclass: HRC 36; 23: the major categories are: tool steel, subclass: HRC 46; 24: the major categories are: tool steel, subclass: HRC 56; 25: the major categories are: magnesium alloy aluminum, subclass: 95 to 100.
The output parameters are three, and specifically include: workpiece material, workpiece material Hardness (HBS), and feed per tooth (mm/z) of the hard alloy face milling cutter.
In the milling dosage data of the coated hard alloy milling cutter, the data is characterized in that: 2070502060309_ Sheet 1;
the function format is string [ ] tcyzhjxdyl (int clph, double ap);
the input parameters are: clph represents the type of workpiece material, wherein 1: the major categories are: carbon steel, subclass: low carbon; 2: the major categories are: carbon steel, subclass: a medium carbon; 3: the major categories are: carbon steel, subclass: high carbon; 4: the major categories are: alloy steel, subclass: low carbon; 5: the major categories are: alloy steel, subclass: a medium carbon; 6: the major classes are: alloy steel, subclass: high carbon; 7: the major classes are: high strength steel, subclass: -; 8: the major categories are: high speed steel, subclass: -; 9: the major categories are: stainless steel, subclass: austenite; 10: the major categories are: stainless steel, subclass: martensite; 11: the major classes are: gray cast iron, subclass: -; 12: the major categories are: malleable cast iron, subclass: -; ap means back bite (mm).
The output parameters are 8 in number, and specifically include: the machining material is large, the machining material is small, the hardness HBS, the back cutting amount ap (mm), the feed per tooth fz (mm/z) of an end milling plane, the cutting speed Vc (m/min) of the end milling plane, the feed per tooth fz (mm/z) of the side face and the groove of the three-edge milling cutter, and the cutting speed Vc (m/min) of the side face and the groove of the three-edge milling cutter.
In the cutting amount data of the diamond milling cutter, the data is named as: 2070502060310_ Sheet 1;
the function format is string [ ] jgsxd (int clph, double ap);
the input parameters are: clph represents the type of workpiece material, wherein 1: the major categories are: aluminum alloys, subclass: deforming; 2: the major classes are: aluminum alloys, subclass: casting; 3: the major categories are: magnesium alloys, subclass: -; 4: the major classes are: copper alloys, subclass: a modification 1; 5: the major categories are: copper alloys, subclass: a deformation 2; 6: the major categories are: copper alloys, subclass: casting; 17: the major categories are: carbon and graphite, subclass: -; 8: the major categories are: glass and ceramic, subclass: -; 9: the major categories are: mica, subclass: -; 10: the major categories are: plastics, subclass: -; 11: the major categories are: hard rubber, subclass: -; 12: the major categories are: kevlar composite, subclass: -; 13: the major categories are: carbon fiber composite materials, subclass: -; 14: the major categories are: glass fiber composites, subclass: -; 15: the major categories are: boron fiber composites, subclass: -; 16: the major categories are: gold, silver, subclass: -; 17: the major categories are: platinum, subclass: -; ap means back bite (mm).
The number of the output parameters is 6, and the method specifically comprises the following steps: the machining material is large, the machining material is small, the hardness, the back cutting amount ap (mm), the feed amount fz (mm/z) of each tooth and the milling speed Vc (m/min).
In the cutting consumption data of milling planes and bosses of the hard alloy end mill, the data is named as follows: 2070502060314_ Sheet 1;
the function format is string [ ] yzhjlxxpmtt (int clph, double vc);
the input parameters are: clph is the type of workpiece material, wherein, 1: the major categories are: carbon steel, subclass: low carbon; 2: the major categories are: carbon steel, subclass: medium carbon; 3: the major categories are: carbon steel, subclass: high carbon; 4: the major categories are: alloy steel, subclass: low carbon; 5: the major categories are: alloy steel, subclass: medium carbon; 6: the major categories are: alloy steel, subclass: high carbon; 7: the major categories are: high strength steel, subclass: -; 8: the major categories are: high speed steel, subclass: -; 9: the major classes are: tool steel, subclass: -; 10: the major categories are: high temperature alloys, subclass: -; 11: the major categories are: stainless steel, subclass: austenite; 12: the major categories are: stainless steel, subclass: ma's; 13: the major categories are: gray cast iron, subclass: -; 14: the major categories are: malleable cast iron, subclass: -; 15: the major categories are: aluminum alloys, subclass: -; 16: the major categories are: copper alloys, subclass: -; 17: the major categories are: titanium alloys, subclass: -; vc milling speed Vc (m/min).
The output parameters are 8 in number, and specifically include: the machining material is large, the machining material is small, the hardness HBS, the milling speed Vc (m/min), the feed per tooth fz (mm/z) when the mill diameter d is 10mm, the feed per tooth fz (mm/z) when the mill diameter d is 12mm, the feed per tooth fz (mm/z) when the mill diameter d is 18mm, and the feed per tooth fz (mm/z) when the mill diameter d is 25 to 50 mm.
When the query is carried out through a 'heavy cutting data' query module, the query type (processing method), the part material, the hardness and the back-biting amount are sequentially input, and the result can be output by calling a query function.
Preferably, in the ISO 13399-based collaborative design and manufacturing data integration system, the query module of "domestic manufacturer cutting data" specifically includes: cutting process data from shores carbide mills, kuan carbide mills and shanxi aviation carbide tools.
The input parameters of the query function are the manufacturer, the processing mode, the material and the hardness of the part, the material and the feed quantity of the cutter in the corresponding data table in the database, and the output parameters are the cutting speed, the feed quantity and the recommended material of the cutter.
When the query is carried out through a 'domestic manufacturer cutting data' query module, a manufacturer, a machining mode, a part material, hardness, a cutter material and a feeding amount are sequentially input, and a result can be output by calling a query function.
Preferably, in the co-design manufacturing data integration system based on ISO13399, the query module of the "foreign manufacturer cutting data" specifically includes cutting data such as the cutting data of the nidgen co.
The input parameters of the query function are the manufacturer, the processing mode, the material and hardness of parts, the material of blades and the diameter of cutters in corresponding data tables in the database, and the output parameters are the cutting speed, the feed amount and the recommended cutter material.
When the cutting data of foreign manufacturers is inquired through an inquiry module, the cutting data of the foreign manufacturers are sequentially input into a manufacturer, a machining mode, a part material, hardness, a blade material and the diameter of a cutter, and then a result can be output by calling an inquiry function.
Example 1:
a design method for machining a single-throw crankshaft is carried out by No. 1 designer, namely, the specific machining steps of the single-throw crankshaft from a blank part to a qualified part are designed, and the information of the single-throw crankshaft to be machined is as follows:
Figure BDA0003596529920000201
a No. 1 designer executes a design task, and according to part information, by calling cutting machine tool data and cutting tool data of a resource integration layer in an ISO 13399-based collaborative design and manufacturing data integration system, the existing machine tool is determined to comprise a lathe, a milling machine and a grinding machine, the existing tool is determined to comprise a turning tool, a drill bit and a milling cutter, and therefore the process information of crankshaft machining is designed as shown in the following table:
Figure BDA0003596529920000202
based on the process information, further calling cutting tool data of a resource integration layer in a collaborative design and manufacturing data integration system based on ISO13399 to obtain the model of the existing tool, and then combining with a machining method or workpiece material information to obtain the specific cutting width, feed amount and main shaft rotating speed through an inquiry module so as to design the machining process step of crankshaft machining,
wherein, the query interface corresponding to the query module is shown in fig. 9;
the crankshaft machining steps obtained by the query module are shown in the following table:
Figure BDA0003596529920000203
Figure BDA0003596529920000211
and (3) the crankshaft machining step is obtained, namely the design task of machining the single-throw crankshaft is completed, the time for completing the design task is counted to be 5 minutes and 21 seconds, and the crankshaft machining step obtained by design completely meets the ISO13399 standard.
The machining operation of the crankshaft is executed according to the crankshaft machining process steps obtained through design, and the obtained single-throw crankshaft workpiece completely meets the design requirements in the part drawing, so that the design method for carrying out metal machining by using the ISO 13399-based collaborative design and manufacturing data integration system can ensure the accuracy of part machining and obtain parts meeting the requirements.
The time required for the designer No. 1, who performs the design task, to design the single-throw crankshaft part machining process steps of consistent size and shape is 37 minutes without resorting to the co-design manufacturing data integration system based on ISO 13399; the crankshaft machining steps obtained are shown in the following table:
Figure BDA0003596529920000212
Figure BDA0003596529920000221
example 2
The same design task of machining the single-throw crankshaft as in example 1 was performed by 5 other designers, respectively, the serial numbers of the designers were divided into numbers 2 to 6, the machining steps obtained by the design were all the same as those in example 1, and the design time was 5 minutes 10 seconds, 4 minutes 42 seconds, 5 minutes 50 seconds, 5 minutes 15 seconds, 5 minutes 52 seconds, respectively;
further, the 5 designers are counted to obtain the tool information and the corresponding cutting width, feed amount and spindle rotation speed in a manual query mode without the aid of a collaborative design manufacturing data integration system based on ISO13399, and the time required for designing the machining steps of the single-throw crankshaft parts with consistent sizes and shapes is 35 minutes, 28 minutes, 37 minutes, 32 minutes and 40 minutes respectively. The crankshaft machining steps obtained by designers nos. 2 to 6 are different and use tools that do not comply with the ISO13399 standard.
Through the above embodiment 1 and embodiment 2, it can be known that, when the working step design is performed by using the coordinated design and manufacturing data integration system based on ISO13399 provided by the present application, not only the standard of ISO13399 can be ensured, but also the design time can be shortened, and the design efficiency can be improved.
The present invention has been described above in connection with preferred embodiments, but these embodiments are merely exemplary and merely illustrative. On the basis of the above, the invention can be subjected to various substitutions and modifications, and the substitutions and the modifications are all within the protection scope of the invention.

Claims (10)

1. An ISO 13399-based collaborative design and manufacturing data integration system in which data is sorted, stored hierarchically, and each identified with an identifier.
2. The ISO 13399-based collaborative design manufacturing data integration system according to claim 1,
classifying the data in the collaborative design manufacturing data integration system based on ISO13399 according to the data content, and storing the classification name and the specific data in a layering manner;
preferably, the ISO 13399-based collaborative design and manufacturing data integration system comprises a multi-layer structure connected up and down, wherein the lowest layer in the multi-layer structure is a resource object layer for storing specific data,
other layers in the multi-layer structure are resource aggregation layers, and are used for storing the classification names or the vacancy of the specific data.
3. The ISO 13399-based collaborative design manufacturing data integration system according to claim 2,
and each resource assembly layer and resource object layer where the data is located are corresponding to a decimal code, and long codes obtained by sequentially splicing the decimal codes are identifiers for identifying the data.
4. The ISO 13399-based collaborative design manufacturing data integration system according to claim 3,
the resource integration layer is provided with 5 layers, i.e. the long code consists of 6 decimal codes.
5. The ISO 13399-based collaborative design manufacturing data integration system according to claim 2,
in each layer of the multilayer structure, a plurality of subspaces are arranged, and the subspaces in different layers can be in data connection with each other;
the subspace is used for storing specific data, or storing the classification name of the specific data, or being vacant;
preferably, the name "advanced cutting technique" is stored in the subspace of the first layer of the resource assembly layer;
the subspace of the second layer of the resource assembly layer is stored with the names of the advanced cutting technologies after the advanced cutting technologies are classified according to the volumes: "metal cutting principle", "workpiece material", "cutting machine tool", "cutting process", "latest dynamic state of cutting technique", "typical advanced cutting technique", "typical application", "cutting technical paper";
in the third layer of the resource assembly layer, a subspace connected with the subspace where the metal cutting principle is located stores a name: "cutting motion", "cutting surface", "three elements of cutting dosage", "cutting force and cutting power", "cutting heat and cutting temperature", "basic term for metal cutting", "metal cutting tool reamer term", "metal cutting tool milling cutter term", "metal cutting tool round die term", "metal cutting tool twist drill term";
in the third layer of the resource assembly layer, a subspace connected with the subspace where the workpiece material is located stores a name: "common material", "Chinese and foreign material contrast", "machinability of workpiece material", "machinability of common material";
in the third layer of the resource assembly layer, a subspace connected with a subspace where the 'cutting machine tool' is located stores a name: "machining center", "numerical control lathe", "numerical control milling machine", "lathes", "milling machines", "drilling machines", "boring machines", "threading machine", "broaching machine", "electric machine tool", "saws", "gear machine tool", "numerical control series functional parts and machine tool electric appliance", "machine tool technical parameters", "machine tool usage and Chinese and English contrast";
in the third layer of the resource assembly layer, a subspace connected with a subspace where the 'cutting tool' is located stores a name: "tool base material", "tool construction parameters", "tool surface modification", "tool type", "tool system";
in the third layer of the resource assembly layer, a subspace connected with the subspace where the 'cutting process' is located stores a name: "cutting aid", "cutting amount", "cutting medium", "cutting reference process";
in the third layer of the resource assembly layer, a subspace connected with a subspace where the latest dynamic state of the cutting technology is located stores a name: "related results", "paper refinement", "meeting information", "development dynamics";
in the third layer of the resource assembly layer, a subspace connected with a subspace where the "typical advanced cutting technology" is located stores a name: "high-speed cutting processing technique", "dry cutting processing technique", "hard cutting processing technique", "precision and ultra-precision cutting processing technique", "virtual cutting processing technique";
in the third layer of the resource assembly layer, a subspace connected with a subspace in which the "typical application" is located stores a name: the machining method comprises the steps of automobile part machining, mould machining, aerospace part machining and efficient cutting.
6. The ISO 13399-based collaborative design manufacturing data integration system according to claim 1,
the data type format types stored in the ISO 13399-based co-design manufacturing data integration system include: data table type, web page type, WORD document type, picture type, PDF type, slide type, video file type;
wherein, the Data form type Data information is stored in the Data _ tableList Data form, and a field is used to store the actual Data form format Data form name,
for data of a web page type, a WORD document type, a picture type, a PDF type, a slide show type and a video file type, in the storage process, the data is firstly converted into long binary data and then stored into a database.
7. The ISO 13399-based collaborative design manufacturing data integration system according to claim 1,
the data consulting and calling method in the system comprises the following steps:
step 1, searching and locking concrete data in a resource integration layer through an identifier, locking a classification name of the concrete data,
step 2, listing the content stored in the layer and the next layer for the classification name in each resource integration layer, and listing the specific content for the resource object layer, all presenting in the data display area; preferably, the presentation is via a tree-like multi-level menu.
8. The ISO 13399-based collaborative design manufacturing data integration system according to claim 7,
in the step 2, a WebBrowser control for browsing the homepage is adopted to display data of a webpage type, a WORD document type, a PDF type and a slide type,
wherein, the WORD document data is converted into a webpage file and then presented,
the webpage type, PDF type and slide type data are directly presented through a navigator function of the webBrowser control;
preferably, in the presentation process of the data in the form of the data table, when the number of rows of the data table is too large or the number of columns of the data table is too large, a temporary web page file is generated first, then the temporary web page file temp. htm is called, and then the data presentation is performed by using the navigator attribute of the webBrowser1. navigator of the webBrowser control;
and when the number of rows of the data table is not large and the number of columns of the data table is not large, directly generating a webpage character string sText, and presenting data by using a documentText attribute webBrower 1 of the webBrowser control.
9. A method for designing a metal working using an ISO 13399-based co-design manufacturing data integration system,
the method comprises the following steps:
step a, designing a machining procedure of a part according to the size and the technological requirements of the part to be machined;
step b, designing a machining process step of the part based on the machining process;
in step b, the cutting parameters related in the processing step, including specific values of cutting width, feed rate and rpm, are obtained by calling data in the ISO 13399-based collaborative design and manufacturing data integration system through the query module.
10. The method of designing for metal fabrication utilizing an ISO 13399-based co-design manufacturing data integration system of claim 9,
the query module is provided with 5 query modules, namely a query module of 'cutting data based on cutting test', a query module of 'general cutting data', a query module of 'heavy cutting data', a query module of 'domestic manufacturer cutting data' and a query module of 'foreign manufacturer cutting data', and in the step b, one or more query modules can be optionally selected for query.
CN202210390135.8A 2022-04-14 2022-04-14 ISO 13399-based collaborative design and manufacturing data integration system and metal processing design method Pending CN114969466A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202210390135.8A CN114969466A (en) 2022-04-14 2022-04-14 ISO 13399-based collaborative design and manufacturing data integration system and metal processing design method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202210390135.8A CN114969466A (en) 2022-04-14 2022-04-14 ISO 13399-based collaborative design and manufacturing data integration system and metal processing design method

Publications (1)

Publication Number Publication Date
CN114969466A true CN114969466A (en) 2022-08-30

Family

ID=82977572

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202210390135.8A Pending CN114969466A (en) 2022-04-14 2022-04-14 ISO 13399-based collaborative design and manufacturing data integration system and metal processing design method

Country Status (1)

Country Link
CN (1) CN114969466A (en)

Similar Documents

Publication Publication Date Title
Arezoo et al. Selection of cutting tools and conditions of machining operations using an expert system
CN106776712A (en) Turning process database and its application process based on i5 intelligent digital control lathes
Astakhov Drills: science and technology of advanced operations
Chryssolouris Manufacturing systems: theory and practice
Childs Metal machining: theory and applications
CN104400527B (en) A kind of Tool preparation method towards mechanical processing process
Zhou et al. Ontology-based cutting tool configuration considering carbon emissions
Jiang et al. An automatic process planning system for the quick generation of manufacturing process plans directly from CAD drawings
US10754322B2 (en) System and method for selecting a tool assembly
Cakir et al. Development of a knowledge-based expert system for solving metal cutting problems
Carpenter et al. A flexible tool selection decision support system for milling operations
CN113868725B (en) Three-dimensional process procedure guiding method and system based on structured knowledge
Prasad et al. A knowledge-based system for end mill selection
CN114969466A (en) ISO 13399-based collaborative design and manufacturing data integration system and metal processing design method
Nicolaou et al. Machining quality and cost: estimation and tradeoffs
Kumar et al. Bibliometric analysis of specific energy consumption (SEC) in machining operations: a sustainable response. Sustainability 2021; 13: 5617
CN107024906A (en) The code generating method and device of a kind of NC cutting tool
Jambor Quality of production process with CAD/CAM system support
Güllü et al. Dynamic chip breaker design for Inconel 718 using positive angle tool holder
Jiang et al. A process planning expert system based on a flexible digit length coding scheme
CN117291552B (en) Method for intelligently creating cross-provider cutter scheme and cutting amount in webpage environment
Ostojic et al. An integral system for automated cutting tool selection
Asghari Innovative cutting tool design for machining advanced engineering materials
Ren et al. A computer-based intelligent system for automatic tool selection
Jurrens et al. Beyond product design data: data standards for manufacturing resources

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination