Electronic component material archiving method, device, equipment and storage medium

Abstract

The application discloses an electronic component material archiving method and device, equipment and storage medium, and relates to the technical field of computer software, which comprises the following steps: obtaining a material category based on a specification file of an electronic component; determining a file type of the specification file based on a preset keyword and the material category, wherein the file type comprises a material single file and a material series file; determining a target area from the specification file according to the file type, and extracting component parameters according to the material category and the target area; and generating a target material description and archiving based on the component parameters and the material category. The technical problem that the extracted parameters are mixed with multiple sub-model information due to the inability to automatically identify the material series file, resulting in low information extraction accuracy of the specification file, is solved, the extracted component parameters are accurately matched with the current archived material, the accuracy of parameter extraction is improved, and the usability of archived data is improved.

Description

Technical Field

[0001] This application relates to the field of computer software technology, and in particular to a method, apparatus, device and storage medium for archiving electronic component materials. Background Technology

[0002] As the electronic components industry develops towards high integration and rapid iteration, the number of specifications that need to be archived in enterprise material management systems is growing exponentially. At the same time, the specifications provided by different suppliers have significant differences in structure. Some specifications are presented as "series documents" covering multiple sub-models, rather than independent documents for a single material. This requires the archiving system to be able to automatically adapt to the different organizational forms of specifications and accurately locate the parameter information related to the target material.

[0003] Current methods for archiving electronic component materials mainly rely on manual identification of specification document types and manual extraction of parameters, lacking the ability to automatically distinguish specification document file types. When encountering a series of material files containing multiple sub-models, existing technology cannot automatically determine the file type, causing the system to directly extract parameters from the entire series of files. The extraction results are mixed with parameter information from multiple sub-models, which cannot accurately correspond to the single material to be archived, and the extracted parameters lack usability.

[0004] Therefore, how to provide a method that can automatically distinguish whether an electronic component specification sheet is a single material file or a material series file, and extract the parameter area corresponding to the target material from the specification sheet according to the different file types, has become an urgent technical problem to be solved. Summary of the Invention

[0005] The main purpose of this application is to provide a method, apparatus, equipment and storage medium for archiving electronic component materials, aiming to solve the technical problem of how to improve the accuracy of information extraction from electronic component materials.

[0006] To achieve the above objectives, this application proposes a method for archiving electronic component materials, the method comprising: Based on the datasheets of electronic components, the material categories are obtained; Based on preset keywords and the material category, the file type of the specification document is determined, wherein the file type includes individual material files and material series files; The target area is determined from the specification document according to the file type, and the component parameters are extracted according to the material category and the target area; Based on the component parameters and the material category, a target material description is generated and archived.

[0007] In one embodiment, the datasheet based on electronic components yields material categories, including: Detect whether the user has entered a material category; When no user-inputted material category is detected, category keywords are extracted based on the specification documents of electronic components; The material category is obtained based on the matching results between the preset category library and the category keywords.

[0008] In one embodiment, determining the file type of the specification document based on preset keywords and the material category includes: Based on the material category, a default confidence level is obtained; Based on the charts in the specification document, the character repetition rate of the charts is obtained; When the specification document contains preset keywords and the repetition of the chart characters is within a preset repetition range, the default confidence level is adjusted according to a preset step size; The file type of the specification document is determined based on the adjusted default confidence level.

[0009] In one embodiment, determining the target region from the specification file according to the file type and extracting component parameters according to the material category and the target region includes: When the file type is the material series file, the target area is determined from the specification file based on the sub-model input by the user; When the file type is the material unit file, the specification file is used as the target area; Based on the material category, determine the parameter extraction rules; Component parameters are extracted from the target area according to the parameter extraction rules.

[0010] In one embodiment, when the file type is the material series file, determining the target area from the specification file based on the sub-model input by the user includes: When the file type is the material series file, obtain the sub-model input by the user; The target sub-model table is obtained by filtering the tables in the specification document according to the sub-model. Extract the model information of each row in the preset column from the target sub-model table; The model information is compared with the sub-model information to obtain the row confidence score for each row; The region in the target sub-model table whose row confidence level falls within a preset row confidence level range is taken as the target region.

[0011] In one embodiment, generating and archiving a target material description based on the component parameters and the material category includes: Based on the material category, determine the material description template and material part number; The material description template is filled with the component parameters to obtain the target material description; The verification identifier is obtained based on the file hash value and original file name of the specification file; Generate a standardized filename based on the current timestamp, the verification identifier, and the material part number; The description of the target material is archived according to the standardized file name.

[0012] In one embodiment, the step of filling the material description template according to the component parameters to obtain the target material description includes: The material description template is filled with the component parameters to obtain the initial material description; Parse the parameter placeholders in the material description template and establish a mapping relationship between the parameter placeholders and the component parameters; Based on the mapping relationship, an audit interface is generated; In response to the user's parameter modification operation on the review interface, the initial material description is updated according to the parameter modification operation to obtain the target material description.

[0013] Furthermore, to achieve the above objectives, this application also proposes an electronic component material archiving device, which includes: The input module is used to obtain the material category based on the specification document of electronic components; The file module is used to determine the file type of the specification file based on preset keywords and the material category, wherein the file type includes individual material files and material series files; The extraction module is used to determine the target area from the specification file according to the file type, and extract component parameters according to the target area; The output module is used to generate and archive target material descriptions based on the component parameters and the material category.

