CN111460042A - Method for synchronizing and matching power grid user mark information among heterogeneous multiple systems - Google Patents
Method for synchronizing and matching power grid user mark information among heterogeneous multiple systems Download PDFInfo
- Publication number
- CN111460042A CN111460042A CN202010334487.2A CN202010334487A CN111460042A CN 111460042 A CN111460042 A CN 111460042A CN 202010334487 A CN202010334487 A CN 202010334487A CN 111460042 A CN111460042 A CN 111460042A
- Authority
- CN
- China
- Prior art keywords
- power grid
- variable
- user
- operator
- management system
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2291—User-Defined Types; Storage management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/06—Electricity, gas or water supply
Abstract
The invention discloses a method for synchronizing and matching power grid user mark information among heterogeneous multiple systems, which combines the name of a power grid management system, a user mark and the name of a power grid management system to be synchronously matched, converts a power grid user long character string mapping operator into an integer, and stores the associated user mark and the absolute position of a database record by taking the integer as a key value, thereby realizing the synchronization and matching of the power grid user mark information among the heterogeneous multiple systems. By utilizing the method, on one hand, the synchronization and the matching of the power grid user mark information among the heterogeneous multi-systems can be realized quickly and flexibly, and the coupling degree among the systems is reduced; on the other hand, direct association is hidden in related data structures, and user association relations of different power grid management systems cannot be directly read from the data structures, so that the advantages of safety and confidentiality are obtained.
Description
The technical field is as follows:
the invention discloses a method for synchronizing and matching power grid user mark information among heterogeneous multiple systems, and belongs to the technical field of power grid user management systems.
Background art:
with the advancement of technology and society, more and more individuals, enterprises and units are becoming grid users as a result of using power resources. Due to centralized management, modernization and big data requirements, many new power grid management systems need to access a series of information of other power grid user management systems, however, due to history and technical development reasons, the information is distributed on a plurality of power grid user management systems which are incompatible with each other, not directly connected and have larger differences in structure; therefore, in order to effectively access the grid user information, it is necessary to synchronize and match grid user identifier information among heterogeneous multiple systems.
The method mainly comprises the following steps of carrying out synchronization and matching of power grid user mark information among a plurality of heterogeneous power grid management systems, and currently, mainly adopting the following means: (1) if the power grid user identification information between the two systems needs to be matched, cross-system matching query (such as using the identity card number and taxpayer identification number of a user) can be performed based on the common unique characteristics of the two systems, although the method is simple and direct, the query operation needs to be performed by spanning different network segments and servers, and the related management systems of the power grid usually have more verification and safety mechanisms, so the query efficiency is usually low, and the requirement of rapid mass data processing is difficult to meet. This approach will also result in tight coupling between the different systems, resulting in some single system problems spreading rapidly to multiple systems. (2) Establishing a data table, wherein the system name and the user mark of one system are used as key values, and marks corresponding to other systems are used as values corresponding to the key; the defect of the method is that the number of fields of the table is relatively fixed, and the structure of the table needs to be modified when the matching relation with a new system needs to be added; meanwhile, as users of the heterogeneous power grid management system are not in a one-to-one relationship, a large number of null values appear in the table, and the processing of the null values in the access process also greatly reduces the access efficiency. Meanwhile, the field content of the data table directly exposes the direct association relationship between the grid user mark in one system and the grid user mark of another system, the association may involve different confidentiality and access levels, and setting a record of the access and visibility of different fields at the database level obviously reduces the I/O efficiency.
Therefore, a method is needed to be constructed, on one hand, synchronization and matching of power grid user identifier information among heterogeneous multiple systems can be quickly and flexibly achieved, and on the other hand, user association relations of different power grid management systems are not directly exposed in related data structures.
Disclosure of Invention
The invention provides a method for synchronizing and matching power grid user mark information among heterogeneous multiple systems. Combining the name of a power grid management system, a user mark and the name of the power grid management system to be synchronously matched, converting the name into an integer by using a power grid user long character string mapping operator, and storing the associated user mark and the absolute position of a database record by using the integer as a key value, thereby realizing the synchronization and matching of power grid user mark information among heterogeneous multi-systems.
The invention relates to a method for synchronizing and matching power grid user mark information among heterogeneous multiple systems, which comprises the following steps:
s1, inputting the number SYSNum of the power grid management systems participating in synchronization, accessing all the power grid management systems participating in synchronization, and establishing a system user mark list SysUser L ist;
and S101, inputting the number SYSNum of the power grid management systems participating in synchronization. Wherein SYSNum is an integer number, and the value of the SYSNum is more than or equal to 1;
s102, initializing a system user mark list SysUser L ist = empty list;
s103, enabling a system number counter variable SYSCounter = 1;
s104, obtaining the name of the SYSCounter system by the system name variable SYSName =;
s105, obtaining the number of power grid users in a SYSCounter system by using a user number variable UserNum =;
s106, a user number counter variable UserCounter = 1;
s107, acquiring the power grid user marks of the users of the UserCounter on the SYSCounter power grid management system by the user mark character string variable IDString =;
s108, acquiring the absolute position of a user with a UserCounter on a SYSCounter power grid management system in a database record by using a database absolute position variable RowID = and reading a corresponding record without query and traversal by using the absolute position;
s109, establishing a power grid user mark record UserRecord which is a structure and comprises the following fields:
URSystem = corresponding grid management system name;
URID = user identification in the corresponding grid management system;
URRow = absolute position in database record;
s110, setting user record.ursystem = SYSName of the content of the user record;
UserRecord.URID=IDString；
UserRecord.URRow=RowID；
s111, adding a UserRecord into a SysUser L ist;
s112, calculating UserCounter = UserCounter +1, if the UserCounter < = UserNum, turning to S107, otherwise, turning to S113;
s113, calculating SYSCounter = SYSCounter +1; go to S104 if SYSCounter < = SYSNum, otherwise go to S114;
s114, ending the part of the calculation process;
s2, constructing a long character string mapping operator Extractor of a power grid user, wherein the input of the operator is a mapping operator character string variable InputString, and the output of the operator is a mapping operator result variable Extractresult;
s201, constructing a long character string mapping operator Extractor of a power grid user, and inputting a mapping operator character string variable InputString;
s202, mapping the length of an operator input/output string length variable InputString L ength = InputString;
s203, mapping a floating-point array with an operator temporary storage array variable TempArray =10 elements, wherein the initial value of each element of the array is 0;
s204, a mapping operator iteration count variable ECounter = InputString L ength;
s205, the mapping operator temporary storage character variable cc = InputString [ eco ];
s206, calculating the value of the first temporary storage variable temp1 of the mapping operator in the following way: temp1= (cc- '0')/20 if cc is a character of a numeral, temp1= (cc- 'a')/26 × 0.25+0.5 if cc is a character of capital english, temp1= (cc- 'a')/26 × 0.25+0.75 if cc is a character of lowercase english, and temp1=0 if cc is another character.
S207, calculating the value of the mapping operator second temporary storage variable temp2, wherein the formula is as follows:
s208, calculating a mapping operator temporary storage array offset variable pos = floor (temp1 × 10), wherein floor is a part with a decimal removed;
s209, setting TempArray [ pos ] = TempArray [ pos ] + temp 2;
s210, ECounter = ECounter-1, if ECounter is larger than or equal to 1, then going to S205, otherwise, going to S211;
s211, a mapping operator summation iteration variable TCounter =10, a mapping operator result variable ExtractResult =0, and a mapping operator calculation step variable step = 1;
s212, ExtractResult = ExtractResult + round (TempArray [ TCounter ] × step), where round is rounded;
s213, step = step x 50, TCounter = TCounter-1; go to S214 if TCounter is less than or equal to 0, otherwise go to S212;
s214, after the calculation of the operator is finished, outputting an ExtractResult;
s3, establishing an intersystem information synchronization list Syn L ist by using a system user mark list SysUser L ist and a power grid user long character string mapping operator Extractor;
s301, establishing an intersystem information synchronization list Syn L ist = empty list;
s302, inputting an association Relation relationship of a pair of inter-system power grid user marks, wherein the association Relation includes the following fields:
RSys 1: the name of the first grid management system;
RUser 1: user identification information in the first grid management system;
RSys 2: the name of the second grid management system;
RUser 2: user identifier information of a user corresponding to the RUser1 in the second grid management system;
s303, setting key value character string variable of synchronous table item
KeyString=Relation.RSys1+Relation.RUser1+Relation.RSys2；
S304, setting Value1= synchronization table key result variable Value to search the list item with the ur system of relationship.rsys 2 and the URID of relationship.ruser2 in SysUser L ist, and obtaining URRow of the table item
S305, setting a first Key value variable Key1= of a Key value of a synchronization table item to be calculated by using an Extractor, and inputting String = KeyString of an operator, and acquiring a return result of the operator as ExtractResult;
s306, constructing a synchronous list item SyncItem, wherein the SyncItem comprises the following fields;
SyncKey: a synchronized key value;
SyncValue 1: after synchronization, the absolute position of the database corresponding to the power grid user mark is obtained;
s307, setting the content of SyncItem, SyncItem. synckey = Key1, SyncItem. syncvalue1= Value 1;
s308, adding the SyncItem into the Syn L ist;
s309, continuously repeating 302 to 308, and adding the association relation of each pair of grid user marks into Syn L ist;
s4, inputting a name QSys1 and a power grid user mark QUser1 of a power grid user management system to be matched, and a name QSys2 of a target management system to be matched, and realizing the matching of the power grid user marks among the systems by utilizing a power grid user long character string mapping operator Extractor and an information synchronization list Syn L ist among the systems;
s401, inputting a name QSys1 and a grid user mark QUser1 of a grid user management system to be matched and a name QSys2 of a target management system to be matched;
s402, matching the combination string variable QKeyString = QSys1+ quesr 1+ QSys 2;
s403, matching the first key value variable QKey1= calculating by using an ExtractOperator, where InputString = QKeyString, and the operator returns a result as an ExtractResult;
s404, searching SyncKey in Syn L ist as list item of QKey1, if found, setting matched list item variable QItem = list item found in SyncKey, and going to S405, otherwise going to S407;
s405, outputting matching success, wherein the absolute position of the data of the corresponding user in a database of a QSys2 system is QItem. SyncValue1, and finding corresponding matching data;
s406, turning to S408;
s407, outputting the content which is not matched, and turning to S408;
s408, the matching process is ended.
The invention has the beneficial effects that:
the invention combines the name of a power grid management system, the user mark and the name of the power grid management system to be synchronously matched, converts the name into an integer by utilizing a power grid user long character string mapping operator, and stores the associated user mark and the absolute position of a database record by taking the integer as a key value, thereby realizing the synchronization and matching of power grid user mark information among heterogeneous multi-systems. By utilizing the method, on one hand, the synchronization and the matching of the power grid user mark information among the heterogeneous multi-systems can be realized quickly and flexibly, and the coupling degree among the systems is reduced; on the other hand, direct association is hidden in related data structures, and user association relations of different power grid management systems cannot be directly read from the data structures, so that the advantages of safety and confidentiality are obtained.
Detailed Description
The present invention is further illustrated by the following examples, which do not limit the present invention in any way, and any modifications or changes that can be easily made by a person skilled in the art to the present invention will fall within the scope of the claims of the present invention without departing from the technical solution of the present invention.
Example 1
1. A method for synchronizing and matching power grid user mark information among heterogeneous multiple systems comprises the following steps:
s1, inputting the number SYSNum of the power grid management systems participating in synchronization, accessing all the power grid management systems participating in synchronization, and establishing a system user mark list SysUser L ist;
and S101, inputting the number SYSNum of the power grid management systems participating in synchronization. Wherein SYSNum is an integer number, and the value of the SYSNum is more than or equal to 1;
s102, initializing a system user mark list SysUser L ist = empty list;
s103, enabling a system number counter variable SYSCounter = 1;
s104, obtaining the name of the SYSCounter system by the system name variable SYSName =;
s105, obtaining the number of power grid users in a SYSCounter system by using a user number variable UserNum =;
s106, a user number counter variable UserCounter = 1;
s107, acquiring the power grid user marks of the users of the UserCounter on the SYSCounter power grid management system by the user mark character string variable IDString =;
s108, acquiring the absolute position of a user with a UserCounter on a SYSCounter power grid management system in a database record by using a database absolute position variable RowID = and reading a corresponding record without query and traversal by using the absolute position;
s109, establishing a power grid user mark record UserRecord which is a structure and comprises the following fields:
URSystem = corresponding grid management system name;
URID = user identification in the corresponding grid management system;
URRow = absolute position in database record;
s110, setting user record.ursystem = SYSName of the content of the user record;
UserRecord.URID=IDString；
UserRecord.URRow=RowID；
s111, adding a UserRecord into a SysUser L ist;
s112, calculating UserCounter = UserCounter +1, if the UserCounter < = UserNum, turning to S107, otherwise, turning to S113;
s113, calculating SYSCounter = SYSCounter +1; go to S104 if SYSCounter < = SYSNum, otherwise go to S114;
s114, ending the part of the calculation process;
s2, constructing a long character string mapping operator Extractor of a power grid user, wherein the input of the operator is a mapping operator character string variable InputString, and the output of the operator is a mapping operator result variable Extractresult;
s201, constructing a long character string mapping operator Extractor of a power grid user, and inputting a mapping operator character string variable InputString;
s202, mapping the length of an operator input/output string length variable InputString L ength = InputString;
s203, mapping a floating-point array with an operator temporary storage array variable TempArray =10 elements, wherein the initial value of each element of the array is 0;
s204, a mapping operator iteration count variable ECounter = InputString L ength;
s205, the mapping operator temporary storage character variable cc = InputString [ eco ];
s206, calculating the value of the first temporary storage variable temp1 of the mapping operator in the following way: temp1= (cc- '0')/20 if cc is a character of a numeral, temp1= (cc- 'a')/26 × 0.25+0.5 if cc is a character of capital english, temp1= (cc- 'a')/26 × 0.25+0.75 if cc is a character of lowercase english, and temp1=0 if cc is another character.
S207, calculating the value of the mapping operator second temporary storage variable temp2, wherein the formula is as follows:
s208, calculating a mapping operator temporary storage array offset variable pos = floor (temp1 × 10), wherein floor is a part with a decimal removed;
s209, setting TempArray [ pos ] = TempArray [ pos ] + temp 2;
s210, ECounter = ECounter-1, if ECounter is larger than or equal to 1, then going to S205, otherwise, going to S211;
s211, a mapping operator summation iteration variable TCounter =10, a mapping operator result variable ExtractResult =0, and a mapping operator calculation step variable step = 1;
s212, ExtractResult = ExtractResult + round (TempArray [ TCounter ] × step), where round is rounded;
s213, step = step x 50, TCounter = TCounter-1; go to S214 if TCounter is less than or equal to 0, otherwise go to S212;
s214, after the calculation of the operator is finished, outputting an ExtractResult;
s3, establishing an intersystem information synchronization list Syn L ist by using a system user mark list SysUser L ist and a power grid user long character string mapping operator Extractor;
s301, establishing an intersystem information synchronization list Syn L ist = empty list;
s302, inputting an association Relation relationship of a pair of inter-system power grid user marks, wherein the association Relation includes the following fields:
RSys 1: the name of the first grid management system;
RUser 1: user identification information in the first grid management system;
RSys 2: the name of the second grid management system;
RUser 2: user identifier information of a user corresponding to the RUser1 in the second grid management system;
s303, setting key value character string variable of synchronous table item
KeyString=Relation.RSys1+Relation.RUser1+Relation.RSys2；
S304, setting Value1= synchronization table key result variable Value to search the list item with the ur system of relationship.rsys 2 and the URID of relationship.ruser2 in SysUser L ist, and obtaining URRow of the table item
S305, setting a first Key value variable Key1= of a Key value of a synchronization table item to be calculated by using an Extractor, and inputting String = KeyString of an operator, and acquiring a return result of the operator as ExtractResult;
s306, constructing a synchronous list item SyncItem, wherein the SyncItem comprises the following fields;
SyncKey: a synchronized key value;
SyncValue 1: after synchronization, the absolute position of the database corresponding to the power grid user mark is obtained;
s307, setting the content of SyncItem, SyncItem. synckey = Key1, SyncItem. syncvalue1= Value 1;
s308, adding the SyncItem into the Syn L ist;
s309, continuously repeating 302 to 308, and adding the association relation of each pair of grid user marks into Syn L ist;
s4, inputting a name QSys1 and a power grid user mark QUser1 of a power grid user management system to be matched, and a name QSys2 of a target management system to be matched, and realizing the matching of the power grid user marks among the systems by utilizing a power grid user long character string mapping operator Extractor and an information synchronization list Syn L ist among the systems;
s401, inputting a name QSys1 and a grid user mark QUser1 of a grid user management system to be matched and a name QSys2 of a target management system to be matched;
s402, matching the combination string variable QKeyString = QSys1+ quesr 1+ QSys 2;
s403, matching the first key value variable QKey1= calculating by using an ExtractOperator, where InputString = QKeyString, and the operator returns a result as an ExtractResult;
s404, searching SyncKey in Syn L ist as list item of QKey1, if found, setting matched list item variable QItem = list item found in SyncKey, and going to S405, otherwise going to S407;
s405, outputting matching success, wherein the absolute position of the data of the corresponding user in a database of a QSys2 system is QItem. SyncValue1, and finding corresponding matching data;
s406, turning to S408;
s407, outputting the content which is not matched, and turning to S408;
s408, the matching process is ended.
Example 2
S1, for data of a certain power grid management enterprise in the north, inputting the number SYSNum =15 of power grid management systems participating in synchronization, accessing all power grid management systems participating in synchronization, and establishing a system user mark list SysUser L ist, SysUser L ist, wherein the content is as follows:
| URSystem | URID | URRow |
| HeatSp | 1007821 | 48c1-a133-62befb114ee5 |
| HeatSp | 1007822 | 40d0-85c0-d4c550b7cb4c |
| HeatSp | 1007823 | 4c15-8f0a-4e9a24d459a8 |
| … | ||
| AgricultureSP | AD3041 | 4b16-9618-df4c0f7d24d8 |
| AgricultureSP | AD3042 | 4b97-af7e-2019f5e02df6 |
| AgricultureSP | AD3043 | |
| … | ||
| ChemSP | 6731 | a2f1-be9fbce54edd |
| ChemSP | 6732 | a87f-d4c2387a9b0c |
| ChemSP | 6733 | a379-cdadd1b97fd3 |
s2, constructing a long character string mapping operator Extractor of a power grid user, inputting a mapping operator character string variable InputString, and outputting a mapping operator result variable ExtractResult;
s3, establishing an intersystem information synchronization list Syn L ist by using a system user mark list SysUser L ist and a power grid user long character string mapping operator Extractor, wherein the Syn L ist comprises the following contents:
| SyncKey | SyncValue1 |
| 217953457232323421 | bd6a-95e968f423e9 |
| 66723232335453132 | 962f-f79f83e4d9b2 |
| 324234223433434342 | 8aa3-4fa9fbee94cb |
| … |
the direct association relation between two system user IDs cannot be read in the table, meanwhile, the length of each SyncKey is different due to the computing mode of the Extractor, and the user IDs and the system names cannot be directly predicted from the content of the data; the mode ensures the loose coupling between systems and the security of data;
s4, inputting a name QSys1 and a power grid user mark QUser1 of a power grid user management system to be matched, and a name QSys2 of a target management system to be matched, and realizing the matching of the power grid user marks among the systems by utilizing a power grid user long character string mapping operator Extractor and an information synchronization list Syn L ist among the systems;
when input QSys1= Agriculture ESP, QUser1=1002356 and QSys2= ChemSP, QKey1=564223435321342 is obtained through Extractor calculation, corresponding content can be found in Syn L ist, absolute positions a792-b1494ec79e24 of corresponding database record sets are obtained, matching is successfully achieved, and matching success is output;
when input QSys1= AgricultureSP, QUser1=10099123 and QSys2= ChemSP, QKey1=9783122144545223 is obtained through Extractor calculation, the value cannot find corresponding content in Syn L ist, and the fact that a user 10099123 of the AgricultureSP system does not have a corresponding user in the ChemSP system indicates that output matching is unsuccessful.
Example 3
In order to verify the method described by the invention, the method described by the invention is compared with two traditional methods of directly performing cross-system query and establishing a mark data table. 5 heterogeneous power grid user management systems are introduced, the number of users on each system exceeds 5 thousands, and the comparison of synchronization and matching is as follows:
(1) establishing a comparison of the time required to synchronize user marks
The time required for completing the establishment of the related data structure from initialization to traversal of all data is used as a comparison standard; the method described in the invention: the time for establishing a related data structure is 11 minutes; performing cross-system query: 0 minute, the method does not need to establish a relevant data structure in advance; establishing a mark data table: a large amount of database query operation is needed to establish a table and insert data, and the required time is 210 minutes;
(2) efficiency comparison for grid user sign matching
Carrying out random user mark matching query between two heterogeneous systems, and taking the times of executing query per minute as comparison standard;
the method described in the invention: 7200 times;
performing cross-system query: 13 times;
establishing a mark data table: 370 times of treatment;
from the above comparison, it can be seen that the method described in the present invention is significantly superior to the time required to create the flag data table, since it only requires 11 minutes for the creation of the relevant data structure; meanwhile, on the matching query, because the user mark and the query of the target system are mapped into an integer, the query is converted into a process of finding a numerical value associated with the integer, the process is very easy for a modern computer, and the query times per minute are far higher than those of the other two methods. The comparison shows that the method provided by the invention has higher application value.
Claims (2)
1. A method for synchronizing and matching power grid user mark information among heterogeneous multiple systems comprises the following steps:
s1, inputting the number SYSNum of the power grid management systems participating in synchronization, accessing all the power grid management systems participating in synchronization, and establishing a system user mark list SysUser L ist;
s101, inputting the number SYSNum of power grid management systems participating in synchronization;
wherein SYSNum is an integer number, and the value of the SYSNum is more than or equal to 1;
s102, initializing a system user mark list SysUser L ist = empty list;
s103, enabling a system number counter variable SYSCounter = 1;
s104, obtaining the name of the SYSCounter system by the system name variable SYSName =;
s105, obtaining the number of power grid users in a SYSCounter system by using a user number variable UserNum =;
s106, a user number counter variable UserCounter = 1;
s107, acquiring the power grid user marks of the users of the UserCounter on the SYSCounter power grid management system by the user mark character string variable IDString =;
s108, acquiring the absolute position of a user with a UserCounter on a SYSCounter power grid management system in a database record by using a database absolute position variable RowID = and reading a corresponding record without query and traversal by using the absolute position;
s109, establishing a power grid user mark record UserRecord which is a structure and comprises the following fields:
URSystem = corresponding grid management system name;
URID = user identification in the corresponding grid management system;
URRow = absolute position in database record;
s110, setting user record.ursystem = SYSName of the content of the user record;
UserRecord.URID=IDString；
UserRecord.URRow=RowID；
s111, adding a UserRecord into a SysUser L ist;
s112, calculating UserCounter = UserCounter +1, if the UserCounter < = UserNum, turning to S107, otherwise, turning to S113;
s113, calculating SYSCounter = SYSCounter +1; go to S104 if SYSCounter < = SYSNum, otherwise go to S114;
s114, ending the part of the calculation process;
s2, constructing a long character string mapping operator Extractor of a power grid user, wherein the input of the operator is a mapping operator character string variable InputString, and the output of the operator is a mapping operator result variable Extractresult;
s201, constructing a long character string mapping operator Extractor of a power grid user, and inputting a mapping operator character string variable InputString;
s202, mapping the length of an operator input/output string length variable InputString L ength = InputString;
s203, mapping a floating-point array with an operator temporary storage array variable TempArray =10 elements, wherein the initial value of each element of the array is 0;
s204, a mapping operator iteration count variable ECounter = InputString L ength;
s205, the mapping operator temporary storage character variable cc = InputString [ eco ];
s206, calculating the value of the first temporary storage variable temp1 of the mapping operator in the following way: temp1= (cc- '0')/20 if cc is a character of a numeral, temp1= (cc- 'a')/26 × 0.25+0.5 if cc is a character of capital english, temp1= (cc- 'a')/26 × 0.25+0.75 if cc is a character of lowercase english, and temp1=0 if cc is another character.
S207, calculating the value of the mapping operator second temporary storage variable temp2, which has the formula:
s208, calculating a mapping operator temporary storage array offset variable pos = floor (temp1 × 10), wherein floor is a part with a decimal removed;
s209, setting TempArray [ pos ] = TempArray [ pos ] + temp 2;
s210, ECounter = ECounter-1, if ECounter is larger than or equal to 1, then going to S205, otherwise, going to S211;
s211, a mapping operator summation iteration variable TCounter =10, a mapping operator result variable ExtractResult =0, and a mapping operator calculation step variable step = 1;
s212, ExtractResult = ExtractResult + round (TempArray [ TCounter ] × step), where round is rounded;
s213, step = step x 50, TCounter = TCounter-1; go to S214 if TCounter is less than or equal to 0, otherwise go to S212;
s214, after the calculation of the operator is finished, outputting an ExtractResult;
s3, establishing an intersystem information synchronization list Syn L ist by using a system user mark list SysUser L ist and a power grid user long character string mapping operator Extractor;
s301, establishing an intersystem information synchronization list Syn L ist = empty list;
s302, inputting an association Relation relationship of a pair of inter-system power grid user marks, wherein the association Relation includes the following fields:
RSys 1: the name of the first grid management system;
RUser 1: user identification information in the first grid management system;
RSys 2: the name of the second grid management system;
RUser 2: user identifier information of a user corresponding to the RUser1 in the second grid management system;
s303, setting key value character string variable of synchronous table item
KeyString=Relation.RSys1+Relation.RUser1+Relation.RSys2；
S304, setting Value1= synchronization table key result variable Value to search the list item with the ur system of relationship.rsys 2 and the URID of relationship.ruser2 in SysUser L ist, and obtaining URRow of the table item
S305, setting a first Key value variable Key1= of a Key value of a synchronization table item to be calculated by using an Extractor, and inputting String = KeyString of an operator, and acquiring a return result of the operator as ExtractResult;
s306, constructing a synchronous list item SyncItem, wherein the SyncItem comprises the following fields;
SyncKey: a synchronized key value;
SyncValue 1: after synchronization, the absolute position of the database corresponding to the power grid user mark is obtained;
s307, setting the content of SyncItem, SyncItem. synckey = Key1, SyncItem. syncvalue1= Value 1;
s308, adding the SyncItem into the Syn L ist;
s309, continuously repeating 302 to 308, and adding the association relation of each pair of grid user marks into Syn L ist;
s4, inputting a name QSys1 and a power grid user mark QUser1 of a power grid user management system to be matched, and a name QSys2 of a target management system to be matched, and realizing the matching of the power grid user marks among the systems by utilizing a power grid user long character string mapping operator Extractor and an information synchronization list Syn L ist among the systems;
s401, inputting a name QSys1 and a grid user mark QUser1 of a grid user management system to be matched and a name QSys2 of a target management system to be matched;
s402, matching the combination string variable QKeyString = QSys1+ quesr 1+ QSys 2;
s403, matching the first key value variable QKey1= calculating by using an ExtractOperator, where InputString = QKeyString, and the operator returns a result as an ExtractResult;
s404, searching SyncKey in Syn L ist as list item of QKey1, if found, setting matched list item variable QItem = list item found in SyncKey, and going to S405, otherwise going to S407;
s405, outputting matching success, wherein the absolute position of the data of the corresponding user in a database of a QSys2 system is QItem. SyncValue1, and finding corresponding matching data;
s406, turning to S408;
s407, outputting the content which is not matched, and turning to S408;
s408, the matching process is ended.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010334487.2A CN111460042B (en) | 2020-04-24 | 2020-04-24 | Method for synchronizing and matching power grid user mark information among heterogeneous multiple systems |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010334487.2A CN111460042B (en) | 2020-04-24 | 2020-04-24 | Method for synchronizing and matching power grid user mark information among heterogeneous multiple systems |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111460042A true CN111460042A (en) | 2020-07-28 |
| CN111460042B CN111460042B (en) | 2022-06-14 |
Family
ID=71681113
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010334487.2A Active CN111460042B (en) | 2020-04-24 | 2020-04-24 | Method for synchronizing and matching power grid user mark information among heterogeneous multiple systems |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111460042B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112433776A (en) * | 2020-10-16 | 2021-03-02 | 广东电力信息科技有限公司 | Power grid business processing system |
Citations (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080222061A1 (en) * | 2007-03-10 | 2008-09-11 | Hendra Soetjahja | Adaptive Multivariate Model Construction |
| US20090222506A1 (en) * | 2008-02-29 | 2009-09-03 | Evident Software, Inc. | System and method for metering and analyzing usage and performance data of a virtualized compute and network infrastructure |
| CN101754372A (en) * | 2008-12-01 | 2010-06-23 | 中兴通讯股份有限公司 | Method and system for tracking performance parameters of user equipment |
| US20110274041A1 (en) * | 2010-03-05 | 2011-11-10 | Interdigital Patent Holdings, Inc. | Dynamic peer discovery and inter-unit transfer (iut) using mobile internet protocol (mip) |
| CN102710623A (en) * | 2012-05-23 | 2012-10-03 | 中国电力科学研究院 | Intelligent grid electricity information privacy protection method based on multi-party interaction |
| US20140081698A1 (en) * | 2012-09-14 | 2014-03-20 | SolveDirect Service Management GmbH | Service Process Integration Systems and Methods |
| US20140153439A1 (en) * | 2012-12-04 | 2014-06-05 | Intucell Ltd. | Method for managing hetereogeneous cellular networks |
| CN106372219A (en) * | 2016-09-07 | 2017-02-01 | 大地风景（武汉）信息技术有限公司 | User behavior data association method and system based on heterogeneous platform |
| CN107301219A (en) * | 2017-06-16 | 2017-10-27 | 杭州凯达电力建设有限公司 | A kind of Electric Power Network Planning data management system |
| CN108448575A (en) * | 2018-04-02 | 2018-08-24 | 广州供电局有限公司 | Power distribution network electric load analysis method and system, computer storage media and equipment |
| CN108899903A (en) * | 2018-08-24 | 2018-11-27 | 国网安徽省电力有限公司阜阳供电公司 | A kind of operation of power networks status data management method and system |
| CN109932585A (en) * | 2017-12-18 | 2019-06-25 | 中国科学院沈阳自动化研究所 | The adaptive binary chop algorithm of smart grid-oriented neighborhood net malicious user positioning |
| CN110287186A (en) * | 2019-05-31 | 2019-09-27 | 武汉大学 | A kind of smart grid data management system and method based on block chain technology with sovereign right |
| US20200042857A1 (en) * | 2018-08-02 | 2020-02-06 | Optum Services (Ireland) Limited | Method, system, and apparatus for generating and training a digital signal processor for evaluating graph data |
| CN110889614A (en) * | 2019-11-21 | 2020-03-17 | 中国南方电网有限责任公司 | Power grid system important user power supply risk analysis method based on SCADA big data |
-
2020
- 2020-04-24 CN CN202010334487.2A patent/CN111460042B/en active Active
Patent Citations (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080222061A1 (en) * | 2007-03-10 | 2008-09-11 | Hendra Soetjahja | Adaptive Multivariate Model Construction |
| US20090222506A1 (en) * | 2008-02-29 | 2009-09-03 | Evident Software, Inc. | System and method for metering and analyzing usage and performance data of a virtualized compute and network infrastructure |
| CN101754372A (en) * | 2008-12-01 | 2010-06-23 | 中兴通讯股份有限公司 | Method and system for tracking performance parameters of user equipment |
| US20110274041A1 (en) * | 2010-03-05 | 2011-11-10 | Interdigital Patent Holdings, Inc. | Dynamic peer discovery and inter-unit transfer (iut) using mobile internet protocol (mip) |
| CN102710623A (en) * | 2012-05-23 | 2012-10-03 | 中国电力科学研究院 | Intelligent grid electricity information privacy protection method based on multi-party interaction |
| US20140081698A1 (en) * | 2012-09-14 | 2014-03-20 | SolveDirect Service Management GmbH | Service Process Integration Systems and Methods |
| US20140153439A1 (en) * | 2012-12-04 | 2014-06-05 | Intucell Ltd. | Method for managing hetereogeneous cellular networks |
| CN106372219A (en) * | 2016-09-07 | 2017-02-01 | 大地风景（武汉）信息技术有限公司 | User behavior data association method and system based on heterogeneous platform |
| CN107301219A (en) * | 2017-06-16 | 2017-10-27 | 杭州凯达电力建设有限公司 | A kind of Electric Power Network Planning data management system |
| CN109932585A (en) * | 2017-12-18 | 2019-06-25 | 中国科学院沈阳自动化研究所 | The adaptive binary chop algorithm of smart grid-oriented neighborhood net malicious user positioning |
| CN108448575A (en) * | 2018-04-02 | 2018-08-24 | 广州供电局有限公司 | Power distribution network electric load analysis method and system, computer storage media and equipment |
| US20200042857A1 (en) * | 2018-08-02 | 2020-02-06 | Optum Services (Ireland) Limited | Method, system, and apparatus for generating and training a digital signal processor for evaluating graph data |
| CN108899903A (en) * | 2018-08-24 | 2018-11-27 | 国网安徽省电力有限公司阜阳供电公司 | A kind of operation of power networks status data management method and system |
| CN110287186A (en) * | 2019-05-31 | 2019-09-27 | 武汉大学 | A kind of smart grid data management system and method based on block chain technology with sovereign right |
| CN110889614A (en) * | 2019-11-21 | 2020-03-17 | 中国南方电网有限责任公司 | Power grid system important user power supply risk analysis method based on SCADA big data |
Non-Patent Citations (2)
| Title |
|---|
| LINGLING PAN 等: ""Multi-dimensional Index Construction of Electric"", 《2019 IEEE 4TH ADVANCED INFORMATION TECHNOLOGY, ELECTRONIC AND AUTOMATION CONTROL CONFERENCE (IAEAC 2019)》 * |
| 徐敏 等: ""HBase 在智能电网异构数据同步中的应用研究"", 《网络信息工程》 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112433776A (en) * | 2020-10-16 | 2021-03-02 | 广东电力信息科技有限公司 | Power grid business processing system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111460042B (en) | 2022-06-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7792822B2 (en) | Systems and methods for modeling partitioned tables as logical indexes | |
| US20060155753A1 (en) | Global asynchronous serialized transaction identifier | |
| CN111026874A (en) | Data processing method and server of knowledge graph | |
| WO2021174788A1 (en) | Information matching analysis method and apparatus, and computer system and readable storage medium | |
| CN105786950A (en) | Method and device for processing data | |
| CN110727663A (en) | Data cleaning method, device, equipment and medium | |
| CN111460042B (en) | Method for synchronizing and matching power grid user mark information among heterogeneous multiple systems | |
| CN111259004A (en) | Method for indexing data in storage engine and related device | |
| CN115374129A (en) | Database joint index coding method and system | |
| CN111625640B (en) | Question and answer processing method, device and storage medium | |
| CN110874365B (en) | Information query method and related equipment thereof | |
| CN110209661B (en) | Population basic information base maintenance method, system and storage medium | |
| CN110147396B (en) | Mapping relation generation method and device | |
| CN111414364B (en) | User information generation method and device and electronic equipment | |
| GB2366405A (en) | Property storage for database structures | |
| CN114860806A (en) | Data query method and device of block chain, computer equipment and storage medium | |
| WO2021207831A1 (en) | Method and systems for indexing databases on a contextual basis | |
| CN113076365A (en) | Data synchronization method and device, electronic equipment and storage medium | |
| CN112765169A (en) | Data processing method, device, equipment and storage medium | |
| Hayhoe et al. | SPECTRE: Seedless network alignment via spectral centralities | |
| Khan et al. | Secured technique for healthcare record linkage | |
| EP3506120B1 (en) | Universally unique resources with no dictionary management | |
| US8250108B1 (en) | Method for transferring data into database systems | |
| CN113221543B (en) | Medical term integration method and system | |
| JPH03150668A (en) | Input character string normalization system for retrieval system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |