Project association matching method and device, electronic equipment and storage medium
By obtaining information on new energy projects from various business systems, extracting key fields, and correcting the matching results, the problem of low accuracy in new energy data matching was solved, and more efficient project association matching was achieved.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2022-05-18
- Publication Date
- 2026-03-27
AI Technical Summary
Existing methods for matching new energy data suffer from low accuracy and low efficiency, especially in centralized and distributed processing methods.
By obtaining project information of new energy projects from various business systems, extracting key fields, determining the matching results between the main project and the subsystem based on the key fields, correcting suspected matching results, and finally outputting fully matched project information.
This improves the accuracy and efficiency of matching new energy projects, ensuring the accuracy and consistency of the matching results.
Smart Images

Figure CN114741480B_ABST
Abstract
Description
TECHNICAL FIELD
[0001] The present application relates to the technical field of electric power information data processing, and particularly relates to a project association matching method and device, electronic equipment and a storage medium. BACKGROUND
[0002] With the proposal of the "double carbon" concept, new energy has also developed rapidly. However, in the process of coordinating the business system processing of new energy, the processing methods of the same new energy project in different business systems are different, and therefore it is necessary to match each new energy project and associate the data belonging to the same project.
[0003] For the existing new energy data matching method, three methods are mainly used for matching. One is to use a centralized processing method, in which the association standard in the association matching center is used as the matching standard between new energy data in the process of matching each new energy data, so as to associate and match the new energy data. Another is to use a distributed processing method, in which there are multiple independent association matching centers, and in the matching process, the matching information in each association matching center can be used to associate and match each new energy data. The third is to use a name information association matching method, which associates and matches the data based on the pinyin information of the new energy name.
[0004] However, for the existing first method, since only the association standard of the association matching center is used as the matching standard between the new energy data, for some new energy data with high matching standard, using the association standard for matching will result in low matching accuracy. For the second method, in the matching process, time is needed to search each independent association matching center before matching, which results in low matching efficiency. For the third method, since the pinyin information of the new energy name is used to associate and match the data, there is less matching information, which cannot accurately match each new energy data. SUMMARY
[0005] Based on the above deficiencies of the prior art, the present application provides a project association matching method and device, electronic equipment and a storage medium to solve the problem of low accuracy of matching new energy data in the prior art.
[0006] In order to achieve the above purpose, the present application provides the following technical solutions:
[0007] The first aspect of the present application provides a project association matching method, comprising:
[0008] obtaining project information of each new energy project from each business system;
[0009] extracting a key field corresponding to each new energy project from the project information of each new energy target;
[0010] determining a matching result of the main project and a matching project in each subsystem based on the key field corresponding to the main project and the key field corresponding to each new energy project in each subsystem, respectively, for each main project, wherein the main project refers to the new energy project in the main system; the main system refers to the business system containing the most project information; the subsystem refers to each business system other than the main system; the matching project in the subsystem refers to the new energy project in the subsystem that has the maximum matching degree with the main project; and the matching result is one of complete matching, suspected matching and unable to match;
[0011] correcting the result of suspected matching in each matching result; wherein the corrected matching result is complete matching or unable to match;
[0012] outputting the project information of each new energy project with a complete matching result.
[0013] Optionally, in the project association matching method described above, after obtaining the project information of each new energy project from each business system, the method further comprises:
[0014] deleting blank fields in the project information;
[0015] deleting abnormal fields in the project information;
[0016] replacing the expression of numbers in the project information with a preset target expression;
[0017] converting the data format in the project information into a preset format.
[0018] Optionally, in the project association matching method described above, the extracting of the key field corresponding to each new energy project from the project information of each new energy target comprises:
[0019] performing word segmentation processing on the project information of each new energy project to obtain a plurality of subfields, respectively;
[0020] extracting an attribute field in the subfield;
[0021] combining the remaining fields in the order in the project information to obtain a combined field, wherein the remaining fields refer to subfields other than the attribute field;
[0022] The attribute field and the combined field are determined as the key fields of the new energy project.
[0023] Optionally, in the above-described project association matching method, the step of determining the matching result between the main project and the matching project in each subsystem based on the key field corresponding to the main project and the key field corresponding to each new energy project in each subsystem for each main project includes:
[0024] For each main project, based on the consistency between the key field corresponding to the main project and the key field corresponding to each sub-project in each subsystem, the matching degree between the main project and each sub-project in each subsystem is calculated; wherein, the sub-project refers to the new energy project in the subsystem.
[0025] Based on the matching degree between the main project and each of the sub-projects in each subsystem, the matching project in each subsystem is determined;
[0026] For each of the subsystems, if the matching degree between the main item and the matching item in the subsystem is greater than a preset high threshold, then the matching result between the main item and the matching item in the subsystem is determined to be a complete match.
[0027] If the matching degree between the main item and the matching item in the subsystem is less than a preset high threshold and greater than a preset low threshold, then the matching result between the main item and the matching item in the subsystem is determined to be a suspected match.
[0028] If the matching degree between the main item and the matching item in the subsystem is less than the preset low threshold, then the matching result between the main item and the matching item in the subsystem is determined to be unmatchable.
[0029] Optionally, in the above-mentioned project association matching method, the step of correcting the suspected matches in each of the matching results includes:
[0030] For each target item, check whether there is a complete match result between the target item and each matching item in each subsystem; wherein, the target item refers to the main item whose match result with any matching item in the subsystem is the suspected match.
[0031] If it is detected that there is a complete match in the matching result of the target item and the matching item in any one of the subsystems, the key field corresponding to the target item is merged with the key field corresponding to the matching item in the target subsystem to obtain a joint key field; wherein the target subsystem refers to the subsystem in which the matching result between the matching item and the target item is complete match;
[0032] The key field corresponding to the target item is updated to the joint key field;
[0033] Based on the joint key field corresponding to the target item, an updated matching result between the target item and the matching item in the suspected subsystem is determined; wherein the suspected subsystem refers to the subsystem in which the matching result between the matching item and the target item is suspected match;
[0034] The updated matching result is replaced by the matching result between the target item and the matching item in the suspected subsystem;
[0035] If it is detected that there is no complete match in the matching result of the target item and the matching item in all the subsystems, it is determined whether a first matching degree is greater than an intermediate threshold value; wherein the intermediate threshold value is a threshold value that is not less than the preset low threshold value and not greater than the preset high threshold value; the first matching degree refers to the matching degree between the target item and the matching item in the suspected subsystem;
[0036] If the first matching degree is greater than the intermediate threshold value, the matching result of the target item is corrected to complete match;
[0037] If the first matching degree is less than the intermediate threshold value, the matching result of the target item is corrected to be unable to match.
[0038] The second aspect of the present application provides a kind of association matching device of item, comprising:
[0039] An acquisition unit is configured to acquire project information of each new energy project from each business system;
[0040] A first extraction unit is configured to extract a key field corresponding to each new energy project from the project information of each new energy target.
[0041] The first determining unit is configured to, for each main project, determine the matching result between the main project and the matching project in each subsystem based on the key field corresponding to the main project and the key field corresponding to each new energy project in each subsystem; wherein, the main project refers to the new energy project in the main system; the main system refers to the business system containing the most project information; the subsystem refers to each business system other than the main system; the matching project in the subsystem refers to the new energy project in the subsystem with the highest matching degree with the main project; the matching result is one of complete match, suspected match, and no match;
[0042] The first correction unit is used to correct the suspected matches among the various matching results; wherein the corrected matching results are either complete matches or no matches.
[0043] The output unit is used to output the project information of each of the new energy projects for which the matching result is a complete match.
[0044] Optionally, the above-mentioned project association matching device further includes:
[0045] The first deletion unit is used to delete blank fields in the project information;
[0046] The second deletion unit is used to delete abnormal fields in the project information;
[0047] The first replacement unit is used to replace the expression of numbers in the project information with a preset target expression.
[0048] The conversion unit is used to convert the data format in the project information into a preset format.
[0049] Optionally, in the above-mentioned project association matching device, the first extraction unit includes:
[0050] The processing unit is used to perform word segmentation on the project information of each new energy project to obtain multiple sub-fields;
[0051] The second extraction unit is used to extract the attribute fields from the subfield;
[0052] A combination unit is used to combine the remaining fields in the order they appear in the project information to obtain a combined field; wherein, the remaining fields refer to subfields other than the attribute fields.
[0053] The second determining unit is used to determine the attribute field and the combined field as the key field of the new energy project.
[0054] Optionally, in the project association matching device, the first determining unit comprises:
[0055] a calculating unit configured to calculate, for each main project, a matching degree between the main project and each sub-project in each sub-system based on consistency between the key field corresponding to the main project and the key field corresponding to each sub-project in each sub-system, wherein the sub-project refers to the new energy project in the sub-system;
[0056] a third determining unit configured to determine the matching project in each sub-system based on the matching degree between the main project and each sub-project in each sub-system;
[0057] a fourth determining unit configured to, for each sub-system, determine that the matching result between the main project and the matching project in the sub-system is complete matching if the matching degree between the main project and the matching project in the sub-system is greater than a preset high threshold;
[0058] a fifth determining unit configured to determine that the matching result between the main project and the matching project in the sub-system is suspected matching if the matching degree between the main project and the matching project in the sub-system is less than the preset high threshold and greater than a preset low threshold;
[0059] a sixth determining unit configured to determine that the matching result between the main project and the matching project in the sub-system is unmatchable if the matching degree between the main project and the matching project in the sub-system is less than the preset low threshold.
[0060] Optionally, in the project association matching device, the first correcting unit comprises:
[0061] a detecting unit configured to, for each target project, detect whether there is a complete matching result in the matching result between the target project and each matching project in each sub-system, wherein the target project refers to the main project whose matching result with the matching project in any one of the sub-systems is suspected matching;
[0062] a merging unit configured to, if it is detected that there is a complete matching result in the matching result between the target project and the matching project in any one of the sub-systems, merge the key field corresponding to the target project and the key field corresponding to the matching project in the target sub-system to obtain a joint key field, wherein the target sub-system refers to the sub-system in which the matching result between the matching project and the target project is complete matching;
[0063] an updating unit, configured to update the key field corresponding to the target item as the joint key field;
[0064] a seventh determining unit, configured to determine an updating matching result between the target item and the matching item in the suspected subsystem based on the joint key field corresponding to the target item; wherein the suspected subsystem refers to the subsystem in which the matching result between the matching item and the target item is suspected matching;
[0065] a second replacing unit, configured to replace the updating matching result as the matching result between the target item and the matching item in the suspected subsystem;
[0066] a judging unit, configured to judge whether a first matching degree is greater than an intermediate threshold value if it is detected that there is no completely matching result in the matching result between the target item and the matching item in all the subsystems; wherein the intermediate threshold value is a threshold value which is set to be not less than the preset low threshold value and not greater than the preset high threshold value; and the first matching degree refers to a matching degree between the target item and the matching item in the suspected subsystem;
[0067] a second correcting unit, configured to correct the matching result of the target item as completely matching if the first matching degree is greater than the intermediate threshold value;
[0068] a third correcting unit, configured to correct the matching result of the target item as unable to match if the first matching degree is less than the intermediate threshold value.
[0069] The third aspect of the present application provides a computer storage medium, comprising:
[0070] a memory and a processor;
[0071] wherein the memory is configured to store a program;
[0072] the processor is configured to execute the program, and the program is configured to implement the project association matching method according to any one of the above.
[0073] The fourth aspect of the present application provides an electronic device configured to store a computer program, and the computer program is configured to implement the project association matching method according to any one of the above.
[0074] The application provides a project correlation matching method, which realizes correlation matching between new energy projects by acquiring project information of each new energy project in each business system. When the project information of each new energy project is acquired from each business system, the key field corresponding to each new energy project is extracted from the project information of each new energy target, and then the matching result of the main project and the matching project in each subsystem is determined based on the key field corresponding to the main project and the key field corresponding to each new energy project in each subsystem for each main project, wherein the main project refers to the new energy project in the main system, the main system refers to the business system with the most project information, the subsystem refers to each business system except the main system, the matching project in the subsystem refers to the new energy project with the maximum matching degree with the main project in the subsystem, and the matching result is one of complete matching, suspected matching and unable matching. Then, the result of suspected matching in each matching result is corrected, wherein the corrected matching result is complete matching or unable matching, and finally the project information of each new energy project with the matching result of complete matching is output. Thus, the matching result between the main project and each new energy project in each subsystem is determined based on the key field corresponding to the main project and the key field corresponding to each new energy project in each subsystem, so that the matching accuracy between each new energy project can be effectively improved. BRIEF DESCRIPTION OF DRAWINGS
[0075] In order to more clearly illustrate the technical solutions in the embodiments of the present application or the prior art, the drawings needed to be used in the embodiments or prior art description will be briefly introduced. Obviously, the drawings in the following description are only embodiments of the present application, and other drawings can be obtained by those skilled in the art without creative labor on the basis of the provided drawings.
[0076] Figure 1 A flowchart of a project correlation matching method provided by the embodiments of the present application;
[0077] Figure 2 A flowchart of a pre-processing field method provided by the embodiments of the present application;
[0078] Figure 3 A flowchart of a method for determining a key field provided by the embodiments of the present application;
[0079] Figure 4 A flowchart of a method for determining a matching result provided by the embodiments of the present application;
[0080] Figure 5 A flowchart of a method for correcting a matching result provided by the embodiments of the present application;
[0081] Figure 6A structural schematic diagram of an item association matching device according to another embodiment of the present application is provided.
[0082] Figure 7 A structural schematic diagram of an electronic device according to another embodiment of the present application is provided. DETAILED DESCRIPTION
[0083] The technical solutions in the embodiments of the present application will be described clearly and completely below with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, rather than all the embodiments of the present application. Based on the embodiments in the present application, all other embodiments obtained by those skilled in the art without creative work fall within the scope of protection of the present application.
[0084] In the present application, the relationship terms such as first and second are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply that there is any such actual relationship or order between these entities or operations. Moreover, the terms "include", "contain" or any other variants thereof are intended to cover non-exclusive inclusion, so that the process, method, article or device including a series of elements not only includes those elements, but also includes other elements not explicitly listed or inherent to such process, method, article or device. Without more limitations, the element defined by the statement "including a" does not exclude the presence of another identical element in the process, method, article or device including the element.
[0085] The item association matching method provided by the embodiments of the present application comprises the steps of: Figure 1 as shown, specifically comprising the following steps:
[0086] S101, obtaining project information of each new energy project from each business system.
[0087] It should be noted that the project information is related information describing the new energy project, for example, the project information can include the name, address and album capacity of the new energy project and other related information. Therefore, whether two new energy projects belong to the same project can be determined based on the consistency of the project information.
[0088] The business system is a system for managing new energy projects, which can include information systems, marketing systems, transaction systems, dispatching systems and other systems.
[0089] In the embodiments of the present application, it is judged whether two new energy projects match based on the consistency of the project information. However, there may be some project information that is described in the same way but is described in different ways, which is not convenient for subsequent accurate matching of the project information. Therefore, optionally, after step S101 is performed, the related information in the project information can be uniformly processed in advance. Therefore, as shown in FIG. 8, the present application provides a method for pre-processing fields, including the following steps: Figure 2
[0090] S201, deleting the blank fields in the project information.
[0091] S202, deleting the abnormal fields in the project information.
[0092] It should be noted that subsequent matching of each new energy project is based on the consistency of the key fields. Therefore, in order to facilitate subsequent extraction of the key fields corresponding to the new energy project from the project information without interference from the abnormal fields, the abnormal fields in the project information are deleted in advance. For example, the abnormal fields in the project information contain special characters (?,! ), English strings (abc) and the like.
[0093] S203, replacing the expression of numbers in the project information with a preset target expression.
[0094] It should be noted that the expression of numbers in the project information is unified in order to better identify whether there are new energy projects with consistent expression of numbers in the project information. Therefore, the expression of numbers in the project information is replaced with a preset target expression in advance. For example, the fields in the project information contain Arabic numerals (I, II, III, etc.), Chinese capital numerals (Yi, Er, San, etc.) and Chinese small numerals (one, two, three, etc.) and the like. At this time, the expression of these numbers is replaced with the expression of Roman numerals (1, 2, 3, etc.).
[0095] S204, converting the data format in the project information into a preset format.
[0096] It should be noted that in addition to the conversion of the expression of numbers in the project information into a preset target expression, other expressions also need to be uniformly converted. For example, the English letters in the project information are converted into capital letters, the punctuation marks are converted into English punctuation marks, and the numbers are converted into string formats.
[0097] It should be noted that in the application embodiment, the execution order of steps S201 to S204 is only one optional way, since steps S201 to S204 are completely independent of each other in the application embodiment, the execution order of steps S201 to S204 can also be executed in other execution orders, and the specific execution order can be set according to the requirements.
[0098] S102, respectively extracting the key field corresponding to each new energy project from the project information of each new energy target.
[0099] It should be noted that the project information contains a large amount of information of the new energy project, but not all information can be used to distinguish whether two new energy projects belong to the same project, so it is necessary to extract the matching field from the project information which can be used to judge whether two new energy projects belong to the same project. For example, the information system involves five important fields of "project name", "provincial affiliation", "municipal affiliation", "detailed address" and "installed capacity", wherein the five important fields are important fields of the new energy project.
[0100] Alternatively, in another embodiment of the application, another specific embodiment of step S102 includes the following steps as shown in Figure 3
[0101] S301, respectively for each new energy project, performing word segmentation processing on the project information of the new energy project to obtain a plurality of subfields.
[0102] It should be noted that the description of the new energy project in the project information can be a whole sentence expression, so it is necessary to perform Chinese word segmentation processing on the whole sentence field in the project information in advance to obtain a plurality of subfields, so as to extract the key field corresponding to the new energy project from each subfield. For example, when the project information is "Inner Mongolia Autonomous Region Longyuan Manzhouli Gaerzhen wind power project with a capacity of 49.5MW", the project information is processed by Chinese word segmentation to obtain 7 subfields of "Inner Mongolia Autonomous Region", "Longyuan", "Manzhouli", "Gaerzhen", "wind power field", "49.5MW", and "wind power project".
[0103] S302, extracting the attribute field in the subfield.
[0104] It should be noted that the attribute field can distinguish the information of different attributes in the new energy project, so the attribute field of the new energy project needs to be extracted from each subfield. For example, the attribute field can include province attribute field, city attribute field, address attribute field, power generation type attribute field, installed capacity attribute field and the like. Assuming that there are 7 subfields, which are "Inner Mongolia Autonomous Region", "Longyuan", "Manzhouli", "Gaoerzhen", "wind power station", "49.5MW", and "wind power project", wherein "Inner Mongolia Autonomous Region" is the province attribute field, "Manzhouli" is the city attribute field, "wind power station" and "wind power project" are both the power generation type attribute field, and "49.5MW" is the installed capacity attribute field.
[0105] Optionally, after extracting the attribute field in the subfield, the field content in the attribute field also needs to be normalized to avoid the situation that the matching accuracy of the new energy project is reduced due to the non-uniformity of the attribute field. For example, "Beijing" in the province attribute field is normalized to "Beijing City", and "wind power generation" and "wind power" in the power generation type attribute field are normalized to "wind power".
[0106] S303, combine the remaining fields in the order in the project information to obtain a combined field.
[0107] Among them, the remaining field refers to the subfield other than the attribute field.
[0108] It should be noted that the remaining field may also exist to determine whether two new energy projects belong to the same project, so in order to improve the matching efficiency of the new energy project, the remaining fields need to be combined in the order in the original field. For example, the field in the project information is "Inner Mongolia Autonomous Region Longyuan Manzhouli Gaoerzhen wind power station 49.5MW wind power project", wherein "Inner Mongolia Autonomous Region", "Manzhouli", "wind power station", "wind power project", and "49.5MW" are all attribute fields, and the remaining two subfields are "Longyuan" and "Gaoerzhen". The two remaining fields are combined in the order in the original field to obtain the "Longyuan Gaoerzhen" combined field.
[0109] S304, determine the attribute field and the combined field as the key field of the new energy project.
[0110] S103, respectively for each main project, based on the key field corresponding to the main project and the key field corresponding to each new energy project in each subsystem, determine the matching result of the main project and the matching project in each subsystem.
[0111] Among them, the main project refers to the new energy project in the main system, the main system refers to the business system containing the most project information, and the subsystem refers to each business system other than the main system.
[0112] Specifically, in the application embodiment, the following method can be used as the condition that the main system needs to meet: in the set S of information fields of each business system, for any s_system e S, if there exists m_system e S, the following needs to be met:
[0113]
[0114] Wherein, the Size_row(*) and Size_col(*) functions represent the number of rows and columns of the element array respectively, m_system is defined as the main system in the business system, and the other systems in the set S are defined as the subsystems in the business system. For example, for the set S of each business system = {information system, marketing system, transaction system, dispatching system}, the project information and important fields in the information system are the most in all business systems, so the information system in the set S is selected as the main system, and the remaining marketing system, transaction system and dispatching system are all subsystems.
[0115] Wherein, the matching project in the subsystem refers to the new energy project in the subsystem with the largest matching degree with the main project, and the matching result is one of complete matching, suspected matching and unable to match.
[0116] It should be noted that the matching project is the sub-project in the subsystem with the largest matching degree with the main project, wherein the sub-project refers to the new energy project in the subsystem, so in the application embodiment, only the matching result between the main project and the matching project in each subsystem needs to be determined.
[0117] It should be further noted that for any one subsystem, there is no repeated sub-project in the subsystem, and the matching project is the sub-project with the largest matching degree, so in the application embodiment, only the matching project needs to be monitored, so if the matching result between the main project and the matching project in any one subsystem is complete matching, then the matching result between the main project and the other sub-projects except the matching project is unable to match.
[0118] Alternatively, in another embodiment of the application, another specific implementation of step S103 includes the following steps as shown in Figure 4 .
[0119] S401, for each main project, based on the consistency of the key field corresponding to the main project and the key field corresponding to each sub-project in each subsystem, the matching degree between the main project and each sub-project in each subsystem is calculated.
[0120] Wherein, the sub-project refers to the new energy project in the subsystem.
[0121] It should be noted that in order to determine the matching between the main project and each sub-project in each subsystem, the matching degree between the main project and each sub-project in each subsystem is calculated by using the consistency of the key field corresponding to the main project and the key field corresponding to each sub-project in each subsystem, so as to subsequently obtain the sub-project in the subsystem with the largest matching degree with the main project.
[0122] Specifically, based on the extracted key field corresponding to the main project and the key field corresponding to each sub-project in each subsystem, the matching degree function between each subsystem and the main system is defined as:
[0123]
[0124] wherein J is the total number of key fields in each business system, m j is the matching coefficient of the jth key field, j = 1, 2,... J, g j (i) is the matching value of the jth key field of the ith subsystem and the main system, wherein g j (i) needs to satisfy:
[0125] When the jth key field is an attribute field and the content of the same key field in the main system is completely the same: g j (i) = 1.
[0126] When the jth key field is an attribute field and the content of the same key field in the main system is not completely the same: g j (i) = 0.
[0127] When the jth key field is a combination field:
[0128]
[0129] wherein n1 and n2 are both matching coefficients, N s_size is the number of characters in the combination field in the subsystem, N m_size is the number of characters in the combination field in the main system, N match_size is the number of the same characters in the combination field in the subsystem and the main system. For example, the business systems include information system, marketing system, transaction system, dispatching system, etc. At this time, the information system can be selected as the main system, and the marketing system, the transaction system, and the dispatching system can be selected as the subsystems. J = 5 is the total number of key fields in the four business systems, and the key fields include province attribute field, city attribute field, power generation type attribute field, installed capacity attribute field, and combination field. j is the matching coefficient of the jth key field, j = 1, 2,... 5, g j(i) is the matching value of the jth key field of the ith subsystem with the same key field in the information system, i = 1, 2, 3, so:
[0130] When the jth key field is an attribute field and the content of the same key field in the information system is completely identical: g j (i) = 1.
[0131] When the jth key field is an attribute field and the content of the same key field in the information system is not completely identical: g j (i) = 0.
[0132] When the jth key field is a combination field:
[0133]
[0134] Wherein, n1 and n2 are matching coefficients, N s_size is the number of characters in the combination field in the subsystem (marketing system, transaction system, dispatching system), N m_size is the number of characters in the combination field in the information system, and N match_size is the number of identical characters in the combination field in the subsystem (marketing system, transaction system, dispatching system) and the information system.
[0135] S402, based on the matching degree between the main item and each sub-item in each subsystem, determine the matching item in each subsystem.
[0136] It should be noted that based on the matching degree between the main item and each sub-item in each subsystem calculated in step S401, the matching item with the largest matching degree between the main item and each sub-item in each subsystem is determined, so as to facilitate subsequent determination of the matching result between the main item and the matching item in each subsystem.
[0137] Specifically, by traversing the main item and all items in each subsystem, the matching degree between the pth main item in the main system and the qth sub-item in the ith subsystem is calculated, and then all sub-items in the ith subsystem and the matching degree of the pth main item in the main system are sorted in descending order, and the largest matching degree F i,p is recorded, so as to determine the matching item with the largest matching degree from the pth main item in the main system and all sub-items in the ith subsystem.
[0138] S403, for each subsystem, respectively, judge whether the matching degree between the main item and the matching item in the subsystem is greater than a preset high threshold.
[0139] It should be noted that if the matching degree between the main project and the matching project in the subsystem is greater than the preset high threshold, it indicates that the matching degree between the main project and the matching project in the subsystem meets the preset matching standard value, and the matching result between the main project and the matching project in the subsystem is determined as complete matching, that is, step S404. If the matching degree between the main project and the matching project in the subsystem is less than the preset high threshold, it indicates that the matching degree between the main project and the matching project in the subsystem does not meet the preset matching standard value, and step S405 is performed.
[0140] Optionally, the preset high threshold is 0.8, and of course can be other thresholds, and the specific can be set according to the demand.
[0141] S404, determining that the matching result between the main project and the matching project in the subsystem is complete matching.
[0142] S405, determining whether the matching degree between the main project and the matching project in the subsystem is less than a preset low threshold.
[0143] It should be noted that if the matching degree between the main project and the matching project in the subsystem is greater than the preset low threshold, and the matching degree is less than the preset high threshold, it indicates that the matching degree between the main project and the matching project in the subsystem does not meet the preset matching low standard value, and also does not meet the preset matching standard value, and the matching result between the main project and the matching project in the subsystem is determined as suspected matching, that is, step S406 is performed. If the matching degree between the main project and the matching project in the subsystem is less than the preset low threshold, it indicates that the matching degree between the main project and the matching project in the subsystem meets the preset matching low standard value, and the matching result between the main project and the matching project in the subsystem is determined as unable to match, that is, step S407.
[0144] Optionally, the preset low threshold is 0.2, and of course can be other thresholds, and the specific can be set according to the demand.
[0145] It should be further noted that in the application embodiment, the execution step of step S405 is only one optional way, and since step S403 and step S405 are completely independent in the application embodiment, step S405 can also be executed after step S402, that is., after determining the matching project in each subsystem.
[0146] S406, determining that the matching result between the main project and the matching project in the subsystem is suspected matching.
[0147] S407, determining that the matching result between the main project and the matching project in the subsystem is unable to match.
[0148] S104, correcting the result of suspected matching in each matching result.
[0149] Wherein, the corrected matching result is complete matching or unmatchable.
[0150] It should be noted that if the matching result is a suspected matching result, it is not possible to determine whether the matching result between the main item and the sub-item in the subsystem is a complete matching result or an unmatchable result, so it is necessary to further correct the matching result which is a suspected matching result.
[0151] Alternatively, in another embodiment of the present application, another specific implementation of step S104 includes the following steps as shown in the following table: Figure 5
[0152] S501, for each target item, detecting whether there is a complete matching result in the matching result between the target item and each matching item in each subsystem.
[0153] Wherein, the target item refers to a main item whose matching result with the matching item in any one of the subsystems is a suspected matching result.
[0154] It should be noted that if it is detected that there is a complete matching result in the matching result between the target item and the matching item in any one of the subsystems, it means that the key field corresponding to the target item is completely matched with the key field corresponding to the matching item, and then the key field corresponding to the target item and the key field corresponding to the matching item in the target subsystem need to be merged, that is, step S502. If it is detected that there is no complete matching result in the matching result between the target item and the matching item in all subsystems, it means that the key field corresponding to the target item is unmatchable with the key field corresponding to the matching item, and then it is necessary to determine whether the matching degree between the target item and the matching item in the suspected subsystem is greater than the intermediate threshold, that is, step S506.
[0155] For example, the matching result between the 250th item and the 251st item in the information system and the two items with the maximum matching degree in the marketing system is a suspected matching result, and it is detected that the 250th item in the information system is "completely matched" with the 36th item in the transaction system.
[0156] S502, merging the key field corresponding to the target item and the key field corresponding to the matching item in the target subsystem to obtain a joint key field.
[0157] Wherein, the target subsystem refers to the subsystem in which the matching result between the matching item and the target item is completely matched.
[0158] For example, for the example in step S501, the key field corresponding to the 250th item in the information system can be merged with the key field corresponding to the 36th item in the transaction system. The province attribute field of the 250th item in the information system is "Inner Mongolia Autonomous Region", the city attribute field is "Manzhouli City", the power generation type attribute field is "wind power", the device capacity attribute field is "49.5 MW", and the combined field is "Longyuan Gaoerzhen". The province attribute field of the 36th item in the transaction system is "Inner Mongolia Autonomous Region", the city attribute field is "Manzhouli City", the power generation type attribute field is "wind power", the device capacity attribute field is empty, and the combined field is "Chifeng Longyuan Songzhou Gaoerzhen". Therefore, the key field corresponding to the 250th item in the information system is merged with the key field corresponding to the 36th item in the transaction system, and the joint key field is "Inner Mongolia Autonomous Region Manzhouli City Chifeng Longyuan Songzhou Gaoerzhen wind power 49.5 MW".
[0159] S503, updating the key field corresponding to the target item to the joint key field.
[0160] It should be noted that in order to re-match the target item with the matching item in the suspected subsystem, the key field corresponding to the target item is replaced with the joint key field, and then matched with the key field corresponding to the matching item in the suspected subsystem to obtain the re-matching result.
[0161] For example, for the example in step S502, step S503 specifically updates the province attribute field of the 250th item in the information system to "Inner Mongolia Autonomous Region", the city attribute field to "Manzhouli City", the power generation type attribute field to "wind power", the device capacity attribute field to "49.5 MW", and the combined field to "Chifeng Longyuan Songzhou Gaoerzhen".
[0162] S504, determining the update matching result between the target item and the matching item in the suspected subsystem based on the joint key field corresponding to the target item.
[0163] The suspected subsystem refers to the subsystem in which the matching result between the matching item and the target item is suspected matching.
[0164] For example, also for the example of step S503, step S504 specifically is to re-match the joint key field corresponding to the 250th item in the information system with the key field corresponding to the item with the maximum matching degree in the marketing system, to obtain an updated matching result between the 250th item in the information system and the 182nd item in the marketing system as complete matching, and replace the original matching result between the 250th item in the information system and the 182nd item in the marketing system with the updated matching result, i.e., step S505.
[0165] S505, replacing the updated matching result as the matching result between the target item and the matching item in the suspected subsystem.
[0166] S506, judging whether the first matching degree is greater than an intermediate threshold value.
[0167] The intermediate threshold value is a threshold value that is not less than a preset low threshold value and not greater than a preset high threshold value, and the first matching degree refers to the matching degree between the target item and the matching item in the suspected subsystem.
[0168] It should be noted that if the first matching degree is greater than the intermediate threshold value, it indicates that the matching degree between the target item and the matching item in the suspected subsystem meets the intermediate standard value of the preset matching, and the matching result between the target item and the matching item in the suspected subsystem is determined as complete matching, i.e., step S507. If the first matching degree is less than the intermediate threshold value, it indicates that the matching degree between the target item and the matching item in the suspected subsystem does not meet the intermediate standard value of the preset matching, and the matching result between the target item and the matching item in the suspected subsystem is determined as unable to match, i.e., step S508.
[0169] Optionally, the preset intermediate threshold value is 0.5, and of course it can also be other threshold values, which can be set according to requirements.
[0170] For example, also for the example of step S501, the same method of steps S501 to S504 is used to re-match the 251st item in the information system with the key field corresponding to the item with the maximum matching degree in the marketing system, and it is not obtained that the matching result between the 251st item in the information system and the item with the maximum matching degree in the marketing system is complete matching, so step S506 judges the matching degree between the 251st item in the information system and the item with the maximum matching degree in the marketing system with the preset intermediate threshold value. If it is judged that the matching degree is greater than the preset intermediate threshold value, the matching result between the 251st item in the information system and the item with the maximum matching degree in the marketing system is corrected as complete matching. If it is judged that the matching degree is less than the preset intermediate threshold value, the matching result between the 251st item in the information system and the item with the maximum matching degree in the marketing system is corrected as unable to match.
[0171] S507, correcting the matching result of the target project to complete matching.
[0172] S508, correcting the matching result of the target project to no matching.
[0173] S105, outputting the project information of each new energy project with the matching result of complete matching.
[0174] Optionally, since the new energy projects in the main system are pre-sequenced by labels, when the matching result between a main project and a sub-project in the sub-system is complete matching, the project information of the main project and the project information of the sub-project in the sub-system are outputted in the label sequence of the main project in the main system.
[0175] The project correlation matching method provided by the application realizes the correlation matching between the new energy projects by obtaining the project information of each new energy project in each business system. When the project information of each new energy project is obtained from each business system, the key field corresponding to each new energy project is extracted from the project information of each new energy target, and then for each main project, the matching result of the main project and the matching project in each sub-system is determined based on the key field corresponding to the main project and the key field corresponding to each new energy project in each sub-system, wherein the main project refers to the new energy project in the main system, the main system refers to the business system with the most project information, the sub-system refers to each business system except the main system, the matching project in the sub-system refers to the new energy project in the sub-system with the largest matching degree with the main project, and the matching result is one of complete matching, suspected matching and no matching. Then, the result of suspected matching in each matching result is corrected, wherein the corrected matching result is complete matching or no matching, and finally the project information of each new energy project with the matching result of complete matching is outputted. Thus, the matching result between the main project and each new energy project in each sub-system is determined by the key field corresponding to the main project and the key field corresponding to each new energy project in each sub-system, which can effectively improve the matching accuracy between the new energy projects.
[0176] Another embodiment of the application provides a project correlation matching device, as shown in Figure 6 The device comprises:
[0177] The second aspect of the application provides a project correlation matching device, which comprises:
[0178] The acquisition unit 601 is configured to obtain the project information of each new energy project from each business system.
[0179] The first extraction unit 602 is configured to extract, from the project information of each new energy target, a key field corresponding to each new energy project.
[0180] The first determination unit 603 is configured to determine, for each main project, a matching result of the main project and a matching project in each subsystem based on the key field corresponding to the main project and the key field corresponding to each new energy project in each subsystem.
[0181] The main project refers to a new energy project in a main system, the main system refers to a business system with the most project information, the subsystem refers to each business system except the main system, the matching project in the subsystem refers to a new energy project in the subsystem with the largest matching degree with the main project, and the matching result is one of complete matching, suspected matching and no matching.
[0182] The first correction unit 604 is configured to correct the result of suspected matching in each matching result.
[0183] The corrected matching result is complete matching or no matching.
[0184] The output unit 605 is configured to output the project information of each new energy project with the matching result of complete matching.
[0185] It should be noted that the specific working process of the above-mentioned units in the embodiments of the present application can correspondingly refer to steps S101-S105 in the above-mentioned method embodiments, which will not be described here.
[0186] Optionally, another embodiment of the present application further includes the following units:
[0187] The first deletion unit is configured to delete the blank field in the project information.
[0188] The second deletion unit is configured to delete the abnormal field in the project information.
[0189] The first replacement unit is configured to replace the expression of the number in the project information with a preset target expression.
[0190] The conversion unit is configured to convert the data format in the project information into a preset format.
[0191] It should be noted that the specific working process of each unit provided in the above-mentioned embodiments of the present application can correspondingly refer to the corresponding steps in the above-mentioned method embodiments, which will not be described here.
[0192] Optionally, in another embodiment of the present application, the first extraction unit 602 includes:
[0193] The processing unit is configured to perform word segmentation on the project information of each new energy project to obtain a plurality of subfields.
[0194] The second extraction unit is configured to extract an attribute field in the subfields.
[0195] The combination unit is configured to combine the remaining fields in the order in the project information to obtain a combined field.
[0196] The remaining fields refer to the subfields other than the attribute field.
[0197] The second determination unit is configured to determine the attribute field and the combined field as the key fields of the new energy project.
[0198] It should be noted that the specific working processes of the various units provided in the above embodiments of the present application can correspondingly refer to the corresponding steps in the above method embodiments, which will not be described here.
[0199] Optionally, in another embodiment of the present application, the first determination unit 603 comprises:
[0200] The calculation unit is configured to calculate, for each main project, a matching degree between the main project and each sub-project in each subsystem based on the consistency of the key field corresponding to the main project and the key field corresponding to each sub-project in each subsystem.
[0201] The sub-projects refer to the new energy projects in the subsystems.
[0202] The third determination unit is configured to determine, based on the matching degree between the main project and each sub-project in each subsystem, a matching project in each subsystem.
[0203] The fourth determination unit is configured to determine, for each subsystem, that the matching result between the main project and the matching project in the subsystem is complete matching if the matching degree between the main project and the matching project in the subsystem is greater than a preset high threshold.
[0204] The fifth determination unit is configured to determine that the matching result between the main project and the matching project in the subsystem is suspected matching if the matching degree between the main project and the matching project in the subsystem is less than the preset high threshold and greater than a preset low threshold.
[0205] The sixth determination unit is configured to determine that the matching result between the main project and the matching project in the subsystem is unable to match if the matching degree between the main project and the matching project in the subsystem is less than the preset low threshold.
[0206] It should be noted that the specific working processes of the various units provided in the above embodiments of the present application can correspondingly refer to the corresponding steps in the above method embodiments, which will not be described here.
[0207] Optionally, in another embodiment of the present application, the first correction unit 604 comprises:
[0208] The detection unit is configured to detect, for each target item, whether there is a complete match in the matching result of the target item and each matching item in each subsystem.
[0209] The target item refers to a main item whose matching result with the matching item in any one of the subsystems is a suspected match.
[0210] The merging unit is configured to merge the key field corresponding to the target item with the key field corresponding to the matching item in the target subsystem to obtain a joint key field if a complete match is detected in the matching result of the target item and the matching item in any one of the subsystems.
[0211] The target subsystem refers to a subsystem in which the matching result between the matching item and the target item is a complete match.
[0212] The updating unit is configured to update the key field corresponding to the target item to the joint key field.
[0213] The seventh determination unit is configured to determine an updated matching result between the target item and the matching item in the suspected subsystem based on the joint key field corresponding to the target item.
[0214] The suspected subsystem refers to a subsystem in which the matching result between the matching item and the target item is a suspected match.
[0215] The second replacement unit is configured to replace the updated matching result with the matching result between the target item and the matching item in the suspected subsystem.
[0216] The judgment unit is configured to judge whether the first matching degree is greater than an intermediate threshold value if it is detected that there is no complete match in the matching result of the target item and the matching item in all subsystems.
[0217] The intermediate threshold value is a threshold value that is not less than a preset low threshold value and not greater than a preset high threshold value, and the first matching degree refers to the matching degree between the target item and the matching item in the suspected subsystem.
[0218] The second correction unit is configured to correct the matching result of the target item to a complete match if the first matching degree is greater than the intermediate threshold value.
[0219] The third correction unit is configured to correct the matching result of the target item to an unmatchable result if the first matching degree is less than the intermediate threshold value.
[0220] It should be noted that the specific working process of each unit provided in the above embodiments of the present application can correspondingly refer to the corresponding steps in the above method embodiments, which will not be described here.
[0221] Another embodiment of the present application provides an electronic device, as shown in the figure, comprising: Figure 7
[0222] The memory 701 and the processor 702.
[0223] The memory 701 is configured to store a program.
[0224] The processor 702 is configured to execute the program, and when the program is executed, it is specifically configured to implement the item association matching method provided in any one of the above embodiments.
[0225] Another embodiment of the present application provides a computer storage medium for storing a computer program, and when the computer program is executed, it is used to implement the item association matching method provided in any one of the above embodiments.
[0226] The computer storage medium includes permanent and non-permanent, removable and non-removable media, which can be implemented by any method or technology to store information. The information can be computer readable instructions, data structures, program modules or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technologies, compact disc read-only memory (CD-ROM), digital versatile disc (DVD) or other optical storage, magnetic cassette, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information accessible by a computing device. According to the definition in this paper, computer readable medium does not include transitory computer readable medium, such as modulated data signals and carriers.
[0227] The skilled person can further realize that the units and algorithm steps of the examples described in conjunction with the embodiments disclosed herein can be realized in electronic hardware, computer software or a combination of the two. In order to clearly illustrate the interchangeability of hardware and software, the components and steps of the examples have been described in the above description. Whether the functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. The skilled person can use different methods to implement the described functions for each specific application, but such implementation should not be considered beyond the scope of the present application.
[0228] The foregoing description of the disclosed embodiments enables a person skilled in the art to make or use the application. Modifications of these embodiments will occur to persons of skill in the art, and that the generic principles defined herein can be applied to other embodiments without departing from the spirit or scope of the application. Therefore, the present application is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims
1. A method for associating and matching projects, characterized in that, include: Obtain project information for various new energy projects from various business systems; Extract the key fields corresponding to each new energy project from the project information of each new energy project; For each main project, based on the key fields corresponding to the main project and the key fields corresponding to each new energy project in each subsystem, the matching result between the main project and the matching project in each subsystem is determined; wherein, the main project refers to the new energy project in the main system; the main system refers to the business system containing the most project information; the subsystem refers to each business system other than the main system; the matching project in the subsystem refers to the new energy project in the subsystem with the highest matching degree with the main project; the matching result is one of complete match, suspected match, and no match; The results that are suspected matches in each of the matching results are corrected; wherein, the corrected matching results are either complete matches or no matches. Output the project information of each of the new energy projects that are a complete match; The step of correcting the suspected matches in each of the matching results includes: For each target item, check whether there is a complete match result between the target item and each matching item in each subsystem; wherein, the target item refers to the main item whose match result with any matching item in the subsystem is the suspected match. If a complete match is detected between the target item and any matching item in the subsystem, the key field corresponding to the target item is merged with the key field corresponding to the matching item in the target subsystem to obtain a joint key field; wherein, the target subsystem refers to the subsystem in which the matching item and the target item have a complete match. Update the key field corresponding to the target project to the joint key field; Based on the joint key field corresponding to the target project, the updated matching result between the target project and the matching project in the suspected subsystem is determined; wherein, the suspected subsystem refers to the subsystem in which the matching result between the matching project and the target project is a suspected match; Replace the updated matching result with the matching result between the target item and the matching item in the suspected subsystem; If it is detected that there is no complete match between the target item and the matching items in all the subsystems, then it is determined whether the first matching degree is greater than the intermediate threshold; wherein, the intermediate threshold is a preset threshold that is not less than a preset low threshold and not greater than a preset high threshold; the first matching degree refers to the matching degree between the target item and the matching items in the suspected subsystem; If the first matching degree is greater than the intermediate threshold, then the matching result of the target item is corrected to a complete match; If the first matching degree is less than the intermediate threshold, the matching result of the target item is corrected to be unmatchable.
2. The method according to claim 1, characterized in that, After obtaining project information for each new energy project from various business systems, the process also includes: Delete the blank fields in the project information; Delete the abnormal fields in the project information; Replace the way the numbers in the project information are expressed with a preset target expression; Convert the data format in the project information into a preset format.
3. The method according to claim 1, characterized in that, The step of extracting key fields corresponding to each new energy project from the project information of each new energy project includes: For each of the new energy projects, the project information of the new energy project is segmented into words to obtain multiple sub-fields; Extract the attribute fields from the subfields; The remaining fields are combined in the order they appear in the project information to obtain combined fields; wherein, the remaining fields refer to subfields other than the attribute fields. The attribute field and the combined field are determined as the key fields of the new energy project.
4. The method according to claim 1, characterized in that, The step of determining the matching result between the main project and the matching project in each subsystem, based on the key fields corresponding to the main project and the key fields corresponding to each new energy project in each subsystem, includes: For each main project, based on the consistency between the key field corresponding to the main project and the key field corresponding to each sub-project in each subsystem, the matching degree between the main project and each sub-project in each subsystem is calculated; wherein, the sub-project refers to the new energy project in the subsystem. Based on the matching degree between the main project and each of the sub-projects in each subsystem, the matching project in each subsystem is determined; For each of the subsystems, if the matching degree between the main item and the matching item in the subsystem is greater than a preset high threshold, then the matching result between the main item and the matching item in the subsystem is determined to be a complete match. If the matching degree between the main item and the matching item in the subsystem is less than a preset high threshold and greater than a preset low threshold, then the matching result between the main item and the matching item in the subsystem is determined to be a suspected match. If the matching degree between the main item and the matching item in the subsystem is less than the preset low threshold, then the matching result between the main item and the matching item in the subsystem is determined to be unmatchable.
5. A project association matching device, characterized in that, include: The acquisition unit is used to obtain project information of various new energy projects from various business systems. The first extraction unit is used to extract the key fields corresponding to each new energy project from the project information of each new energy project; The first determining unit is configured to, for each main project, determine the matching result between the main project and the matching project in each subsystem based on the key field corresponding to the main project and the key field corresponding to each new energy project in each subsystem; wherein, the main project refers to the new energy project in the main system; the main system refers to the business system containing the most project information; the subsystem refers to each business system other than the main system; the matching project in the subsystem refers to the new energy project in the subsystem with the highest matching degree with the main project; the matching result is one of complete match, suspected match, and no match; The first correction unit is used to correct the suspected matches among the various matching results; wherein the corrected matching results are either complete matches or no matches. The output unit is used to output the project information of each of the new energy projects that are completely matched; The first correction unit is further configured to detect, for each target item, whether there is a complete match result among the matching results of the target item and each matching item in each subsystem; wherein, the target item refers to the main item whose matching result with any matching item in the subsystem is the suspected match. If a complete match is detected between the target item and any matching item in the subsystem, the key field corresponding to the target item is merged with the key field corresponding to the matching item in the target subsystem to obtain a joint key field; wherein, the target subsystem refers to the subsystem in which the matching item and the target item have a complete match. Update the key field corresponding to the target project to the joint key field; Based on the joint key field corresponding to the target project, the updated matching result between the target project and the matching project in the suspected subsystem is determined; wherein, the suspected subsystem refers to the subsystem in which the matching result between the matching project and the target project is a suspected match; Replace the updated matching result with the matching result between the target item and the matching item in the suspected subsystem; If it is detected that there is no complete match between the target item and the matching items in all the subsystems, then it is determined whether the first matching degree is greater than the intermediate threshold; wherein, the intermediate threshold is a preset threshold that is not less than a preset low threshold and not greater than a preset high threshold; the first matching degree refers to the matching degree between the target item and the matching items in the suspected subsystem; If the first matching degree is greater than the intermediate threshold, then the matching result of the target item is corrected to a complete match; If the first matching degree is less than the intermediate threshold, the matching result of the target item is corrected to be unmatchable.
6. The apparatus according to claim 5, characterized in that, Also includes: The first deletion unit is used to delete blank fields in the project information; The second deletion unit is used to delete abnormal fields in the project information; The first replacement unit is used to replace the expression of numbers in the project information with a preset target expression. The conversion unit is used to convert the data format in the project information into a preset format.
7. The apparatus according to claim 5, characterized in that, The first extraction unit includes: The processing unit is used to perform word segmentation on the project information of each new energy project to obtain multiple sub-fields; The second extraction unit is used to extract the attribute fields from the subfield; A combination unit is used to combine the remaining fields in the order they appear in the project information to obtain a combined field; wherein, the remaining fields refer to subfields other than the attribute fields. The second determining unit is used to determine the attribute field and the combined field as the key field of the new energy project.
8. An electronic device, characterized in that, include: Memory and processor; The memory is used to store programs; The processor is used to execute the program, which, when executed, is specifically used to implement the project association matching method as described in any one of claims 1 to 4.
9. A computer storage medium, characterized in that, Used to store a computer program, which, when executed, implements the project association matching method as described in any one of claims 1 to 4.
Citation Information
Patent Citations
Method and device for enquire enquiry extending as well as related searching word stock
CN101281523A
Similar text determination method and device
CN111061842A
Identical item detection device and program
JP2014092967A