[0014] In addition, to achieve the above objectives, this application also proposes an electronic component material archiving device, the device comprising: a memory, a processor, and a computer program stored in the memory and executable on the processor, the computer program being configured to implement the steps of the electronic component material archiving method as described above.

[0015] In addition, to achieve the above objectives, this application also proposes a storage medium, which is a computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, it implements the steps of the electronic component material archiving method described above.

[0016] In addition, to achieve the above objectives, this application also provides a computer program product, which includes a computer program that, when executed by a processor, implements the steps of the electronic component material archiving method described above.

[0017] This application obtains material categories based on the datasheet documents of electronic components; determines the file type of the datasheet document based on preset keywords and the material category, wherein the file type includes individual material files and material series files; determines a target area from the datasheet document according to the file type, and extracts component parameters according to the material category and the target area; and generates and archives a target material description based on the component parameters and the material category. This solves the technical problem in existing technologies where the inability to automatically identify material series files leads to extracted parameters containing multiple sub-model information, making it impossible to accurately correspond to the target material. It achieves automatic identification and targeted parameter extraction of material series files, ensuring that the extracted component parameters accurately match the currently archived material, thus improving the accuracy of parameter extraction and the usability of archived data. Attached Figure Description

[0018] The accompanying drawings, which are incorporated in and form part of this specification, illustrate embodiments consistent with this application and, together with the description, serve to explain the principles of this application.

[0019] To more clearly illustrate the technical solutions in the embodiments of this application or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, for those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0020] Figure 1 A flowchart illustrating an embodiment of the electronic component material archiving method of this application; Figure 2 This is a schematic diagram of the upload interface provided in Embodiment 1 of the electronic component material archiving method of this application; Figure 3 A schematic diagram of the review interface provided in Embodiment 1 of the electronic component material archiving method of this application; Figure 4 This is a flowchart illustrating Embodiment 2 of the electronic component material archiving method of this application; Figure 5This is a schematic diagram of the module structure of the electronic component material archiving device according to an embodiment of this application; Figure 6 This is a schematic diagram of the equipment structure of the hardware operating environment involved in the electronic component material archiving method in the embodiments of this application.

[0021] The purpose, features, and advantages of this application will be further explained in conjunction with the embodiments and with reference to the accompanying drawings. Detailed Implementation

[0022] It should be understood that the specific embodiments described herein are merely illustrative of the technical solutions of this application and are not intended to limit this application.

[0023] To better understand the technical solution of this application, a detailed description will be provided below in conjunction with the accompanying drawings and specific implementation methods.

[0024] The main solution of this application embodiment is as follows: based on the specification document of electronic components, the material category is obtained; based on preset keywords and the material category, the file type of the specification document is determined, wherein the file type includes material individual file and material series file; the target area is determined from the specification document according to the file type, and the component parameters are extracted according to the material category and the target area; based on the component parameters and the material category, the target material description is generated and archived.

[0025] In this embodiment, for ease of description, the following description uses a computer as the execution subject.

[0026] Current electronic component material archiving methods mainly rely on manual identification of specification document types and manual extraction of parameters, lacking the ability to automatically distinguish specification document file types. When encountering a series of material files containing multiple sub-models, existing technology cannot automatically determine the file type, causing the system to directly extract parameters from the entire series of files. The extraction results are mixed with parameter information from multiple sub-models, which cannot accurately correspond to the single material to be archived, and the extracted parameters lack usability.

[0027] This application provides a solution that addresses the technical problem of existing technologies failing to automatically identify material series files, resulting in extracted parameters containing multiple sub-model information that cannot accurately correspond to the target material. It achieves automatic identification and targeted parameter extraction of material series files, ensuring that the extracted component parameters accurately match the currently archived material, thereby improving the accuracy of parameter extraction and the usability of archived data.

[0028] It should be noted that the executing entity in this embodiment can be a computing service device with data processing, network communication, and program execution functions, such as a tablet computer, personal computer, or mobile phone, or an electronic device or computer capable of performing the above functions. The following description uses a computer as an example to illustrate this embodiment and the subsequent embodiments.

[0029] Based on this, embodiments of this application provide a method for archiving electronic component materials, referring to... Figure 1 , Figure 1 This is a flowchart illustrating the first embodiment of the electronic component material archiving method of this application.

[0030] In this embodiment, the electronic component material archiving method includes steps S10 to S40: Step S10: Obtain the material category based on the specification sheet of the electronic components; It should be noted that electronic components refer to basic components used in electronic circuits, such as resistors, capacitors, inductors, and ferrite beads; datasheets refer to PDF documents provided by component suppliers that record the electrical characteristics, physical dimensions, performance parameters, and other technical specifications of the electronic components; and material categories refer to the classification results of electronic components according to their function or structure, such as resistors, capacitors, inductors, and ferrite beads.

[0031] It is understandable that the parameter types corresponding to different material categories are significantly different. For example, resistors need to have their resistance, accuracy, and power extracted, while capacitors need to have their capacitance, withstand voltage, and material extracted. If a uniform parameter extraction rule is applied to all specification documents directly, the extracted parameters will not match the actual properties of the materials. Therefore, step S10 can avoid using incorrect parameter extraction rules due to missing material categories, thereby improving the relevance and accuracy of parameter extraction.

[0032] In one feasible implementation, step S10 may include: detecting whether the user has entered a material category; if no user input of a material category is detected, extracting category keywords based on the specification document of the electronic components; and obtaining the material category based on the matching result between the preset category library and the category keywords.

