CN105678498A - BOM realization method for carrying out automatic matching based on features - Google Patents
BOM realization method for carrying out 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
- data model
- 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 16
- 238000013499 data model Methods 0.000 claims abstract description 21
- 238000012423 maintenance Methods 0.000 abstract description 4
- 238000007726 management method Methods 0.000 abstract description 2
- 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
- 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, which belongs to the technical field of assembling management, provides a BOM realization method for carrying out automatic matching based on features. The method comprises: establishing a material data model; establishing a basic BOM data model; establishing a feature BOM data model; and carrying out separated maintenance by employing the feature BOM and the basic BOM and carrying out automatic matching based on features to realize the BOM. Therefore, the BOM maintenance load can be simplified and the BOM matching work becomes easy, so that the most serious technical problems can be solved and the storage and redundancy of the BOM data can be substantially 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 realization method for carrying out 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 realization method for carrying out 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 realization method for carrying out 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 realization method for carrying out automatic matching based on features | |
CN102426587B (en) | Method for customizing and inquiring heterogeneous BOM (Bill of Materiel) based on complex product | |
US20180357055A1 (en) | System and method for computer language migration | |
CN105447122A (en) | Implementation method for autonomously creating file system based on multi-table association | |
CN102254012B (en) | Graph data storing method and subgraph enquiring method based on external memory | |
CN106776962A (en) | A kind of general Excel data import multiple database physical table methods | |
US20150278268A1 (en) | Data encoding and corresponding data structure | |
US20160173122A1 (en) | System That Reconfigures Usage of a Storage Device and Method Thereof | |
CN104298769B (en) | Domain variance data synchronization system and method are had between a kind of database | |
US9195729B2 (en) | Efficient loading of data in databases | |
CN104572895A (en) | MPP (Massively Parallel Processor) database and Hadoop cluster data intercommunication method, tool and realization method | |
CN104299094A (en) | Enterprise purchase-sales-inventory management information system | |
CN104462434A (en) | Data inquiring method and device | |
CN105678459A (en) | Metadatabase-based business flow customization model | |
CN106066895A (en) | A kind of intelligent inquiry system | |
CN107346314A (en) | A kind of database unidirectional synchronization method | |
CN102314480A (en) | Distributed data storage method specific to mass data | |
CN103164573A (en) | Product data management (PDM) design system | |
CN107103035A (en) | This earth's surface data-updating method and device | |
CN103455516A (en) | Operation platform and maintaining method for database | |
CN103995832A (en) | Complex relational data storage technology implementation method based on separation of attributes and relations | |
CN104932904A (en) | Configurable database programming mode aiming at intelligent smart home | |
CN103440272A (en) | Database maintenance method and device | |
US20030191727A1 (en) | Managing multiple data mining scoring results | |
CN106528105A (en) | A BOM maintenance method |
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 |
Application publication date: 20160615 |
|
RJ01 | Rejection of invention patent application after publication |