[go: up one dir, main page]

CN110515951B - BOM standardization method and system, electronic device and storage medium - Google Patents

BOM standardization method and system, electronic device and storage medium Download PDF

Info

Publication number
CN110515951B
CN110515951B CN201910796495.6A CN201910796495A CN110515951B CN 110515951 B CN110515951 B CN 110515951B CN 201910796495 A CN201910796495 A CN 201910796495A CN 110515951 B CN110515951 B CN 110515951B
Authority
CN
China
Prior art keywords
original
bom
column
content
standard
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201910796495.6A
Other languages
Chinese (zh)
Other versions
CN110515951A (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.)
Ickey Shanghai Internet Technology Co ltd
Original Assignee
Ickey Shanghai Internet Technology 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 Ickey Shanghai Internet Technology Co ltd filed Critical Ickey Shanghai Internet Technology Co ltd
Priority to CN201910796495.6A priority Critical patent/CN110515951B/en
Publication of CN110515951A publication Critical patent/CN110515951A/en
Application granted granted Critical
Publication of CN110515951B publication Critical patent/CN110515951B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/221Column-oriented storage; Management thereof
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/258Data format conversion from or to a database
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06QINFORMATION 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/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087Inventory or stock management, e.g. order filling, procurement or balancing against orders
    • G06Q10/0875Itemisation 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)
  • Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • Economics (AREA)
  • General Engineering & Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Operations Research (AREA)
  • Finance (AREA)
  • Strategic Management (AREA)
  • Tourism & Hospitality (AREA)
  • Marketing (AREA)
  • General Business, Economics & Management (AREA)
  • Development Economics (AREA)
  • Quality & Reliability (AREA)
  • Software Systems (AREA)
  • Human Resources & Organizations (AREA)
  • Accounting & Taxation (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • User Interface Of Digital Computer (AREA)

Abstract

The application discloses a BOM standardization method, a system, an electronic device and a computer readable storage medium, wherein the method comprises the following steps: acquiring an original BOM; extracting original contents stored in each original column of the original BOM, and matching the original contents by using content characteristics corresponding to a target column in a standard BOM to obtain a matching result; and importing the original content into a corresponding target column according to the matching result. That is, after the original BOM is obtained, the original content stored in the original column of the original BOM is extracted, and the original content is matched by using the content features corresponding to the target column in the standard BOM, so that the original content can be imported into the target column according to the matched result, the standardization of the BOM is realized, the standardization efficiency of the BOM is improved, the manual operation time is reduced, and the labor cost is reduced.

Description

BOM standardization method and system, electronic device and storage medium
Technical Field
The present application relates to the field of material management technologies, and in particular, to a method and a system for standardizing a BOM, an electronic device, and a computer-readable storage medium.
Background
BOM (bill of material; Chinese full name: bill of materials) is a table for recording all electronic components and parts required by a product. Because the internal templates of each electronic research and development enterprise are different, the formats of the BOMs from different sources are greatly different, and if the needs of the customers are acquired from different BOMs so as to help the customers to find the required materials, the information belonging to the parameters, the information belonging to the models and the like need to be manually distinguished from the original BOMs of the customers, and the information is manually copied into the standardized BOMs, so that certain manpower and material resources are wasted.
Therefore, how to solve the above problems is a great concern for those skilled in the art.
Disclosure of Invention
The utility model aims to provide a BOM standardization method, system, an electronic device and a computer readable storage medium, which improves the BOM standardization efficiency, reduces the manual operation time and reduces the labor cost.
To achieve the above object, the present application provides a BOM normalization method, including:
acquiring an original BOM;
extracting original contents stored in each original column of the original BOM, and matching the original contents by using content characteristics corresponding to a target column in a standard BOM to obtain a matching result;
and importing the original content into a corresponding target column according to the matching result.
Optionally, before extracting the original content stored in each original column of the original BOM and matching the original content by using the content features corresponding to the target column in the standard BOM, the method further includes:
and judging whether the original columns of the original BOM are matched or not by using preset identification information, and if not, starting the step of extracting the original content stored in each original column of the original BOM.
Optionally, after extracting the original content stored in each original column of the original BOM and matching the original content by using the content features corresponding to the target column in the standard BOM to obtain a matching result, the method further includes:
and determining the effective information density corresponding to the successfully matched original column.
Optionally, the importing the original content into a corresponding target column according to the matching result includes:
and if a plurality of original columns which are successfully matched with the content features in the original BOM are provided, importing the original content stored in the column with the maximum effective information density in all the original columns into the target column.
Optionally, before the importing the original content stored in the column with the maximum effective information density in all the original columns into the target column, the method further includes:
judging whether the maximum effective information density is greater than a preset threshold value or not;
if yes, starting the step of importing the original content stored in the column with the maximum effective information density in all the original columns into the target column;
if not, generating corresponding prompt information.
Optionally, the method further includes:
receiving a BOM modification instruction by using a preset interactive interface;
and modifying the standard BOM based on the BOM modification instruction.
Optionally, the method further includes:
acquiring a preset number of historical original BOMs;
and identifying and obtaining the content characteristics corresponding to the target column in the standard BOM based on the phrase occurrence frequency or the character combination rule of the stored content in the column of the historical original BOM.
Optionally, the method further includes:
determining a parameter column storing various types of parameters in the standard BOM;
and extracting the parameters of the multiple types in the parameter list to the list corresponding to each parameter type of the standard BOM by using the content characteristics corresponding to the list in the standard BOM.
To achieve the above object, the present application provides a BOM normalization system, comprising:
the acquisition module is used for acquiring an original BOM;
the extraction module is used for extracting the original content stored in each original column of the original BOM and matching the original content by using the content characteristics corresponding to the target column in the standard BOM to obtain a matching result;
and the importing module is used for importing the original content into the corresponding target column according to the matching result.
To achieve the above object, the present application provides an electronic device including:
a memory for storing a computer program;
a processor for implementing the steps of any of the BOM normalization methods disclosed above when executing the computer program.
To achieve the above object, the present application provides a computer-readable storage medium having a computer program stored thereon, which when executed by a processor, implements the steps of any of the aforementioned BOM normalization methods disclosed.
According to the scheme, the BOM standardization method provided by the application comprises the following steps: acquiring an original BOM; extracting original contents stored in each original column of the original BOM, and matching the original contents by using content characteristics corresponding to a target column in a standard BOM to obtain a matching result; and importing the original content into a corresponding target column according to the matching result. That is, after the original BOM is obtained, the original content stored in the original column of the original BOM is extracted, and the original content is matched by using the content features corresponding to the target column in the standard BOM, so that the original content can be imported into the target column according to the matched result, the standardization of the BOM is realized, the standardization efficiency of the BOM is improved, the manual operation time is reduced, and the labor cost is reduced.
The application also discloses a BOM standardization system, an electronic device and a computer readable storage medium, which can also achieve the technical effects.
It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the application.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a flow chart of a method for BOM normalization as disclosed in an embodiment of the present application;
FIG. 2 is a flow chart of another method for BOM normalization as disclosed in embodiments herein;
FIG. 3 is a flow chart of yet another method for BOM normalization as disclosed in an embodiment of the present application;
FIG. 4 is a flowchart of a specific method for BOM normalization as disclosed in an embodiment of the present application;
FIG. 5 is a block diagram of a BOM standardized system disclosed in an embodiment of the present application;
fig. 6 is a block diagram of an electronic device disclosed in an embodiment of the present application;
fig. 7 is a block diagram of another electronic device disclosed in the embodiments of the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, 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 application.
In the conventional technology, because internal templates of electronic research and development enterprises are different, formats of BOMs from different sources are greatly different, and if the needs of customers are acquired from different BOMs so as to help the customers to find required materials, the information belonging to parameters, the information belonging to models and the like needs to be manually identified from the original BOMs of the customers and manually copied to the standardized BOMs, so that certain manpower and material resources are wasted.
Therefore, the embodiment of the application discloses a BOM standardization method, which improves the BOM standardization efficiency, reduces the manual operation time and reduces the labor cost.
Referring to fig. 1, a BOM normalization method disclosed in an embodiment of the present application includes:
s101: acquiring an original BOM;
original BOMs from different sources of different users are obtained. Specifically, the BOM may be obtained by using an intelligent terminal or a server, where the intelligent terminal may include but is not limited to: smart phones, tablet computers, PCs, PDAs, wearable devices, head-mounted display devices, and the like; the server may include, but is not limited to: a single web server, a server group of multiple web servers, or a cloud based on cloud computing consisting of a large number of computers or web servers.
In a specific implementation, the method for obtaining the original BOM may be to import the original BOM through a preset interface or a data transmission line, or may receive the original BOM sent by a user through a wireless communication method.
S102: extracting original contents stored in each original column of the original BOM, and matching the original contents by using content characteristics corresponding to a target column in a standard BOM to obtain a matching result;
after the original BOM is obtained, content extraction is carried out on the original BOM to obtain specific content stored in a column of the original BOM, and then the original content can be matched based on content characteristics corresponding to a target column of the current standard BOM.
It is understood that the above-mentioned content features may be obtained in a specific manner, including: acquiring a preset number of historical original BOMs; and identifying and obtaining the content characteristics corresponding to the target column in the standard BOM based on the phrase occurrence frequency or the character combination rule of the stored content in the column of the historical original BOM. That is, in this embodiment, a large number of original BOMs from different sources may be obtained in advance, and the content in the columns in the original BOMs may be identified, and the content features corresponding to each column may be obtained by extracting the keywords or the combination rules. For example, for the mounting positions of the electronic components stored in the BOM, the contents stored in the columns are usually in the formats of C1, C2, L1, L2, R1, and the like, and thus, the content characteristics corresponding to the columns storing the mounting positions can be summarized as the combination of the english alphabet and the number, and the content characteristics can be used as the content characteristics of the mounting position columns.
S103: and importing the original content into a corresponding target column according to the matching result.
In this embodiment, after performing the row-column matching according to the content characteristics of the rows, the original content of the original BOM is imported into the target row of the standard BOM according to the matching result, so as to achieve the standardization of the BOM, so as to obtain the material requirements of the user by using the standard BOM in the following.
Further, as a preferred implementation, this embodiment may further include: receiving a BOM modification instruction by using a preset interactive interface; and modifying the standard BOM based on the BOM modification instruction. Specifically, a preset interactive interface may be provided for the user through the display device or the display screen, so that the BOM modification instruction issued by the user is obtained through the preset interactive interface. Specifically, a user can select a column title of the original BOM from a pull-down list of the standard BOM in a mode of clicking a page by a mouse or touching the page by a touch screen, copy the whole column content of the original BOM into the standard BOM, and adjust the standard BOM; in addition, the user can independently edit each cell in the original BOM through the preset interactive interface, so that the standard BOM can be modified.
In this embodiment, in order to update the content features corresponding to the standard BOM column in real time, after the matching is completed, it may be determined whether an unmatched column exists in the original BOM, where the column is an unrecorded content feature, so that the features of the content of the column may be extracted and added to the content features corresponding to the standard BOM column, and the success rate and accuracy of the matching may be gradually improved.
It should be noted that, because some original BOMs may store a plurality of different types of parameters of electronic components in the same column of the BOM, in order to achieve better sorting of the parameters and efficiently obtain information of the parameters, in this embodiment, after the original content is imported into the corresponding target column, the parameters in the parameter column of the standard BOM are further extracted into the column corresponding to each parameter type through the content features of the column. The parameter columns are columns preset in the standard BOM in the embodiment, and the columns correspond to columns storing various types of parameters in the original BOM.
According to the scheme, the BOM standardization method provided by the application comprises the following steps: acquiring an original BOM; extracting original contents stored in each original column of the original BOM, and matching the original contents by using content characteristics corresponding to a target column in a standard BOM to obtain a matching result; and importing the original content into a corresponding target column according to the matching result. That is, after the original BOM is obtained, the original content stored in the original column of the original BOM is extracted, and the original content is matched by using the content features corresponding to the target column in the standard BOM, so that the original content can be imported into the target column according to the matched result, the standardization of the BOM is realized, the standardization efficiency of the BOM is improved, the manual operation time is reduced, and the labor cost is reduced.
The embodiment of the application discloses another BOM standardization method, and compared with the previous embodiment, the embodiment further explains and optimizes the technical scheme. Referring to fig. 2, specifically:
s201: acquiring an original BOM;
s202: judging whether the original column of the original BOM is subjected to matching operation or not by using preset identification information;
s203: if not, extracting the original content stored in each original column of the original BOM, and matching the original content by using the content characteristics corresponding to the target column in the standard BOM to obtain a matching result;
s204: and importing the original content into a corresponding target column according to the matching result.
In specific implementation, after the columns of the original BOM are matched based on the content features corresponding to the target columns in the standard BOM, the columns which are successfully matched can be identified, so that whether the columns are successfully matched can be known according to whether the columns of the original BOM have identification information, and repeated matching of the columns which are successfully matched can be avoided. The column that is successfully matched may be identified by changing the column that is successfully matched into a preset color, or a preset symbol may be added after the column name of the column, and of course, other methods for identifying the column may also be used, which are not limited herein.
The embodiment of the application discloses another BOM standardization method, and compared with the previous embodiment, the embodiment further explains and optimizes the technical scheme. Referring to fig. 3, specifically:
s301: acquiring an original BOM;
s302: extracting original contents stored in each original column of the original BOM, and matching the original contents by using content characteristics corresponding to a target column in a standard BOM to obtain a matching result;
s303: determining effective information density corresponding to the successfully matched original column;
s304: and if a plurality of original columns which are successfully matched with the content features in the original BOM are provided, importing the original content stored in the column with the maximum effective information density in all the original columns into the target column.
In specific implementation, after the original content is matched by using the content features corresponding to the target columns in the standard BOM, the effective information density corresponding to the successfully matched columns in the original BOM can be calculated. In particular, the effective information density refers to the percentage of the total content stored in the column that is successfully matched.
If there are a plurality of columns successfully matched with the content features of the target column in the standard BOM in the original BOM, then a column with the maximum effective information density is further determined from the plurality of columns, and the content of the column is imported into the target column.
Preferably, after determining the effective information density corresponding to the successfully matched original column, if there is only one column in the successfully matched column, the embodiment determines whether the effective information density of the column is greater than a preset threshold; and if the successfully matched columns have multiple columns, judging whether the maximum effective information density in all the columns is greater than a preset threshold value. If the effective information density is larger than the preset threshold value, starting a step of importing the original content in the original column into the corresponding target column; and if the effective information density is smaller than or equal to the preset threshold value, forbidding to execute the step of importing the original content in the original column into the corresponding target column, and generating corresponding prompt information, wherein the prompt information is used for reminding a worker that the effective information density is smaller than the preset threshold value so as to facilitate the worker to perform manual intervention. It can be understood that by setting a preset threshold value of the effective information density, the probability of BOM normalization error can be reduced.
Fig. 4 is a flowchart of a specific BOM normalization method according to an embodiment of the present disclosure, and as shown in fig. 4, in this embodiment, a column is identified according to characteristics of column contents to match a target column of a standard BOM. Starting matching from a first column of an original BOM, firstly judging whether the column is marked as a certain column of a standard BOM; if the column is not marked as a certain column of the standard BOM, matching the column according to the content of the target column, and determining the effective information density of the column; if the column is marked as a certain column of the standard BOM, judging whether the next column exists, and if so, performing the matching operation on the next column; and if the next column does not exist, judging whether the effective information density is greater than a preset threshold value, marking the column corresponding to the density which is the maximum in the effective information density and is greater than the preset threshold value as a target column of the standard BOM, and further importing the content.
A BOM normalization system provided in an embodiment of the present application is introduced below, and a BOM normalization system described below and a BOM normalization method described above may be referred to each other.
Referring to fig. 5, a BOM normalization system provided in an embodiment of the present application includes:
an obtaining module 100, configured to obtain an original BOM;
an extracting module 200, configured to extract original content stored in each original column of the original BOM, and match the original content by using content features corresponding to a target column in a standard BOM to obtain a matching result;
an importing module 300, configured to import the original content into a corresponding target column according to the matching result.
On the basis of the foregoing embodiment, as a preferred implementation manner, the BOM standardization system provided in the embodiment of the present application may further include:
the first judgment module is used for judging whether the matching operation is carried out on the original column of the original BOM or not by utilizing preset identification information;
and the first starting module is used for starting the step of extracting the original content stored in each original column of the original BOM if the current original column in the original BOM does not contain preset identification information.
On the basis of the foregoing embodiment, as a preferred implementation manner, the BOM standardization system provided in the embodiment of the present application may further include:
and the density determining module is used for determining the effective information density corresponding to the successfully matched original column.
On the basis of the foregoing embodiment, as a preferred implementation manner, the import module in the BOM standardization system provided in the embodiment of the present application may include:
and the content import unit is used for importing the original content stored in the column with the maximum effective information density in all the original columns into the target column if the original columns successfully matched with the content features in the original BOM are multiple.
On the basis of the foregoing embodiment, as a preferred implementation manner, the BOM standardization system provided in the embodiment of the present application may further include:
the second judging unit is used for judging whether the maximum effective information density is larger than a preset threshold value or not;
a second starting module, configured to start the step of importing, into the target column, the original content stored in the column with the largest effective information density in all the original columns, if the maximum effective information density is greater than the preset threshold;
and the prompt generation unit is used for generating corresponding prompt information if the maximum effective information density is less than or equal to the preset threshold value.
On the basis of the foregoing embodiment, as a preferred implementation manner, the BOM standardization system provided in the embodiment of the present application may further include:
the modification receiving module is used for receiving a BOM modification instruction by using a preset interactive interface;
and the BOM modification module is used for modifying the standard BOM based on the BOM modification instruction.
On the basis of the foregoing embodiment, as a preferred implementation manner, the BOM standardization system provided in the embodiment of the present application may further include:
the history acquisition module is used for acquiring a preset number of historical original BOMs;
and the characteristic identification module is used for identifying and obtaining the content characteristics corresponding to the target column in the standard BOM based on the phrase occurrence frequency or the character combination rule of the content stored in the column of the historical original BOM.
On the basis of the foregoing embodiment, as a preferred implementation manner, the BOM standardization system provided in the embodiment of the present application may further include:
the parameter column determining module is used for determining parameter columns for storing various types of parameters in the standard BOM;
and the parameter extraction module is used for extracting various types of parameters in the parameter list to the column corresponding to each parameter type of the standard BOM by using the content characteristics corresponding to the column in the standard BOM.
For more specific working processes of the modules and units, reference may be made to specific contents disclosed in the foregoing embodiments, which are not described in detail in this embodiment.
Further, an embodiment of the present invention further discloses an electronic device, as shown in fig. 6, the electronic device includes a memory 11 and a processor 12, where the processor 12 implements the steps of the BOM standardization method provided in the foregoing embodiment when executing the computer program stored in the memory 11.
The memory 11 includes a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and computer-readable instructions, and the internal memory provides an environment for the operating system and the computer-readable instructions in the non-volatile storage medium to run. The processor 12 may be a Central Processing Unit (CPU), a controller, a microcontroller, a microprocessor or other data processing chip in some embodiments, and provides computing and controlling capability for the electronic device, and when executing the computer program stored in the memory 100, the steps of the BOM standardization method provided in any of the foregoing embodiments may be implemented.
Further, referring to fig. 7, the electronic device in this embodiment may further include:
the input interface 13 is configured to obtain a computer program imported from the outside, store the obtained computer program in the memory 11, and also be configured to obtain various instructions and parameters transmitted by an external terminal device, and transmit the instructions and parameters to the processor 12, so that the processor 12 performs corresponding processing by using the instructions and parameters. In this embodiment, the input interface 13 may specifically include, but is not limited to, a USB interface, a serial interface, a voice input interface, a fingerprint input interface, a hard disk reading interface, and the like.
And the output interface 14 is used for outputting various data generated by the processor 12 to the terminal equipment connected with the output interface 14, so that other terminal equipment connected with the output interface 14 can acquire various data generated by the processor 12. In this embodiment, the output interface 14 may specifically include, but is not limited to, a USB interface, a serial interface, and the like.
And a display unit 15 for displaying the data sent by the processor 12.
The communication unit 16 is configured to establish a remote communication connection with an external server, acquire data sent by an external terminal, and send the data to the processor 11 for processing and analysis, and in addition, the processor 11 may also send various results obtained after processing to preset various data receiving ends through the communication unit 16. In this embodiment, the communication technology adopted by the communication unit 16 may be a wired communication technology or a wireless communication technology, such as a Universal Serial Bus (USB), a wireless fidelity technology (WiFi), a bluetooth communication technology, a low-power bluetooth communication technology (BLE), and the like. Additionally, the communication unit 16 may embody a cellular radio transceiver operating in accordance with wideband code division multiple access (W-CDMA), Long Term Evolution (LTE), and similar standards.
Fig. 7 shows only an electronic device with components 11-16, and it will be understood by those skilled in the art that the structure shown in fig. 7 does not constitute a limitation of the electronic device, and may comprise fewer or more components than shown, or some components may be combined, or a different arrangement of components.
The present application also provides a computer-readable storage medium, which may include: various media capable of storing program codes, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk. The storage medium has a computer program stored thereon, which when executed by a processor implements the steps of the BOM normalization method provided in any of the preceding embodiments. For the specific steps of the method, reference may be made to the corresponding contents disclosed in the foregoing embodiments, which are not described herein again.
According to the method and the device, after the original BOM is obtained, the original content stored in the original column of the original BOM is extracted, the original content is matched by using the content characteristics corresponding to the target column in the standard BOM, so that the original content can be imported into the target column according to the matched result, the standardization of the BOM is realized, the standardization efficiency of the BOM is improved, the manual operation time is reduced, and the labor cost is reduced.
The embodiments are described in a progressive manner in the specification, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments are referred to each other. For the system disclosed by the embodiment, the description is relatively simple because the system corresponds to the method disclosed by the embodiment, and the relevant points can be referred to the method part for description. It should be noted that, for those skilled in the art, it is possible to make several improvements and modifications to the present application without departing from the principle of the present application, and such improvements and modifications also fall within the scope of the claims of the present application.
It is further noted that, in the present specification, relational terms such as first and second, and the like are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.

Claims (9)

1.一种BOM标准化方法,其特征在于,包括:1. a BOM standardization method, is characterized in that, comprises: 获取原始BOM;Get the original BOM; 提取所述原始BOM每个原始列中保存的原始内容,利用标准BOM中目标列对应的内容特征对所述原始内容进行匹配,得到匹配结果;Extract the original content saved in each original column of the original BOM, and utilize the content feature corresponding to the target column in the standard BOM to match the original content to obtain a matching result; 根据所述匹配结果将所述原始内容导入对应的目标列中;importing the original content into the corresponding target column according to the matching result; 所述提取所述原始BOM每个原始列中保存的原始内容,利用标准BOM中目标列对应的内容特征对所述原始内容进行匹配,得到匹配结果之后,还包括:Described extracting the original content saved in each original column of the original BOM, using the content feature corresponding to the target column in the standard BOM to match the original content, after obtaining the matching result, it also includes: 确定匹配成功的原始列对应的有效信息密度;Determine the effective information density corresponding to the original column that is successfully matched; 所述根据所述匹配结果将所述原始内容导入对应的目标列中,包括:The importing the original content into the corresponding target column according to the matching result includes: 若所述原始BOM中与所述内容特征匹配成功的原始列为多个,则将所有原始列中所述有效信息密度最大的列中保存的原始内容导入所述目标列中。If there are multiple original columns in the original BOM that are successfully matched with the content feature, the original content stored in the column with the highest effective information density among all the original columns is imported into the target column. 2.根据权利要求1所述的BOM标准化方法,其特征在于,所述提取所述原始BOM每个原始列中保存的原始内容,利用标准BOM中目标列对应的内容特征对所述原始内容进行匹配之前,还包括:2. The BOM standardization method according to claim 1, characterized in that, by extracting the original content saved in each original column of the original BOM, the original content is performed on the original content by using the content feature corresponding to the target column in the standard BOM. Before matching, also include: 利用预设标识信息判断是否已对所述原始BOM的原始列进行匹配操作;Utilize the preset identification information to judge whether the original column of the original BOM has been matched; 如果否,则启动所述提取所述原始BOM每个原始列中保存的原始内容的步骤。If not, the step of extracting the original content stored in each original column of the original BOM is started. 3.根据权利要求1所述的BOM标准化方法,其特征在于,所述将所有原始列中所述有效信息密度最大的列中保存的原始内容导入所述目标列中之前,还包括:3. The BOM standardization method according to claim 1, wherein, before the original content saved in the column with the largest effective information density in all original columns is imported into the target column, the method further comprises: 判断最大有效信息密度是否大于预设阈值;Determine whether the maximum effective information density is greater than a preset threshold; 若是,则启动所述将所有原始列中所述有效信息密度最大的列中保存的原始内容导入所述目标列中的步骤;If yes, then start the step of importing the original content saved in the column with the highest effective information density in all the original columns into the target column; 若否,则生成相应的提示信息。If not, generate corresponding prompt information. 4.根据权利要求1所述的BOM标准化方法,其特征在于,还包括:4. BOM standardization method according to claim 1, is characterized in that, also comprises: 利用预设交互界面接收BOM修改指令;Use the preset interactive interface to receive BOM modification instructions; 基于所述BOM修改指令对所述标准BOM进行修改。The standard BOM is modified based on the BOM modification instruction. 5.根据权利要求1至4任一项所述的BOM标准化方法,其特征在于,还包括:5. BOM standardization method according to any one of claims 1 to 4, is characterized in that, also comprises: 获取预设数量的历史原始BOM;Get a preset number of historical raw BOMs; 基于所述历史原始BOM的列中保存内容的词组出现频率或字符组合规则,识别得到所述标准BOM中目标列对应的内容特征。Based on the frequency of occurrence of phrases or character combination rules of the stored content in the column of the historical original BOM, the content feature corresponding to the target column in the standard BOM is identified and obtained. 6.根据权利要求5所述的BOM标准化方法,其特征在于,还包括:6. BOM standardization method according to claim 5, is characterized in that, also comprises: 确定所述标准BOM中存储多种类型参数的参数列;Determine the parameter columns that store multiple types of parameters in the standard BOM; 利用所述标准BOM中列对应的内容特征将所述参数列中多种类型的参数提取至所述标准BOM各参数类型对应的列中。Various types of parameters in the parameter column are extracted into columns corresponding to each parameter type of the standard BOM by using the content features corresponding to the columns in the standard BOM. 7.一种BOM标准化系统,其特征在于,包括:7. a BOM standardization system, is characterized in that, comprises: 获取模块,用于获取原始BOM;Get module, used to get the original BOM; 提取模块,用于提取所述原始BOM每个原始列中保存的原始内容,利用标准BOM中目标列对应的内容特征对所述原始内容进行匹配,得到匹配结果;The extraction module is used for extracting the original content saved in each original column of the original BOM, and utilizes the content feature corresponding to the target column in the standard BOM to match the original content to obtain a matching result; 导入模块,用于根据所述匹配结果将所述原始内容导入对应的目标列中;an import module for importing the original content into the corresponding target column according to the matching result; 所述提取所述原始BOM每个原始列中保存的原始内容,利用标准BOM中目标列对应的内容特征对所述原始内容进行匹配,得到匹配结果之后,还包括:Described extracting the original content saved in each original column of the original BOM, using the content feature corresponding to the target column in the standard BOM to match the original content, after obtaining the matching result, it also includes: 确定匹配成功的原始列对应的有效信息密度;Determine the effective information density corresponding to the original column that is successfully matched; 所述根据所述匹配结果将所述原始内容导入对应的目标列中,包括:The importing the original content into the corresponding target column according to the matching result includes: 若所述原始BOM中与所述内容特征匹配成功的原始列为多个,则将所有原始列中所述有效信息密度最大的列中保存的原始内容导入所述目标列中。If there are multiple original columns in the original BOM that are successfully matched with the content feature, the original content stored in the column with the highest effective information density among all the original columns is imported into the target column. 8.一种电子设备,其特征在于,包括:8. An electronic device, characterized in that, comprising: 存储器,用于存储计算机程序;memory for storing computer programs; 处理器,用于执行所述计算机程序时实现如权利要求1至6任一项所述BOM标准化方法的步骤。A processor, configured to implement the steps of the BOM standardization method according to any one of claims 1 to 6 when executing the computer program. 9.一种计算机可读存储介质,其特征在于,所述计算机可读存储介质上存储有计算机程序,所述计算机程序被处理器执行时实现如权利要求1至6任一项所述BOM标准化方法的步骤。9. A computer-readable storage medium, characterized in that, a computer program is stored on the computer-readable storage medium, and when the computer program is executed by a processor, the BOM standardization as described in any one of claims 1 to 6 is realized steps of the method.
CN201910796495.6A 2019-08-27 2019-08-27 BOM standardization method and system, electronic device and storage medium Active CN110515951B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201910796495.6A CN110515951B (en) 2019-08-27 2019-08-27 BOM standardization method and system, electronic device and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910796495.6A CN110515951B (en) 2019-08-27 2019-08-27 BOM standardization method and system, electronic device and storage medium

Publications (2)

Publication Number Publication Date
CN110515951A CN110515951A (en) 2019-11-29
CN110515951B true CN110515951B (en) 2020-05-08

Family

ID=68628186

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910796495.6A Active CN110515951B (en) 2019-08-27 2019-08-27 BOM standardization method and system, electronic device and storage medium

Country Status (1)

Country Link
CN (1) CN110515951B (en)

Families Citing this family (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111143278A (en) * 2019-12-04 2020-05-12 深圳市铭华航电工艺技术有限公司 Electronic assembly-based bill of material processing method, device, equipment and readable medium
CN111061770A (en) * 2019-12-27 2020-04-24 云汉芯城(上海)互联网科技股份有限公司 BOM model matching device and method, electronic equipment and storage medium
CN111080208B (en) * 2019-12-27 2020-09-01 云汉芯城(上海)互联网科技股份有限公司 BOM (bill of material) matching device and method, electronic equipment and storage medium
CN112347750B (en) * 2020-10-29 2023-05-23 浪潮通用软件有限公司 Method, equipment and medium for generating bill of materials
CN112597350B (en) * 2020-12-25 2023-04-11 云汉芯城(上海)互联网科技股份有限公司 Parameter verification method, system and computer storage medium
CN113627892B (en) * 2021-08-16 2023-09-01 深圳市云采网络科技有限公司 A method for identifying BOM data and its electronic equipment
CN113627893B (en) * 2021-08-16 2023-09-01 深圳市云采网络科技有限公司 A method for parsing and identifying BOM files and electronic equipment
CN115168334A (en) * 2022-04-12 2022-10-11 深圳特发东智科技有限公司 A data processing system for acquiring electronic component information

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107766313A (en) * 2017-10-19 2018-03-06 平安科技(深圳)有限公司 The introduction method and its terminal of a kind of data list
CN108090073A (en) * 2016-11-22 2018-05-29 上海汽车集团股份有限公司 A kind of conversion method and device of configurable bill of materials
CN109325730A (en) * 2018-08-28 2019-02-12 四川九州电子科技股份有限公司 A method of it supports that BOM is directly imported production system

Family Cites Families (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101877080A (en) * 2009-04-30 2010-11-03 厦门敏讯信息技术股份有限公司 Method for automatically generating configuration of bill of material (BOM)
US9633060B2 (en) * 2015-05-14 2017-04-25 Walleye Software, LLC Computer data distribution architecture with table data cache proxy
CN106570668A (en) * 2016-11-02 2017-04-19 深圳效率科技有限公司 Bill-of-materials (BOM) information organizing method and BOM information organizing device
CN107038555A (en) * 2017-04-10 2017-08-11 广州智造家网络科技有限公司 A kind of BOM tables introduction method and device
CN107797980A (en) * 2017-11-24 2018-03-13 山东省煤田地质规划勘察研究院 A kind of geological prospecting borehole data processing and control system based on Internet of Things
CN108197207A (en) * 2017-12-28 2018-06-22 南京涵韬信息科技有限公司 Batch data matches introduction method

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108090073A (en) * 2016-11-22 2018-05-29 上海汽车集团股份有限公司 A kind of conversion method and device of configurable bill of materials
CN107766313A (en) * 2017-10-19 2018-03-06 平安科技(深圳)有限公司 The introduction method and its terminal of a kind of data list
CN109325730A (en) * 2018-08-28 2019-02-12 四川九州电子科技股份有限公司 A method of it supports that BOM is directly imported production system

Also Published As

Publication number Publication date
CN110515951A (en) 2019-11-29

Similar Documents

Publication Publication Date Title
CN110515951B (en) BOM standardization method and system, electronic device and storage medium
CN112613917B (en) Information pushing method, device, equipment and storage medium based on user portrait
EP3413212A1 (en) Random forest model training method, electronic apparatus and storage medium
CN107392655B (en) Coupon push method, system, storage medium, electronic device and distribution method
CN109359284A (en) A kind of reporting and processing method, device and terminal device
CN111984792A (en) Website classification method and device, computer equipment and storage medium
CN110807002B (en) A workflow-based report generation method, system, device and storage medium
CN112416858B (en) Document storage method, apparatus, electronic device, and computer-readable storage medium
CN112085087B (en) Business rule generation method, device, computer equipment and storage medium
US20200286100A1 (en) Payment complaint method, device, server and readable storage medium
CN113515703B (en) Information recommendation method, device, electronic device and readable storage medium
CN111339166A (en) Thesaurus-based matching recommendation method, electronic device and storage medium
CN114637831A (en) Data query method and related equipment based on semantic analysis
JP7309811B2 (en) Data annotation method, apparatus, electronics and storage medium
CN115712422A (en) Form page generation method and device, computer equipment and storage medium
CN111625567A (en) Data model matching method, device, computer system and readable storage medium
CN118761579A (en) Resource scheduling method and device, non-volatile storage medium, and electronic device
CN110737432A (en) script aided design method and device based on root list
CN115146194B (en) Content quality determination method, device, equipment and storage medium
WO2019080419A1 (en) Method for building standard knowledge base, electronic device, and storage medium
CN111581915A (en) Project task management method, platform, electronic equipment and storage medium
CN113283231B (en) Method for acquiring signature bit, setting system, signature system and storage medium
CN116016692B (en) Protocol description text construction method, device, equipment and storage medium
CN110503378A (en) A BOM standardization method, system, electronic equipment and storage medium
CN118916453A (en) Intelligent operation and maintenance method based on self-developed GPT model and related equipment thereof

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
GR01 Patent grant
GR01 Patent grant