CN111460053A - Data model and data query method for cutter data in manufacturing industry - Google Patents
Data model and data query method for cutter data in manufacturing industry Download PDFInfo
- Publication number
- CN111460053A CN111460053A CN202010294844.7A CN202010294844A CN111460053A CN 111460053 A CN111460053 A CN 111460053A CN 202010294844 A CN202010294844 A CN 202010294844A CN 111460053 A CN111460053 A CN 111460053A
- Authority
- CN
- China
- Prior art keywords
- tool
- class
- information
- data
- proxy
- 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.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/289—Object oriented databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
- G06F16/212—Schema design and management with details for data modelling support
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
-
- Y—GENERAL 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
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing 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 tool data in manufacturing industry, and provides a tool data model and a data query method based on an object proxy model based on tool data application requirements. And storing the basic relationship of the tool data through the basic class and the relationship class of the tool application, and then querying and optimizing the data in a cross-class query mode. The method ensures that the relation expression between the tool data is clear, the semantic relation is flexible, and when the related information needs to be inquired and retrieved, the inquiry statement is direct, simple and convenient, and the inquiry is efficient.
Description
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 cutter data in the manufacturing industry based on an object proxy model.
Background
The cutter and the reasonable use of the cutter in the traditional metal manufacturing and processing have great significance for improving the production efficiency, the product quality and the safety of the processing process and reducing the cost. Today, where numerical control machining is widely used, the use of tool and tool data in the programming process, particularly those compensation methods that relate to the recommended cutting parameters of the tool for machining a workpiece and certain geometrical parameters of the tool, is of decisive significance for the geometrical dimensions of the finished product. The advanced manufacturing countries attach great importance to tool data and management, and related commercial products have been developed since a long time ago. The situation is still blank in China, and the situation is extremely inconsistent with the situation that China is the first major manufacturing country in the world at present. Therefore, intensive research is carried out on the requirements of tool data types, tool data semantics and application scenes used in the machining of the numerical control machine tool, and the work related to tool database establishment is hopefully developed on the basis of the industrial big data processing and industrial internet technology.
The object proxy model has the same concept of objects and classes as the object model, but there is a proxy relationship between objects and classes, and one object may have a plurality of proxy objects, the former is called the source object of the latter, the latter becomes the proxy object of the former, the relationship between classes and proxy classes is the same as the relationship between objects and proxy objects, the class without parent class is called the source class, the object contained in the class is the source object, the class with 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 self needs, the inherited attributes are called virtual attributes, the virtual attributes do not occupy the actual physical storage, therefore, each virtual attribute records the corresponding relation through the 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 direct data read-write operation is supported. In this way, semantic relationships between objects and between classes are intuitively recorded.
Disclosure of Invention
The invention provides a data model and a data query method for cutter data in manufacturing industry based on an object proxy model in a brand-new way from the application requirement of the cutter data, wherein the method comprises the steps of firstly establishing a basic class by utilizing a source class in the object proxy model and storing basic information of a cutter; secondly, modeling of various relation classes is completed by utilizing the agent class in the object agent, and semantic association of connection data is completed. And finally, realizing a query and optimization scheme for tool data by using cross-class query statements. Compared with the current relational tool data management mode, the tool data management method and the tool data management system can efficiently store tool data, query sentences are visual and clear, connection operation of a data table is reduced, and query efficiency is improved.
The data model adopts the technical scheme that: a data model for manufacturing tool data, the data model being constructed by the steps of:
step 1: constructing a basic tool information class according to the effect and the relation of the tool in the tool application scene, wherein the basic tool information class comprises geometric shape parameter information of the tool, and naming all the tools and related data attributes according to standard naming in the tool application scene; the related data comprises tool holder information, machining process information and workpiece material information;
step 2: recording the form of the table for determining the cutter and the related attributes thereof in the step 1 as the basic class of the cutter information in the object proxy model;
and step 3: and (3) constructing a tool material proxy class which is a select proxy class according to the tool information basic class constructed in the step (2), wherein the tool material proxy class is generated from the tool basic class according to different tool materials, wherein the tool material proxy class comprises manufacturing materials, dimension parameters, tool number information and description information of the tool, and the description information comprises tool application range, material information, diameter, cutting edge angle, cutting length and tool holder interface information.
And 4, step 4: constructing a tool processing proxy class according to the basic class of the tool information in the step 2, wherein the tool processing proxy class is a join proxy class and comprises tool information used in tool processing, workpiece information used for processing and a processing technology; the cutter information comprises a cutting data number, a cutting speed, a cutter number and a workpiece material;
and 5: constructing a tool agent class according to the tool information basic class in the step 2, wherein the tool agent class is an union agent class and contains description information of all tools in the numerical control machine tool machining; the cutter bit cutter, the turning tool cutter, the boring tool cutter and the milling cutter; the description information comprises tool application range, material information, diameter, cutting edge angle, cutting length and tool holder interface information;
step 6: constructing a tool holder proxy class according to the basic class of the tool information in the step 2, wherein the tool holder proxy class is a join proxy class and comprises tool description information and tool holder information matched with the tool interface; the description information comprises the application range of the cutter, material information, diameter, cutting edge angle, cutting length and machine tool interface information;
and 7: according to the tool holder information basic component in the step 6, tool holder proxy classes are machine tool holder proxy classes, the machine tool holder proxy classes are group proxy classes, and tool description information which can be matched for each machine tool interface is contained in the tool holder proxy classes; the description 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 industry cutter data is characterized in that:
when cutting data needs to be inquired, a data model facing tool data of the manufacturing industry is utilized, a cross-class inquiry statement is used, a specific recommended cutting speed value of a tool when the tool is used for machining a workpiece is required to be searched, the cutting speed (cuttingspeed) is inquired from a tool machining proxy class (Cuttingdata), a machined tool class (Spiral) is found from the tool machining proxy class (Cuttingdata) only through the cross-class inquiry, a filtering condition is determined through a diameter (diameter), a machining process class (using case) is found through the tool machining proxy class (cutingdata), the filtering condition is determined through tool description information (description), a machined workpiece material class (part material) is found from the tool machining proxy class (cutingdata), and the recommended cutting speed of tool machining meeting the condition is determined through the description information (description) of the workpiece material;
when the number of cutters stored in a cutter processing library needs to be counted, a data model facing cutter data in the manufacturing industry is used, and query statements are used; when the tool inventory needs to be searched, directly obtaining the number of tools by using a polymerization operation count for tool agents (such as Spiral);
when all tool holders applicable to a certain machine tool in a factory need to be searched, cross-class query statements are used by utilizing a data model facing tool data in the manufacturing industry; constitute cutter tool holder class (tool) through cutter agent class (Spiral) and cutter tool holder agent class (toolholder), machine tool cutter holder agent class (machineol) wherein the main attribute is machine tool interface (MConnection), so through the machine tool interface (MConnection) attribute value of confirming machine tool class (machineol) as the filter condition, find cutter ID (id) in cutter tool holder class (tool) through striding class inquiry for simply find the cutter that matches with high-efficiently when changing the cutter on the machine tool.
The invention provides a tool data management method based on an object proxy model based on tool data application requirements, which stores data by classes and proxy classes in the object proxy model. And storing the basic relationship of the tool data through the basic class and the relationship class of the tool application, and then querying and optimizing the data in a cross-class query mode. The method ensures that the relation expression between the tool data is clear, the semantic relation is flexible, and when the related information needs to be inquired and retrieved, the inquiry statement is direct, simple and convenient, and the inquiry is efficient.
Drawings
FIG. 1 is a schematic diagram of the basic information of a twist drill type tool in accordance with an embodiment of the present invention;
FIG. 2 is a diagram of select type agent classes 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 union-type proxy class according to an embodiment of the present invention;
FIG. 5 is a schematic view of a joint-type tool holder proxy according to an embodiment of the present invention;
FIG. 6 is a schematic diagram of group type proxy classes according to an embodiment of the present invention;
Detailed Description
In order to facilitate the understanding and implementation of the present invention for those of ordinary skill in the art, the present invention is further described in detail with reference to the accompanying drawings and examples, it is to be understood that the embodiments described herein are merely illustrative and explanatory of the present invention and are not restrictive thereof.
The invention provides a data model for manufacturing industry cutter data, which comprises the following steps:
step 1: constructing a basic tool information class according to the action and the relation of the tool in the tool application scene, wherein the basic tool information class comprises geometric shape parameter information of the tool, and naming all the tools and related data attributes according to standard naming in the tool application scene so as to avoid data conflict; the related data comprises tool holder information, machining process information and workpiece material information;
step 2: recording the form of the table for determining the cutter and the related attributes thereof in the step 1 as the basic class of the cutter information in the object proxy model;
the invention is applied to the example of a cutter scene in the manufacturing industry, and the basic classes constructed according to the cutter application scene store basic cutter classes, twist drills (Spiraldrils), use cases (usectase), workpieces (partial), and tool holders (toolholders). Fig. 1 shows basic information of a twist drill type tool, such as basic information of the tool, including information of a number, a diameter, a cutting edge angle, a programmed length, and the like.
Through the last step, the construction of the base classes in the tool data is completed. Next, it is necessary to use a modeling method to represent the associated data information by rich semantic relationships, so that the association relationships between different data can be expressed simply and accurately.
The embodiment carries out modeling management on the manufacturing tool data through selecting, connecting, combining and grouping the agent relations of four different agents.
And step 3: and (3) constructing a tool material proxy class which is a select proxy class according to the tool information basic class constructed in the step (2), wherein the tool material proxy class is generated from the tool basic class according to different tool materials, wherein the tool material proxy class comprises manufacturing materials, dimension parameters, tool number information and description information of the tool, and the description information comprises tool application range, material information, diameter, cutting edge angle, cutting length and tool holder interface information.
In this embodiment, since tools made of different tool materials are required for different processes in a tool processing scene, a select agent class is constructed on a tool source class through a select agent relationship, so that the problems of a large variety of tools and complex representation are solved, and as shown in fig. 2, four different types of tools are simply and clearly represented by creating an SE L ECT agent class for the tool source class.
And 4, step 4: constructing a tool processing proxy class according to the basic class of the tool information in the step 2, wherein the tool processing proxy class is a join proxy class and comprises tool information used in tool processing, workpiece information used for processing and a processing technology; the cutter information comprises a cutting data number, a cutting speed, a cutter number and a workpiece material;
in this embodiment, in practical application, a worker is required to determine the cutting speed of the tool machining according to the characteristics of the tool, the machining process and the shape of the machined workpiece, so that the tool machining class is created on the tool class, the use case class and the workpiece class by applying the connection relation, and thus, in specific machining application, judgment and selection are not required to be performed through the experience of the worker, and the recommended cutting speed can be directly searched for by machining requirements. As shown in fig. 3, a tool machining class is created by performing a join proxy for a twist drill tool using a class and a workpiece class.
And 5: constructing a tool agent class according to the tool information basic class in the step 2, wherein the tool agent class is an union agent class and contains description information of all tools in the numerical control machine tool machining; a cutter bit cutter, a turning tool cutter, a boring cutter and a milling cutter; the description information comprises tool application range, material information, diameter, cutting edge angle, cutting length and tool holder interface information;
in the embodiment, in the tool processing scene, because of different processing technology requirements, four different tool bodies are provided, in order to make the tool body type no longer single, a union proxy class is constructed on the four tool bodies by using a joint relation to contain all types of tool bodies, and the tool data information is enriched. As shown in fig. 4: the union proxy class is created on milling cutters, boring cutters, drill bits and turning cutters, so that the cutter body is rich in types.
Step 6: constructing a tool holder proxy class according to the basic class of the tool information in the step 2, wherein the tool holder proxy class is a join proxy class and comprises tool description information and tool holder information matched with the tool interface; the description information comprises the application range of the cutter, material information, diameter, cutting edge angle, cutting length and machine tool interface information;
in this embodiment, in the application of tool machining, the tool body cannot be directly mounted on a machine tool for machining, 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 a joint proxy class is constructed on the tool body and the tool holder through the joint proxy 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 proxy class. As shown in fig. 5: and constructing a join proxy class on the cutter body class and the cutter holder class through interface attributes.
And 7: according to the tool holder information basic component in the step 6, tool holder proxy classes are machine tool holder proxy classes, the machine tool holder proxy classes are group proxy classes, and tool description information which can be matched for each machine tool interface is contained in the tool holder proxy classes; the description information includes tool applicability, material information, diameter, cutting edge angle, cutting length, and machine tool interface information.
In the embodiment, in the application of tool machining, the tool needs to be frequently replaced due to the fact that a machined workpiece is abraded, and in the past, workers need to confirm the interface model of the machine tool and then go to a warehouse to find the tool with the same model interface, so that tools with different machine tool interface models are grouped by utilizing group proxy classes, and all tools suitable for the machine tool can be quickly found. As shown in fig. 6: and constructing a group proxy class on the tool class by using the interface attribute.
By the last step, the tool data has been modelled. Next, in order to meet the requirements for tool data in the machining scene of the numerically-controlled machine tool, the query requirements are simply and intuitively expressed by using the characteristics of the object proxy model, namely, a cross-class query mechanism.
The invention also provides a data query method for the cutter data in the manufacturing industry, which comprises the following steps:
when cutting data needs to be inquired, a data model facing tool data of the manufacturing industry is utilized, a cross-class inquiry statement is used, a specific recommended cutting speed value of a tool when the tool is used for machining a workpiece is required to be searched, the cutting speed (cuttingspeed) is inquired from a tool machining proxy class (Cuttingdata), a machined tool class (Spiral) is found from the tool machining proxy class (Cuttingdata) only through the cross-class inquiry, a filtering condition is determined through a diameter (diameter), a machining process class (using case) is found through the tool machining proxy class (cutingdata), the filtering condition is determined through tool description information (description), a machined workpiece material class (part material) is found from the tool machining proxy class (cutingdata), and the recommended cutting speed of tool machining meeting the condition is determined through the description information (description) of the workpiece material;
the query is represented by SQ L statement as SE L ECT cutting speed FROM tool machining agent class
WHERE (tool machining agent- > tool basic information class). diameter ═ 16.0'
AND (tool machining agent class- > machining case class) · descriptive information ═ roughing'
AND (tool processing agent class- > workpiece material information class). description information ═ GG';
an example of a query statement is 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 cutters stored in a cutter processing library needs to be counted, a data model facing cutter data in the manufacturing industry is used, and query statements are used; in the last step, different tools are classified and stored through modeling, so that when the tool inventory needs to be searched, the tool quantity is directly obtained by using an aggregation operation count for tool agent classes (such as Spiral);
an example of a query statement is as follows:
SELECT COUNT(attribute)FROM class;
when all tool holders applicable to a certain machine tool in a factory need to be searched, cross-class query statements are used by utilizing a data model facing tool data in the manufacturing industry; constitute cutter tool holder class (tool) through cutter agent class (Spiral) and cutter tool holder agent class (toolholder), machine tool cutter holder agent class (machineol) wherein the main attribute is machine tool interface (MConnection), so through the machine tool interface (MConnection) attribute value of confirming machine tool class (machineol) as the filter condition, find cutter ID (id) in cutter tool holder class (tool) through striding class inquiry for simply find the cutter that matches with high-efficiently when changing the cutter on the machine tool.
The query is represented by the SQ L statement as Select (machine tool toolholder agent class → tool agent class) — tool number (arrow represents cross-class query);
an example of a query statement is as follows:
SELECT(machinetool→tool).toolid FROM machinetool
WHERE machinetool.MConnection==<value>;
and modeling is carried out by utilizing step data, and all proxy relations in the model are recorded by a bidirectional pointer and a switching expression, so that the association relation between classes is represented by an arrow in query, and finally the recommended cutting speed meeting the conditions, the number of cutters and the cutter id matched with the fixed machine tool can be obtained, and query sentences are visual and clear.
The invention has the following advantages:
first, the tool data management method based on the object agent model provided in the present invention can be applied to any scene requiring similar application requirements, and the following specific description is provided:
in the text, the data of the tool machined by the numerical control machine is taken as an example, the entity and the data related to the scene of the machined workpiece are effectively managed, and in practical application, the data management method provided by the patent can be adopted when the scene of manufacturing industry, which relates to a plurality of entities and has complex association relation, is encountered.
Secondly, the data model in the invention not only carries out effective modeling management on the tool data, but also has flexible semantic expression, and the specific description is as follows:
when data modeling is carried out, firstly, analysis is carried out according to entities and data in an application scene, problems to be solved are determined, then the relation among different types of data is judged, and finally, modeling representation is carried out by using four different agent relations, namely a selected type, a join type, an union type and a group type, so that the problems in scene application are flexibly solved.
The method provided by the invention can well solve the problem of tool data management in the numerical control machine tool machining, and has important significance for the management of manufacturing data in a big data environment.
It should be understood that parts of the specification not set forth in detail are prior art; the above description of the preferred embodiments is intended to be illustrative, and not to be construed as limiting the scope of the invention, which is defined by the appended claims, and all changes and modifications that fall within the metes and bounds of the claims, or equivalences of such metes and bounds are therefore intended to be embraced by the appended claims.
Claims (2)
1. A data model for manufacturing tool data, the data model being constructed by the steps of:
step 1: constructing a basic tool information class according to the effect and the relation of the tool in the tool application scene, wherein the basic tool information class comprises geometric shape parameter information of the tool, and naming all the tools and related data attributes according to standard naming in the tool application scene; the related data comprises tool holder information, machining process information and workpiece material information;
step 2: recording the form of the table for determining the cutter and the related attributes thereof in the step 1 as the basic class of the cutter information in the object proxy model;
and step 3: constructing a tool material proxy class according to the tool information basic class constructed in the step 2, wherein the tool material proxy class is a select proxy class, and the tool material proxy class is generated from the tool basic class according to different tool materials, wherein the tool material proxy class comprises manufacturing materials, size parameters, tool number information and description information of a tool, and the description information comprises tool application range, material information, diameter, cutting edge angle, cutting length and tool holder interface information;
and 4, step 4: constructing a tool processing proxy class according to the basic class of the tool information in the step 2, wherein the tool processing proxy class is a join proxy class and comprises tool information used in tool processing, workpiece information used for processing and a processing technology; the cutter information comprises a cutting data number, a cutting speed, a cutter number and a workpiece material;
and 5: constructing a tool agent class according to the tool information basic class in the step 2, wherein the tool agent class is an union agent class and contains description information of all tools in the numerical control machine tool machining; the cutter bit cutter, the turning tool cutter, the boring tool cutter and the milling cutter; the description information comprises tool application range, material information, diameter, cutting edge angle, cutting length and tool holder interface information;
step 6: constructing a tool holder proxy class according to the basic class of the tool information in the step 2, wherein the tool holder proxy class is a join proxy class and comprises tool description information and tool holder information matched with the tool interface; the description information comprises the application range of the cutter, material information, diameter, cutting edge angle, cutting length and machine tool interface information;
and 7: according to the tool holder information basic component in the step 6, tool holder proxy classes are machine tool holder proxy classes, the machine tool holder proxy classes are group proxy classes, and tool description information which can be matched for each machine tool interface is contained in the tool holder proxy classes; the description information includes tool application range, material information, diameter, cutting edge angle, cutting length and machine tool interface information.
2. A data query method for manufacturing industry cutter data is characterized in that:
when cutting data needs to be inquired, a data model facing tool data of the manufacturing industry is utilized, a cross-class inquiry statement is used, a specific recommended cutting speed value of a tool when the tool is used for machining a workpiece is required to be searched, the cutting speed is inquired from a tool machining proxy class, the machined tool class is found from the tool machining proxy class through the cross-class inquiry, a filtering condition is determined through the diameter, a machining process class is found from the tool machining proxy class, the filtering condition is determined through tool description information, the machined workpiece material class is found from the tool machining proxy class, and the description information of the workpiece material is determined to determine the recommended cutting speed of the tool machining meeting the condition;
when the number of cutters stored in a cutter processing library needs to be counted, a data model facing cutter data in the manufacturing industry is used, and query statements are used; when the tool inventory needs to be searched, directly using the aggregation operation count for tool agents to obtain the number of tools;
when all tool holders applicable to a certain machine tool in a factory need to be searched, cross-class query statements are used by utilizing a data model facing tool data in the manufacturing industry; the tool holder class is formed by the tool agent class and the tool holder agent class, wherein the main attribute of the machine tool holder agent class is a machine tool interface, so that the machine tool interface attribute value of the machine tool class is determined to be used as a filtering condition, and the tool ID in the tool holder class is found by cross-class query, so that the matched tool can be simply and efficiently found when the tool is replaced on the machine tool.
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 true CN111460053A (en) | 2020-07-28 |
CN111460053B 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) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN115689452A (en) * | 2022-11-14 | 2023-02-03 | 深圳市金洲精工科技股份有限公司 | Drill bit inventory plan management method |
Citations (7)
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 |
-
2020
- 2020-04-15 CN CN202010294844.7A patent/CN111460053B/en active Active
Patent Citations (7)
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 (2)
Title |
---|
王敏: "制造业大数据分布式存储管理方法研究" * |
黄泽谦等: "一种支持对象代理数据库高效查询处理的索引结构" * |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN115689452A (en) * | 2022-11-14 | 2023-02-03 | 深圳市金洲精工科技股份有限公司 | Drill bit inventory plan management method |
CN115689452B (en) * | 2022-11-14 | 2023-06-20 | 深圳市金洲精工科技股份有限公司 | Drill stock planning management method |
Also Published As
Publication number | Publication date |
---|---|
CN111460053B (en) | 2023-09-08 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
Dubovska et al. | Implementation of CAD/CAM system CATIA V5 in Simulation of CNC Machining Process | |
CN106776712B (en) | Turning process database based on i5 intelligent numerical control lathe and application method thereof | |
CN101796463B (en) | NC program generating device and NC program generating method | |
US20160259323A1 (en) | Method for implementing design-for-manufacturability checks | |
US20200201284A1 (en) | Method and system for automatic generation of computer-aided manufacturing instructions | |
CN104289954A (en) | System and method for selecting cutting tools | |
US10754322B2 (en) | System and method for selecting a tool assembly | |
CN111460053B (en) | Data query method for manufacturing cutter data | |
Wong et al. | A knowledge-based approach to automated machining process selection and sequencing | |
Abdou et al. | TVCAPP, tolerance verification in computer-aided process planning | |
Fernandes et al. | Incorporated tool selection system using object technology | |
CN114626190A (en) | Knowledge graph-based process design resource model construction method | |
Kang et al. | A classification of multi-axis features based on manufacturing process | |
Pande et al. | PC-CAPP—a computer-assisted process planning system for prismatic components | |
CN106528953A (en) | Aircraft structural part process design-oriented process knowledge conception model description method | |
CN115113584B (en) | Numerical control automatic programming method based on example and rule reasoning | |
Pande et al. | Expert CAPP system for single spindle automats | |
Ostojic et al. | An integral system for automated cutting tool selection | |
Lee et al. | Development of ISO14649 compliant CNC milling machine operated by STEP-NC in XML format | |
Usher | Object oriented approach to feature-based process planning | |
Xiang et al. | A generative feature-based CAPP/CNC system for hydraulic manifold blocks | |
Ahola | Creo Parametric Milling | |
JP2972048B2 (en) | How to create NC data | |
Wong et al. | An automated process planning system for prismatic parts | |
Jang et al. | Tool selection in machining by integration of a data base and a rule based system |
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 |