CN106250422B - A kind of standard component data method for quickly retrieving based on PDM systems - Google Patents
A kind of standard component data method for quickly retrieving based on PDM systems Download PDFInfo
- Publication number
- CN106250422B CN106250422B CN201610590016.1A CN201610590016A CN106250422B CN 106250422 B CN106250422 B CN 106250422B CN 201610590016 A CN201610590016 A CN 201610590016A CN 106250422 B CN106250422 B CN 106250422B
- Authority
- CN
- China
- Prior art keywords
- standard component
- pdm
- standard
- module
- sequence
- 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
Links
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/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
- G06F16/90335—Query processing
- G06F16/90348—Query processing by searching ordered data, e.g. alpha-numerically ordered data
Abstract
The invention discloses a kind of standard component data method for quickly retrieving based on PDM systems, the system module that the search method is used in detection process includes PDM systems and its file volume server, PDM and standard component sequence interface module, standard component load-on module, standard component order module；When opening standard parts library, according to engineer's use habit, realize variation sequence, and ranking results are output in PDM system standard parts storehouse, the present invention builds a Unified frame based on PDM systems, PDM systems and standard component quick-searching function is integrated, the standard component by Optimal scheduling is shown in PDM system standard parts storehouse, simplify the operating procedure of engineer, improve design efficiency, solve the problems, such as three-dimensional standard component data sorted sequencing display in PDM systems, can be by loading the standard component after sequence, standard component needed for quick positioning, it is easy to data retrieval with using；Also it can be recorded in PDM systems and collect Update log, and feed back to engineer in time.
Description
Technical field
The present invention relates to the retrieval technique of standard component, more particularly to a kind of standard component data based on PDM systems are quickly examined
Suo Fangfa.
Background technology
PDM systems are a kind of centered on product data and activity, to business events flow path, design data and production process
The integrated platform being managed.PDM main function of system includes eletronic data management, Classification Management, workflow and process management, item
Mesh is managed, CAD is integrated etc..At present, enterprise uses Classification Management module creation class library, management enterprise in the PDM systems of implementation
Industry basic data and knowledge data.The class library created by Classification Management includes standard parts library, material pieces storehouse, frock and fixture
Storehouse, technical standard storehouse etc..Wherein standard parts library classification stores the standard component threedimensional model that enterprise needs to use, these standards
Part can be divided into the major classes such as national standard, professional standard, company standard by standard.Engineer is produced using Three-dimensional CAD Software
When product are designed, standard component threedimensional model is browsed according to standard component criteria for classification, standard component figure number from standard parts library, luggage of going forward side by side
With using.As scope of the enterprise is bigger, product line is more, and the standard component quantity classified and be put in storage is increasing, and species is more next
More complete, the scale of standard parts library is more and more huger.
After PDM systems, the standard component in standard parts library is called to be assembled in integrated Three-dimensional CAD Software,
Shortcomings during standard component lookup, use, are mainly manifested in the following aspects：
（1）Class library Plays part substantial amounts, standard is numerous, and engineer is when in use, it is necessary first to deploy classification tree,
Step by step by branches such as criteria for classification, classification groups, then each standard component is browsed one by one according to parameters such as specification, sizes,
Search, time-consuming effort.
（2）Engineer when being assembled to part using standard component, according to use habit, can preferentially select in design three-dimensional objects
With standard component that is conventional, being familiar with to specification, standard, or the modular construction feature designed in itself according to engineer, compared with
Some specific criterias, the standard component of specification are often used, other standard components are used less.Traditional PDM systems, which provide engineer, to be made
Be the standard component candidate list in unified standard parts library structure, storehouse always according to the loading of standard component figure number order, display,
In search criteria part, the standard component more often used can be because sorting position rearward, causes each query time of engineer longer.
Current PDM systems lack a kind of engineer to the quick search of standard parts library standard component and use have efficacious prescriptions
Formula, if the characteristics of being assembled according to every engineer using the custom and part of standard component, system is timely, obtain standard component automatically
The frequency and number of times used, the dynamically order standard part under the conditions of different settings so that candidate criteria part puts in order more
Meet engineer's use habit, so that the quicksort to standard component and the function of system self study are realized, while in PDM systems
Real-time statistics standard component service condition in standard parts library, in time adjustment is sorted and notifies engineer, can effectively simplify engineer's
Inquiry, improves design work efficiency.
The content of the invention
For above-mentioned technical problem, the present invention provides a kind of standard component data method for quickly retrieving based on PDM systems,
When opening standard parts library, according to engineer's use habit, variation sequence is realized, and ranking results are output to PDM system marks
In quasi- part storehouse, facilitate engineer's retrieval and the standard component sort method based on PDM systems used.
The technical scheme is that：
A kind of standard component data method for quickly retrieving based on PDM systems, the search method is used in detection process
The system module arrived includes PDM systems and its file volume server, PDM and standard component sequence interface module, standard component loading mould
Block and standard component order module；Specific search method comprises the following steps：
The standard parts library of step 1, opening defined in PDM genealogical classifications management, passes through PDM and standard component sequence interface mould
Block sets standard component sortord, ordering rule, ranking replacement cycle, and PDM and the standard component interface module that sorts will be set
Sortord, ordering rule and the storage of ranking replacement cycle are into PDM system databases；
Standard component information in step 2, PDM and standard component sequence interface module ergodic data storehouse table, obtains standard component most
General assembly number of times and standard component user of service information of the time, standard component of nearly first use in assembling, by the mark got
Quasi- part use information is stored in standard component ranking index table, and generates journal file；
Step 3, PDM and standard component sequence interface module call standard component load-on module, and standard component load-on module is from PDM numbers
The sortord set according to being obtained in storehouse, biography value sets in calculator memory memory space to standard component order module,
Wait standard component order module operation collator；
Step 4, standard component order module load the ordering rule set according to the sortord of setting, read PDM numbers
According to the standard component ranking index table in storehouse, finally standard component is ranked up.
Specifically, standard component sortord is divided into two kinds of quicksort mode and progressive sortord.
Standard component order module is ranked up using quicksort mode, reads the ranking replacement stored in PDM databases
Cycle parameter value, judges whether to update standard component ranking index table：When needing to update concordance list, sorted by PDM and standard component
Interface module traversal PDM system databases in standard component, obtain standard component the last time use time, standard component assembling
In general assembly number of times, standard component user of service's information, then automatically update concordance list, and generate Update log file；Sequence
Module is ranked up according to the ordering rule of setting to all standard components；Standard component load-on module is stored in calculator memory
Order standard part, and the standard component candidate list in PDM system standard parts storehouse is output to by PDM and the standard component interface module that sorts,
PDM reads journal file with standard component sequence interface module, is engineer's display refresh time.
Standard component order module is ranked up using progressive sortord, and PDM starts with standard component sequence interface module to be marked
Quasi- part is using program is intercepted, when engineer is assembled using some standard component, intercepts program real-time from PDM databases
The use information of standard component is obtained, updates and arrives standard component ranking index table；Standard component order module uses progressive sortord, adjusts
Ordering rule is taken, the sequence to the standard component is adjusted, and it is changed in standard component by PDM and standard component sequence interface module
The home position of storehouse candidate list, is allowed to move forward.
It is preferred that, the standard component, using program is intercepted, is by PDM and standard component sequence interface module real-time sense PDM
The INSERT triggers of system database standard component information table, UPDATE triggers, when having triggering generation, then calculating standard component is made
With once, standard component ranking index table is updated.
It is preferred that, ordering rule includes described in step 1：（1）Sorted by standard component criteria for classification；（2）By engineer's name
Sequence；（3）The time-sequencing used by the last time；（4）By general assembly number of times sequence of the standard component in assembling；（5）By mark
Quasi- part figure number sequence.
It is preferred that, PDM described in step 2 updates the use information of each standard component to mark with standard component sequence interface module
Quasi- part ranking index table, generates corresponding journal file when updating every time, is stored in PDM systems, the letter of journal file record
Breath includes renewal time, updates standard component, updates result.
It is preferred that, the PDM and standard component sequence interface module by setting parameters sortnig, perform standard component loading, renewal
Three sub-function module compositions of standard component use information：
Parameters sortnig sub-function module is set to be used to set sort method, ordering rule is set, the ranking replacement cycle is set,
Stored after being provided with PDM system databases；
Performing standard component loading sub-function module is used to call standard component load-on module, by the sequence in calculator memory
Standard component is output in PDM standard parts library standard component candidate lists；
Updating standard component use information sub-function module, there is standard component to use listening functions, real-time sense PDM system numbers
According to the INSERT of library standard part information table, UPDATE triggers, for real-time judge standard component whether by Utility Engineers in assembling,
Standard component use information is read from PDM system databases, and is updated to database standard part ranking index table, while generating day
Will file, record renewal time, renewal standard component, renewal object information.
It is an advantage of the invention that：
A kind of standard component data method for quickly retrieving based on PDM systems of the present invention is using above technical scheme and now
There is technology to compare, with following technique effect：
1. the present invention builds a Unified frame based on PDM systems, by PDM systems and standard component quick-searching function
It is integrated, the standard component by Optimal scheduling is shown in PDM system standard parts storehouse, the operating procedure of engineer is simplified, improved
Design efficiency；
2. solving the problems, such as three-dimensional standard component data sorted sequencing display in PDM systems, it can be sorted by loading
Standard component afterwards, standard component needed for quick positioning, is easy to data retrieval with using；Also it can be recorded in PDM systems and collect renewal
Daily record, and engineer is fed back in time.
Brief description of the drawings
Below in conjunction with the accompanying drawings and embodiment the invention will be further described：
Fig. 1 is the module diagram of the standard component data method for quickly retrieving of the present invention based on PDM systems；
Fig. 2 is the standard component data quick-searching flow chart of the present invention based on PDM systems；
Fig. 3 is present invention design PDM and the schematic diagram of standard component sequence interface module.
Embodiment
As shown in figure 1, the disclosed standard component data method for quickly retrieving based on PDM systems is in practical application mistake
Cheng Zhong, the system module used includes PDM systems and its file volume server, PDM and standard component sequence interface module（With
Lower abbreviation interface module）, standard component load-on module, standard component order module.
As shown in Fig. 2 the standard component method for quickly retrieving based on PDM systems is operated as follows：
Step 1, engineer open the standard parts library defined in being managed in PDM genealogical classifications, are sorted by PDM and standard component
Interface module sets standard component sortord, ordering rule, ranking replacement cycle, interface module by the sortord set,
Ordering rule is stored into PDM system databases with the ranking replacement cycle；Standard component sortord be divided into quicksort mode and
Progressive two kinds of sortord.
It is as shown in the table in the content of ordering rule settable with standard component sequence interface module PDM.
Standard component information in step 2, PDM and standard component sequence interface module ergodic data storehouse table, obtains standard component most
General assembly number of times of the time, standard component of nearly first use in assembling, standard component user of service's information, by the standard got
Part use information is stored in standard component ranking index table, and generates journal file.
Interface module, which updates the use information of each standard component, arrives standard component ranking index table, generation pair when updating every time
The journal file answered, is stored in PDM systems, and the information of journal file record includes renewal time, updates standard component, updates knot
Really.
Step 3, PDM and standard component sequence interface module call standard component load-on module, and standard component load-on module is from PDM numbers
The sortord set according to being obtained in storehouse, biography value sets in calculator memory memory space to standard component order module,
Wait standard component order module operation collator.
Step 4, standard component order module load the ordering rule set according to the sortord of setting, read PDM numbers
According to the standard component ranking index table in storehouse.
Step 4 can perform the two ways order standard part of step 5, step 6 respectively after terminating.
Step 5, sorted using quicksort mode by standard component order module, read the sequence stored in PDM databases
Update cycle parameter value, judges whether to update standard component ranking index table：When needing to update concordance list, traveled through by interface module
Standard component in PDM system databases, the time, standard component that acquisition standard component the last time the uses general assembly in assembling time
Number, standard component user of service's information, then automatically update concordance list, and generate journal file；Order module according to setting row
Sequence rule is ranked up to all standard components；Standard component load-on module stores order standard part in calculator memory, and by
Interface module is output to the standard component candidate list in PDM system standard parts storehouse, and interface module reads journal file, is that engineer shows
Show renewal time；
Step 6, interface module start standard component using program is intercepted, when engineer is assembled using some standard component
When, the use information that program obtains standard component from PDM databases in real time is intercepted, updates and arrives standard component ranking index table；Standard
Part order module uses progressive sortord, transfers ordering rule, the sequence to the standard component is adjusted, and by interface module
Change it in the home position of standard parts library candidate list, be allowed to move forward；
The standard component, using program is intercepted, is by interface module real-time sense PDM system database standard component information tables
INSERT triggers, UPDATE triggers, have triggering occur when, then calculate standard component be only used once, update standard component sequence
Concordance list.
As shown in figure 3, PDM and standard component sequence interface module in the standard component data quick retrieval system, by setting
Parameters sortnig is put, standard component loading is performed, updates three sub-function module compositions of standard component use information：
Parameters sortnig sub-function module is set to be used to set sort method, ordering rule is set, the ranking replacement cycle is set,
Stored after being provided with PDM system databases.
Performing standard component loading sub-function module is used to call standard component load-on module, by the sequence in calculator memory
Standard component is output in PDM standard parts library standard component candidate lists, while reading database Update log file, when display updates
Between.
Updating standard component use information sub-function module, there is standard component to use listening functions, can real-time sense PDM systems
The INSERT of database standard part information table, UPDATE triggers, for real-time judge standard component whether by Utility Engineers in dress
Match somebody with somebody.When engineer adds standard component in assembling and is preserved, relevant information deposit PDM system database standard component information
Table, updates standard component use information sub-function module and standard component use information, including standard component is read from PDM system databases
General assembly number of times of the time, standard component that the last time uses in assembling, standard component user of service's information, and by these information
Database standard part ranking index table is updated, while journal file is generated, record renewal time, renewal standard component, renewal knot
The information such as fruit.
The above embodiments merely illustrate the technical concept and features of the present invention, and its object is to allow person skilled in the art
Present disclosure can be understood and implemented according to this, it is not intended to limit the scope of the present invention.It is all main according to the present invention
The modification for wanting the Spirit Essence of technical scheme to be done, should all be included within the scope of the present invention.
Claims (7)
1. a kind of standard component data method for quickly retrieving based on PDM systems, it is characterised in that：The search method was being detected
The system module used in journey includes PDM systems and its file volume server, PDM and standard component sequence interface module, standard
Part load-on module and standard component order module；Specific search method comprises the following steps：
The standard parts library of step 1, opening defined in PDM genealogical classifications management, is set by PDM with standard component sequence interface module
Put standard component sortord, ordering rule, ranking replacement cycle, PDM and standard component sequence interface module are by the sequence set
Mode, ordering rule and the storage of ranking replacement cycle are into PDM system databases；
Standard component information in step 2, PDM and standard component sequence interface module ergodic data storehouse table, obtains standard component nearest one
The general assembly number of times and standard component user of service's information of the secondary time used, standard component in assembling, by the standard component got
Use information is stored in standard component ranking index table, and generates journal file；
Step 3, PDM and standard component sequence interface module call standard component load-on module, and standard component load-on module is from PDM databases
Middle to obtain the sortord set, biography value sets memory space to standard component order module, and in calculator memory, waits
Standard component order module runs collator；
Step 4, standard component order module load the ordering rule set according to the sortord of setting, read PDM databases
In standard component ranking index table, finally standard component is ranked up.
2. the standard component data method for quickly retrieving according to claim 1 based on PDM systems, it is characterised in that：Step 4
Plays part order module is ranked up using quicksort mode, reads the ranking replacement cycle ginseng stored in PDM databases
Numerical value, judges whether to update standard component ranking index table：When needing to update concordance list, by PDM and standard component sequence interface mould
Standard component in block traversal PDM system databases, obtains time for using standard component the last time, standard component total in assembling
Number of times, standard component user of service's information are assembled, concordance list is then automatically updated, and generate Update log file；Order module is pressed
All standard components are ranked up according to the ordering rule of setting；Standard component load-on module stores the mark that sorted in calculator memory
Quasi- part, and the standard component candidate list in PDM system standard parts storehouse, PDM and mark are output to by PDM and the standard component interface module that sorts
Quasi- part sequence interface module reads journal file, is engineer's display refresh time.
3. the standard component data method for quickly retrieving according to claim 1 based on PDM systems, it is characterised in that：Step 4
Plays part order module is ranked up using progressive sortord, and PDM starts standard component with standard component sequence interface module to be made
With program is intercepted, when engineer is assembled using some standard component, intercept program and obtain mark from PDM databases in real time
The use information of quasi- part, updates and arrives standard component ranking index table；Standard component order module uses progressive sortord, transfers sequence
Rule, the sequence to the standard component is adjusted, and changes it in standard parts library candidate by PDM and standard component sequence interface module
The home position of list, is allowed to move forward.
4. the standard component data method for quickly retrieving according to claim 3 based on PDM systems, it is characterised in that：It is described
Standard component, using program is intercepted, is by PDM and standard component sequence interface module real-time sense PDM system database standard component information
The INSERT triggers of table, UPDATE triggers when having triggering generation, are then calculated standard component and are only used once, update standard component row
Sequence index table.
5. the standard component data method for quickly retrieving according to claim 1 based on PDM systems, it is characterised in that：Step 1
The ordering rule includes：（1）Sorted by standard component criteria for classification；（2）Sorted by engineer's name；（3）Make by the last time
Time-sequencing；（4）By general assembly number of times sequence of the standard component in assembling；（5）Sorted by standard component figure number.
6. the standard component data method for quickly retrieving according to claim 1 based on PDM systems, it is characterised in that：Step 2
The PDM, which updates the use information of each standard component with standard component sequence interface module, arrives standard component ranking index table, every time
Corresponding journal file is generated during renewal, is stored in PDM systems, the information of journal file record includes renewal time, updated
Standard component, renewal result.
7. the standard component data method for quickly retrieving according to claim 1 based on PDM systems, it is characterised in that：It is described
PDM and standard component sequence interface module, by setting parameters sortnig, perform standard component loading, renewal standard component use information three
Sub-function module is constituted：
Set parameters sortnig sub-function module to be used to set sort method, ordering rule is set, the ranking replacement cycle is set, set
After the completion of store in PDM system databases；
Performing standard component loading sub-function module is used to call standard component load-on module, by the order standard in calculator memory
Part is output in PDM standard parts library standard component candidate lists；
Updating standard component use information sub-function module, there is standard component to use listening functions, real-time sense PDM system databases
The INSERT of standard component information table, UPDATE trigger, for real-time judge standard component whether by Utility Engineers in assembling, from
Standard component use information is read in PDM system databases, and is updated to database standard part ranking index table, while generating daily record
File, record renewal time, renewal standard component, renewal object information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610590016.1A CN106250422B (en) | 2016-07-26 | 2016-07-26 | A kind of standard component data method for quickly retrieving based on PDM systems |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610590016.1A CN106250422B (en) | 2016-07-26 | 2016-07-26 | A kind of standard component data method for quickly retrieving based on PDM systems |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106250422A CN106250422A (en) | 2016-12-21 |
| CN106250422B true CN106250422B (en) | 2017-09-19 |
Family
ID=57604618
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610590016.1A Active CN106250422B (en) | 2016-07-26 | 2016-07-26 | A kind of standard component data method for quickly retrieving based on PDM systems |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106250422B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106649718B (en) * | 2016-12-22 | 2019-10-25 | 盐城工学院 | A kind of big data acquisition and processing method for PDM system |
| CN108334600A (en) * | 2018-01-31 | 2018-07-27 | 杭州优工品科技有限公司 | Data storage method and device for industrial part |
| CN109492266B (en) * | 2018-10-18 | 2023-09-29 | 沈阳透平机械股份有限公司 | Optimization design method, device and equipment for standard part model data |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20060022371A (en) * | 2004-09-07 | 2006-03-10 | 현대중공업 주식회사 | Method for attribute control of 3d cad(unigraphics) |
| CN102004800A (en) * | 2010-12-28 | 2011-04-06 | 北京数码大方科技有限公司 | Data query method and device of PDM (Product Data Management) system |
| CN104021002B (en) * | 2014-06-19 | 2017-03-29 | 盐城工学院 | A kind of PDM system standards part storage method |
-
2016
- 2016-07-26 CN CN201610590016.1A patent/CN106250422B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN106250422A (en) | 2016-12-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103218719B (en) | A kind of e-commerce website air navigation aid and system | |
| CN106250422B (en) | A kind of standard component data method for quickly retrieving based on PDM systems | |
| EP2915074A1 (en) | Automated report generation method | |
| CN105718565A (en) | Data warehouse model construction method and construction apparatus | |
| CN103631922A (en) | Hadoop cluster-based large-scale Web information extraction method and system | |
| CN104899143A (en) | Software peer review system realizing device for providing DM (Data Mining) | |
| CN106408435A (en) | Process compiling system and process compiling method | |
| CN108363776A (en) | A kind of self-defined display methods of table field | |
| CN106649718A (en) | Large data acquisition and processing method for PDM system | |
| CN102332004A (en) | Data processing method and system for managing mass data | |
| CN113807629A (en) | Green building project report evaluation system and method | |
| CN106127863B (en) | A kind of refrigerator foaming die series design system and its method | |
| TWI231437B (en) | An apparatus and method for settling cutting tools | |
| CN1277232C (en) | Data joining/displaying method | |
| CN111241176A (en) | Data management system | |
| CN116204979A (en) | Product data management method and system of complex system | |
| KR20050061557A (en) | Data processing method and data processing program | |
| CN115422898A (en) | Visual self-defined report form analysis system based on container cloud | |
| CN113537758A (en) | Manufacturing industry high-quality development comprehensive evaluation method and system based on big data technology | |
| CN106776704A (en) | Statistical information collection method and device | |
| JP6974953B2 (en) | Aggregate data creation device, aggregate data creation method, and aggregate data creation program | |
| CN110262973A (en) | Data form maintaining method, device, equipment and computer storage medium | |
| CN110147406A (en) | A kind of visual numeric simulation system and its framework method towards cloud computing | |
| CN103365909A (en) | Method for sequentially generating accumulated values one by one in data table | |
| Germani et al. | How facilitate the use of LCA tools in SMEs-a practical example |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB03 | Change of inventor or designer information |
Inventor after: Wang Wei Inventor after: Li Chunyan Inventor after: Liu Jianzhao Inventor after: Chen Jun Inventor after: Ding Changwen Inventor before: Wang Wei Inventor before: Liu Jianzhao Inventor before: Wang Chengsheng Inventor before: An Jing Inventor before: Jiao Lili |
|
| CB03 | Change of inventor or designer information | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |