CN111460053B - Data query method for manufacturing cutter data - Google Patents

Data query method for manufacturing cutter data Download PDF

Info

Publication number
CN111460053B
CN111460053B CN202010294844.7A CN202010294844A CN111460053B CN 111460053 B CN111460053 B CN 111460053B CN 202010294844 A CN202010294844 A CN 202010294844A CN 111460053 B CN111460053 B CN 111460053B
Authority
CN
China
Prior art keywords
cutter
class
information
data
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.)
Active
Application number
CN202010294844.7A
Other languages
Chinese (zh)
Other versions
CN111460053A (en
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.)
Wuhan University WHU
Original Assignee
Wuhan University WHU
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 Wuhan University WHU filed Critical Wuhan University WHU
Priority to CN202010294844.7A priority Critical patent/CN111460053B/en
Publication of CN111460053A publication Critical patent/CN111460053A/en
Application granted granted Critical
Publication of CN111460053B publication Critical patent/CN111460053B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • 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/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/289Object oriented databases
    • 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/21Design, administration or maintenance of databases
    • G06F16/211Schema design and management
    • G06F16/212Schema design and management with details for data modelling support
    • 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/245Query processing
    • G06F16/2458Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • 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)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • General Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Mathematical Physics (AREA)
  • Computational Linguistics (AREA)
  • Software Systems (AREA)
  • Probability & Statistics with Applications (AREA)
  • Fuzzy Systems (AREA)
  • Numerical Control (AREA)

Abstract

The invention discloses a data model and a data query method for manufacturing cutter data, which are based on an object proxy model from the requirement of cutter data application and store data by classes and proxy classes in the object proxy model. And realizing the basic relation storage of cutter data through the basic class and the relation class of cutter application, and then inquiring and optimizing the data by utilizing a cross-class inquiring mode. The method ensures that the relation expression between the cutter data is clear, the semantic relation is flexible, and when the related information is required to be searched, the query statement is direct and simple, and the query is efficient.

Description