[0033] It should be noted that category keywords refer to words extracted from the specification document that can characterize the category to which the component belongs, such as "resistor" and "capacitor"; the preset category library refers to a pre-established data set that stores category names and their corresponding keyword mapping relationships; the matching result refers to the category name with the highest relevance to the extracted category keywords after comparing them with the keywords in the preset category library.

[0034] Specifically, Figure 2This is the upload interface for specification documents. After receiving the specification document uploaded by the user through the upload interface, the system extracts the text content from the specification document, performs keyword scanning on the text content, locates the nouns that represent the component category, and uses these nouns as category keywords. Then, the category keywords are entered into a preset category library for matching queries. The preset category library stores mapping relationships between keywords such as "Resistor, R" for "resistor" and keywords such as "Capacitor, C" for "capacitor". The matching process compares the category keywords with the keyword sets corresponding to each category, and outputs the category name with the highest matching degree as the material category.

[0035] For example, if a user uploads a resistor specification document without actively selecting a material category, the system extracts two category keywords, "Resistor" and "resistor," from the specification document, inputs these keywords into a preset category library for matching, and if the matching result is "resistor," then the system determines the material category as "resistor."

[0036] In this embodiment, by automatically extracting category keywords from the specification document and matching them with the preset category library when the user does not input a material category, the problem of missing material categories when the user operation is incomplete is solved, and the automatic completion and intelligent recognition of material categories are realized.

[0037] The above are merely feasible implementations of step S10 provided in this embodiment. This embodiment does not specifically limit the specific implementation of step S10.

[0038] Step S20: Determine the file type of the specification document based on preset keywords and the material category; It should be noted that the preset keywords are characteristic words used to identify whether a specification document belongs to a series of documents, including words such as "Series", "Serie" and "series"; the document types include material unit documents and material series documents. Material unit documents are specification documents that describe the parameter information of a single model of electronic component, while material series documents are specification documents that describe the parameter information of multiple related sub-models in one specification document.

[0039] It is understandable that since the material series file contains parameter information of multiple sub-models, if the file type is not distinguished and the parameters are extracted directly from the entire document, the extraction result will contain parameter data of non-target sub-models, making it unusable. Therefore, step S20 can avoid using the same full document extraction method as the material individual file for the material series file, thereby improving the accuracy of parameter extraction and the accuracy of subsequent material description.

[0040] In a feasible implementation manner, step S20 may include: obtaining a default confidence level based on the material category; obtaining a chart character repeatability based on the chart in the specification file; when the specification file contains a preset keyword and the chart character repeatability is within a preset repeatability range, adjusting the default confidence level according to a preset step size; and determining the file type of the specification file according to the adjusted default confidence level.

[0041] It should be noted that the default confidence level is an initial credibility value preset according to the material category and used to represent that the specification file belongs to the material series file; the chart refers to the parameter data area presented in tabular form in the specification file; the chart character repeatability refers to the similarity degree of the character content between specific position cells in the chart; the preset repeatability range is a numerical interval of the character repeatability used to determine that the chart conforms to the characteristics of the material series file; the preset step size is a fixed value for adding or subtracting the default confidence level each time the determination condition is satisfied.

[0042] Exemplarily, set the initial value of the default confidence level according to the material category. When the material category is resistor, capacitor, inductor or magnetic bead, the default confidence level is set to a lower value, such as 0.5; read the specification file. If the specification information contains keywords such as "Series / Serie / 系列", the confidence level parameter is increased by 0.3. Then scan the table area in the specification file, extract the character content of the last three cells in the first column on the left of each table, and calculate the repeat degree between the characters of these three cells to obtain the chart character repeatability. When the specification file contains the preset keyword and the chart character repeatability is within the preset repeatability range (such as 50% - 100%), the default confidence level is increased by 0.35; compare the adjusted confidence level with a preset threshold (such as 0.65). If the adjusted confidence level reaches or exceeds the threshold, it is determined as a material series file, otherwise it is determined as a material monomer file.

[0043] In this implementation manner, by comprehensively detecting the preset keyword and calculating the chart character repeatability to dynamically adjust the confidence level and determine the file type, the problem of easy misjudgment caused by a single determination condition is solved, and the accurate identification of the material series file is achieved.

[0044] The above is only a feasible implementation manner of step S20 provided in this embodiment, and this embodiment does not specifically limit the specific implementation manner of step S20.

[0045] Step S30, determine a target area from the specification file according to the file type, and extract component parameters according to the material category and the target area; It should be noted that the target area refers to the data range in the specification document that actually carries the parameter information of the material to be archived. For a single material file, the target area is the entire specification document, while for a series of material files, the target area is a local area of ​​the table in the specification document associated with the user-specified sub-model. Component parameters refer to the technical indicators that describe the electrical and physical characteristics of electronic components, including resistance, accuracy, power, package, withstand voltage, capacitance, and temperature coefficient.

[0046] Specifically, the file type determines the strategy for determining the target area. When the file type is a material unit file, the entire text content of the entire specification file is used as the target area. When the file type is a material series file, the table area associated with the sub-model is selected from multiple tables in the specification file based on the sub-model entered by the user as the target area. After determining the target area, the corresponding parameter extraction rules are called according to the material category. The position of the parameter value is located from the text content of the target area through keyword matching and regular expressions, and the parameter name and its corresponding value and unit are extracted.

