CN113569107A - Method for quickly comparing BOM (bill of material) - Google Patents

Method for quickly comparing BOM (bill of material) Download PDF

Info

Publication number
CN113569107A
CN113569107A CN202110915594.9A CN202110915594A CN113569107A CN 113569107 A CN113569107 A CN 113569107A CN 202110915594 A CN202110915594 A CN 202110915594A CN 113569107 A CN113569107 A CN 113569107A
Authority
CN
China
Prior art keywords
bom
database
comparison
module
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.)
Granted
Application number
CN202110915594.9A
Other languages
Chinese (zh)
Other versions
CN113569107B (en
Inventor
严新发
肖南海
杨斌
贾美景
洪海霞
杨雄辉
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shanghai Yinte Electronics Co ltd
Original Assignee
Shanghai Yinte Electronics Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Shanghai Yinte Electronics Co ltd filed Critical Shanghai Yinte Electronics Co ltd
Priority to CN202110915594.9A priority Critical patent/CN113569107B/en
Publication of CN113569107A publication Critical patent/CN113569107A/en
Application granted granted Critical
Publication of CN113569107B publication Critical patent/CN113569107B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/903Querying
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/906Clustering; Classification
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02PCLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30Computing systems specially adapted for manufacturing

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a method for quickly comparing BOMs (bill of materials), and relates to the technical field of material management. The invention is realized based on a material BOM quick comparison system, wherein the material BOM quick comparison system comprises a material BOM leading-in module, a material BOM keyword extraction module, a product classification module according to categories, a comparison module and a database; the comparison method comprises the following steps: the material BOM import module imports the material BOM into the system; extracting key words from the material BOM; classifying products in a large category; the model is automatically compared with the model in the database; acquiring three types; respectively deriving and marking corresponding three types of lists; the data is rechecked and audited; and recording the heat of the search for multiple times and supplementing. The method adopts the import of various file forms, accords with the habit of searching materials by electronic engineers, is favorable for the file compatibility after the files are mutually transmitted, and is very close to the practical application; the method is beneficial to data management and continuously corrects the material database.

Description

Method for quickly comparing BOM (bill of material)
Technical Field
The invention belongs to the technical field of material management, and particularly relates to a method for quickly comparing BOMs (bill of material).
Background
With the rise of the electronic product industry, electronic material manufacturers, distributors and suppliers have huge quantities, electronic material models have huge quantities, and each manufacturer establishes a set of material number names in order to maintain the respective brand independence. Many materials are identical or close in parameters and can be mutually replaced in application. When a product engineer searches for a material, the product engineer often only gives a material number of a certain manufacturer or some key parameters, and the material supplier has actual requirements on the material work.
The material comparison work is completely finished manually, the problems of repetition, low efficiency, omission, errors and the like are often presented, the requirements on a material engineer are high, and the problems of high labor cost, low material efficiency, poor pertinence and the like of a material supplier are obvious; therefore, in order to solve the above problems, the technical scheme provides a method for quickly comparing BOMs, which is of great significance.
Disclosure of Invention
The invention provides a method for quickly comparing BOMs (bill of materials), which solves the problems.
In order to solve the technical problems, the invention is realized by the following technical scheme:
the method for quickly comparing the BOM of the material is realized based on a quick comparison system of the BOM of the material, wherein the quick comparison system of the BOM of the material comprises a material BOM import module, a material BOM keyword extraction module, a product classification module according to the category, a comparison module and a database;
the comparison method comprises the following steps:
s01, introducing the material BOM of the incoming material into the system through a material BOM introduction module;
s02, extracting keywords of the imported material BOM through a material BOM keyword extraction module, and finishing input of materials or models through manual intervention if extraction fails, wherein the keywords comprise models;
s03, performing product large-class classification on the extracted keywords according to a product classification module according to the large classes, and if the classification fails, providing the keyword data for manual comparison;
s04, automatically comparing the extracted model with the model in the database through a comparison module, if no corresponding model exists in the database, manually checking, comparing the model, and recording the model in the database;
s05, according to the compared model data, three types of complete matching, partial non-important parameter mismatching or missing and key parameter mismatching are distinguished;
s06, respectively deriving and labeling corresponding three types of lists according to the matching condition of the step S05;
s07, summarizing the automatically compared data and the manually compared data, and manually reviewing and auditing partial data with unmatched or missing unimportant parameters and unmatched key parameters;
and S08, according to the result of the step S07, deriving a comparison result file of the BOM, recording the heat of multiple pairs of search for protecting the device supplier and the material supplier as production basis, optimizing the data in the database, and complementing the missing information in the database as the comparison reference of the next material.
Further, the material BOM includes EXCEL forms, pictures, TXT files or a single data entry by a human.
Further, the keyword extraction in the step S02 is specifically:
for the EXCEL table, single-row or single-column data is adopted for retrieval and is compared with common keywords preset in a database;
for the picture, searching in a mode of identifying picture content to obtain character data and comparing the searched picture with common keywords preset in a database;
and for the TXT file, searching by using the acquired characters and comparing with the preset common keywords in the database.
Further, in the step S03, the product classification module classifies the major categories of the products according to the major categories, the system pre-judgment classification is performed in a preset major category mode, and if the system fails to automatically pre-judge and classify, the comparison is performed manually by a material engineer, and a comparison result is directly given.
Further, the medium-size number in the database in the step S04 is specifically a database composed of the material model of the material supplier itself and the corresponding material number with the matching record, which are imported in advance by the material supplier, and the database is maintained by the material engineer, and the parameter keywords such as the new material number and the product parameter are added for the next material comparison, retrieval and calling.
Further, in the step S05, the system automatically processes the material number that is completely matched, and provides difference information for partial non-important parameter mismatching or missing and key parameter mismatching, so that an engineer can manually complete review.
Further, the collecting in S07 specifically means classifying and collecting the three types of product model lists derived from steps S05 and S06 and the manual comparison results.
Further, the popularity in the step S08 means that the number of times of retrieval is increased once for each retrieval, and then the retrieval frequency and popularity are counted according to month, quarter and year, and the import interface of the material BOM import module in the step S01 is placed on a website to accumulate the popularity of external search and apply the popularity.
Compared with the prior art, the invention has the following beneficial effects:
1. the BOM comparison method for the materials and the designed system can import EXCEL, pictures and TXT data, can manually carry out single input, and can import multiple file forms, thereby conforming to the habit of retrieving materials by electronic engineers, being beneficial to the compatibility of the files after the files are mutually transmitted and being very close to the practical application;
2. the method adopts a material model classification derivation and data storage mode, is very favorable for data management, avoids manual simple and repeated labor, can effectively remind possible device parameter errors, and provides basis and convenience for a material comparison engineer to adjust a comparison database;
3. the material BOM comparison system designed by the invention can be mounted on an enterprise website for retrieval and comparison, and the retrieval heat is counted; the website management party can lead out the retrieval heat through the background, so that the use frequency and the shortage of the devices in the market are determined, and the materials are used for stock preparation, sale and production as data support;
4. the material BOM comparison method and the material BOM comparison system can quickly and effectively compare common materials, continuously correct a material database, provide retrieval heat of material comparison, have important meanings of reducing cost, improving efficiency and the like for electronic component suppliers, and provide tools for quickly searching for replacement materials for downstream enterprise engineers.
Of course, it is not necessary for any product in which the invention is practiced to achieve all of the above-described advantages at the same time.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art that other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a diagram illustrating the steps of a method for rapid comparison of BOMs in accordance with the present invention;
FIG. 2 is a block diagram of a BOM rapid comparison system according to the present invention;
FIG. 3 is a BOM to BOM system login interface according to an embodiment of the present invention;
FIG. 4 is a BOM material to material system add inventory interface according to an embodiment of the present invention;
FIG. 5 is an exemplary diagram of a material BOM versus material system database import template according to the present invention;
FIG. 6 is an exemplary diagram of a data export format of a BOM versus material system according to the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1-6, the method for quickly comparing the material BOM according to the present invention is implemented based on a material BOM quick comparison system, which includes a material BOM import module, a material BOM keyword extraction module, a product classification module according to categories, a comparison module, and a database;
the comparison method comprises the following steps:
s01, introducing the material BOM of the incoming material into the system through a material BOM introduction module;
s02, extracting keywords from the imported material BOM through a material BOM keyword extraction module, and finishing inputting materials or models through manual intervention if the extraction fails, wherein the keywords comprise models;
s03, performing product large-class classification on the extracted keywords according to a product classification module according to the large classes, and if the classification fails, providing the keyword data for manual comparison;
s04, automatically comparing the extracted model with the model in the database through a comparison module, if no corresponding model exists in the database, manually checking, comparing the model, and recording the model in the database;
s05, according to the compared model data, three types of complete matching, partial non-important parameter mismatching or missing and key parameter mismatching are distinguished;
s06, respectively deriving and labeling corresponding three types of lists according to the matching condition of the step S05;
s07, summarizing the automatically compared data and the manually compared data, and manually reviewing and auditing partial data with unmatched or missing unimportant parameters and unmatched key parameters;
and S08, according to the result of the step S07, deriving a comparison result file of the BOM, recording the heat of multiple pairs of search for protecting the device supplier and the material supplier as production basis, optimizing the data in the database, and complementing the missing information in the database as the reference for comparing the next material.
Wherein, the material BOM comprises EXCEL tables, pictures, TXT files or single data input is carried out manually.
Wherein, the keyword extraction in the step S02 is specifically:
for the EXCEL table, single-row or single-column data is adopted for retrieval and is compared with common keywords preset in a database, and the common keywords are packaged into packages and the like; for extracting the BOM keywords, parameters such as a name of Part Number, a Voltage of Voltage, a Package of Package, and the like are mainly extracted;
for the picture, searching in a mode of identifying picture content to obtain character data and comparing the searched picture with common keywords preset in a database;
and for the TXT file, searching by using the acquired characters and comparing with the preset common keywords in the database.
In the step S03, the product classification module classifies the major categories of the products according to the major categories, and the system pre-judgment and classification are performed in a preset major category manner, which is adopted in this specific embodiment: the system is pre-judged and classified in a preset large-class mode of a resistor, a capacitor, an inductor, a diode, a chip and the like, if the system fails to automatically pre-judge and classify, a material engineer manually compares the system and directly gives a comparison result; for the category of the preset products, for the protection device suppliers, the general reference schemes can be divided into nine categories, such as transient suppression diodes TVS, gas discharge tubes GDT, piezoresistors MOV, electrostatic protection devices ESD, self-recovery fuses PPTC, temperature-sensitive resistors NTC, rectifier diodes RD, fast recovery diodes FRD, schottky SBR, and the like.
The medium-size number in the database in the step S04 is specifically a database composed of the material model of the material supplier itself and the corresponding material number with a matching record, which are imported in advance by the material supplier, and the database is maintained by the material engineer, and the parameter keywords such as the material number, the product parameters and the like are added for the next material comparison, retrieval and calling.
In the step S05, the system automatically processes the completely matched material numbers, and provides difference information for partial non-important parameter mismatching or missing and key parameter mismatching, so that engineers can manually complete review.
The step S07 is to sort and collect the lists of the three types of product models derived from the steps S05 and S06 and the manual comparison result.
The popularity in the step S08 means that the number of times of retrieval is increased once for each retrieval, and then the retrieval frequency and popularity are counted according to month, quarter and year, and the import interface of the material BOM import module in the step S01 is placed on a website to accumulate the popularity of external search and apply the popularity.
Has the advantages that:
1. the BOM comparison method for the materials and the designed system can import EXCEL, pictures and TXT data, can manually carry out single input, and can import multiple file forms, thereby conforming to the habit of retrieving materials by electronic engineers, being beneficial to the compatibility of the files after the files are mutually transmitted and being very close to the practical application;
2. the method adopts a material model classification derivation and data storage mode, is very favorable for data management, avoids manual simple and repeated labor, can effectively remind possible device parameter errors, and provides basis and convenience for a material comparison engineer to adjust a comparison database;
3. the material BOM comparison system designed by the invention can be mounted on an enterprise website for retrieval and comparison, and the retrieval heat is counted; the website management party can lead out the retrieval heat through the background, so that the use frequency and the shortage of the devices in the market are determined, and the materials are used for stock preparation, sale and production as data support;
4. the material BOM comparison method and the material BOM comparison system can quickly and effectively compare common materials, continuously correct a material database, provide retrieval heat of material comparison, have important meanings of reducing cost, improving efficiency and the like for electronic component suppliers, and provide tools for quickly searching for replacement materials for downstream enterprise engineers.
The preferred embodiments of the invention disclosed above are intended to be illustrative only. The preferred embodiments are not intended to be exhaustive or to limit the invention to the precise embodiments disclosed. Obviously, many modifications and variations are possible in light of the above teaching. The embodiments were chosen and described in order to best explain the principles of the invention and the practical application, to thereby enable others skilled in the art to best utilize the invention. The invention is limited only by the claims and their full scope and equivalents.

Claims (8)

1. A method for quickly comparing material BOM is realized based on a material BOM quick comparison system, and is characterized in that the material BOM quick comparison system comprises a material BOM import module, a material BOM keyword extraction module, a product classification module according to categories, a comparison module and a database;
the comparison method comprises the following steps:
s01, introducing the material BOM of the incoming material into the system through a material BOM introduction module;
s02, extracting keywords of the imported material BOM through a material BOM keyword extraction module, and finishing input of materials or models through manual intervention if extraction fails, wherein the keywords comprise models;
s03, performing product large-class classification on the extracted keywords according to a product classification module according to the large classes, and if the classification fails, providing the keyword data for manual comparison;
s04, automatically comparing the extracted model with the model in the database through a comparison module, if no corresponding model exists in the database, manually checking, comparing the model, and recording the model in the database;
s05, according to the compared model data, three types of complete matching, partial non-important parameter mismatching or missing and key parameter mismatching are distinguished;
s06, respectively deriving and labeling corresponding three types of lists according to the matching condition of the step S05;
s07, summarizing the automatically compared data and the manually compared data, and manually reviewing and auditing partial data with unmatched or missing unimportant parameters and unmatched key parameters;
and S08, according to the result of the step S07, deriving a comparison result file of the BOM, recording the heat of multiple pairs of search for protecting the device supplier and the material supplier as production basis, optimizing the data in the database, and complementing the missing information in the database as the comparison reference of the next material.
2. The method of claim 1, wherein the material BOM comprises EXCEL tables, pictures, TXT files or single data entry by human.
3. The method for rapidly comparing the BOM of the material according to claim 1, wherein the keyword extraction in the step S02 is specifically as follows:
for the EXCEL table, single-row or single-column data is adopted for retrieval and is compared with common keywords preset in a database;
for the picture, searching in a mode of identifying picture content to obtain character data and comparing the searched picture with common keywords preset in a database;
and for the TXT file, searching by using the acquired characters and comparing with the preset common keywords in the database.
4. The method according to claim 1, wherein in step S03, the product classification module performs major classification of major classes of products according to major classes, a predetermined major classification mode is used to perform systematic pre-determination classification, and if the systematic automatic pre-determination classification fails, a material engineer performs manual comparison and directly provides a comparison result.
5. The method according to claim 1, wherein the model in the database in step S04 is a database consisting of model of the material itself and the corresponding material model with matching records, which are imported by the material supplier in advance, and the database is maintained by the material engineer, and the keywords of the parameters such as the new material model and the product parameter are added for the next retrieval of the material.
6. The method according to claim 1, wherein in step S05, the system automatically processes the completely matched material numbers, and provides differential information for partial non-significant parameter mismatch or missing and critical parameter mismatch, so that engineers can manually complete review.
7. The method of claim 1, wherein the summarizing in S07 specifically means classifying and summarizing lists of three product types derived from steps S05 and S06 and manual comparison results.
8. The method of claim 1, wherein the heat in the step S08 is obtained by adding a number of searches for each search, and then counting the search frequency and heat according to month, quarter and year, and the import interface of the material BOM import module in the step S01 is placed on a website for accumulating the external search heat and applying the accumulated external search heat.
CN202110915594.9A 2021-08-10 2021-08-10 Material BOM rapid comparison method Active CN113569107B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110915594.9A CN113569107B (en) 2021-08-10 2021-08-10 Material BOM rapid comparison method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110915594.9A CN113569107B (en) 2021-08-10 2021-08-10 Material BOM rapid comparison method

Publications (2)

Publication Number Publication Date
CN113569107A true CN113569107A (en) 2021-10-29
CN113569107B CN113569107B (en) 2023-12-15

Family

ID=78171153

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110915594.9A Active CN113569107B (en) 2021-08-10 2021-08-10 Material BOM rapid comparison method

Country Status (1)

Country Link
CN (1) CN113569107B (en)

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20020032611A1 (en) * 2000-03-06 2002-03-14 Khan Ahmad Hasan Methods and systems for sourcing bill of material and data handling configurations software
CN106355375A (en) * 2016-09-18 2017-01-25 福州大学 Automatic confirming method of materials
CN111061770A (en) * 2019-12-27 2020-04-24 云汉芯城(上海)互联网科技股份有限公司 BOM model matching device and method, electronic equipment and storage medium

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20020032611A1 (en) * 2000-03-06 2002-03-14 Khan Ahmad Hasan Methods and systems for sourcing bill of material and data handling configurations software
CN106355375A (en) * 2016-09-18 2017-01-25 福州大学 Automatic confirming method of materials
CN111061770A (en) * 2019-12-27 2020-04-24 云汉芯城(上海)互联网科技股份有限公司 BOM model matching device and method, electronic equipment and storage medium

Also Published As

Publication number Publication date
CN113569107B (en) 2023-12-15

Similar Documents

Publication Publication Date Title
CN103678648B (en) A kind of BOM table sort aggregation system and method thereof
CN109522746A (en) A kind of data processing method, electronic equipment and computer storage medium
CN110851598B (en) Text classification method and device, terminal equipment and storage medium
US20230161802A1 (en) Method and device for constructing standard knowledge graph, and method and device for querying standard
CN112800044B (en) Data quality judging and monitoring method, management system, storage medium and terminal
CN106997390A (en) A kind of equipment part or parts commodity transaction information search method
CN110765639A (en) Electrical simulation modeling method and device and readable storage medium
CN105205038A (en) Complete material list table generation method and device
CN106649557B (en) Semantic association mining method for defect report and mail list
CN110765750A (en) Report data entry method and terminal equipment
CN113569107A (en) Method for quickly comparing BOM (bill of material)
CN104573101B (en) A kind of data flow real-time grading method and system of rule-based route
TW200417884A (en) System and method for automatically classifying bill of material
CN109948015B (en) Meta search list result extraction method and system
CN112395292B (en) Data feature extraction and matching method and device
CN115660493A (en) Enterprise product standard establishing method and system based on big data
CN115760495A (en) Method and device for realizing automatic labeling of legal cases
CN111209397B (en) Method for determining enterprise industry category
CN114356885A (en) Intelligent matching method for scientific and technological service projects, storage medium and equipment
CN111241795B (en) Service form extraction method and device
CN103164468A (en) Patent sort management method and management system
Chen et al. Quality Traceability System for Multistation SMT Manufacturing Process
CN111291031A (en) Data correction method and device
CN113360652B (en) Enterprise-level power user intelligent classification method and device
CN116824604B (en) Financial data management method and system based on image processing

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
CB02 Change of applicant information

Address after: 201613 floor 4, building 9, No. 199, Guangfulin East Road, Songjiang District, Shanghai

Applicant after: SHANGHAI YINTE ELECTRONICS CO.,LTD.

Address before: Room 1528, No. 25, Lane 38, Caoli Road, Fengjing town, Jinshan District, Shanghai 201502

Applicant before: SHANGHAI YINTE ELECTRONICS CO.,LTD.

CB02 Change of applicant information
GR01 Patent grant
GR01 Patent grant