Data query method for manufacturing cutter data
Technical Field
The invention belongs to the technical field of metal manufacturing and processing, and particularly relates to a data model and a data query method for manufacturing industry cutter data based on an object proxy model.
Background
The reasonable use of the cutter and the cutter in the traditional metal manufacturing and processing has great significance for improving the production efficiency, the product quality and the safety in the processing process and reducing the cost. At present, numerical control machining is used in a large number, and the use of tools and tool data in the programming process, in particular, compensation methods related to recommended cutting parameters of a tool machining workpiece and certain geometric parameters of the tool, have decisive significance for the geometric dimensions of the finished product. Therefore, with respect to the type of tool data used in the numerical control machine tool processing, the semantics of the tool data and the requirements of application scenes are intensively studied, and the work of establishing a tool database is expected to be carried out on the basis of the technology of industrial big data processing and industrial Internet.
The object proxy model has the same concepts of objects and classes as those in the object-oriented model, but there is a proxy relationship between the objects and classes, and one object may have a plurality of proxy objects, the former is called a source object of the latter, the latter is called a proxy object of the former, the class is the same as the proxy class in relation to the object and the proxy object, the class without a parent class is called a source class, the object contained in the class is the source object, the class with a parent class is the proxy class, and the object contained in the class is the proxy object. The proxy object can selectively inherit all or part of the attributes of the source object, the method can also add the attributes and the method according to the own requirement, the inherited attributes are called virtual attributes, and the virtual attributes do not occupy actual physical storage, so that each virtual attribute records the corresponding relation through a switching expression, the reading operation of the virtual attributes is switched to the reading of the inherited attributes, and the writing operation of the virtual attributes is switched to the writing of the inherited attributes. The extended attribute is called real attribute, real attribute data occupies actual physical storage space and supports direct data read-write operation. In this way semantic relationships between objects and between classes are recorded intuitively.
Disclosure of Invention
The invention starts from the application requirement of cutter data, and provides a data model and a data query method for manufacturing cutter data based on an object proxy model, wherein the method firstly utilizes a source class in the object proxy model to establish a basic class and stores basic information of a cutter; secondly, modeling of various relation classes is completed by using proxy classes in the object proxy, and semantic association of connection data is achieved. And finally, realizing a query and optimization scheme for the cutter data by using cross-class query sentences. Compared with the current relational tool data management mode, the method and the device can efficiently store the tool data, the query statement is visual and clear, the connection operation of the data table is reduced, and the query efficiency is improved.
The technical scheme adopted by the data model of the invention is as follows: a data model for manufacturing tool data, wherein the construction of the data model comprises the steps of:
step 1: constructing a basic class of cutter information according to the action and relation of cutters in a cutter application scene, including the geometric shape parameter information of the cutters, and naming all the cutters and related data attributes according to standard naming in the cutter application scene; the related data comprise tool holder information, machining process information and workpiece material information;
step 2: recording the determined cutter and the related attribute thereof in the step 1 in a table form to be used as a cutter information basic class in the object proxy model;
step 3: and 2, constructing a cutter material proxy class according to the cutter information basic class constructed in the step 2, wherein the class is a select proxy class, and generating the cutter material proxy class from the cutter basic class according to different cutter materials, wherein the cutter material proxy class comprises manufacturing materials, size parameters, cutter number information and description information of a cutter, and the description information comprises a cutter application range, material information, a diameter, a cutting edge angle, a cutting length and cutter holder interface information.
Step 4: constructing a cutter processing agent class according to the cutter information basic class in the step 2, wherein the class is a join agent class, and comprises cutter information used in cutter processing, workpiece information used for processing and a processing technology; the cutter information comprises cutting data numbers, cutting speeds, cutter numbers and workpiece materials;
step 5: constructing a cutter agent class according to the cutter information basic class in the step 2, wherein the class is a unit agent class, and the description information of all cutters in the numerical control machine tool processing is contained; the cutter bit cutter, the turning tool cutter, the boring cutter and the milling cutter; the description information comprises a tool application range, material information, a diameter, a cutting edge angle, a cutting length and tool holder interface information;
step 6: constructing a cutter holder proxy class according to the cutter information basic class in the step 2, wherein the class is a join proxy class, and comprises cutter description information and cutter holder information matched with the cutter interface; the description information comprises a cutter application range, material information, a diameter, a cutting edge angle, a cutting length and machine tool interface information;
step 7: the machine tool cutter holder proxy class is constructed according to the cutter holder information basic class in the step 6, and the class is a group proxy class, wherein the group proxy class contains cutter description information which can be matched for each machine tool interface; the descriptive information includes tool application range, material information, diameter, cutting edge angle, cutting length, and machine tool interface information.
The technical scheme adopted by the query method of the invention is as follows: a data query method for manufacturing cutter data is characterized in that:
when the cutting data need to be queried, a data model facing manufacturing cutter data is utilized, a cross-class query statement is used, a specific recommended cutting speed value of a cutter when a workpiece is machined is needed to be searched, the cutting speed (cutting speed) is queried from a cutter processing agency (cutting data), the machined cutter class (Spiral) is found from the cutter processing agency (cutting data) through the cross-class query, the filtering condition is determined through the diameter (diameter), meanwhile, the machining process class (usengcase) is found from the cutter processing agency (cutting data), the filtering condition is determined through the cutter description information (description), finally, the machined workpiece material class (PartMaterial) is found from the cutter processing agency (cutting data), and the recommended cutting speed of the cutter which meets the condition is determined through the description information (description) of the workpiece material;
when the number of the cutters stored in the cutter processing library needs to be counted, using a data model facing manufacturing cutter data to use query sentences; when the tool stock quantity is required to be searched, directly counting the tool agent class (such as spir) by using an aggregation operation to obtain the tool quantity;
when all cutter holders applicable to a certain machine tool of a factory need to be searched, using a data model facing manufacturing cutter data and using cross-class query sentences; the tool holder class (tool) is composed of a tool agent class (Spiral) and a tool holder agent class (tool holder), wherein the main attribute of the tool holder agent class (machinetool) is a machine tool interface (MConnection), so that a matched tool is simply and efficiently found when the tool is replaced on a machine tool by determining the machine tool interface (MConnection) attribute value of the machine tool class (machinetool) as a filtering condition and finding the tool ID (ID) in the tool holder class (tool) by cross-class query.
The invention starts from the application requirement of cutter data, and provides a cutter data management method based on an object proxy model, which stores data by classes and proxy classes in the object proxy model. And realizing the basic relation storage of cutter data through the basic class and the relation class of cutter application, and then inquiring and optimizing the data by utilizing a cross-class inquiring mode. The method ensures that the relation expression between the cutter data is clear, the semantic relation is flexible, and when the related information is required to be searched, the query statement is direct and simple, and the query is efficient.
Drawings
Fig. 1 is a basic information schematic diagram of a twist drill type cutter according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of a select proxy class according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of a join-type proxy class according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of a unit type proxy class according to an embodiment of the present invention;
FIG. 5 is a schematic representation of a join-type tool holder proxy class of an embodiment of the present invention;
FIG. 6 is a schematic diagram of a group-type proxy class according to an embodiment of the present invention;
Detailed Description
In order to facilitate the understanding and practice of the invention, those of ordinary skill in the art will now make further details with reference to the drawings and examples, it being understood that the examples described herein are for the purpose of illustration and explanation only and are not intended to limit the invention thereto.
The invention provides a data model for manufacturing cutter data, which is constructed by the following steps:
step 1: constructing a basic class of cutter information according to the action and relation of cutters in a cutter application scene, including the geometric shape parameter information of the cutters, naming all the cutters and related data attributes according to standard naming in the cutter application scene, and avoiding data conflict; the related data comprises tool holder information, machining process information and workpiece material information;
step 2: recording the determined cutter and the related attribute thereof in the step 1 in a table form to be used as a cutter information basic class in the object proxy model;
the invention is applied to an example in a manufacturing cutter scene, and a basic class constructed according to the cutter application scene stores a basic cutter class, a twist drill (spiral), a use case class (usecase), a workpiece class (partial material) and a tool holder class (Toolholder). Basic information of the tool is shown in fig. 1, and includes information such as number, diameter, cutting edge angle, programming length and the like.
Through the previous step, the construction of the basic class in the cutter data is completed. And then, the associated data information is represented by rich semantic relations by using a modeling method, so that the association relations among different data are simply and accurately expressed.
In the embodiment, modeling management is performed on the manufacturing tool data through agent relationships of four different agents, namely selection, connection, combination and grouping.
Step 3: and 2, constructing a cutter material proxy class according to the cutter information basic class constructed in the step 2, wherein the class is a select proxy class, and generating the cutter material proxy class from the cutter basic class according to different cutter materials, wherein the cutter material proxy class comprises manufacturing materials, size parameters, cutter number information and description information of a cutter, and the description information comprises a cutter application range, material information, a diameter, a cutting edge angle, a cutting length and cutter holder interface information.
In this embodiment, because tools with different tool materials are required for different processing in the tool processing scene, the problem of various tool types and complex representation is solved by constructing a SELECT proxy class on the tool source class through a SELECT proxy relationship, and four different types of tools are simply and clearly represented by creating a SELECT proxy class for the tool source class as shown in fig. 2.
Step 4: constructing a cutter processing agent class according to the cutter information basic class in the step 2, wherein the class is a join agent class, and comprises cutter information used in cutter processing, workpiece information used for processing and a processing technology; the cutter information comprises cutting data numbers, cutting speeds, cutter numbers and workpiece materials;
in this embodiment, because in practical application, a worker is required to combine the characteristics of the tool, the processing process and the shape of the processed workpiece determine the cutting speed of the tool processing, and therefore, the connection relationship is applied to create the tool processing class on the tool class, the use case class and the workpiece class, so that in specific processing application, judgment and selection are not required through experience of the worker, and the recommended cutting speed can be directly required to be searched for in the processing. As shown in fig. 3, the tool processing class is created by join proxy for the twist drill tool, case class and workpiece class.
Step 5: constructing a cutter agent class according to the cutter information basic class in the step 2, wherein the class is a unit agent class, and the description information of all cutters in the numerical control machine tool processing is contained; a cutter drill cutter, a turning tool cutter, a boring cutter and a milling cutter; the descriptive information includes tool application range, material information, diameter, cutting edge angle, cutting length and tool holder interface information;
in this embodiment, because of different processing technology requirements in the cutter processing scene, there are four different cutter bodies, so that in order to make the cutter body type no longer single, a joint relation is used to construct a unit proxy class on the four cutter bodies to include all types of cutter bodies, thereby enriching cutter data information. As shown in fig. 4: and creating a unit agent class on milling cutters, boring cutters, drill bits and turning cutters so as to enrich the cutter body types.
Step 6: constructing a cutter holder proxy class according to the cutter information basic class in the step 2, wherein the class is a join proxy class, and comprises cutter description information and cutter holder information matched with the cutter interface; the descriptive information comprises cutter application range, material information, diameter, cutting edge angle, cutting length and machine tool interface information;
in this embodiment, in the tool processing application, the tool body cannot be directly mounted on the machine tool to perform processing, the tool body needs to be fixed on the machine tool through the tool holder, and the tool body and the tool holder are matched through the model of the interface, so that the joint agent class is constructed on the tool body and the tool holder through the joint agent relationship, and after the tool body is determined, the tool holder suitable for the tool body can be quickly found through the interface attribute in the tool holder agent class. As shown in fig. 5: a join proxy class is built on the tool body class and the tool holder class by interface attributes.
Step 7: the machine tool cutter holder proxy class is constructed according to the cutter holder information basic class in the step 6, and the class is a group proxy class, wherein the group proxy class contains cutter description information which can be matched for each machine tool interface; the descriptive information includes tool application range, material information, diameter, cutting edge angle, cutting length, and machine tool interface information.
In this embodiment, in the application of tool machining, since the tools need to be replaced frequently due to wear of machined workpieces, workers are required to confirm the interface model of a machine tool in the past and go to a warehouse to find tools with interfaces of the same model, so that all tools applicable to the machine tool can be found quickly by grouping tools with different machine tool interface models by using group agents. As shown in fig. 6: and constructing a group proxy class on the cutter class by utilizing the interface attribute.
By the last step, the tool data has been modeled. Next, in order to meet the requirements for cutter data in the machining scene of the numerical control machine tool, the characteristics of the object proxy model, namely a cross-class query mechanism, are utilized to simply and intuitively express the query requirements.
The invention also provides a data query method for the manufacturing cutter data, which comprises the following steps:
when the cutting data need to be queried, a data model facing manufacturing cutter data is utilized, a cross-class query statement is used, a specific recommended cutting speed value of a cutter when a workpiece is machined is needed to be searched, the cutting speed (cutting speed) is queried from a cutter processing agency (cutting data), the machined cutter class (Spiral) is found from the cutter processing agency (cutting data) through the cross-class query, the filtering condition is determined through the diameter (diameter), meanwhile, the machining process class (usengcase) is found from the cutter processing agency (cutting data), the filtering condition is determined through the cutter description information (description), finally, the machined workpiece material class (PartMaterial) is found from the cutter processing agency (cutting data), and the recommended cutting speed of the cutter which meets the condition is determined through the description information (description) of the workpiece material;
queries are expressed in SQL statements as: SELECT cutting speed FROM tool machining agent class
WHERE (tool machining agent class- > tool basic information class). Diameter= '16.0'
AND (tool machining agent class- > machining case class) = ' routing ' descriptive information '
AND (tool processing agent class- > workpiece material information class). Description information= 'GG';
the query statement is exemplified as follows:
SELECT cutting speed FROM CuttingData
WHERE (CuttingData→Spiral).diameter==<value>
AND (CuttingData→UsingCase).description ==<value>
AND(CuttingData→PartMaterial).description==<value>
when the number of the cutters stored in the cutter processing library needs to be counted, using a data model facing manufacturing cutter data to use query sentences; in the last step, different tools are classified and stored through modeling, so that when the tool stock is required to be searched, the tool agent class (such as Spiral) is directly counted by aggregation operation to obtain the number of tools;
the query statement is exemplified as follows:
SELECT COUNT(attribute) FROM class;
when all cutter holders applicable to a certain machine tool of a factory need to be searched, using a data model facing manufacturing cutter data and using cross-class query sentences; the tool holder class (tool) is composed of a tool agent class (Spiral) and a tool holder agent class (tool holder), wherein the main attribute of the tool holder agent class (machinetool) is a machine tool interface (MConnection), so that a matched tool is simply and efficiently found when the tool is replaced on a machine tool by determining the machine tool interface (MConnection) attribute value of the machine tool class (machinetool) as a filtering condition and finding the tool ID (ID) in the tool holder class (tool) by cross-class query.
Queries are expressed in SQL statements as: select (machine tool holder proxy class→tool proxy class.) tool number (arrow indicates cross class query);
the query statement is exemplified as follows:
SELECT (machinetool→tool).toolid FROM machinetool
WHERE machinetool.MConnection==<value>;
by using step data modeling, all agent relations in the model are recorded through a bi-directional pointer and a switching expression, so that the association relation between classes is only indicated by an arrow during query, and finally the recommended cutting speed meeting the conditions, the number of cutters and the cutter ids matched with a fixed machine tool can be obtained, so that query sentences are visual and clear.
The invention has the following advantages:
first, the tool data management method based on the object proxy model in the present invention can be applied to any scenario requiring similar application requirements, and specifically described as follows:
in the present invention, the cutter data processed by the numerical control machine tool is taken as an example, the entity and the data related to the scene of processing the workpiece are effectively managed, and in the practical application, the data management method provided by the present invention can be adopted when the scene of manufacturing industry is related to the scene of more entities and complex association relation.
Secondly, the data model in the invention not only effectively models and manages cutter data, but also has flexible semantic expression, and is specifically described as follows:
when the data modeling is carried out, firstly, the problem to be solved is definitely analyzed according to the entity and the data in the application scene, then, the relation among different types of data is judged, and finally, four different proxy relations, namely the model selection type, the join type, the unit type and the group type are used for modeling representation, so that the problem in scene application is flexibly solved.
The method provided by the invention can well solve the problem of management of cutter data in the processing of the numerical control machine tool, and has important significance for management of manufacturing data in a big data environment.
It should be understood that portions of this specification not specifically set forth are all of the prior art; the foregoing description of the preferred embodiments is not to be construed as limiting the scope of the invention, and persons of ordinary skill in the art may make substitutions or alterations without departing from the scope of the invention as set forth in the appended claims.