[0047] It is understandable that since a table in the material series file may contain parameter rows for multiple sub-models, if the target area is not finely located and the parameters are extracted directly from the entire table, the parameter values ​​of multiple sub-models will be extracted, resulting in the parameters not being able to correspond one-to-one with the materials. Therefore, step S30 can avoid the extracted parameters from being mixed with data of non-target sub-models, thereby improving the matching accuracy between parameters and materials.

[0048] Step S40: Based on the component parameters and the material category, generate and archive the target material description.

[0049] It should be noted that the target material description refers to a standardized string organized in a uniform format for uniquely identifying and retrieving electronic components. This string is composed of the material category name and multiple component parameter values ​​concatenated in a preset order.

[0050] It is understandable that different engineers may describe the same component differently. If the original extracted parameters are used directly for archiving, the material description format will be inconsistent, making subsequent retrieval and identification difficult. Therefore, step S40 can avoid material confusion and retrieval obstacles caused by differences in description format, thereby improving the standardization and identifiability of material description.

[0051] In one feasible implementation, step S40 may include: determining a material description template and a material part number based on the material category; filling the material description template according to the component parameters to obtain a target material description; obtaining a verification identifier based on the file hash value and original file name of the specification file; generating a normalized file name based on the current timestamp, the verification identifier, and the material part number; and archiving the target material description according to the normalized file name.

[0052] It should be noted that: a material description template refers to a predefined description format string containing parameter placeholders for a specific material category; a material part number refers to a unique identifier code assigned by the system to each electronic component material; a file hash value refers to a fixed-length string calculated from the content of the specification file using a hash algorithm, used to uniquely identify the file content; the original file name refers to the file name when the user uploads the specification file; the verification identifier refers to an identifier string obtained by combining the file hash value with the original file name, used for file integrity verification and deduplication; and a normalized file name refers to a file name that conforms to archiving specifications and is generated by combining elements such as the material part number, document type, timestamp, and verification identifier according to a preset format.

[0053] Specifically, the corresponding material description template is obtained from the configuration according to the material category, and a unique material part number is generated based on the material category code and the current maximum serial number; the component parameters extracted in step S34 are filled in according to the positions of the parameter placeholders in the material description template to obtain the target material description; the hash value of the specification file uploaded by the user is calculated, and the hash value is concatenated with the original file name to obtain a verification identifier; the current system time is converted into a timestamp string, and the material part number, verification identifier, and timestamp are combined in a preset order to generate a normalized file name; an archive directory named after the material part number is created, the specification file is saved in this directory with a normalized file name, and the target material description is written to the material database.

[0054] Further, the step of filling the material description template according to the component parameters to obtain the target material description includes: filling the material description template according to the component parameters to obtain an initial material description; parsing the parameter placeholders in the material description template and establishing a mapping relationship between the parameter placeholders and the component parameters; generating an audit interface based on the mapping relationship; and updating the initial material description according to the parameter modification operation in response to the user's parameter modification operation on the audit interface to obtain the target material description.

[0055] It should be noted that the initial material description refers to the material description string obtained by directly filling the material description template with component parameters, without user review and confirmation; parameter placeholders refer to the parameter names enclosed in curly braces in the material description template, such as "{resistance}" and "{precision}"; the mapping relationship refers to the data correspondence table that associates each parameter placeholder in the material description template with the corresponding component parameter value extracted in step S34; the review interface refers to the graphical interactive window used to display the extraction results to the user and receive user confirmation of modifications; the parameter modification operation refers to the user instruction to edit, supplement, or restore a parameter value on the review interface.

[0056] Specifically, the extracted component parameters are replaced according to the positions of parameter placeholders in the material description template to generate an initial material description; the material description template is parsed using regular expressions to extract all parameter placeholder strings enclosed in curly braces, resulting in a parameter placeholder list; this list is iterated through, and a key-value mapping relationship is established between each parameter placeholder and the corresponding parameter value in the parameter dictionary extracted in step S34, forming a mapping relationship; based on this mapping relationship, a process is generated as follows: Figure 3 The review interface shown creates a corresponding parameter editing control for each parameter placeholder and fills the parameter value in the mapping relationship into the corresponding editing control. After the user modifies or confirms the parameter value in the editing control, the system captures the parameter modification operation, obtains the modified parameter value, refills the material description template with the modified parameter value, and uses the updated string as the target material description.

[0057] In this embodiment, a mapping relationship between parameter placeholders and extracted parameters is established by parsing the material description template, and an audit interface is generated to receive user parameter modification operations. This solves the problem that AI-extracted parameters may contain errors or omissions and cannot be used directly. It realizes a material description generation mechanism that combines AI automatic extraction with manual review, which ensures both extraction efficiency and description accuracy.

[0058] The above are merely feasible implementations of step S40 provided in this embodiment. This embodiment does not specifically limit the specific implementation of step S40.

[0059] This embodiment provides a method for archiving electronic component materials. Based on the electronic component's specification document (SMD), a material category is obtained. Based on preset keywords and the material category, the file type of the SMD is determined, wherein the file type includes individual material files and material series files. A target area is determined from the SMD according to the file type, and component parameters are extracted based on the material category and the target area. Based on the component parameters and the material category, a target material description is generated and archived. This method solves the technical problem in existing technologies where the inability to automatically identify material series files leads to extracted parameters containing multiple sub-model information, preventing accurate matching with the target material. It achieves automatic identification and targeted parameter extraction of material series files, ensuring that the extracted component parameters accurately match the currently archived material, thus improving the accuracy of parameter extraction and the usability of archived data.

