CN111460042B - Method for synchronizing and matching power grid user mark information among heterogeneous multiple systems - Google Patents

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

Method for synchronizing and matching power grid user mark information among heterogeneous multiple systems

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 identifier information matching between the two systems is required, cross-system matching query (such as using the user identification number and the taxpayer identification number) can be performed based on the common unique characteristics of the two systems, and the mode is simple and direct, but because the query operation needs to be performed by spanning different network segments and servers, and the related management systems of the power grid generally have more verification and safety mechanisms, the query efficiency is generally low, and the requirement for 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 power grid management systems participating in synchronization, and establishing a system user mark list SysUserList;

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 flag list sysuserlst = 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 the UserRecord into the SysUserList;

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 partial 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 InputStringLength = 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, mapping an operator iteration count variable ECounter = InputStringLength;

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 a 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 equal to or less than 0, otherwise go to S212;

s214, after the calculation of the operator is finished, outputting an ExtractResult;

s3, establishing an intersystem information synchronization list SynList by using a system user mark list SysUserList and a power grid user long character string mapping operator Extractor;

s301, establishing an intersystem information synchronization list SynList = 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= result variable Value of synchronization table key Value to search the list item with URSystem of relationship.rsys 2 and URID of relationship.ruser2 in SysUserList, and obtaining URRow of the list 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 SynList;

s309, continuously repeating 302-308, and adding the association relation of each pair of grid user marks into a SynList;

s4, inputting a name QSys1 of a grid user management system needing to be matched and a grid user mark QUser1, and a name QSys2 of a target management system needing to be matched; matching grid user marks among systems is realized by utilizing a grid user long character string mapping operator Extractor and an information synchronization list SynList among 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 combined string variable QKeyString = QSys1+ QUser1+ 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 a list item whose SyncKey is QKey1 in the synclist, if found, setting a matching item variable QItem = the item found in the SyncKey, and going to S405; otherwise go 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 power grid management systems participating in synchronization, and establishing a system user mark list SysUserList;

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 flag list sysuserlst = 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 the UserRecord into the SysUserList;

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 InputStringLength = 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, mapping an operator iteration count variable ECounter = InputStringLength;

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 SynList by using a system user mark list SysUserList and a power grid user long character string mapping operator Extractor;

s301, establishing an intersystem information synchronization list SynList = empty list;

s302, inputting an association Relation relationship of a pair of intersystem power grid user marks, wherein the association relationship comprises 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= result variable Value of synchronization table key Value to search the list item with URSystem of relationship.rsys 2 and URID of relationship.ruser2 in SysUserList, and obtaining URRow of the list item

S305, setting a first Key value variable Key1 of a Key value of a synchronization table entry to be calculated by using an Extractor, and obtaining an operator return result of ExtractResult, wherein InputString of an operator = KeyString;

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 SynList;

s309, continuously repeating 302-308, and adding the association relation of each pair of grid user marks into a SynList;

s4, inputting a name QSys1 and a grid user mark QUser1 of the grid user management system to be matched, and a name QSys2 of a target management system to be matched; matching grid user marks among systems is realized by utilizing a grid user long character string mapping operator Extractor and an information synchronization list SynList among 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 combined string variable QKeyString = QSys1+ QUser1+ 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 a list item whose SyncKey is QKey1 in the synclist, if found, setting a matching item variable QItem = the item found in the SyncKey, and going to S405; otherwise go 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 finished.

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 identifier list SysUserList, wherein the content of the SysUserList 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 SynList by using a system user mark list SysUserList and a power grid user long character string mapping operator Extractor, wherein the SynList 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 grid user mark QUser1 of the grid user management system to be matched, and a name QSys2 of a target management system to be matched; matching grid user marks among systems is realized by utilizing a grid user long character string mapping operator Extractor and an information synchronization list SynList among systems;

when input QSys1= Agriculture eSP, QUser1=1002356 and QSys2= ChemSP, QKey1=564223435321342 is obtained through Extractor calculation, corresponding content can be found in SynList, the absolute position a792-b1494ec79e24 of a corresponding database record set is obtained, matching is successfully achieved, and output matching is successful;

when QSys1= AgricultureSP, QUser1=10099123 and QSys2= ChemSP are input, QKey1=9783122144545223 is obtained through Extractor calculation, the value cannot find corresponding content in SynList, and it shows that the user 10099123 of the AgricultureSP system does not have a corresponding user in the ChemSP system, and the 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 (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 power grid management systems participating in synchronization, and establishing a system user mark list SysUserList;

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 flag list sysuserlst = 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 the UserRecord into the SysUserList;

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, finishing the calculation process in the step S1;

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 InputStringLength = 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, mapping an operator iteration count variable ECounter = InputStringLength;

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 numeric character, temp1= (cc- 'A')/26 =0.25 +0.5 if cc is an upper case English character; if cc is a lower case english character, temp1= (cc- 'a')/26 × 0.25+0.75; temp1=0 if cc is other 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 (SynList) by using a system user mark list (SysUserList) and a power grid user long character string mapping operator (Extractor);

s301, establishing an intersystem information synchronization list SynList = 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= result variable Value of synchronization table key Value to search a list item whose URSystem is relationship.rsys 2 and URID is relationship.ruser2 in the SysUserList, and obtaining URRow of the list 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 SynList;

s309, continuously repeating 302-308, and adding the association relation of each pair of grid user marks into a SynList;

s4, inputting a name QSys1 and a grid user mark QUser1 of the grid user management system to be matched, and a name QSys2 of a target management system to be matched; matching grid user marks among systems is realized by utilizing a grid user long character string mapping operator Extractor and an information synchronization list SynList among 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 combined string variable QKeyString = QSys1+ QUser1+ 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 a list item whose SyncKey is QKey1 in the synclist, if found, setting a matching item variable QItem = the item found in the SyncKey, and going to S405; otherwise go 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 finished.