Claims (1)

1. The data query method for the manufacturing cutter data is characterized by being based on a data model for the manufacturing cutter data; the construction of the data model comprises the following steps:
step 1: constructing a basic class of cutter information according to the action and relation of cutters in a cutter application scene, including the geometric shape parameter information of the cutters, and naming all the cutters and related data attributes according to standard naming in the cutter application scene; the related data attributes comprise tool holder information, machining process information and workpiece material information;
step 2: recording the cutters and the related data attributes thereof determined in the step 1 in a table form to be used as cutter information basic classes in the object proxy model;
step 3: constructing a cutter material proxy class according to the cutter information basic class constructed in the step 2, wherein the class is a select proxy class, and generating the cutter material proxy class from the cutter basic class according to different cutter materials, wherein the cutter material proxy class comprises manufacturing materials, size parameters, cutter number information and description information of a cutter, and the description information comprises a cutter application range, material information, a diameter, a cutting edge angle, a cutting length and cutter holder interface information;
step 4: constructing a cutter processing agent class according to the cutter information basic class in the step 2, wherein the class is a join agent class, and comprises cutter information used in cutter processing, workpiece information used for processing and a processing technology; the cutter information comprises cutting data numbers, cutting speeds, cutter numbers and workpiece materials;
step 5: constructing a cutter agent class according to the cutter information basic class in the step 2, wherein the class is a unit agent class, and the description information of all cutters in the numerical control machine tool processing is contained; the cutter bit cutter, the turning tool cutter, the boring cutter and the milling cutter; the description information comprises a tool application range, material information, a diameter, a cutting edge angle, a cutting length and tool holder interface information;
step 6: constructing a cutter holder proxy class according to the cutter information basic class in the step 2, wherein the class is a join proxy class, and comprises cutter description information and cutter holder information matched with the cutter interface; the description information comprises a cutter application range, material information, a diameter, a cutting edge angle, a cutting length and machine tool interface information;
step 7: constructing a machine tool cutter holder proxy class according to the cutter holder information basic class in the step 6, wherein the class is a group proxy class, and the group proxy class comprises cutter description information which can be matched for each machine tool interface; the description information comprises a cutter application range, material information, a diameter, a cutting edge angle, a cutting length and machine tool interface information;
when the cutting data is required to be inquired, a data model facing the manufacturing cutter data is utilized, a cross-type inquiry statement is used, a specific recommended cutting speed value of a cutter when a workpiece is machined is required to be searched, the cutting speed is inquired from a cutter machining agency, the machined cutter is found out from the cutter machining agency through cross-type inquiry, the filtering condition is determined through the diameter, meanwhile, the machining process is found out from the cutter machining agency, the filtering condition is determined through cutter description information, finally, the machined workpiece material is found out from the cutter machining agency, and the description information of the workpiece material is determined to determine the recommended cutting speed of cutter machining meeting the condition;
when the number of the cutters stored in the cutter processing library needs to be counted, using a data model facing manufacturing cutter data to use query sentences; when the tool stock quantity needs to be searched, directly counting the tool agent class by using an aggregation operation to obtain the tool quantity;
when all cutter holders applicable to a machine tool of a factory need to be searched, using a data model facing manufacturing cutter data and using cross-class query sentences; the tool holder class is formed by the tool agent class and the tool holder agent class, wherein the main attribute of the tool holder class is a machine tool interface, so that the matching tool is simply and efficiently found when the tool is replaced on the machine tool by determining the machine tool interface attribute value of the machine tool class as a filtering condition and finding the tool ID in the tool holder class through cross-class query.
CN202010294844.7A 2020-04-15 2020-04-15 Data query method for manufacturing cutter data Active CN111460053B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010294844.7A CN111460053B (en) 2020-04-15 2020-04-15 Data query method for manufacturing cutter data

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010294844.7A CN111460053B (en) 2020-04-15 2020-04-15 Data query method for manufacturing cutter data