[0060] Based on the first embodiment of this application, in the second embodiment of this application, the content that is the same as or similar to that in the first embodiment described above can be referred to the above description, and will not be repeated hereafter. Based on this, please refer to... Figure 4 The electronic component material archiving method further includes steps S31 to S34 in step S30: Step S31: When the file type is the material series file, determine the target area from the specification file based on the sub-model input by the user; It should be noted that sub-model refers to the specific model identifier used in the material series document to distinguish different specifications within the same series, such as "10K" and "100K" in the resistor series or "104" and "105" in the capacitor series.

[0061] Specifically, a pop-up interactive interface prompts the user to input the sub-model corresponding to the material to be archived. The user inputs the specific sub-model string according to the model list in the specification file. After obtaining the sub-model, the system uses it as a filter to traverse each table in the specification file one by one, and locates the table containing the sub-model and its row. The row containing the sub-model and its corresponding parameter column area are determined as the target area, and the data in the target area uniquely corresponds to the sub-model specified by the user.

[0062] Understandably, since the material series file lists multiple sub-models and their corresponding parameter values, if there is no user-inputted sub-model as a filtering criterion, the system cannot determine which of the multiple candidate sub-models is the target material to be archived. Therefore, performing step S31 can prevent the system from failing to recognize the user's intent and extracting incorrect parameters, thereby improving the accuracy of target area positioning.

[0063] In one feasible implementation, step S31 may include: when the file type is the material series file, obtaining the sub-model input by the user; filtering the table in the specification file according to the sub-model to obtain a target sub-model table; extracting the model information of each row in the target sub-model table located in a preset column; comparing the model information with the sub-model to obtain the row confidence of each row; and taking the area in the target sub-model table where the row confidence is within the preset row confidence range as the target area.

[0064] It should be noted that the target sub-model table refers to the table in the specification document that contains the sub-model string entered by the user; the preset column refers to the column in the table used to store the sub-model name, usually the first column of the table; the model information refers to the string content stored in each cell of the preset column; the row confidence score refers to the similarity value obtained by comparing the model information of a certain row with the sub-model entered by the user; the preset row confidence score range refers to the similarity score range used to determine that the row belongs to the parameter row corresponding to the target sub-model, and this range can be set to greater than or equal to 10% and less than or equal to 99%.

[0065] Specifically, after obtaining the sub-model number input by the user, all tables in the specification file are traversed, and tables that do not contain the sub-model number string are deleted, while tables containing the sub-model number are retained as target sub-model tables. The model information of each row in the first column of the target sub-model table is extracted. The character similarity of the model information in each row with the sub-model number input by the user is calculated to obtain the row confidence of each row. Each row is traversed, and rows with a row confidence greater than 10% and less than 99% are deleted. These rows belong to other sub-models that are similar to the target sub-model but are not exactly matched. The regions corresponding to rows with a row confidence less than or equal to 10% and rows with a row confidence greater than or equal to 99% are retained as target regions, where rows with a row confidence greater than or equal to 99% are the target parameter rows for exact matching of the sub-model.

[0066] For example, the sub-model input by the user is set as a string variable, denoted as S_user, and the model information of a certain row in a preset column (such as the first column) in the target sub-model table is set as a string variable, denoted as S_row. The length of the longest common subsequence between the two strings can be calculated by the longest common subsequence algorithm, denoted as LCS(S_user, S_row).

[0067] Divide the length of the longest common subsequence by the length of the sub-model input by the user and the length of the current row model information, respectively, to obtain two ratios; take the maximum of the two ratios as the row confidence point, calculated as follows:

[0068] Where LCS(S_user, S_row) represents the length of the longest common subsequence of the two strings, Len(S_user) represents the character length of the user-input sub-model, and Len(S_row) represents the character length of the current line of model information.

[0069] In this embodiment, the parameter row that matches the user sub-model is accurately located from the table of the material series file by using row confidence calculation and filtering mechanism. This solves the problem of parameter extraction errors caused by interference from similar sub-models in the material series file and achieves accurate filtering of the target parameter row.

[0070] The above are merely feasible implementations of step S31 provided in this embodiment. This embodiment does not specifically limit the specific implementation of step S31.

[0071] Step S32: When the file type is the material unit file, the specification file is used as the target area; Specifically, when the file type is determined to be a material unit file, the specification file only describes the parameter information of a single electronic component, and there is no situation where parameters of multiple sub-models are mixed. The system takes all the text content and table content of the entire specification file as the target area, without the need for sub-model filtering or table deletion.

[0072] It is understandable that since all parameter information in the material unit file belongs to the same material and there is no interference from non-target data, performing regional filtering on the material unit file may accidentally delete valid parameter information. Therefore, performing step S32 can avoid unnecessary regional filtering operations, thereby improving the completeness of parameter extraction and processing efficiency.

[0073] Step S33: Determine parameter extraction rules based on the material category.

[0074] It should be noted that parameter extraction rules refer to a set of predefined matching rules for a specific material category, used to identify and extract parameter values ​​from text, including the mapping relationship between parameter names and regular expressions and keywords.

[0075] Specifically, the parameter types corresponding to different material categories are fundamentally different; based on the material category obtained in step S10, the system loads the parameter extraction rules associated with that material category from the configuration file; the parameter extraction rules for the resistor category include regular expressions corresponding to resistance values, keyword matching rules corresponding to accuracy, and unit identification rules corresponding to power; the parameter extraction rules for the capacitor category include unit identification rules corresponding to capacitance values, voltage unit matching rules corresponding to withstand voltage, and a keyword library corresponding to the material.

