CN105678498A - BOM implementation method for automatic matching based on features - Google Patents
BOM implementation method for automatic matching based on features Download PDFInfo
- Publication number
- CN105678498A CN105678498A CN201610108206.5A CN201610108206A CN105678498A CN 105678498 A CN105678498 A CN 105678498A CN 201610108206 A CN201610108206 A CN 201610108206A CN 105678498 A CN105678498 A CN 105678498A
- Authority
- CN
- China
- Prior art keywords
- bom
- feature
- basic
- item
- father
- 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
- 238000000034 method Methods 0.000 title claims abstract description 15
- 238000013499 data model Methods 0.000 claims description 18
- 238000012423 maintenance Methods 0.000 abstract description 3
- 206010019233 Headaches Diseases 0.000 abstract 1
- 231100000869 headache Toxicity 0.000 abstract 1
- 230000008878 coupling Effects 0.000 description 2
- 238000010168 coupling process Methods 0.000 description 2
- 238000005859 coupling reaction Methods 0.000 description 2
- 210000000988 bone and bone Anatomy 0.000 description 1
- 210000004556 brain Anatomy 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000007423 decrease Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
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
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/26—Visual data mining; Browsing structured data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Economics (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Development Economics (AREA)
- Software Systems (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a BOM (bill of material) implementation method based on automatic matching of features, belonging to the technical field of assembly management. Therefore, the maintenance amount of the BOM can be simplified, and the selection and matching work of the BOM can be easily performed, so that the headaches of technicians are solved, and the storage and redundancy of BOM data are greatly reduced.
Description
Technical field
The present invention relates to assembling management technique field, particularly relate to a kind of BOM carrying out automatically matching for the feature based in ERP management software and realize method.
Background technology
In the manufacturing enterprise of assembly type, BOM data amount is big, and bare bones, apolegamy part etc. mix and be difficult to differentiate between, and technical staff usually because of how simplifying the data volume of BOM and can conveniently operate and rack one's brains. How does apolegamy part embody in BOM? how to reduce the data volume of BOM? how to reduce the complexity of BOM? simplify operation of BOM etc.?
Summary of the invention
In order to solve above technical problem, the present invention proposes a kind of feature based and carries out the BOM of automatically apolegamy and realize method, have employed feature BOM and basic BOM in the present invention to separately maintain, automatically match a kind of method realizing BOM according to feature simultaneously, so for a kind of product, all fixing parts have only to safeguard portion in basic BOM, and the part matched then is safeguarded in feature BOM, also have only to safeguard portion. The feature BOM and basic BOM of a certain Automatic signature extraction selected by client are grouped together, it is simply that the BOM of whole product. So being possible not only to simplify the maintenance of BOM, the apolegamy work of BOM also can be made to become very light, thus solving the most pain in the neck feelings of technical staff, greatly reducing storage and the redundancy of BOM data.
The present invention gives a kind of feature based to carry out the BOM of automatically apolegamy and realize method, including setting up material data model, basic BOM data model, feature BOM data model,
1) material data model is used for defining basic BOM material information, and including ID, each attribute information etc., wherein ID is for unique material information identified in basic BOM, when revising certain attribute, all in its basic BOM uses also revising therewith of this attribute.
2) basic BOM data model is used for defining basic BOM, including father item ID, subitem ID, whether characteristic item, father's n-th-trem relation n, subitem relation, other relation informations etc., the wherein ID data in father's item ID and subitem ID corresponding material data model respectively, the two ID also denotes the father and son's n-th-trem relation n between basic BOM data simultaneously.
3) feature BOM data model is used for defined feature BOM, and including father item ID, father's item feature, subitem ID, subitem feature, each attribute information etc., wherein father's item ID, subitem ID derive from basic BOM, and are automatically passed in feature BOM by basic BOM.
4) all open-and-shut for basic BOM information displaying in the tree, can farthest be illustrated the integrity of data, maintain easily by material data and basic BOM data model.By basic BOM and feature BOM data model, characteristic item in basic BOM all can be presented on feature BOM, feature BOM also can be saved in feature BOM data model independently simultaneously, so that feature BOM separates with basic BOM data, greatly reduces the degree of coupling between two BOM. The two can be combined again when extracting BOM, significantly reduce the workload of technical staff, reduce the complexity of BOM data, simplify the operation of BOM.
In BOM, standing part is realized by basic BOM, and apolegamy part is realized by feature BOM;
Feature BOM generates according to the characteristic item of basic BOM, automatically matches according to feature simultaneously;
Standing part in BOM is safeguarded in basic BOM, and apolegamy part is unified in feature BOM and safeguards, when matching item and changing, it is only necessary to amendment feature BOM, and basic BOM is constant; Having only to when standing part changes revise basic BOM, feature BOM is constant. So greatly reduce coupling and the amount of storage of data.
Feature BOM generates according to the characteristic item in basic BOM, realizes apolegamy automatically according to feature simultaneously. After basic BOM safeguards, feature BOM automatically generates; Not having basic BOM, feature BOM is also absent from; When the characteristic item of basic BOM changes, feature BOM also can change therewith; Feature BOM realizes apolegamy automatically according to feature simultaneously. Basic BOM and feature BOM separated maintenance, reduce the complexity of BOM, decreases operation loaded down with trivial details in a large number, also can show all of BOM information simultaneously, embody the integrity of BOM, maintain easily in basic BOM.
Detailed description of the invention
A kind of feature based of the present invention carries out the BOM of apolegamy automatically and realizes method,
The method comprises the following steps and content:
1) arranging material data storage, each material has a unique ID to identify:
Title | Row name | Data type | Null value | Default | Rule | Annotation |
Material ID | WLID | varchar(10) | No | Major key | ||
Attribute 1 | WLSX1 | |||||
Attribute 2 | WLSX2 | |||||
…… |
2) arranging basic BOM storage, the relation between data is uniquely identified by father item ID and subitem ID:
Title | Row name | Data type | Null value | Default | Rule | Annotation |
Father item ID | FXID | varchar(10) | No | Major key | ||
Subitem ID | ZXID | varchar(10) | No | Major key | ||
Whether characteristic item | SFTZ | Char(1) | NO | 0 | ||
Father's n-th-trem relation n | FXGX | |||||
Subitem relation | ZXGX | |||||
…… |
3) arranging the storage of feature BOM data, the attribute of each data has father item ID, father's item feature, subitem ID, subitem feature uniquely to identify, and wherein father's item ID and subitem ID derives from basic BOM:
Title | Row name | Data type | Null value | Default | Rule | Annotation |
Father item ID | FXID | varchar(10) | No | Major key | ||
Father's item feature | FXTZ | varchar(30) | No | Major key | ||
Subitem ID | ZXID | varchar(10) | No | Major key | ||
Subitem feature | ZXTZJ | varchar(30) | No | Major key | ||
Attribute 1 | SX1 | |||||
Attribute 2 | SX2 | |||||
…… |
Claims (4)
1. a feature based carries out the BOM of apolegamy automatically and realizes method, it is characterised in that include setting up material data model, basic BOM data model, feature BOM data model, it is achieved method is as follows:
1) material data model is used for defining basic BOM material information, and including ID, each attribute information, wherein ID is for unique material information identified in basic BOM, when revising certain attribute, all in its basic BOM uses also revising therewith of this attribute;
2) basic BOM data model is used for defining basic BOM, including father item ID, subitem ID, whether characteristic item, father's n-th-trem relation n, subitem relation, the wherein ID data in father's item ID and subitem ID corresponding material data model respectively, the two ID also denotes the father and son's n-th-trem relation n between basic BOM data simultaneously;
3) feature BOM data model is used for defined feature BOM, and including father item ID, father's item feature, subitem ID, subitem feature, wherein father's item ID, subitem ID derive from basic BOM, and are automatically passed in feature BOM by basic BOM;
4) can all open-and-shut for basic BOM information displaying in the tree by material data and basic BOM data model.
2. method according to claim 1, it is characterised in that
In BOM, standing part is realized by basic BOM, and apolegamy part is realized by feature BOM.
3. method according to claim 1, it is characterised in that
Feature BOM generates according to the characteristic item of basic BOM, automatically matches according to feature simultaneously;
Standing part in BOM is safeguarded in basic BOM, and apolegamy part is unified in feature BOM and safeguards, when matching item and changing, it is only necessary to amendment feature BOM, and basic BOM is constant; Having only to when standing part changes revise basic BOM, feature BOM is constant.
4. method according to claim 1, it is characterised in that
Feature BOM generates according to the characteristic item in basic BOM, realizes apolegamy automatically according to feature simultaneously; After basic BOM safeguards, feature BOM automatically generates; Not having basic BOM, feature BOM is also absent from; When the characteristic item of basic BOM changes, feature BOM also can change therewith; Feature BOM realizes apolegamy automatically according to feature simultaneously.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610108206.5A CN105678498A (en) | 2016-02-26 | 2016-02-26 | BOM implementation method for automatic matching based on features |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610108206.5A CN105678498A (en) | 2016-02-26 | 2016-02-26 | BOM implementation method for automatic matching based on features |
Publications (1)
Publication Number | Publication Date |
---|---|
CN105678498A true CN105678498A (en) | 2016-06-15 |
Family
ID=56305201
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201610108206.5A Pending CN105678498A (en) | 2016-02-26 | 2016-02-26 | BOM implementation method for automatic matching based on features |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN105678498A (en) |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106484799A (en) * | 2016-09-22 | 2017-03-08 | 济南浪潮高新科技投资发展有限公司 | A kind of method that products configuration numbering is generated according to eigenvalue |
CN106528105A (en) * | 2016-10-31 | 2017-03-22 | 济南浪潮高新科技投资发展有限公司 | A BOM maintenance method |
CN108711035A (en) * | 2018-05-21 | 2018-10-26 | 广东科达洁能股份有限公司 | A kind of implementation method of configurable super BOM |
CN109508861A (en) * | 2018-10-10 | 2019-03-22 | 中通客车控股股份有限公司 | A kind of quick component distribution method and system |
CN111861249A (en) * | 2020-07-29 | 2020-10-30 | 上海控软网络科技有限公司 | Information processing method and device for laser equipment production, electronic equipment and medium |
CN117093144A (en) * | 2023-07-31 | 2023-11-21 | 蒲惠智造科技股份有限公司 | Flexible storage method and system for BOM order |
-
2016
- 2016-02-26 CN CN201610108206.5A patent/CN105678498A/en active Pending
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106484799A (en) * | 2016-09-22 | 2017-03-08 | 济南浪潮高新科技投资发展有限公司 | A kind of method that products configuration numbering is generated according to eigenvalue |
CN106528105A (en) * | 2016-10-31 | 2017-03-22 | 济南浪潮高新科技投资发展有限公司 | A BOM maintenance method |
CN108711035A (en) * | 2018-05-21 | 2018-10-26 | 广东科达洁能股份有限公司 | A kind of implementation method of configurable super BOM |
CN109508861A (en) * | 2018-10-10 | 2019-03-22 | 中通客车控股股份有限公司 | A kind of quick component distribution method and system |
CN111861249A (en) * | 2020-07-29 | 2020-10-30 | 上海控软网络科技有限公司 | Information processing method and device for laser equipment production, electronic equipment and medium |
CN117093144A (en) * | 2023-07-31 | 2023-11-21 | 蒲惠智造科技股份有限公司 | Flexible storage method and system for BOM order |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN105678498A (en) | BOM implementation method for automatic matching based on features | |
US10606573B2 (en) | System and method for computer language migration using a re-architecture tool for decomposing a legacy system and recomposing a modernized system | |
CN102426587B (en) | Method for customizing and inquiring heterogeneous BOM (Bill of Materiel) based on complex product | |
CN105447122A (en) | Implementation method for autonomously creating file system based on multi-table association | |
CN104123374B (en) | The method and device of aggregate query in distributed data base | |
US9754010B2 (en) | Generation of cube metadata and query statement based on an enhanced star schema | |
CN104298769B (en) | Domain variance data synchronization system and method are had between a kind of database | |
CN106776962A (en) | A kind of general Excel data import multiple database physical table methods | |
CN104463482A (en) | Task allocation method and task allocation device | |
US8965838B2 (en) | Efficient loading of data in databases | |
CN105678459A (en) | Metadatabase-based business flow customization model | |
CN102436473A (en) | Menu management device and menu management method | |
CN105893016A (en) | Log recording system and method based on MVC (Model View Controller) framework | |
CN106844320B (en) | Financial statement integration method and equipment | |
CN107103035A (en) | This earth's surface data-updating method and device | |
CN105654182A (en) | System and method for performing automatic time limit management and seat clearing on passenger team | |
CN103164573A (en) | Product data management (PDM) design system | |
CN103455516A (en) | Operation platform and maintaining method for database | |
CN108874873B (en) | Data query method, device, storage medium and processor | |
CN107451846A (en) | The management method and managing device of business rule | |
CN103995832A (en) | Complex relational data storage technology implementation method based on separation of attributes and relations | |
CN106528105A (en) | A BOM maintenance method | |
CN105512826A (en) | Color matrix configuration method based on PLM platform | |
CN105550220A (en) | Fetching method and apparatus for heterogeneous system | |
CN106156197A (en) | The querying method of a kind of data base and device |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160615 |