CN103823895A - Cutter cutting database management system - Google Patents
Cutter cutting database management system Download PDFInfo
- Publication number
- CN103823895A CN103823895A CN201410091954.8A CN201410091954A CN103823895A CN 103823895 A CN103823895 A CN 103823895A CN 201410091954 A CN201410091954 A CN 201410091954A CN 103823895 A CN103823895 A CN 103823895A
- Authority
- CN
- China
- Prior art keywords
- submodule
- cutter
- cutting
- management
- information
- 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
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/21—Design, administration or maintenance of databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Numerical Control (AREA)
Abstract
The invention discloses a cutter cutting database management system, comprising a system management module, a cutter database module and a cutting parameter database module; the system management module comprises a user management submodule, a password amending module and an authority management module; the cutter database module comprises a cutter query submodule, a cutter borrowing-lending submodule, a data maintenance submodule, an information browsing submodule and a service life management submodule; the cutting parameter database module comprises a data retrieval submodule, a data maintenance submodule and a cutting data optimizing submodule. When needed in a manufacturing process, the information related to the cutters are directly queried on a computer terminal, the related information can be automatically displayed, a cutter service life management module can be used for calculating the rest abrasion service life of the cutter and updating the storage of the service life in the database, and the cutting data optimizing module is used for optimizing the cutting condition selected from the database according to cutting conditions and displaying the result onto the computer terminal.
Description
Technical field
The invention belongs to tool management field, relate in particular to a kind of Tool in Cutting data base management system (DBMS).
Background technology
It is the static management of cutter that the current tool management great majority of China also rest on general tool management information system pattern, also there is no at present realization about Real-Time Scheduling and the on-line machining state monitoring and management of cutter.Tool management has traditionally had many theories and method, and has had many successfully experiences.Be engaged in the expert of Tool Management System research both at home and abroad, also developed a lot of tool management software for various different situations, these systems have surmounted simple artificial Tool management model in the past greatly, and advanced database technology, network technology, control technology are all adopted, realize tool management computerize and integrated, realized information sharing.But these systems are mostly analyzed pattern and the feature of tool management from the angle of manufacturing, just simply require tool management to meet the needs of production.Therefore, traditional tool management method does not comprise the full content of tool management, also has some limitations.This limitation is embodied in the following aspects:
1) one or several period in cutter life has only been studied in conventional tool management, lacks the analysis to the whole cutter life cycle, and the content of tool management is comprehensive not.
2) Module Division of conventional tool management is relatively disperseed, is isolated, and lacks corresponding information interaction, thereby cannot realize the integration Management in total life of tool between module.
3) conventional tool management be the Tools Requirement meeting in the manufacturing be that target is not considered the Cost Problems in total life of tool, thereby cannot provide decision support to enterprise production and management.
Summary of the invention
The object of the present invention is to provide a kind of Tool in Cutting data base management system (DBMS), the content that is intended to solve traditional tool management method tool management not comprehensively, cannot realize integration Management in total life of tool, not consider the problem of the Cost Problems in total life of tool.
The present invention is achieved in that a kind of Tool in Cutting data base management system (DBMS), comprises system management module, cutter database module, cutting parameter database module;
Described system management module comprises user management submodule, password modification submodule, rights management submodule; By rights management is set, realize the differentiated control to cutter Database in Cutting Database management system, prevent the illegal use to system resource;
Described cutter database module comprises that cutter inquiry submodule, cutter are by means of going back submodule, data maintenance submodule, information browse submodule, life-span management submodule;
Cutter inquiry submodule is used for inquiring about tool-information, and user can grasp needed tool-information fast;
Cutter carries out record by means of going back submodule for the also information of borrowing to cutter, grasps in real time the parameter information of cutter, upgrades the information in cutter database;
Data maintenance submodule, for tool-information is added, is deleted, and revises;
Information browse submodule refers to that general user browses the information in database;
Life-span management submodule is for predicting cutter life;
Cutting parameter database module comprises data retrieval submodule, data maintenance submodule, cutting data optimization submodule; Realize inquiry to cutting data and the interpolation of relevant cutting data, delete and revise, according to Optimized model, cutting data is optimized.
Further, in administration authority submodule, manager of programming's authority is the highest, can browse and safeguard all resources, and general user can only browse.
Further, described Tool in Cutting data base management system (DBMS) adopts PowerBuilder9.0 as development platform in the time of exploitation.
effect gathers
Tool in Cutting data base management system (DBMS) of the present invention, need to be about the relevant information of cutter in manufacture process time, can directly on terminal, inquire about it, relevant information can show automatically, tool life management module can be calculated cutter residual wear life, and upgrades its storage in database, and cutting data is optimized module, the cutting data of selecting from database according to machining condition is optimized, and result is presented on terminal.
Accompanying drawing explanation
Fig. 1 is the structural representation of the Tool in Cutting data base management system (DBMS) that provides of the embodiment of the present invention;
Fig. 2 is the system management module process flow diagram that the embodiment of the present invention provides;
Fig. 3 is the cutter database module process flow diagram that the embodiment of the present invention provides;
Fig. 4 is the Cutting data library module process flow diagram that the embodiment of the present invention provides;
In figure: 1, system management module; 2, cutter database module; 3, cutting parameter database module.
Embodiment
In order to make object of the present invention, technical scheme and advantage clearer, below in conjunction with drawings and Examples, the present invention is further elaborated.Should be appreciated that specific embodiment described herein, only in order to explain the present invention, is not intended to limit the present invention.
Fig. 1 shows the structure of Tool in Cutting data base management system (DBMS) of the present invention, and as shown in the figure, the present invention is achieved in that a kind of Tool in Cutting data base management system (DBMS), comprises system management module 1, cutter database module 2, cutting parameter database module 3;
Described system management module 1 comprises user management submodule, password modification submodule, rights management submodule; By rights management is set, realize the differentiated control to cutter Database in Cutting Database management system, prevent the illegal use to system resource;
Described cutter database module 2 comprises that cutter inquiry submodule, cutter are by means of going back submodule, data maintenance submodule, information browse submodule, life-span management submodule;
Cutter inquiry submodule is used for inquiring about tool-information, and user can grasp needed tool-information fast;
Cutter carries out record by means of going back submodule for the also information of borrowing to cutter, grasps in real time the parameter information of cutter, upgrades the information in cutter database;
Data maintenance submodule, for tool-information is added, is deleted, and revises;
Information browse submodule refers to that general user browses the information in database;
Life-span management submodule is for predicting cutter life;
Cutting parameter database module 3 comprises data retrieval submodule, data maintenance submodule, cutting data optimization submodule; Realize inquiry to cutting data and the interpolation of relevant cutting data, delete and revise, according to Optimized model, cutting data is optimized.
Further, in administration authority submodule, manager of programming's authority is the highest, can browse and safeguard all resources, and general user can only browse.
Further, described Tool in Cutting data base management system (DBMS) adopts PowerBuilder9.0 as development platform in the time of exploitation.
Tool in Cutting data base management system (DBMS) of the present invention, need to be about the relevant information of cutter in manufacture process time, can directly on terminal, inquire about it, relevant information can show automatically, tool life management module can be calculated cutter residual wear life, and upgrades its storage in database, and cutting data is optimized module, the cutting data of selecting from database according to machining condition is optimized, and result is presented on terminal.
By reference to the accompanying drawings the specific embodiment of the present invention is described although above-mentioned; but not limiting the scope of the invention; one of ordinary skill in the art should be understood that; on the basis of technical scheme of the present invention, those skilled in the art do not need to pay various modifications that performing creative labour can make or distortion still within protection scope of the present invention.
Claims (3)
1. a Tool in Cutting data base management system (DBMS), is characterized in that, described Tool in Cutting data base management system (DBMS) comprises system management module, cutter database module, cutting parameter database module;
Described system management module comprises user management submodule, password modification submodule, rights management submodule; By rights management is set, realize the differentiated control to cutter Database in Cutting Database management system, prevent the illegal use to system resource;
Described cutter database module comprises that cutter inquiry submodule, cutter are by means of going back submodule, data maintenance submodule, information browse submodule, life-span management submodule;
Cutter inquiry submodule is used for inquiring about tool-information, and user can grasp needed tool-information fast;
Cutter carries out record by means of going back submodule for the also information of borrowing to cutter, grasps in real time the parameter information of cutter, upgrades the information in cutter database;
Data maintenance submodule, for tool-information is added, is deleted, and revises;
Information browse submodule refers to that general user browses the information in database;
Life-span management submodule is for predicting cutter life;
Cutting parameter database module comprises data retrieval submodule, data maintenance submodule, cutting data optimization submodule; Realize inquiry to cutting data and the interpolation of relevant cutting data, delete and revise, according to Optimized model, cutting data is optimized.
2. Tool in Cutting data base management system (DBMS) as claimed in claim 1, is characterized in that, in administration authority submodule, manager of programming's authority is the highest, can browse and safeguard all resources, and general user can only browse.
3. Tool in Cutting data base management system (DBMS) as claimed in claim 1, is characterized in that, described Tool in Cutting data base management system (DBMS) adopts PowerBuilder9.0 as development platform in the time of exploitation.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410091954.8A CN103823895A (en) | 2014-03-13 | 2014-03-13 | Cutter cutting database management system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410091954.8A CN103823895A (en) | 2014-03-13 | 2014-03-13 | Cutter cutting database management system |
Publications (1)
Publication Number | Publication Date |
---|---|
CN103823895A true CN103823895A (en) | 2014-05-28 |
Family
ID=50758959
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201410091954.8A Pending CN103823895A (en) | 2014-03-13 | 2014-03-13 | Cutter cutting database management system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN103823895A (en) |
Cited By (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105739434A (en) * | 2016-03-28 | 2016-07-06 | 常熟万克精密工具有限公司 | Informatization management system for machining of hard alloy cutter and use method thereof |
CN105929793A (en) * | 2016-04-25 | 2016-09-07 | 哈尔滨理工大学 | GT-based cutter management method and system |
CN106096809A (en) * | 2016-05-26 | 2016-11-09 | 西京学院 | A kind of the Internet+tool-information and resource distribution integrated management system |
CN113245649A (en) * | 2021-05-28 | 2021-08-13 | 珠海格力精密模具有限公司 | Multi-electrode efficient machining method |
CN113272746A (en) * | 2019-05-09 | 2021-08-17 | 西门子股份公司 | Method, device and system for setting service life of cutting tool based on tool change record |
-
2014
- 2014-03-13 CN CN201410091954.8A patent/CN103823895A/en active Pending
Cited By (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105739434A (en) * | 2016-03-28 | 2016-07-06 | 常熟万克精密工具有限公司 | Informatization management system for machining of hard alloy cutter and use method thereof |
CN105739434B (en) * | 2016-03-28 | 2018-08-14 | 常熟万克精密工具有限公司 | A kind of Information Management System and its application method of hard alloy cutter processing |
CN105929793A (en) * | 2016-04-25 | 2016-09-07 | 哈尔滨理工大学 | GT-based cutter management method and system |
CN105929793B (en) * | 2016-04-25 | 2018-11-02 | 哈尔滨理工大学 | A kind of tool management method and system based on GT technologies |
CN106096809A (en) * | 2016-05-26 | 2016-11-09 | 西京学院 | A kind of the Internet+tool-information and resource distribution integrated management system |
CN113272746A (en) * | 2019-05-09 | 2021-08-17 | 西门子股份公司 | Method, device and system for setting service life of cutting tool based on tool change record |
CN113272746B (en) * | 2019-05-09 | 2024-04-09 | 西门子股份公司 | Cutting tool life setting method, device and system based on tool replacement record |
CN113245649A (en) * | 2021-05-28 | 2021-08-13 | 珠海格力精密模具有限公司 | Multi-electrode efficient machining method |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN103823895A (en) | Cutter cutting database management system | |
CN101075304A (en) | Method for constructing decision supporting system of telecommunication industry based on database | |
US8407669B2 (en) | Device based software authorizations for software asset management | |
US8874455B2 (en) | Convergence of customer and internal assets | |
CN104115139A (en) | Providing configurable workflow capabilities | |
CN102917006B (en) | A kind of unified control and management method and device realizing computational resource and object permission | |
WO2012167267A2 (en) | Building information tracking system and method of use | |
CN103577605A (en) | Data warehouse based on data fusion and data mining and application method of data warehouse | |
US20220391395A1 (en) | Workflow driven database partitioning | |
CN102143202A (en) | Information integration method and information integration system for industrial production equipment | |
CN107944284B (en) | Method and system for internal security control of enterprise data | |
CN104615710A (en) | Electronic map frame data updating method | |
CN110580148A (en) | Integration-oriented EPC project management platform | |
CN107330580A (en) | Power marketing Base data platform construction method | |
CN114756563A (en) | Data management system with multiple coexisting complex service lines of internet | |
CN104834787B (en) | Perception and analysis method for energy consumption of bearing grinding machine production workshop | |
CN102646119B (en) | Method for realizing integration of standardized system and information system | |
CN109918363B (en) | Method for carrying out data model consistency management based on view cross-database type | |
CN101964816A (en) | Method and system for browsing data in browser/server (B/S) framework software system | |
CN104731051A (en) | Method for achieving sensor point position objectification | |
CN104331426A (en) | Quick retrieving method of power system retriever based on browser | |
CN101615272A (en) | A kind of approaches to IM and information management system | |
CN108664370B (en) | Distributed industrial on-line configuration monitoring system and method | |
CN103020139B (en) | Tables of data expanding system and tables of data extended method | |
CN109426947B (en) | Enterprise information interaction system based on tree-shaped virtual node network |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20140528 |
|
WD01 | Invention patent application deemed withdrawn after publication |