[0076] It is understandable that, since resistors require the extraction of resistance and power, while capacitors require the extraction of capacitance and withstand voltage, and the parameter types of different material categories are completely different, if a uniform parameter extraction rule is used for all material categories, it will be impossible to correctly extract the unique parameters of each category. Therefore, step S33 can avoid the problem of mismatch between parameter extraction rules and material categories, thereby improving the targeting and accuracy of parameter extraction.

[0077] Step S34: Extract component parameters from the target area according to the parameter extraction rules.

[0078] Specifically, the target area determined in step S31 or step S32 is used as input to obtain the parameter extraction rules determined in step S33; the text content in the target area is matched item by item according to the order defined in the parameter extraction rules; for each parameter, the regular expression or keyword in the parameter extraction rules is applied to the text in the target area to locate the successfully matched string; the matched string is used as the original value of the parameter; after all parameters are matched, the extracted parameter names and parameter values ​​are associated and stored to form a parameter dictionary.

[0079] It is understandable that since the target area may contain a large amount of descriptive text that is unrelated to the parameters, if a full-text search is performed directly without using a rule-based matching method, a large amount of invalid information will be extracted. Therefore, step S34 can avoid extracting redundant text of non-parameter type, thereby improving the accuracy and structure of parameter extraction.

[0080] This embodiment provides a method for archiving electronic component materials. When the file type is a material series file, a target area is determined from the specification file based on the sub-model number input by the user. When the file type is a material unit file, the specification file is used as the target area. Parameter extraction rules are determined based on the material category. Component parameters are extracted from the target area according to the parameter extraction rules. By employing techniques that dynamically load parameter extraction rules based on the material category and use differentiated target area determination strategies based on the file type, the problem of extraction errors caused by mixed sub-model parameters in the material series file is avoided. This solves the technical problem that existing technologies cannot automatically adapt to different file types for accurate parameter extraction, thereby achieving unified adaptation and accurate parameter extraction for both material unit files and material series files.

[0081] It should be noted that the above examples are only for understanding this application and do not constitute a limitation on the electronic component material archiving method of this application. Any simple modifications based on this technical concept are within the protection scope of this application.

[0082] This application also provides an electronic component material archiving device; please refer to... Figure 5The electronic component material archiving device includes: Input module 10 is used to obtain the material category based on the specification document of electronic components; File module 20 is used to determine the file type of the specification file based on preset keywords and the material category, wherein the file type includes material individual file and material series file; Extraction module 30 is used to determine a target area from the specification file according to the file type, and extract component parameters according to the target area; Output module 40 is used to generate and archive target material descriptions based on the component parameters and the material category.

[0083] The electronic component material archiving device provided in this application, employing the electronic component material archiving method in the above embodiments, can solve the technical problem of how to improve the accuracy of information extraction from electronic component materials. Compared with the prior art, the beneficial effects of the electronic component material archiving device provided in this application are the same as those of the electronic component material archiving method provided in the above embodiments, and other technical features in the electronic component material archiving device are the same as those disclosed in the methods of the above embodiments, and will not be repeated here.

[0084] The input module 10 is also used to detect whether the user has entered a material category; when no user input of a material category is detected, category keywords are extracted based on the specification document of the electronic components; and the material category is obtained based on the matching result of the preset category library and the category keywords.

[0085] The file module 20 is further configured to: obtain a default confidence level based on the material category; obtain the character repetition of the charts in the specification file; adjust the default confidence level according to a preset step size when the specification file contains preset keywords and the character repetition of the charts is within a preset repetition range; and determine the file type of the specification file based on the adjusted default confidence level.

[0086] The extraction module 30 is further configured to: determine a target area from the specification file based on the sub-model input by the user when the file type is the material series file; use the specification file as the target area when the file type is the material unit file; determine parameter extraction rules based on the material category; and extract component parameters from the target area according to the parameter extraction rules.

[0087] The extraction module 30 is further configured to: obtain the sub-model input by the user when the file type is the material series file; filter the table in the specification file according to the sub-model to obtain a target sub-model table; extract the model information of each row in the target sub-model table located in a preset column; compare the model information with the sub-model to obtain the row confidence of each row; and take the area in the target sub-model table where the row confidence is within the preset row confidence range as the target area.

[0088] The output module 40 is further configured to: determine a material description template and a material part number based on the material category; fill the material description template according to the component parameters to obtain a target material description; obtain a verification identifier based on the file hash value and original file name of the specification file; generate a normalized file name based on the current timestamp, the verification identifier, and the material part number; and archive the target material description according to the normalized file name.

[0089] The output module 40 is further configured to fill the material description template according to the component parameters to obtain an initial material description; parse the parameter placeholders in the material description template to establish a mapping relationship between the parameter placeholders and the component parameters; generate an audit interface based on the mapping relationship; and update the initial material description according to the parameter modification operation of the user on the audit interface to obtain a target material description.

[0090] This application provides an electronic component material archiving device, which includes: at least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores instructions executable by the at least one processor, which are executed by the at least one processor to enable the at least one processor to perform the electronic component material archiving method in Embodiment 1 above.

[0091] The following is for reference. Figure 6 The diagram illustrates a structural schematic suitable for implementing the electronic component material archiving device of the embodiments of this application. The electronic component material archiving device in the embodiments of this application may include, but is not limited to, mobile terminals such as mobile phones, laptops, digital broadcast receivers, PDAs (Personal Digital Assistants), PADs (Portable Application Description), PMPs (Portable Media Players), in-vehicle terminals (e.g., in-vehicle navigation terminals), and fixed terminals such as digital TVs and desktop computers. Figure 6The electronic component material archiving device shown is merely an example and should not impose any limitation on the functionality and scope of use of the embodiments of this application.