Publications (2)

Publication Number Publication Date
CN111460053A CN111460053A (en) 2020-07-28
CN111460053B true CN111460053B (en) 2023-09-08

Family

ID=71685332

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010294844.7A Active CN111460053B (en) 2020-04-15 2020-04-15 Data query method for manufacturing cutter data

Country Status (1)

Country Link
CN (1) CN111460053B (en)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115689452B (en) * 2022-11-14 2023-06-20 深圳市金洲精工科技股份有限公司 Drill stock planning management method

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CA2355418A1 (en) * 2001-08-16 2003-02-16 Ibm Canada Limited-Ibm Canada Limitee A schema for sql statements
CN101216844A (en) * 2008-01-03 2008-07-09 彭智勇 Database cross-class inquiry method
CN101833568A (en) * 2010-04-01 2010-09-15 武汉大学 Web data management system
CN101957835A (en) * 2010-08-16 2011-01-26 无锡市浏立方科技有限公司 Complicated relationship and context information-oriented semantic data model
CN104933188A (en) * 2015-07-07 2015-09-23 武汉大学 Data synchronism system and method of patent individuation index
CN110032159A (en) * 2019-04-26 2019-07-19 上海交通大学 Marine diesel important Parts machining control system implementation method
CN110162642A (en) * 2019-05-21 2019-08-23 武汉大学 Patent knowledge map construction method based on object broker database

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CA2355418A1 (en) * 2001-08-16 2003-02-16 Ibm Canada Limited-Ibm Canada Limitee A schema for sql statements
CN101216844A (en) * 2008-01-03 2008-07-09 彭智勇 Database cross-class inquiry method
CN101833568A (en) * 2010-04-01 2010-09-15 武汉大学 Web data management system
CN101957835A (en) * 2010-08-16 2011-01-26 无锡市浏立方科技有限公司 Complicated relationship and context information-oriented semantic data model
CN104933188A (en) * 2015-07-07 2015-09-23 武汉大学 Data synchronism system and method of patent individuation index
CN110032159A (en) * 2019-04-26 2019-07-19 上海交通大学 Marine diesel important Parts machining control system implementation method
CN110162642A (en) * 2019-05-21 2019-08-23 武汉大学 Patent knowledge map construction method based on object broker database

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
王敏.制造业大数据分布式存储管理方法研究.信息科技.2017,全文. *

