CN114881545B - Automatic material matching method and device based on cooperative interconnection - Google Patents
Automatic material matching method and device based on cooperative interconnection Download PDFInfo
- Publication number
- CN114881545B CN114881545B CN202210796086.8A CN202210796086A CN114881545B CN 114881545 B CN114881545 B CN 114881545B CN 202210796086 A CN202210796086 A CN 202210796086A CN 114881545 B CN114881545 B CN 114881545B
- Authority
- CN
- China
- Prior art keywords
- data information
- material data
- matching
- preset
- equipment
- 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
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06315—Needs-based resource requirements planning or analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Abstract
The invention discloses a cooperative interconnection-based automatic material matching method and device, wherein the method comprises the following steps of 1, acquiring a plan declaration form, wherein the plan declaration form comprises required material data information of material equipment; step 2, matching the demand characteristic information with preset characteristic information of preset material data information; step 3, if the unique corresponding relation does not exist between the required characteristic information of the material equipment of a certain plan declaration form and the preset characteristic information, skipping to step 4, if the unique corresponding relation exists, comparing the required material data information of the material equipment of which the corresponding relation is in the plan declaration form with the preset material data information of the material equipment in the material equipment book one by one, if the comparison result is consistent, the material is automatically matched successfully, and if the comparison result is inconsistent, the material is automatically matched unsuccessfully, and skipping to step 4; and 4, analyzing the data information of the required materials. The scheme improves the matching efficiency between the plan declaration form and the material equipment volume.
Description
Technical Field
The invention relates to the technical field of intelligent management of materials, in particular to a material automatic matching method and device based on cooperative interconnection.
Background
More and more enterprises currently use ERP (Enterprise Resource Planning) systems to manage materials. In electric power engineering, the project material declaration list and the project material equipment inventory are required to be matched at all time intervals, the control on materials is achieved, in the prior art, the matching between the project material declaration list and the project material equipment inventory is often required to be completed through manual comparison, the matching efficiency is low, mistakes are easy to make, good measures are not taken for error correction after the matching is made mistakes, and the cost of the electric power engineering is increased, and the efficiency is reduced.
The invention discloses a method for automatically matching materials in material instant stock, which is disclosed in an invention patent of Chinese patent publication No. CN105160510A, which is published on 2015, 12 and 16, and is named as a method and a device for automatically matching materials in material instant stock, and the method comprises the following steps: acquiring target material information; acquiring the weight of the target material according to the target material information; searching materials with the same weight as the target material in a material instant stock database; matching the target materials in the searched materials with the same weight as the target materials; and updating the quantity of the matched materials in the instant material inventory database. By adopting the method for automatically matching the materials in the material instant inventory database, all material information does not need to be matched in the material database, but the matching is directly carried out through the weight, but the method is not suitable for matching the electric power engineering material declaration list and the engineering material equipment inventory, the precise one-to-one correspondence is required in the matching of the material declaration list and the engineering material equipment inventory, and the method is also not suitable for judging the weight in the matching process.
Chinese patent publication No. CN112200640A, published on 2021, 1, 8, entitled "an automatic matching method and system for supply of materials under intelligent contract based on Block chain", discloses an automatic matching method for supply of materials under intelligent contract based on Block chain, which comprises the following steps of S100, registering supply and demand information of materials on the basis of Block chain technology, wherein the supply and demand information of materials comprises supply data and demand data; s200, acquiring demand data and supply data into two sequence queues respectively to obtain a demand queue and a supply queue respectively; s300, matching the information in the demand queue and the supply queue to generate a material allocation and transfer sheet, and realizing material supply according to the material allocation and transfer sheet. The method has the disadvantages that the matching method needs to use a block chain technology, the realization process is complex, and the method is not suitable for matching between the project material declaration list and the project material equipment inventory in the electric power project.
Disclosure of Invention
The invention aims to overcome the defects that in the prior art, matching between an engineering material declaration list and an engineering material equipment inventory is often completed by manual comparison, matching efficiency is low and mistakes are easy to make, and no good measure is taken to correct errors after matching mistakes, so that electric power engineering cost is increased and efficiency is reduced, and provides a material automatic matching method and device based on cooperative interconnection.
The purpose of the invention is realized by the following technical scheme:
the automatic material matching method based on cooperative interconnection comprises the following steps:
step 1, acquiring a plan reporting form, wherein the plan reporting form comprises required material data information of material equipment;
step 2, matching demand characteristic information in the demand material data information with preset characteristic information of preset material data information of material equipment in a material equipment volume;
step 3, determining whether the demand characteristic information in the demand material data information has a unique corresponding relationship with the preset characteristic information of the preset material data information of the material equipment in the material equipment book, if the demand characteristic information of the material equipment of a certain plan declaration form does not have the unique corresponding relationship with the preset characteristic information, skipping to step 4, if the unique corresponding relationship exists, comparing the demand material data information of the material equipment of which the corresponding relationship is in the plan declaration form with the preset material data information of the material equipment in the material equipment book one by one, if the comparison result is consistent, the material is automatically matched successfully, and if the comparison result is inconsistent, the material is automatically matched unsuccessfully, skipping to step 4;
step 4, analyzing the required material data information, determining preset material data information with the maximum matching probability with the required material data information, and matching the required material data information with the preset material data information with the maximum matching probability if the matching probability is greater than or equal to a preset threshold value to complete automatic matching of the material equipment; and if the matching probability is smaller than a preset threshold value, the automatic matching fails, and related personnel are reminded to take measures in time.
In the scheme, the material equipment volume is compiled according to the whole requirement of the project, preset material data of the material equipment volume are uploaded to the material automatic matching device based on cooperative interconnection for storage and recording, the plan report form is a multi-batch demand plan report form, unique materials are found by comparing demand characteristic information of demand material data information with preset characteristic information of preset material data information, and key information such as the model, the quantity, the technical requirement and the arrival time of the two materials are compared, so that the smooth proceeding of the project is ensured. Meanwhile, in the scheme, the best matching scheme can be determined according to the matching probability for the wrong required material data information possibly appearing in the plan declaration form, and the matching efficiency between the plan declaration form and the material equipment volume is improved.
The step 4 is specifically as follows:
the substep 1, extracting all independent fields of the data information of the required materials, and randomly removing one independent field;
substep 2, determining whether the remaining independent fields have corresponding relations with independent fields in the preset material data information, and if at least one corresponding relation exists, recording the preset material data information corresponding to the corresponding relations;
substep 3, removing an independent field which is not removed before, repeating substep 2, and ensuring that all independent fields of the required material data information are removed once;
substep 4, counting the recorded types and times of the preset material data information, calculating the occurrence probability of each preset material data information, and if the occurrence probability of one preset material data information is greater than a preset threshold value, judging that the required material data information is successfully matched with the preset material data information, and finishing the automatic matching of the material equipment; if the probability that none of the preset material data information appears is larger than the preset threshold value, automatic matching fails, and related personnel are reminded to take measures in time.
The design of the scheme considers the possibility that the data information of the required materials and the data information of the preset materials are not successfully matched, and after an independent field is randomly removed, if at least one corresponding relation exists, the preset materials and the data information of the corresponding relation are possibly the correct matched object. Through the repetition of the substep 1 and the substep 2, each independent field is eliminated, all possibilities are considered as far as possible, and finally, the preset material data information which appears most times is judged to be the preset material data information which is successfully matched. The scheme ensures that the required material data information can still be correctly matched with the preset material data information under the condition that one or a small number of independent field data are wrong. However, when the independent fields are wrong, the error is large, the probability that any one preset material data information appears is not larger than the set threshold, and the matching is judged to be failed at the moment.
Preferably, the substep 1 is replaced by: all independent fields of the required material data information are extracted, a plurality of independent fields are randomly removed, and the number of the removed independent fields is not more than one fourth of the number of all the independent fields.
Preferably, if the automatic matching fails in substep 4, a history-based data matching step is further performed, specifically:
s1, constructing a historical database, wherein the historical database comprises historical required material data information, historical preset material data information and a record of successful matching;
s2, extracting all independent fields of the required material data information, and calculating the probability P (N) of each independent field appearing in the historical required material data information, wherein N =1,2,3 … … N;
s3, randomly selecting historical preset material data information, acquiring equipment names of the historical preset material data information, and calculating the probability P (B) of the equipment names appearing in all the equipment names;
s4, calculating the probability that each independent field of the required material data information appears in the historical preset material data information corresponding to the equipment name, namely P (N | B);
s5, calculating the matching probability of the required material data and the historical preset material data information
P= (P(1|B)* P(2|B)*……* P(N|B))*P(B)/(P(1)*P(2)*……*P(N))；
S6, repeating the steps S3-S5 until the matching probability of the required material data information and each historical preset material data information is calculated;
s7, if one matching probability is larger than the sum of the other matching probabilities, judging that the required material data is successfully matched with the historical preset material data information corresponding to the matching probability;
s8, searching preset material data information which contains the preset material data information corresponding to the equipment name and is contained in the preset material data information, comparing each field of the required material data information with the field containing the preset material data information corresponding to the equipment name one by one, and obtaining the preset material data information with the highest matching degree, namely the preset material data information matched with the required material data information, so that the automatic matching of materials is successful.
In the scheme, the historical database is used for helping the existing required material data information to be matched with the preset material data information. Considering that the equipment name has uniqueness, the possibility of matching the demand material data information is judged by the equipment name. The times of occurrence of all fields of a piece of required material data information in the historical database are counted, so that P (1) × P (2) × … … × P (N) represents the probability of occurrence of the required material data information in the historical database, and P (1| B) × P (2| B) × … … × P (N | B) represents the product of the probabilities of occurrence of each individual field in the case of occurrence of randomly selected historical preset material data information, and therefore, the matching probability P can be regarded as the probability of matching the required material data information with the historical preset material data information. When one matching probability P is far greater than other matching probabilities P, the two matching probabilities can be considered to be matched, and then automatic matching can be carried out on materials. The design of the scheme further improves the matching probability.
Preferably, in S8, the matching degree is determined by the number of times that each field of the required material data information matches the field of the preset material data information, and the higher the number of times, the higher the matching degree.
Preferably, the field of the preset material data information includes a technical specification ID, and in S8, it is further determined whether the technical specification ID of the required material data information corresponds to the technical specification ID of the preset material data information, if so, the material is automatically matched successfully, otherwise, the material is automatically matched unsuccessfully. Technical specifications are required to be strictly corresponding, otherwise, material model errors occur to affect engineering safety, and therefore technical specification IDs must be strictly corresponding.
The automatic matching device of materials based on cooperative interconnection comprises
The acquisition module is used for acquiring the information of the plan declaration form and transmitting the required material data information of the material equipment to the matching module;
the matching module is used for automatically matching the required material data information with preset material data information;
the analysis module is used for analyzing the required material data information which fails to be automatically matched, so that the required material data which fails to be automatically matched continuously complete the automatic matching process, and the success rate of automatic matching is ensured;
and the display module is used for displaying the automatic matching result.
Preferably, the automatic material matching device based on cooperative interconnection further comprises a storage module, wherein the storage module stores a historical database, and the historical database comprises historical required material data information, historical preset material data information and a matching success record; the analysis module is connected with the storage module, calls a historical database, and further matches the required material data according to the historical database.
The beneficial effects of the invention are: the cooperative interconnection-based automatic material matching method and device match the required material data information and the preset material data information, so that the plan declaration form corresponds to the materials of the material equipment volume, and the smooth proceeding of the project is ensured. Meanwhile, in the scheme, the best matching scheme can be determined according to the matching probability for the wrong required material data information possibly appearing in the plan declaration form, and the matching efficiency between the plan declaration form and the material equipment volume is improved.
Drawings
FIG. 1 is a schematic flow diagram of the present invention;
FIG. 2 is a schematic flow chart of the present invention for analyzing the demand material data;
FIG. 3 is a flow chart illustrating the process of analyzing the demand material data based on historical data according to the present invention.
Detailed Description
The invention is further described below with reference to the figures and examples.
The embodiment is as follows: as shown in fig. 1, the automatic matching method for materials based on cooperative interconnection includes the following steps:
step 1, acquiring a plan reporting form, wherein the plan reporting form comprises required material data information of material equipment;
step 2, matching demand characteristic information in the demand material data information with preset characteristic information of preset material data information of material equipment of a material equipment book;
step 3, determining whether the demand characteristic information in the demand material data information has a unique corresponding relationship with the preset characteristic information of the preset material data information of the material equipment in the material equipment book, if the demand characteristic information of the material equipment of a certain plan declaration form does not have the unique corresponding relationship with the preset characteristic information, skipping to step 4, if the unique corresponding relationship exists, comparing the demand material data information of the material equipment of which the corresponding relationship is in the plan declaration form with the preset material data information of the material equipment in the material equipment book one by one, if the comparison result is consistent, the material is automatically matched successfully, and if the comparison result is inconsistent, the material is automatically matched unsuccessfully, skipping to step 4;
step 4, analyzing the required material data information, determining preset material data information with the maximum matching probability with the required material data information, and matching the required material data information with the preset material data information with the maximum matching probability if the matching probability is greater than or equal to a preset threshold value to complete automatic matching of the material equipment; and if the matching probability is smaller than a preset threshold value, the automatic matching fails, and related personnel are reminded to take measures in time.
In the scheme, the plan reporting table comprises independent field information such as demand time, material names, material codes, line project numbers, material descriptions and technical specification IDs, and the preset material data information comprises independent field information such as plan time, material names, material codes, line project numbers, material descriptions, technical specification IDs, plan completion conditions and abnormal information. The requirement characteristic information and the preset characteristic information are three independent fields of material name, line item number and technical specification ID. The material equipment volume is compiled according to the whole requirement of the project, preset material data of the material equipment volume is uploaded to a material automatic matching device based on cooperative interconnection for storage and recording, the plan statement is a multi-batch demand plan statement, unique materials are found by comparing demand characteristic information of demand material data information with preset characteristic information of the preset material data information, and key information such as material codes, quantity, technical requirements, arrival time and the like of the two materials are compared, so that the smooth proceeding of the project is ensured. Meanwhile, in the scheme, the best matching scheme can be determined according to the matching probability for the wrong required material data information possibly appearing in the plan declaration form, and the matching efficiency between the plan declaration form and the material equipment volume is improved.
As shown in fig. 2, the step 4 specifically includes:
the substep 1, extracting all independent fields of the data information of the required materials, and randomly removing one independent field;
substep 2, determining whether the remaining independent fields have corresponding relations with independent fields in the preset material data information, and if at least one corresponding relation exists, recording the preset material data information corresponding to the corresponding relations;
substep 3, removing an independent field which is not removed before, repeating substep 2, and ensuring that all independent fields of the required material data information are removed once;
substep 4, counting the recorded types and times of the preset material data information, calculating the occurrence probability of each preset material data information, and if the occurrence probability of one preset material data information is greater than a preset threshold value, judging that the required material data information is successfully matched with the preset material data information, and finishing the automatic matching of the material equipment; if the probability that none of the preset material data information appears is larger than the preset threshold value, automatic matching fails, and related personnel are reminded to take measures in time.
The design of the scheme considers the possibility that the data information of the required materials and the data information of the preset materials are not successfully matched, and after an independent field is randomly removed, if at least one corresponding relation exists, the preset materials and the data information of the corresponding relation are possibly the correct matched object. Through the repetition of the substep 1 and the substep 2, each independent field is eliminated, all possibilities are considered as far as possible, and finally, the preset material data information which appears most times is judged to be the preset material data information which is successfully matched. The scheme ensures that the required material data information can still be correctly matched with the preset material data information under the condition that one or a small number of independent field data are wrong. However, when the independent fields are wrong, the error is large, the probability that any one preset material data information appears is not larger than the set threshold, and the matching is judged to be failed at the moment.
If the automatic matching fails in substep 4, a history data-based matching step is further performed, as shown in fig. 3, specifically:
s1, constructing a historical database, wherein the historical database comprises historical required material data information, historical preset material data information and a record of successful matching;
s2, extracting all independent fields of the required material data information, and calculating the probability P (N) of each independent field appearing in the historical required material data information, wherein N =1,2,3 … … N;
s3, randomly selecting historical preset material data information, obtaining the equipment name of the historical preset material data information, and calculating the probability P (B) of the equipment name appearing in all the equipment names;
s4, calculating the probability that each independent field of the required material data information appears in the historical preset material data information corresponding to the equipment name, namely P (N | B);
s5, calculating the matching probability of the required material data and the historical preset material data information
P= (P(1|B)* P(2|B)*……* P(N|B))*P(B)/(P(1)*P(2)*……*P(N))；
S6, repeating the steps S3-S5 until the matching probability of the required material data information and each historical preset material data information is calculated;
s7, if one matching probability is larger than the sum of the other matching probabilities, judging that the required material data is successfully matched with the historical preset material data information corresponding to the matching probability;
s8, searching preset material data information which contains the preset material data information corresponding to the equipment name and is contained in the preset material data information, comparing each field of the required material data information with the field containing the preset material data information corresponding to the equipment name one by one, and obtaining the preset material data information with the highest matching degree, namely the preset material data information matched with the required material data information, so that the automatic matching of materials is successful.
And matching the existing required material data information with preset material data information by means of a historical database. Considering that the equipment name has uniqueness, the possibility of matching the demand material data information is judged by the equipment name. The times of occurrence of all fields of a piece of required material data information in the historical database are counted, so that P (1) × P (2) × … … × P (N) represents the probability of occurrence of the required material data information in the historical database, and P (1| B) × P (2| B) × … … × P (N | B) represents the product of the probabilities of occurrence of each individual field in the case of occurrence of randomly selected historical preset material data information, and therefore, the matching probability P can be regarded as the probability of matching the required material data information with the historical preset material data information. When one matching probability P is far greater than other matching probabilities P, the two matching probabilities can be considered to be matched, and further automatic matching can be carried out on materials. The design of the scheme further improves the matching probability.
In S8, the matching degree is determined by the number of times that each field of the required material data information matches the field of the preset material data information, and the higher the number of times, the higher the matching degree.
In S8, it is further determined whether the technical specification ID of the required material data information corresponds to the technical specification ID of the preset material data information, if so, the material is automatically matched successfully, otherwise, the material is automatically matched unsuccessfully. Technical specifications often need to be strictly corresponding, otherwise, material model errors can occur to influence engineering safety, so that technical specification IDs need to be strictly corresponding.
The automatic matching device of materials based on cooperative interconnection comprises
The acquisition module is used for acquiring the information of the plan declaration form and transmitting the required material data information of the material equipment to the matching module;
the matching module is used for automatically matching the required material data information with preset material data information;
the analysis module is used for analyzing the required material data information which fails to be automatically matched, so that the required material data which fails to be automatically matched continuously complete the automatic matching process, and the success rate of automatic matching is ensured;
and the display module is used for displaying the automatic matching result.
The automatic material matching device based on cooperative interconnection further comprises a storage module, wherein the storage module stores a historical database, and the historical database comprises historical demand material data information, historical preset material data information and a matching success record; the analysis module is connected with the storage module and calls a historical database, and further matching is carried out on the required material data according to the historical database.
Example 2: the principle and the implementation method of the cooperative interconnection-based automatic material matching method are basically the same as those of the embodiment 1, and the difference is that the substep 1 is replaced by: all independent fields of the required material data information are extracted, a plurality of independent fields are randomly removed, and the number of the removed independent fields is not more than one fourth of the number of all the independent fields. Such a design is applicable to plan declaration and material equipment books different from those of embodiment 1, and the matching success probability is higher but the matching accuracy may be lowered as compared with embodiment 1.
Through the description of the foregoing embodiments, those skilled in the art will understand that, for convenience and simplicity of description, only the division of the functional modules is used for illustration, and in practical applications, the above function distribution may be completed by different functional modules according to needs, that is, the internal structure of the specific calculation is divided into different functional modules, so as to complete all or part of the functions described above.
In the embodiments provided in this application, it should be understood that the described structures and methods may be implemented in other ways. For example, the above-described embodiments with respect to structures are merely illustrative, and for example, a module or a unit may be divided into only one logic function, and may have another division manner in actual implementation, for example, a plurality of units or components may be combined or may be integrated into another structure, or some features may be omitted or not executed.
Units described as separate parts may or may not be physically separate, and parts displayed as units may be one physical unit or a plurality of physical units, may be located in one place, or may be distributed to a plurality of different places. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a readable storage medium. Based on such understanding, the technical solutions of the embodiments of the present application may be essentially or partially contributed to by the prior art, or all or part of the technical solutions may be embodied in the form of a software product, where the software product is stored in a storage medium and includes several instructions to enable a device (which may be a single chip, a chip, or the like) or a processor (processor) to execute all or part of the steps of the methods of the embodiments of the present application. And the aforementioned storage medium includes: 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 above-described embodiment is a preferred embodiment of the present invention, and is not intended to limit the present invention in any way, and other variations and modifications may be made without departing from the spirit and scope of the invention as defined in the appended claims.
Claims (7)
1. The automatic material matching method based on cooperative interconnection is characterized by comprising the following steps of:
step 1, acquiring a plan reporting form, wherein the plan reporting form comprises required material data information of material equipment;
step 2, matching demand characteristic information in the demand material data information with preset characteristic information of preset material data information of material equipment in a material equipment book;
step 3, determining whether the demand characteristic information in the demand material data information has a unique corresponding relation with the preset characteristic information of the preset material data information of the material equipment in the material equipment book,
if the unique corresponding relation does not exist between the required characteristic information of the material equipment of a plan declaration form and the preset characteristic information, jumping to the step 4,
if the unique corresponding relation exists, comparing the required material data information of the material equipment with the preset material data information of the material equipment in the plan declaration form by the corresponding relation one by one, if the comparison result is consistent, the material is automatically matched successfully, and if the comparison result is inconsistent, the material is automatically matched unsuccessfully, and the step 4 is skipped;
step 4, analyzing the required material data information, determining preset material data information with the maximum matching probability with the required material data information, and matching the required material data information with the preset material data information with the maximum matching probability if the matching probability is greater than or equal to a preset threshold value to complete automatic matching of the material equipment; if the matching probability is smaller than a preset threshold value, automatic matching fails, and related personnel are reminded to take measures in time;
the step 4 is specifically as follows:
the substep 1, extracting all independent fields of the data information of the required materials, and randomly removing one independent field;
substep 2, determining whether the remaining independent fields have corresponding relations with independent fields in the preset material data information, and if at least one corresponding relation exists, recording the preset material data information corresponding to the corresponding relations;
substep 3, removing an independent field which is not removed before, repeating substep 2, and ensuring that all independent fields of the required material data information are removed once;
substep 4, counting the recorded types and times of the preset material data information, calculating the occurrence probability of each preset material data information, and if the occurrence probability of one preset material data information is greater than a preset threshold value, judging that the required material data information is successfully matched with the preset material data information, and finishing the automatic matching of the material equipment; if the probability that none of the preset material data information appears is larger than the preset threshold value, automatic matching fails, and related personnel are reminded to take measures in time.
2. The automatic matching method for materials based on cooperative interconnection as claimed in claim 1, wherein the substep 1 is replaced by: all independent fields of the required material data information are extracted, a plurality of independent fields are randomly removed, and the number of the removed independent fields is not more than one fourth of the number of all the independent fields.
3. The automatic matching method for materials based on cooperative interconnection as claimed in claim 1, wherein if the automatic matching fails in substep 4, a historical data-based matching step is further performed, specifically:
s1, constructing a historical database, wherein the historical database comprises historical required material data information, historical preset material data information and a record of successful matching;
s2, extracting all independent fields of the required material data information, and calculating the probability P (N) of each independent field appearing in the historical required material data information, wherein N =1,2,3 … … N;
s3, randomly selecting historical preset material data information, acquiring equipment names of the historical preset material data information, and calculating the probability P (B) of the equipment names appearing in all the equipment names;
s4, calculating the probability that each independent field of the required material data information appears in the historical preset material data information corresponding to the equipment name, namely P (N | B);
s5, calculating the matching probability of the required material data and the historical preset material data information
P= (P(1|B)* P(2|B)*……* P(N|B))*P(B)/(P(1)*P(2)*……*P(N))；
S6, repeating the steps S3-S5 until the matching probability of the required material data information and each historical preset material data information is calculated;
s7, if one matching probability is larger than the sum of the other matching probabilities, judging that the required material data is successfully matched with the historical preset material data information corresponding to the matching probability;
s8, searching preset material data information which contains the preset material data information corresponding to the equipment name and is contained in the preset material data information, comparing each field of the required material data information with the field containing the preset material data information corresponding to the equipment name one by one, and obtaining the preset material data information with the highest matching degree, namely the preset material data information matched with the required material data information, so that the automatic matching of materials is successful.
4. The automatic matching method for materials based on cooperative interconnection as claimed in claim 3, wherein in S8, the matching degree is determined by the number of times each field of the required material data information matches the field of the preset material data information, and the higher the number of times, the higher the matching degree.
5. The automatic matching method for materials based on cooperative interconnection as claimed in claim 3 or 4, wherein the field of the preset material data information includes a technical specification ID, and in S8, it is further determined whether the technical specification ID of the required material data information and the technical specification ID of the preset material data information correspond to each other, if so, the automatic matching of materials is successful, otherwise, the automatic matching of materials is failed.
6. The automatic matching device for materials based on cooperative interconnection is used for executing the automatic matching method for materials based on cooperative interconnection as claimed in any one of claims 1 to 5, and is characterized by comprising
The acquisition module is used for acquiring the information of the plan declaration form and transmitting the required material data information of the material equipment to the matching module;
the matching module is used for automatically matching the required material data information with preset material data information;
the analysis module is used for analyzing the required material data information which fails to be automatically matched, so that the required material data which fails to be automatically matched continuously complete the automatic matching process, and the success rate of automatic matching is ensured;
and the display module is used for displaying the automatic matching result.
7. The automatic goods and materials matching device based on cooperative interconnection as claimed in claim 6, further comprising a storage module, wherein the storage module stores a historical database, and the historical database comprises historical required goods and materials data information, historical preset goods and materials data information and a matching success record; the analysis module is connected with the storage module and calls a historical database, and further matching is carried out on the required material data according to the historical database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210796086.8A CN114881545B (en) | 2022-07-07 | 2022-07-07 | Automatic material matching method and device based on cooperative interconnection |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210796086.8A CN114881545B (en) | 2022-07-07 | 2022-07-07 | Automatic material matching method and device based on cooperative interconnection |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114881545A CN114881545A (en) | 2022-08-09 |
| CN114881545B true CN114881545B (en) | 2022-09-23 |
Family
ID=82683029
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210796086.8A Active CN114881545B (en) | 2022-07-07 | 2022-07-07 | Automatic material matching method and device based on cooperative interconnection |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114881545B (en) |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| TW200741561A (en) * | 2006-01-31 | 2007-11-01 | Toshiba Kk | Method and device for collating biometric information |
| CN108960440A (en) * | 2018-05-31 | 2018-12-07 | 国网福建省电力有限公司 | A kind of Power Material comparison method based on VR technology |
| CN110276665A (en) * | 2019-06-25 | 2019-09-24 | 南方电网能源发展研究院有限责任公司 | Electricity power engineering purchase of goods and materials demand declaration method based on big data |
| CN111160388A (en) * | 2019-11-29 | 2020-05-15 | 江苏方天电力技术有限公司 | Data matching method in material bidding process |
| CN111639100A (en) * | 2020-04-02 | 2020-09-08 | 刘沁 | Method and device for comparing capital construction and capital supply material design inventory and declaration information |
| CN112101848A (en) * | 2020-08-11 | 2020-12-18 | 大亚湾核电运营管理有限责任公司 | Nuclear power plant strategic material receiving method, device, equipment and medium for combined reserve |
| CN112200640A (en) * | 2020-11-06 | 2021-01-08 | 国网安徽省电力有限公司信息通信分公司 | Automatic matching method and system for material supply under intelligent contract based on block chain |
| CN112348337A (en) * | 2020-10-27 | 2021-02-09 | 国网山东省电力公司经济技术研究院 | Material demand planning system and method based on artificial intelligence |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8386325B2 (en) * | 2008-09-18 | 2013-02-26 | Sap Ag | Architectural design for plan-driven procurement application software |
| CN108830534A (en) * | 2018-06-26 | 2018-11-16 | 南通森雅商务服务有限公司 | Computer network system for enterprise purchasing management |
| CN112598358A (en) * | 2020-12-30 | 2021-04-02 | 杭州拓深科技有限公司 | Intelligent aid decision purchasing method |
-
2022
- 2022-07-07 CN CN202210796086.8A patent/CN114881545B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| TW200741561A (en) * | 2006-01-31 | 2007-11-01 | Toshiba Kk | Method and device for collating biometric information |
| CN108960440A (en) * | 2018-05-31 | 2018-12-07 | 国网福建省电力有限公司 | A kind of Power Material comparison method based on VR technology |
| CN110276665A (en) * | 2019-06-25 | 2019-09-24 | 南方电网能源发展研究院有限责任公司 | Electricity power engineering purchase of goods and materials demand declaration method based on big data |
| CN111160388A (en) * | 2019-11-29 | 2020-05-15 | 江苏方天电力技术有限公司 | Data matching method in material bidding process |
| CN111639100A (en) * | 2020-04-02 | 2020-09-08 | 刘沁 | Method and device for comparing capital construction and capital supply material design inventory and declaration information |
| CN112101848A (en) * | 2020-08-11 | 2020-12-18 | 大亚湾核电运营管理有限责任公司 | Nuclear power plant strategic material receiving method, device, equipment and medium for combined reserve |
| CN112348337A (en) * | 2020-10-27 | 2021-02-09 | 国网山东省电力公司经济技术研究院 | Material demand planning system and method based on artificial intelligence |
| CN112200640A (en) * | 2020-11-06 | 2021-01-08 | 国网安徽省电力有限公司信息通信分公司 | Automatic matching method and system for material supply under intelligent contract based on block chain |
Non-Patent Citations (2)
| Title |
|---|
| Supply and Demand Matching Model for Third Party Logistics Integrated Platform;Chunhua Ju et al.;《2009 International Joint Conference on Artificial Intelligence》;20091231;全文 * |
| 电力物资协议库存计划的辅助决策与分析系统设计;薛祥等;《电气应用》;20131231;全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114881545A (en) | 2022-08-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7707058B2 (en) | Predicting parts needed for an onsite repair using expected waste derived from repair history | |
| CN109658181A (en) | Information processing method and device | |
| CN106294125B (en) | Core banking system data processing method | |
| US20070226040A1 (en) | Product market determination | |
| US20030149611A1 (en) | Supplier performance reporting | |
| CN111124732A (en) | Disk fault prediction method, system, device and storage medium | |
| CN115222259A (en) | Strategic target-based comprehensive performance management method and system | |
| CN116126843A (en) | Data quality evaluation method and device, electronic equipment and storage medium | |
| CN114881545B (en) | Automatic material matching method and device based on cooperative interconnection | |
| CN113159421A (en) | Method and device for predicting bid winning probability based on enterprise features | |
| CN115879826B (en) | Fine chemical process quality inspection method, system and medium based on big data | |
| CN115496440B (en) | Determination method and device for stock quantity of second hand vehicle | |
| CN114581251A (en) | Data verification method and device, computer equipment and computer readable storage medium | |
| US20220365841A1 (en) | Repair support system and repair support method | |
| CN115293682A (en) | Abnormal logistics order monitoring method and related device | |
| EP3955127A1 (en) | Automatic database schema updater | |
| CN113435170A (en) | Data verification method and device, electronic equipment and storage medium | |
| CN112232962A (en) | Transaction index processing method, device and equipment | |
| JP5332918B2 (en) | Classification data recommendation method, program, and apparatus | |
| CN111507705A (en) | Processing method of refueling data | |
| CN111737247A (en) | Implementation method for data quality control | |
| CN115907986B (en) | Asset checking method and device, medium and computer equipment | |
| CN117033215A (en) | Test data processing method and device for increment codes, electronic equipment and storage medium | |
| CN114390303B (en) | Data processing method, device, server, storage medium and program product | |
| CN113505159B (en) | Data detection method, device and equipment |
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 |