[0092] like Figure 6 As shown, the electronic component material archiving device may include a processing unit 1001 (e.g., a central processing unit, a graphics processing unit, etc.) that can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 1002 or a program loaded from a storage device 1003 into a random access memory (RAM) 1004. The RAM 1004 also stores various programs and data required for the operation of the electronic component material archiving device. The processing unit 1001, ROM 1002, and RAM 1004 are interconnected via a bus 1005. An input / output (I / O) interface 1006 is also connected to the bus. Typically, the following systems can be connected to the I / O interface 1006: input devices 1007 including, for example, touchscreens, touchpads, keyboards, mice, image sensors, microphones, accelerometers, gyroscopes, etc.; output devices 1008 including, for example, liquid crystal displays (LCDs), speakers, vibrators, etc.; storage devices 1003 including, for example, magnetic tapes, hard disks, etc.; and communication devices 1009. Communication device 1009 allows the electronic component material archiving equipment to communicate wirelessly or wiredly with other devices to exchange data. Although the figure shows electronic component material archiving equipment with various systems, it should be understood that implementation or possession of all the systems shown is not required. More or fewer systems may be implemented alternatively.

[0093] Specifically, according to the embodiments disclosed in this application, the processes described above with reference to the flowcharts can be implemented as computer software programs. For example, embodiments disclosed in this application include a computer program product comprising a computer program carried on a computer-readable medium, the computer program containing program code for performing the methods shown in the flowcharts. In such embodiments, the computer program can be downloaded and installed from a network via a communication device, or installed from storage device 1003, or installed from ROM 1002. When the computer program is executed by processing device 1001, it performs the functions defined in the methods of the embodiments disclosed in this application.

[0094] The electronic component material archiving device provided in this application, employing the electronic component material archiving method in the above embodiments, can solve the technical problem of how to improve the accuracy of information extraction from electronic component materials. Compared with the prior art, the beneficial effects of the electronic component material archiving device provided in this application are the same as those of the electronic component material archiving method provided in the above embodiments, and other technical features in this electronic component material archiving device are the same as those disclosed in the previous embodiment method, and will not be repeated here.

[0095] It should be understood that the various parts disclosed in this application can be implemented using hardware, software, firmware, or a combination thereof. In the description of the above embodiments, specific features, structures, materials, or characteristics can be combined in any suitable manner in one or more embodiments or examples.

[0096] The above description is merely a specific embodiment of this application, but the scope of protection of this application is not limited thereto. Any variations or substitutions that can be easily conceived by those skilled in the art within the scope of the technology disclosed in this application should be included within the scope of protection of this application. Therefore, the scope of protection of this application should be determined by the scope of the claims.

[0097] This application provides a computer-readable storage medium having computer-readable program instructions (i.e., a computer program) stored thereon, the computer-readable program instructions being used to execute the electronic component material archiving method in the above embodiments.

[0098] The computer-readable storage medium provided in this application may be, for example, a USB flash drive, but is not limited to, electrical, magnetic, optical, electromagnetic, infrared, or semiconductor systems, devices, or any combination thereof. More specific examples of computer-readable storage media may include, but are not limited to: electrical connections having one or more wires, portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination thereof. In this embodiment, the computer-readable storage medium may be any tangible medium containing or storing a program that can be used by or in conjunction with an instruction execution system, system, or device. The program code contained on the computer-readable storage medium may be transmitted using any suitable medium, including but not limited to: wires, optical cables, RF (Radio Frequency), etc., or any suitable combination thereof.

[0099] The aforementioned computer-readable storage medium may be included in the electronic component material archiving equipment; or it may exist independently and not be assembled into the electronic component material archiving equipment.

[0100] The aforementioned computer-readable storage medium carries one or more programs. When these programs are executed by the electronic component material archiving device, the electronic component material archiving device: obtains a material category based on the electronic component's specification document; determines the file type of the specification document based on preset keywords and the material category, wherein the file type includes individual material files and material series files; determines a target area from the specification document according to the file type, and extracts component parameters according to the material category and the target area; and generates and archives a target material description based on the component parameters and the material category.

[0101] Computer program code for performing the operations of this application can be written in one or more programming languages ​​or a combination thereof, including object-oriented programming languages ​​such as Java, Smalltalk, and C++, and conventional procedural programming languages ​​such as the "C" language or similar programming languages. The program code can be executed entirely on the user's computer, partially on the user's computer, as a standalone software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving remote computers, the remote computer can be connected to the user's computer via any type of network—including a Local Area Network (LAN) or a Wide Area Network (WAN)—or can be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0102] The flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operation of possible implementations of systems, methods, and computer program products according to various embodiments of this application. In this regard, each block in a flowchart or block diagram may represent a module, segment, or portion of code containing one or more executable instructions for implementing a specified logical function. It should also be noted that in some alternative implementations, the functions indicated in the blocks may occur in a different order than those indicated in the drawings. For example, two consecutively indicated blocks may actually be executed substantially in parallel, and they may sometimes be executed in reverse order, depending on the functions involved. It should also be noted that each block in the block diagrams and / or flowcharts, and combinations of blocks in the block diagrams and / or flowcharts, can be implemented using a dedicated hardware-based system that performs the specified function or operation, or using a combination of dedicated hardware and computer instructions.