Also Published As

Publication number Publication date
CN111460053A (en) 2020-07-28

Similar Documents

Publication Publication Date Title
CN106776712B (en) Turning process database based on i5 intelligent numerical control lathe and application method thereof
Dubovska et al. Implementation of CAD/CAM system CATIA V5 in Simulation of CNC Machining Process
EP1590760B1 (en) Method and system for computer aided manufacturing
CN111460053B (en) Data query method for manufacturing cutter data
US20200201284A1 (en) Method and system for automatic generation of computer-aided manufacturing instructions
US10754322B2 (en) System and method for selecting a tool assembly
Eversheim et al. Structured modelling of manufacturing processes as NC-data preparation
CN106528953A (en) Aircraft structural part process design-oriented process knowledge conception model description method
Pande et al. PC-CAPP—a computer-assisted process planning system for prismatic components
Ostojic et al. An integral system for automated cutting tool selection
Babu et al. Development of a manufacturing database system for STEP-NC data from express entities
Xiang et al. A generative feature-based CAPP/CNC system for hydraulic manifold blocks
Usher Object oriented approach to feature-based process planning
Jang et al. Tool selection in machining by integration of a data base and a rule based system
Yip-Hoi et al. Data extraction from geometric models for process planning for parallel machines
Ahola Creo Parametric Milling
Jiang et al. A process planning expert system based on a flexible digit length coding scheme
CN112069233B (en) Cutting amount determination method based on production field statistical data analysis
WO2018012999A1 (en) System for semantic searching in an object-process data model
Wong et al. An automated process planning system for prismatic parts
CN108804757B (en) Reconfigurable machine tool module selection method based on knowledge
Jurrens et al. Beyond product design data: data standards for manufacturing resources
Mwinuka An extendible computer-aided process planning system for turn-milled components
Lai-Yuen et al. Turn-Mill tool path planning and manufacturing cost analysis for complex parts machining
Huang A Generative Process Planning System for Turned Components

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
GR01 Patent grant
GR01 Patent grant