Cross-business system organization name mapping and matching method
By building a standard organizational name database and screening and preprocessing the organizational name, the problem of low organizational name matching accuracy in the power grid system is solved, efficient organizational name matching is achieved, and the management efficiency and reliability of the power grid system are ensured.
Patent Information
- Application Number
- CN202411830756.9
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-12-12
- Publication Date
- 2025-04-04
Smart Images
Figure CN119760121A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of organization name matching, and in particular to a method for mapping and matching organization names across business systems. Background Art
[0002] With the continuous expansion and development of organizations in the power grid system, the management and supervision of the organizations in the power grid system have become increasingly complex. The power grid system includes multiple business systems, and each business system involves multiple organizations. When managing, recording, calling, matching or analyzing the business data of each business system in the power grid system, there are situations such as confusion in the names of organizations and different naming standards, which makes it difficult to manage the business data of each business system, greatly affecting the data management efficiency of the power grid system and the safe and stable operation of the power grid system.
[0003] At present, the matching of organization names generally adopts the method of calculating the similarity of two organization names and comparing the similarity thresholds. However, this method cannot identify abbreviations and abbreviations, resulting in low matching accuracy and poor matching effect.
[0004] The inventors of the present application discovered during the process of implementing the present invention that the above-mentioned solution in the prior art has the defects of low matching accuracy and poor effect. Summary of the invention
[0005] The purpose of the embodiment of the present invention is to provide a method for mapping and matching organization names across business systems. The method for mapping and matching organization names across business systems has the functions of high matching accuracy and good effect.
[0006] In order to achieve the above object, an embodiment of the present invention provides a method for mapping and matching organization names across business systems, including:
[0007] Build a database of names of standard organizations;
[0008] Obtaining the organization name database of the current business system and performing a preliminary screening of the organization name database;
[0009] Preprocessing each organization name in the organization name database;
[0010] Matching the preprocessed organization name with the standard organization name database;
[0011] Determining whether the organization name successfully matches the standard organization name database;
[0012] In the case where the determined organization name successfully matches the standard organization name database, mapping the current organization name with the corresponding name in the standard organization name database;
[0013] If it is determined that the organization name fails to match the standard organization name database, adjusting the current organization name;
[0014] Return to the step of determining whether the organization name matches the standard organization name database successfully.
[0015] Through the above technical scheme, the cross-business system organization name mapping and matching method provided by the present invention first constructs a standard organization name database, and preliminarily screens the current organization name database, and then matches and maps each organization name in the current organization name database with the standard organization name database. If the current organization name successfully matches the standard organization name database, the standard organization name and corresponding data of the current organization name are obtained, otherwise the current organization name needs to be adjusted and re-matched with the standard organization name database, and so on. The method of adjusting the current organization name to obtain a mapping relationship with the standard organization name database can effectively improve the accuracy and effect of organization name matching, thereby ensuring the efficiency and reliability of power grid system management.
[0016] Other features and advantages of the embodiments of the present invention will be described in detail in the subsequent detailed description. BRIEF DESCRIPTION OF THE DRAWINGS
[0017] The accompanying drawings are used to provide a further understanding of the embodiments of the present invention and constitute a part of the specification. Together with the following specific implementations, they are used to explain the embodiments of the present invention, but do not constitute a limitation on the embodiments of the present invention. In the accompanying drawings:
[0018] Figure 1 is a flow chart of a method for mapping and matching organization names across business systems according to an embodiment of the present invention;
[0019] Figure 2 It is a flowchart of obtaining a standard organization name database in a method for mapping and matching organization names across business systems according to an embodiment of the present invention;
[0020] Figure 3 It is a flowchart of preprocessing an organization name in a method for mapping and matching organization names across business systems according to an embodiment of the present invention;
[0021] Figure 4It is a flow chart of obtaining a skeleton name in a method for mapping and matching organizational names across business systems according to an embodiment of the present invention;
[0022] Figure 5 It is a flow chart of obtaining parent-child organization names in a method for mapping and matching organization names across business systems according to an embodiment of the present invention;
[0023] Figure 6 It is a flowchart of obtaining the names of three-level organizations in the method for mapping and matching organizational names across business systems according to an embodiment of the present invention;
[0024] Figure 7 It is a flow chart of obtaining a characteristic name in a method for mapping and matching organization names across business systems according to an embodiment of the present invention;
[0025] Figure 8 is a flow chart of obtaining a standard reference name in a method for mapping and matching organization names across business systems according to an embodiment of the present invention;
[0026] Fig. 9 It is a flow chart of using similarity matching in a method for mapping and matching organization names across business systems according to an embodiment of the present invention;
[0027] Fig.10 This is an example diagram of obtaining the names of three-level organizations of grandfather, father and son in a method for mapping and matching organizational names across business systems according to an embodiment of the present invention. DETAILED DESCRIPTION
[0028] The specific implementation of the embodiment of the present invention is described in detail below in conjunction with the accompanying drawings. It should be understood that the specific implementation described here is only used to illustrate and explain the embodiment of the present invention, and is not used to limit the embodiment of the present invention.
[0029] It should be noted that the acquisition, transmission, storage, use, and processing of data in the technical solution of this application are in compliance with the relevant provisions of national laws and regulations. In the embodiments of this application, some existing solutions in the industry such as certain software, components, and models may be mentioned, which should be considered as exemplary. Their purpose is only to illustrate the feasibility of implementing the technical solution of this application, but it does not mean that the applicant has or will necessarily use the solution.
[0030] Figure 1 1 is a flowchart of a method for mapping and matching organization names across business systems according to an embodiment of the present invention. Figure 1 In the example, the organization name mapping and matching method may include:
[0031] In step S10, a standard organization name database is constructed. The standard organization name database can be constructed based on the standard organization names of all organizations in the current power grid system or any large enterprise / organization and other data, such as the unified social credit code (USCI) of the organization, historical business data, etc. Specifically, the source of the standard organization name can include data from enterprise association organizations.
[0032] In step S11, the organization name database of the current business system is obtained and the organization name database is preliminarily screened. The organization name database is a collection of organization names involved in various current business systems. Since each business system contains a large amount of invalid data, it is necessary to screen the organization name database.
[0033] In step S12, each organization name in the organization name database is preprocessed. After preliminary screening, the organization name database still includes multiple valid organization names, and each organization name includes some interference data or error data, so each organization name needs to be de-noised.
[0034] In step S13, the preprocessed organization name is matched with the standard organization name database. After the current organization name is preprocessed, valid information of the current organization can be obtained, and then the valid information can be matched with the standard organization name database to determine whether the organization name exists in the standard organization name database. Specifically, the matching with the organization name can include a string matching method, that is, the names of the two are required to be the same.
[0035] In step S14, it is determined whether the organization name matches the standard organization name database successfully.
[0036] In step S15, if the determined organization name matches the standard organization name database successfully, the current organization name is mapped to the corresponding name in the standard organization name database. If the organization name matches the standard organization name database successfully, it means that the organization name exists in the standard organization name database, and the current organization name can be mapped or replaced with the corresponding standard organization name, and a link can be established. Alternatively, the relevant data corresponding to the standard organization name can be called for the current organization name, depending on actual needs.
[0037] In step S16, if it is determined that the organization name fails to match the standard organization name database, the current organization name is adjusted. If the current organization name fails to match the standard organization name database, it means that the organization name does not exist in the standard organization name database, and the current organization name needs to be adjusted and modified, and then the adjusted organization name is re-matched in the standard organization name database until the match is successful, or there is no next adjustment procedure, then the process ends.
[0038] In step S17, the process returns to the step of determining whether the organization name matches the standard organization name database successfully.
[0039] In step S10 to step S17, a standard organization name database is first constructed based on the standard organization names of authoritative third-party organizations. Then, the current organization name database is preliminarily screened, and each organization name in the organization name database is subjected to operations such as denoising. The preprocessed organization name is matched with the standard organization name data. If the organization name can be successfully matched in the standard organization name database, it means that the corresponding standard organization name exists in the standard organization name database, and the current organization name can be replaced or mapped with the corresponding standard organization name in the standard organization name database to facilitate subsequent related data matching and other work. If the organization name fails to match the standard organization name database, it means that the organization name does not exist in the standard organization name database, which may be because the organization has abbreviations, abbreviations, etc., so the current organization name can be adjusted, and the adjusted organization name can be re-matched and mapped.
[0040] Traditionally, the matching of organization names is generally performed by calculating the similarity of two organization names and comparing the similarity by threshold. However, this method cannot identify abbreviations and abbreviations, resulting in low matching accuracy and poor matching effect. In this embodiment of the present invention, the current organization name is adjusted to achieve matching mapping with the standard organization name database, which can effectively improve the accuracy and effect of organization name matching, thereby ensuring the efficiency and reliability of power grid system management.
[0041] In this embodiment of the present invention, there is a lot of invalid data in the organization name database constructed by aggregating the organization name data in various business systems. It is necessary to perform a preliminary screening on the organization name. The specific screening steps can be as follows: Figure 2 Specifically, Figure 2 In the mapping matching method, the mapping matching method may further include:
[0042] In step S101, an illegal organization type data set is constructed, wherein the illegal organization types can be summarized based on observation of table fields in the business system database to identify irrelevant organization types.
[0043] In step S102, illegal organizations in the organization name database are screened and deleted according to the illegal organization type data set. For example, in the "Energy Internet Marketing Service System (Marketing 2.0)" business system, when the organization level code is "department" or "team", it will be filtered out, as shown below:
[0044] Energy Internet Marketing Service System (Marketing 2.0) corp unit Energy Internet Marketing Service System (Marketing 2.0) dept department Energy Internet Marketing Service System (Marketing 2.0) wkgtp team
[0045] In step S103, an unavailable state data set is constructed, wherein the unavailable state data is the organization in the frozen, deactivated, etc. state. By observing the table fields of the business system database, the rules of the unavailable state are summarized.
[0046] In step S104, the unavailable data in the organization name database is filtered and deleted according to the unavailable data set. For example, in the "Unified Rights Management System (ISC)" business system, when the organization status code is "disabled", it will be filtered out:
[0047] Unified Rights Management System (ISC) Y normal Unified Rights Management System (ISC) N Disable
[0048] In step S105, a suspected personnel data set is constructed. Since many business systems / organizations do not have a special field identification for personnel-type organizations, but there is a large amount of personnel-type organization information, it is necessary to judge and filter out such organizations. By exploring and analyzing a large amount of data, such as checking the frequency distribution of the last few characters of the names of all business system organizations, the rules of suspected personnel are obtained: chief engineer, leader, person, specialist, staff, specialist, director, director, etc.
[0049] In step S106, the suspected personnel data in the organization name database is filtered and deleted according to the suspected personnel data set. For example, when the characters in the suspected personnel data set appear in the organization name in a certain system, it can be judged as the organization type of the suspected personnel and filtered out.
[0050] In step S107, a virtual organization data set is constructed. Among them, there are many virtual organizations that do not belong to the benchmark organization, so it is necessary to judge and filter out these organizations. By observing a large amount of organization name data and analyzing the frequently appearing words, the rules of suspected invalid data are obtained: virtual, internal offset, transfer out, transfer in, summary, range, etc. In addition, there are many business systems that do not have a special field to identify the availability of the organization, but there are a large number of unavailable organizations. Therefore, it is necessary to judge and filter out such organizations. By observing a large amount of organization name data and analyzing the frequently appearing words, the rules of suspected invalid data are obtained: delete, stop, freeze, revoke, invalidate, cancel, etc.
[0051] In step S108, the virtual organizations in the organization name database are screened and deleted according to the virtual organization data set.
[0052] In step S101 to step S108, according to the rules and regulations of the organization names in the organization name database of the business system, illegal organization type data sets, unavailable state data sets, suspected personnel data sets, virtual organization data sets, etc. are constructed, and the organization name database is screened and deleted according to the above data sets to obtain a valid organization name database. In this way, the organization name database can be obtained effectively and reliably.
[0053] In this embodiment of the present invention, after obtaining a valid organization name database, there are still some interferences or errors in the organization names inside it, so it is necessary to pre-process each organization name in the organization name database to improve the accuracy of matching with the standard organization name database. The specific pre-processing steps can be as follows: Figure 3 Specifically, Figure 3 In the method for mapping and matching organization names, the method may further include:
[0054] In step S120, it is determined whether the (current) organization name is empty. For the organization names in the valid organization name database, there may be omissions, omissions, or failure to identify, so it is necessary to determine whether the current organization name is empty.
[0055] In step S121, when it is determined that the current organization name is not empty, the invalid data in the current organization name is cleared. Among them, if the current organization name is not empty, it means that further matching and mapping can be performed, and the organization name needs to be processed for invalid data. Specifically, for the invalid data, it may include an empty string, a null value, an abnormal character, etc., which can be cleared, and operations such as converting the data type are performed. At the same time, the invalid data may also include data of suspected departments, such as department data / suffixes of types such as xxx class, xxx department, xxx institute, and xxx business hall. The data is not specifically organized because it can be identified as invalid data and cleared. In addition, in addition to clearing the data of known suspected departments, the organization names ending with words such as "company", "institute", and "bureau" can also be directly matched, and the remaining data are filtered and cleared as data of suspected departments.
[0056] In step S122, if the current organization name is empty, it is determined that the current organization name fails to match. If the current organization name is empty, it means that the current organization name has not been entered or filled in, and the organization name cannot be matched and mapped at this time, so it can be directly determined that the current organization name fails to match.
[0057] In step S120 to step S122, first diagnose whether the current organization name is empty. If the current organization name is not empty, it means that the organization name can be matched and mapped, so invalid data can be cleared from the organization name, such as empty characters, department data, etc. If the current organization name is empty, it means that the current organization name does not exist, and subsequent matching and mapping cannot be performed, so it can be directly determined that the current organization name fails to match. In this way, unqualified data with empty organization names can be further screened out to facilitate the convenience and efficiency of subsequent organization name matching.
[0058] In this embodiment of the present invention, after the current organization name is preprocessed, the preprocessed organization name can be matched with the standard organization name database. If the direct match fails, it means that the organization name does not exist in the current standard organization name database. Specifically, the organization name may still be affected by invalid data or the organization name does not exist in the standard organization name database. Therefore, the current organization name needs to be further adjusted and re-matched to improve the matching accuracy of the organization name. The specific adjustment steps can be as follows: Figure 4 Specifically, Figure 4 In the method for mapping and matching organization names, the method may further include:
[0059] In step S160, a database for replacing equivalent words for unit suffixes is constructed. The purpose of replacing the database for equivalent words for unit suffixes is to perform data cleaning operations on the names of organizations. Specifically, considering that some unit suffixes in the names of organizations may have abbreviations or longer names, they need to be unified. Specifically, the construction of the database for replacing equivalent words for unit suffixes can be constructed based on the actual standard unit suffixes, such as replacing "Limited Liability Company" with "Company", "Electrical Science Institute" with "Electrical Power Research Institute", etc. In addition, the replacement rules for unit suffixes can also be determined based on the summary rules of the organization names in the standard organization name database. Specifically, historical names and current names can also be used as replacement words.
[0060] In step S161, the current organization name is replaced with an equivalent word according to the unit suffix equivalent word replacement database. After obtaining the current organization name, it is determined whether it has a word to be replaced in the single suffix equivalent word replacement database. If it exists, it can be replaced, otherwise it will not be replaced. Specifically, for example, if the current organization name is "Zhangjiajie Xiangneng Agricultural Power Service Co., Ltd. Cili County Branch", the organization name after cleaning and replacement is "Zhangjiajie Xiangneng Agricultural Power Service Co., Ltd. Cili County Company".
[0061] In step S162, a unit suffix database is constructed. After the current organization name is cleaned, a more qualified organization name can be obtained. In order to further improve the convenience of matching the organization name and the matching accuracy, it is necessary to extract the key information in the organization name, that is, to extract the skeleton of its name (the key information in the organization name after removing irrelevant information and maintaining the original information order). Specifically, the construction of the unit suffix database can include commonly used unit suffixes, such as "company", "group", "bureau", etc. Since the unit suffixes of the organization names have been unified in the previous step, the convenience and efficiency of skeleton extraction of some organization names can be improved.
[0062] In step S163, the unit suffix of the current organization name is cleared according to the unit suffix database.
[0063] In step S164, an address administrative level database is constructed, wherein the address administrative level database is the address administrative unit characters such as "province", "city", "county", etc., and the address administrative level database can be constructed according to the address administrative unit characters.
[0064] In step S165, the address administrative level of the current organization name is cleared according to the address administrative level database to obtain the skeleton name of the current organization name. For example, if the current organization name is "Zhangjiajie Xiangneng Agricultural Power Service Co., Ltd. Cili County Branch", the organization name after cleaning and replacement is "Zhangjiajie Xiangneng Agricultural Power Service Co., Ltd. Cili County Company", and after removing the unit suffix and the address administrative level, the name after skeleton extraction is "Zhangjiajie Xiangneng Agricultural Power Service Cili". Through a large number of actual cases, we found that the difference between the names in many business systems and the benchmark organization names lies in the subtle differences in the irrelevant information part, and the extracted skeleton information is often the same, so this adjustment method can further improve the accuracy of organization name matching.
[0065] In step S166, the skeleton name is used as the current organization name.
[0066] In step S160 to step S166, a unit suffix equivalent word replacement database is first constructed based on common actual situations or rules in the standard organization name database to replace the current organization name with equivalent words. Then, a unit suffix database is constructed based on common actual situations or rules in the standard organization name database to remove the unit suffix in the current organization name. Finally, in combination with the existing address administrative level data, the address administrative level in the current organization name is removed to obtain the skeleton name of the organization name, that is, the key name, which can further improve the accuracy and efficiency of organization name matching.
[0067] Specifically, the names of organizations in business systems are generally composed of two parts: "keywords" and "attributes". "Keywords" refer to key information that identifies an organization, such as "Hebei" in "Hebei Company"; "attributes" refer to descriptions that identify the type of organization, such as "company" in "Hebei Company", which often appear frequently in all organization names. The organization "skeleton", which is the collection of all "keywords" in the organization name, is the key information for calibrating a unique organization. By comparing the organization "skeleton", the matching of professional organizations and benchmark organizations can be achieved more accurately and quickly.
[0068] In this embodiment of the present invention, considering that some organization names only contain information of the current level, and the standard organization name database may contain information of the superior organization, it is necessary to concatenate the organization name of the current level with the organization name of the superior level and then match them. The specific steps can be as follows: Figure 5 Specifically, Figure 5 In the mapping matching method, the mapping matching method may further include:
[0069] In step S170, the parent name of the current organization name is obtained. The parent name of the current organization name can be obtained according to the organization name of this level. Specifically, for example, if the current (this level) organization name is "Zhangjiajie Xiangneng Agricultural Power Service Company Cili County Company", then its parent (last) name is "Zhangjiajie Xiangneng Agricultural Power Service Company".
[0070] In step S170, the current organization name and its parent name are merged to obtain the parent and child organization names of the current organization name. The merging of the current organization name and its parent name can be done after cleaning, that is, after replacing the unit suffix, or after extracting the current organization name and the parent name separately.
[0071] In step S172, the skeleton names of the parent and child organizational names are obtained. For example, if the current (current level) organizational name is "Zhangjiajie Xiangneng Agricultural Power Service Company Cili County Company", then its parent (previous) name is "Zhangjiajie Xiangneng Agricultural Power Service Company", and the name after the skeleton is extracted after the two are combined is "Zhangjiajie Xiangneng Agricultural Power Service Cili".
[0072] In step S173, the skeleton name of the parent and child organizational names is used as the current organizational name.
[0073] In step S170 to step S173, the parent name (superior organization name) of the current organization name (this level) is first obtained, and the current organization name and its parent name are cleaned separately, and then spliced to obtain the parent and child organization names. The skeleton name of the parent and child organization names is then extracted, and the skeleton name is used as the adjusted name of the current organization name. Specifically, the method of constructing the parent and child organization names can effectively avoid the situation where the current organization name only contains the information of the current level, further improving the accuracy and effectiveness of the organization name matching.
[0074] In this embodiment of the present invention, according to the above-mentioned parent and child organization names, some organization names only contain information of the current level, while the standard organization name database may also contain information of the parent organization of the parent organization, that is, the information of the grandfather level. Therefore, it is also necessary to splice the organization name of the current level with the organization name of the parent and the organization name of the parent-parent level, and then match them. The specific steps can be as follows: Figure 6 Specifically, Figure 6 In the mapping matching method, the mapping matching method may further include:
[0075] In step S180, the parent-level name of the current organization name is obtained. The parent-level name of the current organization name can be obtained according to the organization name of the current level, for example, the three levels of "province, city, and county" constitute the parent-child three-level organization name.
[0076] In step S181, the current organization name and its grandparent name and parent name are merged to obtain the grandparent, father, and son three-level organization names of the current organization name. Similarly, the organization name, parent name, and grandparent name are cleaned separately and then spliced and merged into the grandparent, father, and son three-level organization names.
[0077] In step S182, the skeleton name of the three-level organizational structure of the grandfather, father and son is obtained. In the same way, the skeleton name of the three-level organizational structure of the grandfather, father and son is obtained, that is, the key information name. Specifically, the skeleton extraction of the three-level organizational structure of the grandfather, father and son can be as follows Fig.10 As shown, in Fig.10 The benchmark organization is the data in the standard organization name database.
[0078] In step S183, the skeleton name of the three-level organizational structure name is used as the current organizational structure name.
[0079] In step S180 to step S183, the parent and grandparent of the current organization name are first obtained, and the current organization name and its parent name and grandparent name are cleaned and then spliced to obtain the three-level organization name of the grandfather, father and son. The skeleton name of the three-level organization name of the grandfather, father and son is then extracted, and the skeleton name is used as the adjusted name of the current organization name. Specifically, the method of constructing the three-level organization name of the grandfather, father and son can effectively avoid the situation where the current organization name of the current level only contains the information of the current level, and further improves the accuracy and effectiveness of the organization name matching.
[0080] In this embodiment of the present invention, some organization names have some commonalities, that is, they have the same naming rules. For such organization names, the names can be judged to make unified adjustments and obtain key information. The specific steps can be as follows: Figure 7 Specifically, Figure 7 In the mapping matching method, the mapping matching method may further include:
[0081] In step S190, a name template of an organization is constructed, wherein the name template can be summarized according to the name rules of actual organizations, such as "State Grid xxx Provincial Power Company", State Grid "xxx" City Power Supply Company, State Grid "xxx" County Power Supply Company, etc.
[0082] In step S191, it is determined whether the current organization name satisfies the name template.
[0083] In step S192, when it is determined that the current organization name meets the name template, the preset characters are filtered and deleted to obtain the characteristic name of the current organization name. If the current organization name meets the name template, the preset characters, such as "State Grid", "Power Supply", "Electric Power", provincial, municipal and county address administrative level suffixes and unit suffixes such as "Company", can be deleted to obtain the characteristic name of the current organization name, that is, the skeleton name.
[0084] In step S193, the administrative address is completed for the feature name. Among them, after obtaining the skeleton name / information, it is also necessary to complete the minimum address in the skeleton information upward to the provincial address. For example, the name of the organization in the business system is "State Grid Hebei Yanshan County Power Supply Company". This organization name is the name of an organization of a power supply company type, and the minimum address level is a county. If the city-level address is missing, the city-level address needs to be completed, so that the extracted skeleton is "Hebei Cangzhou Yanshan". The corresponding standard organization name may be "State Grid Hebei Electric Power Company Yanshan County Power Supply Company", and its corresponding skeleton is also "Hebei Cangzhou Yanshan", so as to obtain the correct matching result.
[0085] In step S194, the completed characteristic name is used as the current organization name.
[0086] In step S190 to step S194, a name template of the organization is first constructed according to the rules / commonalities of the organization names of the existing business organizations, and the current organization name is compared with the name template to determine whether the current organization name satisfies the name template. If the current organization name satisfies the name template, the characters to be deleted preset in the name template can be deleted to obtain a feature name / skeleton name. The feature name / skeleton name is completed with the administrative address to obtain a complete skeleton name, and finally the complete skeleton name is used as the current organization name. In this way, skeleton / feature extraction can be performed on the organization name of a specific template, further improving the scope of extraction of the organization name skeleton information, thereby effectively improving the efficiency and effect of organization name matching.
[0087] In this embodiment of the present invention, the above adjustment idea for the organization name is mainly to remove the redundant information or noise data in the organization name, and only extract the text that distinguishes the organization name information. However, for some organization names that use abbreviations or abbreviations, reliable matching cannot be performed. For such abbreviations or abbreviations, the name can be replaced to improve the matching accuracy. The specific steps can be as follows: Figure 8 Specifically, Figure 8 In the mapping matching method, the mapping matching method may further include:
[0088] In step S200, a database for replacing abbreviations of names is constructed. The database for replacing abbreviations of names can be summarized according to the possible abbreviations of the current names of various organizations, including abbreviations and full names / base names. Specifically, for example, the standard name corresponding to "Xinchan Group" is "Information and Communication Industry", the standard name corresponding to "Yingda Life Insurance" is "Yingda Taihe Life Insurance", the standard name corresponding to "Zhangjiakou Power Supply" is "Zhangjiakou Power Supply", and so on.
[0089] In step S201, characters of the current organization name are replaced according to the name abbreviation replacement database to obtain the base name of the current organization name. The replacement of the abbreviation with the full name / base name can already match a certain amount of standard organization names.
[0090] In step S202, a name standard template is constructed, wherein the name standard template can be understood as a unified rule of the standard organization name in the standard organization name database, forming the name standard template.
[0091] In step S203, it is determined whether the base name satisfies the name standard template.
[0092] In step S204, if it is determined that the base name satisfies the name standard template, the base name is modified according to the standard template to obtain a standard base name. If the base name satisfies the name standard template, it is replaced with the corresponding standard base name. Specifically, the replacement example is shown in Table 1.
[0093] Table 1. Examples of base name replacement
[0094]
[0095] According to the interpretation of Table 1, it can be understood that when the following structure appears, it can be rewritten as "State Grid xxx Provincial Electric Power Company Electric Power Research Institute":
[0096] Electric Power Research Institute of xxx Electric Power Company, State Grid xxx Electric Power Research Institute, State Grid xxx Company Electric Power Research Institute, xxx Company Electric Power Research Institute, xxx Provincial Electric Power Research Institute...
[0097] In step S205, the standard reference name is used as the current organization name.
[0098] In step S200 to step S205, a name abbreviation replacement database is first constructed based on the customary abbreviations of the existing organizational names, and then the current organizational name is replaced based on the name abbreviation replacement database to obtain the base name of the current organizational name. A name standard template is then constructed based on the standard organizational names and rules of each organizational name, and the base name is compared with the name standard template. If the base name satisfies the name standard template, the base name is converted into a standard base name, and the standard base name is used as the current organizational name. In this way, it is possible to achieve standardized processing of partially abbreviated or irregular organizational names, thereby facilitating the improvement of the accuracy and efficiency of subsequent matching.
[0099] In this embodiment of the present invention, the mapping and matching method may further include screening the property unit. The property unit refers to a partially-invested organization / enterprise that does not participate in management but only owns part of the property rights. Specifically, the data without personnel codes in the benchmark organization name are screened out as the property unit, and then the current organization name is matched with the property unit data. If the match is successful, the current organization name is determined to be the property unit.
[0100] In this embodiment of the present invention, considering that some organization names may not be entered in the standard organization name but their superior units are entered, multiple matches are performed on the current organization name. The specific steps may be as follows: Fig. 9 Specifically, Fig. 9 In the method for mapping and matching organization names, the method may further include:
[0101] In step S210, it is determined whether the current organization name has a parent organization. The parent organization is the parent organization mentioned above. Specifically, the parent organization of the current organization name is determined on the premise that the current organization name fails to match the standard organization name database, that is, the current organization name cannot be found in the standard organization name database.
[0102] In step S211, when it is determined that the current organization name has a parent organization, the parent organization name of the parent organization is obtained, wherein the previous organization name is also the parent name of the current organization name.
[0103] In step S212, the superior organization name is matched with the standard organization name database.
[0104] In step S213, it is determined whether the superior organization name matches the standard organization name database successfully.
[0105] In step S214, when it is determined that the name of the superior organization successfully matches the standard organization name database, it is determined that the superior organization of the current organization name successfully matches. If the name of the superior organization successfully matches the standard organization name database, it is considered that the organization name belongs to the subordinate unit data of the superior organization that has been matched or recorded in the database, but the organization name of the current level is not recorded in the database. Specifically, whether the organization name of the current level is a subordinate of the matched standard organization name can be determined according to the example in Table 2 below:
[0106] Table 2 Example of judgment of subordinate organizations
[0107] Organization at this level Matching standard organizations judge Shandong Electric Power Company Qingdao Branch Shandong Electric Power Company Belongs to the lower level organization Comprehensive Service Department Ultra-High Voltage Branch Ultra-high Voltage Branch Belongs to the lower level organization
[0108] When judging whether it is a subordinate, it should be noted that when the organization at this level begins with the matched standard organization name, the matched standard organization name must end with "Company". When the organization at this level ends with the matched standard organization name, the matched standard organization name must end with "Non-Company" to avoid the following situation:
[0109] Organization at this level Matching standard organizations judge Comprehensive Service Department-Ultra High Voltage Branch Comprehensive Service Department Not a subordinate organization Shandong Electric Power Company Qingdao Branch Qingdao Branch Not a subordinate organization
[0110] In step S215, when it is determined that the current organization name does not have a parent organization, each character of the current organization name is split to form a name split sequence. If the current organization name does not have a parent organization, it is necessary to further calculate the similarity. Specifically, the current organization name is first split to form a radical sequence, that is, each character is split into radicals and combined into a name split sequence.
[0111] In step S216, the n-gram feature of each individual in the split sequence is obtained by using the n-gram method. In which, each radical sequence is split into n elements in sequence using the n-gram (n-gram model), for example, if n=3, it is split into small sequence segments of 3 radicals each, and each radical corresponds to an n-gram vector value.
[0112] In step S217, the n-gram features of the name split sequence are calculated using the tf-idf algorithm to obtain the feature vector of the current organization name. Among them, the tf-idf weight vector is generated using the tf-idf algorithm (term frequency-inverse document frequency algorithm) according to the n-gram features. It can be understood that the n-gram features of the name split sequence have been generated in step S216, that is, each name has generated many small sequence fragments, and the tf-idf algorithm can score each small sequence. If the small sequence fragment appears multiple times in the name sequence, its score will be improved. And it will be considered that if a small sequence fragment in the name also appears multiple times in other names, its score will be reduced, thereby obtaining a feature vector that can characterize the name information.
[0113] In step S218, based on the similarity between the feature vector of the current organization name and each standard organization name in the standard organization name database, the feature vector of the current organization name is calculated for similarity with the feature vector of each standard organization name in the standard organization name database. Specifically, the calculation may be performed using methods including but not limited to cosine similarity to obtain the standard organization name with the highest similarity in the standard organization name database.
[0114] In step S219, it is determined whether the highest value of the similarity between the feature vector of the current organization name and the standard organization name database is greater than or equal to a standard threshold.
[0115] In step S220, when it is determined that the highest value of similarity between the feature vector of the current organization name and the standard organization name database is greater than or equal to the standard threshold, the standard organization name corresponding to the highest similarity value is obtained. Among them, if the similarity value of the standard organization name with the highest similarity is greater than or equal to the standard threshold, it means that there is a high possibility of successful matching, and the standard organization name with the highest similarity needs to be further confirmed. Specifically, the standard threshold may include 0.8.
[0116] In step S221, the current organization name and the minimum address of the standard organization name corresponding to the highest similarity value are obtained.
[0117] In step S222, it is determined whether the minimum address of the current organization name and the standard organization name corresponding to the highest similarity value are the same.
[0118] In step S223, if it is determined that the minimum address of the current organization name and the standard organization name corresponding to the highest similarity value is the same, it is determined that the current organization name matches successfully. For example, if the organization name in the current organization name database is "Luohe Huili-Energy Service Company" and the standard organization name is "Luohe Huili Industrial (Group) Co., Ltd. Energy Service Company", assuming that the similarity between the two is 0.9>0.8, and the minimum address of both is "Luohe", then it is considered that the two match successfully.
[0119] In step S224, when it is determined that the minimum address of the current organization name and the standard organization name corresponding to the highest similarity value are not the same, it is determined that the current organization name fails to match.
[0120] In step S210 to step S224, if the current organization name fails to match, and if the adjustment of the organization name still fails, the parent organization name of the current organization name can be obtained. Then the parent organization name is matched with the standard organization name database to determine whether the parent organization name is matched successfully. If the parent organization name is matched successfully, it means that the organization name belongs to the subordinate unit data of the parent organization that has been matched or recorded in the library, but the organization name of this level is not recorded in the library. If the current organization name does not have a parent organization name, each character in its organization name can be split to obtain a name split sequence. The n-gram feature of the split sequence is obtained using the n-gram method, and the feature vector of the current organization name is obtained. The feature vector of the current organization name is calculated for similarity with each standard organization name in the standard organization name database to obtain the standard organization name with the highest similarity. The value with the highest similarity is compared with the standard threshold. If the value with the highest similarity is greater than or equal to the standard threshold, it means that the standard organization name has a high probability of successful matching, but it is necessary to further match the minimum address of the current organization name and the standard organization name. If the minimum address is also the same, it can be determined that the two match successfully, otherwise it is unsuccessful. This method can accurately match some irregular or other organization names with erroneous characters, further improving the versatility and applicability of the mapping matching method.
[0121] In this embodiment of the present invention, for matching the current organization name, it is also possible to use an external industrial and commercial enterprise data set to determine whether the current organization name belongs to the external industrial and commercial enterprise data. If so, the match is successful, otherwise the match is unsuccessful.
[0122] In this embodiment of the present invention, considering that some current organizations include, in addition to the organization name, the unified social credit code of the organization. Therefore, the unified social credit code can be matched. Specifically, the USCI (unified social credit code) will first be pre-processed, and the empty string, null value, abnormal characters (the correctness of the USCI will be judged, that is, whether the USCI conforms to the correct and standardized USCI format, such as whether the length is 18 bits, etc.) will be cleared, and data type conversion and other operations will be performed to prepare for various subsequent processing and matching. Then it is determined whether the USCI corresponding to the business system organization can be matched with the USCI corresponding to the benchmark organization. If it can be matched, it is considered that the two belong to the same organization and the match is determined to be successful. Specifically, for example, the organization "Fuqing Branch of Fujian Pilot Plant" in the financial control system and the organization "Fuqing Branch of Fujian Pilot Plant Electric Power Adjustment Test Co., Ltd." in the benchmark organization, although the names are not completely consistent after standardization, the USCIs of the two are the same, thereby achieving through matching.
[0123] In this embodiment of the present invention, the order of adjusting the current organization name and the order of judging the organization name may be based on the above-mentioned step sequence, or the judging sequence may be adjusted according to actual needs.
[0124] In this embodiment of the present invention, the matching rate of mapping only through the organization name and the unified social credit code is 32.6%, and the matching rate of mapping through the organization name, the unified social credit code, the organization abbreviation, the organization skeleton and the text structure vector algorithm reaches 96.32%.
[0125] Through the above technical scheme, the cross-business system organization name mapping and matching method provided by the present invention first constructs a standard organization name database, and preliminarily screens the current organization name database, and then matches and maps each organization name in the current organization name database with the standard organization name database. If the current organization name successfully matches the standard organization name database, the standard organization name and corresponding data of the current organization name are obtained, otherwise the current organization name needs to be adjusted and re-matched with the standard organization name database, and so on. The method of adjusting the current organization name to obtain a mapping relationship with the standard organization name database can effectively improve the accuracy and effect of organization name matching, thereby ensuring the efficiency and reliability of power grid system management.
[0126] Those skilled in the art will appreciate that the embodiments of the present application may be provided as methods, systems, or computer program products. Therefore, the present application may adopt the form of a complete hardware embodiment, a complete software embodiment, or an embodiment in combination with software and hardware. Moreover, the present application may adopt the form of a computer program product implemented in one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) that include computer-usable program code.
[0127] The present application is described with reference to the flowcharts and / or block diagrams of the methods, devices (systems), and computer program products according to the embodiments of the present application. It should be understood that each process and / or box in the flowchart and / or block diagram, as well as the combination of the processes and / or boxes in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.
[0128] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.
[0129] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.
[0130] In a typical configuration, a computing device includes one or more processors (CPU), input / output interfaces, network interfaces, and memory.
[0131] The memory may include non-permanent memory in a computer-readable medium, random access memory (RAM) and / or non-volatile memory in the form of read-only memory (ROM) or flash RAM. The memory is an example of a computer-readable medium.
[0132] Computer readable media include permanent and non-permanent, removable and non-removable media that can be implemented by any method or technology to store information. 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 technology, compact disk read-only memory (CD-ROM), digital versatile disk (DVD) or other optical storage, magnetic cassettes, magnetic tape disk storage or other magnetic storage devices or any other non-transmission media that can be used to store information that can be accessed by a computing device. As defined herein, computer readable media does not include temporary computer readable media (transitory media), such as modulated data signals and carrier waves.
[0133] It should also be noted that the terms "include", "comprises" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, commodity or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, commodity or device. In the absence of more restrictions, the elements defined by the sentence "comprises a ..." do not exclude the existence of other identical elements in the process, method, commodity or device including the elements.
[0134] The above are only embodiments of the present application and are not intended to limit the present application. For those skilled in the art, the present application may have various changes and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included within the scope of the claims of the present application.
Claims
1. A method for mapping and matching organization names across business systems, characterized in that: include: Build a database of names of standard organizations; Obtaining the organization name database of the current business system and performing a preliminary screening of the organization name database; Preprocessing each organization name in the organization name database; Matching the preprocessed organization name with the standard organization name database; Determining whether the organization name successfully matches the standard organization name database; In the case where the determined organization name successfully matches the standard organization name database, mapping the current organization name with the corresponding name in the standard organization name database; If it is determined that the organization name fails to match the standard organization name database, adjusting the current organization name; Return to the step of determining whether the organization name matches the standard organization name database successfully.
2. The organization name mapping and matching method according to claim 1, characterized in that: The preliminary screening of the said organization name database includes: Constructing illegal organization type dataset; Screening and deleting illegal organizations in the organization name database according to the illegal organization type data set; Construct unavailable state dataset; Screening and deleting the unavailable data in the organization name database according to the unavailable data set; Construct a dataset of suspected persons; Screening and deleting the suspected personnel data in the organization name database according to the suspected personnel data set; constructing a virtual tissue dataset; The virtual organizations in the organizational name database are screened and deleted according to the virtual organization data set.
3. The organization name mapping and matching method according to claim 1, characterized in that: Preprocessing each organization name in the organization name database includes: Determine whether the organization name is empty; In the case where it is determined that the organization name is not empty, clearing invalid data in the organization name; When it is determined that the organization name is empty, it is determined that the organization name matching fails.
4. The organization name mapping and matching method according to claim 1, characterized in that: Adjustments to the current organizational names include: Construct a unit suffix equivalent word replacement database; Replacing the current organization name with an equivalent word according to the unit suffix equivalent word replacement database; Build unit suffix database; Clearing the unit suffix of the current organization name according to the unit suffix database; Constructing address administrative level database; Clearing the address administrative level of the current organization name according to the address administrative level database to obtain a skeleton name of the current organization name; The skeleton name is used as the current organization name.
5. The organization name mapping and matching method according to claim 4, characterized in that: Adjustments to the current organizational names also include: Get the parent name of the current organization name; Merge the current organization name and its parent name to obtain the parent and child organization names of the current organization name; Obtain the skeleton names of the parent and child organizational structure names; The skeleton name of the parent-child organizational structure names is used as the current organizational structure name.
6. The organization name mapping and matching method according to claim 5, characterized in that: Adjustments to the current organizational names also include: Get the parent name of the current organization name; Merge the current organization name and its grandparent name and parent name to obtain the grandparent, parent, and child organization names of the current organization name; Get the skeleton name of the three-level organizational structure name; The skeleton name of the three-level organizational structure name is used as the current organizational structure name.
7. The organization name mapping and matching method according to claim 6, characterized in that: Adjustments to the current organizational names also include: Build a name template for an organization; Determine whether the current organization name satisfies the name template; When it is determined that the current organization name satisfies the name template, the preset characters are filtered and deleted to obtain a characteristic name of the current organization name; Performing administrative address completion on the feature name; The completed characteristic name is used as the current organization name.
8. The organization name mapping and matching method according to claim 1, characterized in that: The organization name mapping and matching method further includes: Build a replacement database for the abbreviation name; Performing character replacement on the current organization name according to the name abbreviation replacement database to obtain a base name of the current organization name; Build a name standard template; Determining whether the base name satisfies the name standard template; In the case where it is determined that the base name satisfies the name standard template, modifying the base name according to the standard template to obtain a standard base name; The standard reference name is used as the current organization name.
9. The organization name mapping and matching method according to claim 8, characterized in that: Adjustments to the current organizational names also include: Determine whether the current organization name has a parent organization; If it is determined that the current organization name has a parent organization, obtain the parent organization name of the parent organization; Matching the parent organization name with the standard organization name database; Determine whether the superior organization name matches the standard organization name database successfully; When it is determined that the superior organization name matches the standard organization name database successfully, it is determined that the superior organization of the current organization name matches successfully.
10. The organization name mapping and matching method according to claim 9, characterized in that: Adjustments to the current organizational names also include: In the case where it is determined that the current organization name does not have a parent organization, each character of the current organization name is split to form a name split sequence; Using n-gram method to obtain n-gram features of each individual in the split sequence; Using the tf-idf algorithm to calculate the n-gram features of the name split sequence to obtain a feature vector of the current organization name; Based on the similarity between the feature vector of the current organization name and each standard organization name in the standard organization name database; Determine whether the highest value of similarity between the feature vector of the current organization name and the standard organization name database is greater than or equal to a standard threshold; When it is determined that the highest value of similarity between the feature vector of the current organization name and the standard organization name database is greater than or equal to a standard threshold, obtaining the standard organization name corresponding to the highest value of similarity; Obtain the minimum address of the standard organization name corresponding to the current organization name and the highest similarity value; Determine whether the current organization name and the minimum address of the standard organization name corresponding to the highest similarity value are the same; In the case where it is determined that the minimum address of the current organization name and the standard organization name corresponding to the highest similarity value is the same, it is determined that the current organization name is matched successfully; When it is determined that the minimum address of the current organization name and the standard organization name corresponding to the highest similarity value are not the same, it is determined that the current organization name fails to match.