[0103] The modules described in the embodiments of this application can be implemented in software or hardware. The names of the modules do not necessarily limit the functionality of the unit itself.

[0104] The readable storage medium provided in this application is a computer-readable storage medium that stores computer-readable program instructions (i.e., a computer program) for executing the above-described electronic component material archiving method, thereby solving the technical problem of how to improve the accuracy of information extraction from electronic component materials. Compared with the prior art, the beneficial effects of the computer-readable storage medium provided in this application are the same as those of the electronic component material archiving method provided in the above embodiments, and will not be repeated here.

[0105] This application also provides a computer program product, including a computer program that, when executed by a processor, implements the steps of the electronic component material archiving method described above.

[0106] The computer program product provided in this application can solve the technical problem of how to improve the accuracy of information extraction from electronic component materials. Compared with the prior art, the beneficial effects of the computer program product provided in this application are the same as those of the electronic component material archiving method provided in the above embodiments, and will not be repeated here.

[0107] The above description is only a part of the embodiments of this application and does not limit the patent scope of this application. All equivalent structural transformations made under the technical concept of this application and using the contents of the specification and drawings of this application, or direct / indirect applications in other related technical fields, are included in the patent protection scope of this application.

Claims

1. A method for archiving electronic component materials, characterized in that, The method includes: Based on the datasheets of electronic components, the material categories are obtained; Based on preset keywords and the material category, the file type of the specification document is determined, wherein the file type includes individual material files and material series files; The target area is determined from the specification document according to the file type, and the component parameters are extracted according to the material category and the target area; Based on the component parameters and the material category, generate and archive the target material description; The step of determining the target region from the specification file according to the file type, and extracting component parameters according to the material category and the target region, includes: When the file type is the material series file, the target area is determined from the specification file based on the sub-model input by the user; When the file type is the material unit file, the specification file is used as the target area; Based on the material category, determine the parameter extraction rules; Component parameters are extracted from the target region according to the parameter extraction rules; When the file type is the material series file, determining the target area from the specification file based on the sub-model input by the user includes: When the file type is the material series file, obtain the sub-model input by the user; The target sub-model table is obtained by filtering the tables in the specification document according to the sub-model. Extract the model information of each row in the preset column from the target sub-model table; The model information is compared with the sub-model information to obtain the row confidence score for each row; The region in the target sub-model table whose row confidence level falls within a preset row confidence level range is taken as the target region.

2. The method as described in claim 1, characterized in that, The datasheet document based on electronic components yields material categories, including: Detect whether the user has entered a material category; When no user-inputted material category is detected, category keywords are extracted based on the specification documents of electronic components; The material category is obtained based on the matching results between the preset category library and the category keywords.

3. The method as described in claim 1, characterized in that, The process of determining the file type of the specification document based on preset keywords and the material category includes: Based on the material category, a default confidence level is obtained; Based on the charts in the specification document, the character repetition rate of the charts is obtained; When the specification document contains preset keywords and the repetition of the chart characters is within a preset repetition range, the default confidence level is adjusted according to a preset step size; The file type of the specification document is determined based on the adjusted default confidence level.

4. The method as described in claim 1, characterized in that, The process of generating and archiving a target material description based on the component parameters and the material category includes: Based on the material category, determine the material description template and material part number; The material description template is filled with the component parameters to obtain the target material description; The verification identifier is obtained based on the file hash value and original file name of the specification file; Generate a standardized filename based on the current timestamp, the verification identifier, and the material part number; The description of the target material is archived according to the standardized file name.

5. The method as described in claim 4, characterized in that, The step of filling the material description template according to the component parameters to obtain the target material description includes: The initial material description is obtained by filling the material description template with the component parameters. Parse the parameter placeholders in the material description template and establish a mapping relationship between the parameter placeholders and the component parameters; Based on the mapping relationship, an audit interface is generated; In response to the user's parameter modification operation on the review interface, the initial material description is updated according to the parameter modification operation to obtain the target material description.

6. An electronic component material archiving device, characterized in that, The device includes: The input module is used to obtain the material category based on the specification document of electronic components; The file module is used to determine the file type of the specification file based on preset keywords and the material category, wherein the file type includes individual material files and material series files; The extraction module is used to determine the target area from the specification file according to the file type, and extract component parameters according to the target area; The output module is used to generate and archive the target material description based on the component parameters and the material category; The extraction module is further configured to: determine the target area from the specification file based on the sub-model input by the user when the file type is the material series file; use the specification file as the target area when the file type is the material unit file; determine parameter extraction rules based on the material category; and extract component parameters from the target area according to the parameter extraction rules. The extraction module is further configured to: obtain the sub-model input by the user when the file type is the material series file; filter the table in the specification file according to the sub-model to obtain a target sub-model table; extract the model information of each row in the target sub-model table located in a preset column; compare the model information with the sub-model to obtain the row confidence of each row; and take the area in the target sub-model table where the row confidence is within the preset row confidence range as the target area.

7. An electronic component material archiving device, characterized in that, The device includes: a memory, a processor, and a computer program stored in the memory and executable on the processor, the computer program being configured to implement the steps of the electronic component material archiving method as described in any one of claims 1 to 5.

8. A storage medium, characterized in that, The storage medium is a computer-readable storage medium, and a computer program is stored on the storage medium. When the computer program is executed by a processor, it implements the steps of the electronic component material archiving method as described in any one of claims 1 to 5.

Images