CN102479226A - Synchronous updating method of use priority of drawing database parts - Google Patents
Synchronous updating method of use priority of drawing database parts Download PDFInfo
- Publication number
- CN102479226A CN102479226A CN2010105691366A CN201010569136A CN102479226A CN 102479226 A CN102479226 A CN 102479226A CN 2010105691366 A CN2010105691366 A CN 2010105691366A CN 201010569136 A CN201010569136 A CN 201010569136A CN 102479226 A CN102479226 A CN 102479226A
- Authority
- CN
- China
- Prior art keywords
- priority
- data table
- database
- updating method
- storehouse
- 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
Abstract
The invention discloses a synchronous updating method, which is applicable to a drawing database and comprises the steps of: copying a first part basic datasheet of a product data management database to a temporary storage region; comparing the first part basic datasheet of the temporary storage region to a second part basic datasheet of a sharing material database to obtain a modification list, wherein the first part basic datasheet and the second part basic datasheet respectively comprise the use priority of each part; copying the first part basic datasheet of the temporary storage region to the second part basic datasheet of the sharing material database; starting a drawing application program; and updating part priority marks of the drawing database corresponding to the drawing application program according to the modification list, wherein one part priority mark corresponds to one part in the modification list. The synchronous updating method has the advantages that whether the contents of the first part basic datasheet or the second part basic datasheet of each database are changed or not can be automatically judged, and the automatic updating is carried out, so users of the drawing application program can fast know the use priority of each part.
Description
Technical field
The present invention relates to the update method in a kind of draw data storehouse, particularly relate to the synchronous updating method of use right of priority of the part in a kind of draw data storehouse.
Background technology
Along with the progress of science and technology, the widespread use of electronics, information and automatic technology makes a large amount of human resources that powerful computing machine and machinery replace traditional manufacturing industry gradually and relied on.And even therefore be designed into the manufacturing completion and be sold in the process client's hand, all can see the therefrom auxiliary shadow of computing machine or machinery from Products Development.Relative, though the process of the development and Design and the manufacturing is on the cost of labour, time and money, can significantly reduce in the past.And enterprise be meet competition fierce environment with change the market demand fast; Except reforming to the physique of enterprise itself and framework; How can be more efficient in product development design and the process of manufacturing, using relevant computer-aided equipment and measure, also is an important problem.
Yet, make management be difficult to implement even occur mistake because the process of the development and Design and the manufacturing is often complicated and meeting reciprocal effect.Management with material is an example, and it may receive material price, quality of material, client's indication and senior officer's indication or the like factor affecting.Because above-mentioned each side factor is not almost occured simultaneously each other, so they generally can safeguard the database of a management material individually.For the consistance of the inner body data that keep these databases, existing way is to rely on manual work to confirm and upgrade.But this method when wherein a side revises, is difficult to successfully the information of modification conveyed to the people of other department in the data of material.And in the face of the huge database of content, existing way not only lacks efficient easy error again.And the time point that each database can be confirmed is inconsistent, and can produce the serious problems that drop is arranged between the database.
For example, can't stock up because stopped production if material is arranged, then the procurement staff learns at first.But the product design slip-stick artist or the employed database of the staff of production line is not to be managed by the procurement staff, therefore can be compelled to stop making commodity because of required material is not enough in the Products Development manufacture process.When for example certain material is banned use of by customer requirement again, even learn with the vocational window of trade connection and also to be difficult to notify each the product design slip-stick artist or the staff of production line, and the problem of customer requirement takes place to reach.
Summary of the invention
In order to address the above problem, the synchronous updating method of the use right of priority of the part in a kind of draw data storehouse is provided.The synchronous updating method of the use right of priority of the part in draw data storehouse comprises: the synchronous updating method of the use right of priority of the part in a kind of draw data storehouse; Comprise: the one first part master data table (parts information table) of a product data management database (product data management database, PDM database) is copied to a working area; The first part master data table in comparison working area and one is shared material database (Mechanical component library; MCL) one second part master data table is to obtain a list of modification, and wherein first the and second part master data table comprises that individually one of a plurality of parts use right of priority; The first part master data table in working area is copied to the second part master data table of sharing the material database; Start a drawing application program; And according to list of modification, a draw data storehouse one part right of priority of revising corresponding to the drawing application program indicates, and wherein the part right of priority indicates corresponding at least one part in the list of modification.
Except the use right of priority of each part, can comprise a dash number and a trade name of each part in addition in the first or second part master data table of each database.And use right of priority can be preferentially, generally, not advise one of use or absolute prohibition.And the surface of each part in draw data storehouse can be marked with part right of priority sign.
According to an enforcement example, the drawing application program can be three-dimensional (3 dimensions, 3D) plotter program, for example Pro/E; Also two-dimentional (2 dimensions, 2D) plotter program, for example Photoshop.And the drawing application program can will use the part right of priority to be shown on the corresponding part according to marker color.
In addition, the synchronous updating method of the use right of priority of the part in draw data storehouse can be that self-timing is carried out.
In sum, the synchronous updating method of the use right of priority of the part in draw data storehouse can judge automatically whether the content of the first or second part master data table of each database has change and renewal automatically, therefore can be in real time and the storehouse that synchronously Updates Information.Moreover through the part right of priority sign of mark different colours, the user of drawing application program more can learn the use right of priority of each part apace.
Description of drawings
Fig. 1 is the synoptic diagram of the database of an enforcement example;
Fig. 2 one implements the process flow diagram of synchronous updating method of use right of priority of part in the draw data storehouse of example;
Fig. 3 A one implements the synoptic diagram of use right of priority of the part of example; And
Fig. 3 B is the synoptic diagram of the use right of priority of the part of another enforcement example.
Wherein, Reference numeral:
20 product data management databases
22 first part master data tables
24 data transfer programs
30 working areas
The 32 temporary first part master data tables
40 share the material database
42 second part master data tables
44 data exchange programs
46 lists of modification
500 drawing application programs
50 draw data storehouses
60 parts
62 part right of priority indicate
Embodiment
Describe the present invention below in conjunction with accompanying drawing and specific embodiment, but not as to qualification of the present invention.
Below in embodiment, be described in detail detailed features of the present invention and advantage; Its content is enough to make any related art techniques person of haveing the knack of to understand technology contents of the present invention and implements according to this; And according to content, the claim and graphic that this instructions disclosed, any related art techniques person of haveing the knack of can understand purpose and the advantage that the present invention is correlated with easily.
The synchronous updating method of the use right of priority of the part (part) in a kind of draw data storehouse is applicable to a draw data storehouse (graphics database) of a product data management database (product data management database, PDM database) and a drawing application program (graphics application) is synchronously upgraded.The application program of wherein drawing can be three-dimensional (3 dimensions, 3D) plotter program, for example Pro/E; Also two-dimentional (2 dimensions, 2D) plotter program, for example Photoshop.
Please be simultaneously with reference to Fig. 1 and Fig. 2, it is respectively the synoptic diagram of the database of an enforcement example, and the process flow diagram of the synchronous updating method of the use right of priority of the part in the draw data storehouse of an enforcement example.
(Mechanical component library MCL) can prestore one first part master data table 22, the temporary first part master data table 32 and one second a part master data table 42 in 40 individually to share the material database at product data management database 20, a working area 30 and one at first.But wherein also can prestore the first temporary part master data table 32 in the working area 30.
Product data management is meant management product when exploitation, technological document, map file, data-base recording or the forms etc. of institute's output.And product data management can be subdivided into file management (document management again; DM), Product Information Management (product information management; PIM), Technical Data Management (technology data management; TDM), technical information management (technology information management, TIM) and image management (image management, project such as IM).
In other words, product data management is the technology that is used for managing all and product related information and all and product correlated process.All information relevant with product can comprise components information, product structure, structural arrangements, file, computer-aided design (CAD) (computer aided design, CAD) archives, scan image or approval information etc.And can comprise for life cycle, workflow, examine/provide or the definition and the monitoring of engineering change (EC) etc. with the product correlated process.Product data management database 20 then can be the system strengthen discipline the record above-mentioned various projects database.
In response to networks development, product data management database 20 often is configured in the server.And the managerial personnel that are responsible for can be through the data such as the first part master data table 22 in the mode remotely modifying product data management database 20 of network on-line.
Working area 30 can be the space that the first part master data table (the first promptly temporary part master data table) 32 is deposited in a confession temporarily on the server.
Share material database 40 and deposit the materials and parts data that can supply all departments company in, product to use, so that can use identical materials and parts with the saving cost during development, also minimizing use proving time that different materials and parts increased.
The database that use for the application program 500 that can supply to draw in draw data storehouse 50 wherein can have the model of the part that the user draws with drawing application program 500.The model of these parts can be wasted the unnecessary time to improve the drawing efficiency and the person of avoiding the use of in 500 recyclings of drawing application program.For example, drawing application program 500 can be PRO/E, and draw data storehouse 50 stores the model of each part that can supply the PRO/E use.
Product data management database 20, working area 30 and share the related data that to note down multiple part and these parts in 40 first part master data tables of not safeguarding 22 of material database, the first part master data table 32 of keeping in and the second part master data table 42.Be otherwise known as element or material (material, matter, supply, or substance) of part wherein.The first part master data table 22, the temporary first part master data table 32 and the second part master data table 42 comprise that one of each part uses right of priority (usage priority), can comprise a dash number and a trade name of each part in addition.In addition, the attributes such as price, size or material that the first part master data table 22, the temporary first part master data table 32 and the second part master data table 42 also can comprise each part are looked user's demand and are decided.
Wherein the use right of priority of part can be set to preferentially, generally, not recommend to use or absolute prohibition.The part that for example is considered to be not suitable for existing commodity can use right of priority to be made as " not recommending to use " it; For example the part of the shortage of stock can use right of priority to be made as " absolute prohibition " it again.But the use right of priority can also be with numeral, and for example 1 representes minimum use right of priority, the highest use right of priority of 10 expressions.
The first part master data table 22 can be accordinged to procurement staff, client's indication, manufacturer, product design slip-stick artist, the present situation of production line or senior officer's indication or the like factor and revised by the personnel that are responsible for.The first temporary part master data table 32 and the second part master data table 42 are then upgraded according to the synchronous updating method of the use right of priority of the part in draw data storehouse automatically synchronously.Product data management database 20 can have a data transfer program 24, shares 40 of databases of material and can have a data exchange program 44, with the synchronous updating method of the use right of priority of the part of carrying out the draw data storehouse.
At first data transfer program 24 copies to working area 30 (step S100) with the first part master data table 22 of product data management database 20, and this step can regularly carry out, with the correctness of the first temporary part master data table 32 of keeping working area 30.
Then the second part master data table 42 of the first temporary part master data table 32 in data exchange program 44 comparison working areas 30 and shared material database 40 is to obtain a list of modification 46 (step S110).That is to say; Data exchange program 44 can be compared the use right of priority of all parts in the first temporary part master data table 32 and the second part master data table 42, and the association attributeses such as use right of priority of the part that will change to some extent and this part write in the list of modification 46.
Obtain after the list of modification 46, data exchange program 44 duplicates the second part master data table 42 (step S120) that becomes shared material database 40 with the first temporary part master data table 32 in working area 30.
Then can start drawing application program 500 (step S130) through data exchange program 44.According to list of modification 46, a part right of priority of revising the draw data storehouse 50 of corresponding drawing application program 500 indicates (step S140).
According to an enforcement example, each use right of priority (for example preferentially, generally, not advising using and absolute prohibition) can be individually corresponding to a marker color.Please with reference to Fig. 3 A and Fig. 3 B, it is respectively the synoptic diagram of the use right of priority of the different parts of implementing examples.At other embodiment, each use right of priority can be individually corresponding to the profile of a sign, size, lines etc.
The drawing application program can be according to the use right of priority of part 60, and mark part right of priority indicates 62 on the surface of part 60, and part right of priority sign 62 has and use the corresponding marker color of right of priority.For example use right of priority be preferentially, generally, do not advise using and the part right of priority of absolute prohibition to indicate 62 marker color can be green, blue, yellow and red.
Thus, the user sees that the part right of priority indicates 62 and just can learn and use this part 60.
In addition, the synchronous updating method of the use right of priority of the part in draw data storehouse can be that self-timing is carried out.According to an enforcement example, data transfer program 24 and data exchange program 44 can be set an execution time individually, and the execution time each other staggers.For example data transfer program 24 and data exchange program 44 can periodically be automatically performed 7 o'clock every nights and 7: 20 respectively.But the front and back that must note the execution time need the order of data-driven transmission procedure 24 and data exchange program 44, just can not cause and upgrade wrong situation.
Implement example according to another, only have the data transfer program 24 of product data management database 20 to be set to automatic startup.Behind the data transfer program 24 execution of step S100, remove to wake up the data exchange program 44 of sharing material database 40.And after the data exchange program 44 execution of step S110-S120, wake drawing application program 500 again up.Thus, just can be automatically and carry out the synchronous updating method of use right of priority of the part in draw data storehouse efficiently.
Because the use right of priority through the product data management database update can be updated to relevant database automatically, therefore can solve the problem that drop appears in a plurality of data-base contents in the prior art.And, can let the user of drawing application program notice more easily whether the part that oneself uses is suitable through the mode that indicates in part marked part right of priority.In addition, the people of fellowship exploitation (for example being responsible for) also can learn the attribute of part fast, and gives suitable suggestion.
Certainly; The present invention also can have other various embodiments; Under the situation that does not deviate from spirit of the present invention and essence thereof; Those of ordinary skill in the art work as can make various corresponding changes and distortion according to the present invention, but these corresponding changes and distortion all should belong to the protection domain of the appended claim of the present invention.
Claims (7)
1. the synchronous updating method of the use right of priority of the part in a draw data storehouse is characterized in that, comprising:
One first part master data table of one product data management database is copied to a working area;
Compare one second part master data table that this first part master data table and in this working area shares the material database to obtain a list of modification, wherein this first part master data table and this second part master data table comprise that individually one of a plurality of parts use right of priority;
This first part master data table in this working area is copied to this second part master data table that this shares the material database;
Start a drawing application program; And
According to this list of modification, revise part right of priority sign to a draw data storehouse of the application program of should drawing, wherein this part right of priority indicates corresponding at least one this part in this list of modification.
2. the synchronous updating method of the use right of priority of the part in draw data according to claim 1 storehouse; It is characterized in that this first part master data table and this second part master data table comprise a dash number and a trade name of each this part in addition.
3. the synchronous updating method of the use right of priority of the part in draw data according to claim 1 storehouse is characterized in that, this use right of priority is not for preferentially, generally, advising one of use or absolute prohibition.
4. the synchronous updating method of the use right of priority of the part in draw data according to claim 3 storehouse is characterized in that, the surface of each this part in this draw data storehouse has this part right of priority to indicate.
5. the synchronous updating method of the use right of priority of the part in draw data according to claim 1 storehouse is characterized in that, for self-timing is carried out.
6. the synchronous updating method of the use right of priority of the part in draw data according to claim 1 storehouse is characterized in that, this drawing application program is a three-dimensional drawing application program.
7. the synchronous updating method of the use right of priority of the part in draw data according to claim 1 storehouse is characterized in that, this drawing application program is a two-dimensional graphics application program.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010105691366A CN102479226A (en) | 2010-11-25 | 2010-11-25 | Synchronous updating method of use priority of drawing database parts |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010105691366A CN102479226A (en) | 2010-11-25 | 2010-11-25 | Synchronous updating method of use priority of drawing database parts |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102479226A true CN102479226A (en) | 2012-05-30 |
Family
ID=46091874
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2010105691366A Pending CN102479226A (en) | 2010-11-25 | 2010-11-25 | Synchronous updating method of use priority of drawing database parts |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102479226A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5826252A (en) * | 1996-06-28 | 1998-10-20 | General Electric Company | System for managing multiple projects of similar type using dynamically updated global database |
| JP2002055707A (en) * | 2000-08-11 | 2002-02-20 | Sumitomo Heavy Ind Ltd | Product management system for production facility and computer readable recording medium with the same recorded and product management device |
| CN1534524A (en) * | 2003-03-28 | 2004-10-06 | 鸿富锦精密工业（深圳）有限公司 | BOM table automatic comparison system and method |
| CN101751393A (en) * | 2008-12-01 | 2010-06-23 | 宏碁股份有限公司 | System and method for synchronizing data |
-
2010
- 2010-11-25 CN CN2010105691366A patent/CN102479226A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5826252A (en) * | 1996-06-28 | 1998-10-20 | General Electric Company | System for managing multiple projects of similar type using dynamically updated global database |
| JP2002055707A (en) * | 2000-08-11 | 2002-02-20 | Sumitomo Heavy Ind Ltd | Product management system for production facility and computer readable recording medium with the same recorded and product management device |
| CN1534524A (en) * | 2003-03-28 | 2004-10-06 | 鸿富锦精密工业（深圳）有限公司 | BOM table automatic comparison system and method |
| CN101751393A (en) * | 2008-12-01 | 2010-06-23 | 宏碁股份有限公司 | System and method for synchronizing data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Cankurtaran et al. | Using design thinking to respond to crises: B2B lessons from the 2020 COVID-19 pandemic | |
| CN101937463B (en) | Method for automatically generating form for workflow model | |
| JP3458728B2 (en) | Component data management device and computer readable storage medium storing component data management program | |
| CN104679846B (en) | The method and system of BIM are described using XML format data | |
| Soto-Acosta et al. | A case analysis of a product lifecycle information management framework for SMEs | |
| Page | Soft systems modelling of the new project development process-A case study | |
| CN105654228A (en) | Common plant model for modelling of physical plant items of production plant | |
| DE112004001031T5 (en) | Ordering procedure and system | |
| CN105654226A (en) | Common plant model for modelling of physical plant items of production plant | |
| TW469403B (en) | System and method for generating dependent data | |
| Kannengiesser et al. | Multi-level, viewpoint-oriented engineering of cyber-physical production systems: an approach based on industry 4.0, system architecture and semantic web standards | |
| CN113807651A (en) | Big data based component whole process management system, terminal equipment and management method | |
| CN102737316A (en) | Construction method of automatic pricing and multi-organization price adjustment model and apparatus thereof | |
| Sly | Integrating 3D product models with assembly line balancing via process consumption | |
| CN111709702A (en) | Product full life cycle management system | |
| TW561424B (en) | System and method for providing a three-dimensional display of values relative to comparison values | |
| Ahn et al. | Modeling of smart supply chain for sustainability | |
| CN102479226A (en) | Synchronous updating method of use priority of drawing database parts | |
| CN100568286C (en) | The dynamic creation method and system of label | |
| CN1963849A (en) | Conformity method of managing system of data of product | |
| US20130346126A1 (en) | Business process development | |
| Aslani et al. | Building information model: The role and need of the constructors | |
| Chang et al. | A case study for implementing a B2B collaborative information system: a textile case | |
| CN101958893A (en) | Pre-positioned business server and processing method thereof | |
| CN100489864C (en) | Material list integrating method via computer software |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20120530 |