CN105184482A - Transformer machine account data verification system and method thereof - Google Patents

Abstract

The invention discloses a transformer machine account data verification system and a method thereof. The method comprises respectively acquiring station equipment machine account information and power station equipment machine account nonstandard information for transmitting to a server; encoding the station equipment machine account information and the station equipment machine account nonstandard information by use of a character string form; carrying out one-to-one character matching on transformer information in the encoded station equipment machine account nonstandard information and transformer information in the encoded station equipment machine account standard information; on the basis that the transformer information matches each other, according to preset ownership relations between transformer stations and transformers, querying and obtaining a transformer machine account list of a corresponding transformer; comparing the transformer attributes of the obtained transformer machine account list to obtain transformer machine account information with different matching degree values; classifying the transformers with the same matching degree value into the same kind of transformers; and storing machine account information of the same kind of transformers in the form of a machine account corresponding table, and ending transformer machine account data verification.

Description

A transformer ledger data verification system and method thereof

technical field

The invention relates to the field of electric power industry, in particular to a transformer ledger data checking system and a method thereof.

Background technique

Ledger originally refers to the account books placed on the stage for people to read, hence the name ledger. For example: Ledgers in production safety management The safety production ledger is a data record that reflects the overall situation of a unit's safety production management. In the process of recording, collating and accumulating ledger data, it plays a role in self-supervision and strengthening safety production management; ledger is the need for enterprises to standardize management and improve enterprise management level; ledger has played a role in units and safety management personnel The role of self-protection.

The ledgers include the safety responsibility letter, safety production inspection data, and equipment management data such as mechanical and electrical equipment. Among them, the equipment ledgers are not unified due to the different management methods and purposes of different enterprises, and it is difficult to achieve a unified General management of devices. In the construction process of the smart grid, a unified and standardized information management system is built to realize the general management of a piece of equipment, which can effectively centralize various services and prevent management confusion caused by the separation of systems.

Since the transformer is the main equipment for the operation of the power grid, the verification of the transformer ledger data is more important. At present, there are the following shortcomings in the verification process of transformer ledger data: the verification of ledger data is basically manual, which is slow and inefficient when faced with massive equipment; different staff have different thinking modes, and the verification results are not uniform; There is subjective consciousness when verifying ledger data, the accuracy cannot be quantified, and the accuracy is unreliable.

Contents of the invention

In order to solve the shortcomings of the prior art, the present invention provides a transformer ledger data verification system and method thereof. The method is based on the string matching principle to realize efficient and accurate verification of transformer ledger data in different systems.

To achieve the above object, the present invention adopts the following technical solutions:

A transformer ledger data verification system, including a data acquisition unit, which is connected to a substation workstation through an interface;

The data acquisition unit obtains the in-station equipment ledger information stored in the substation workstation through the interface, and transmits it to the server; the in-station equipment ledger information includes in-station equipment ledger standard information and in-station equipment ledger non-standard information;

The server includes a standard information storage unit, which is used to store the standard information of the equipment ledger in the station; a non-standard information storage unit, which is used to store the non-standard information of the equipment ledger in the station;

The intelligent terminal processing unit communicates with the server, and the intelligent terminal processing unit includes a character string encoding module, which is used to obtain standard information of the equipment account in the station and non-standard information of the equipment account in the station, and use the form of a character string to encode the acquired The information is encoded, and the encoded information is sent to the substation matching module;

Substation matching module, which is used to match the substation information in the non-standard information of the encoded station equipment ledger with the substation information in the standard information of the station equipment ledger in a one-to-one character way, and then split the verification data ;

The ledger query module is used to query and obtain the transformer ledger list under the corresponding substation according to the preset relationship between the substation and the transformer on the basis of substation information matching;

An attribute comparison module, which is used to compare the transformer attributes of the obtained transformer ledger list in a one-to-one character matching manner, and obtain transformer ledger information with different matching degree values;

A matching verification module, which is used to classify transformers with the same matching degree value into the same type of transformers;

The result storage module is used for storing the same type of transformer ledger information in the form of ledger correspondence table, and ends the verification of transformer ledger data.

The intelligent terminal processing unit is a computer, which communicates with the server using the TCP/IP protocol.

The information encoded by the character string encoding module is a character string in digital form.

A verification method based on a transformer ledger data verification system, comprising:

The substation equipment ledger information and substation equipment ledger non-standard information are collected and stored in the substation workstation through the interface, and are transmitted to the server for storage;

Obtain the standard information of the equipment ledger in the station and the non-standard information of the equipment ledger in the station, and encode the obtained information in the form of a string;

The substation information in the non-standard information of the encoded station equipment ledger is matched with the substation information in the standard information of the station equipment ledger in a one-to-one character way, and then the verification data is divided;

On the basis of substation information matching, according to the preset relationship between substations and transformers, query and obtain the transformer ledger list under the corresponding substation;

Use one-to-one character matching to compare the transformer attributes of the obtained transformer ledger list, and obtain the transformer ledger information with different matching degree values; divide the transformers with the same matching degree value into the same type of transformer; use the ledger Store the same type of transformer ledger information in the form of a corresponding table, and end the transformer ledger data verification.

After obtaining the standard information of the on-site equipment ledger and non-standard information on the on-site equipment ledger, and encoding the obtained information in the form of a string, both the standard information on the on-site equipment ledger and the non-standard information on the on-site equipment ledger are in digital form String.

According to the preset relationship between the substation and the transformer, the process of querying and obtaining the transformer ledger list under the corresponding substation is as follows:

The preset relationship between the substation and the transformer is that all the transformers in a substation are associated with the substation;

Build a tree structure of cotyledons with the substation information as the root node and the transformer information in the substation as the root node;

Obtain substation information, query according to the constructed tree structure and obtain the transformer ledger list under the corresponding substation.

The process of comparing the transformer attributes of the obtained transformer ledger list by means of one-to-one character matching includes:

First, remove the redundant fields in the transformer properties;

Then, split the deredundant transformer attributes by characters;

Finally, compare the divided characters one by one, and calculate the matching degree value of the transformer ledger information.

The properties of the transformer include the name, voltage level and type of the transformer.

When all characters in the non-standard information of the on-site equipment ledger and the standard information on the on-site equipment ledger are exactly the same, the non-standard information on the on-site equipment ledger and the standard information on the on-site equipment ledger are standard matches;

The standard matching between the non-standard information of the on-site equipment ledger and the standard information on the on-site equipment ledger includes:

The non-standard information of the on-site equipment ledger and the standard information on the on-site equipment ledger contain the same characters and the characters are in the same order;

The non-standard information of the on-site equipment ledger and the standard information of the on-site equipment ledger contain the same characters, but the order of the characters is different.

The beneficial effects of the present invention are:

(1) The present invention replaces manual equipment correspondence in an intelligent manner, which can greatly improve the comparison speed and efficiency; because the name of the substation is relatively fixed, the number is relatively small, and data verification is easy, so the present invention first compares the substations in the standard library with the The substations in the ledger information database perform data verification, and the verification data is distributed through substation matching;

(2) The present invention can quantify the corresponding results, improve the accuracy and applicability, and at the same time, batch process the results with the same accuracy in the later stage;

(3) The present invention shields the possibility of large differences in matching results due to different thinking of people, and can compare all devices with the same standard, and the results are highly standardized;

(4) The system of the present invention has reusability, reduces the irregular factors caused by manual correspondence, and can quantify the corresponding results at the same time, so as to realize the classification and processing of results with different accuracy; it can be greatly improved compared with manual correspondence one by one Improve the corresponding speed and efficiency, and finally realize the high efficiency and high accuracy of transformer ledger data verification in different systems.

Description of drawings

Fig. 1 is the schematic flow sheet of transformer ledger data verification method of the present invention;

Fig. 2 is a schematic structural diagram of the transformer ledger data verification system of the present invention.

Detailed ways

Below in conjunction with accompanying drawing and embodiment the present invention will be further described:

As shown in Figure 2, the transformer account data verification system of the present invention includes a data acquisition unit, which is connected to the substation workstation through an interface; the data acquisition unit obtains the equipment account information stored in the substation workstation through the interface , and sent to the server; the in-station equipment ledger information includes in-station equipment ledger standard information and in-station equipment ledger non-standard information;

The server includes a standard information storage unit, which is used to store the standard information of the equipment ledger in the station; a non-standard information storage unit, which is used to store the non-standard information of the equipment ledger in the station;

The intelligent terminal processing unit communicates with the server. The intelligent terminal processing unit includes a character string encoding module, which is used to obtain the standard information of the equipment ledger in the station and the non-standard information of the equipment ledger in the station, and use the string form to process the obtained information. Coding, sending the coded information to the substation matching module;

Substation matching module, which is used to match the substation information in the non-standard information of the encoded station equipment ledger with the substation information in the standard information of the station equipment ledger in a one-to-one character way, and then split the verification data ;

The ledger query module is used to query and obtain the transformer ledger list under the corresponding substation according to the preset relationship between the substation and the transformer on the basis of substation information matching;

An attribute comparison module, which is used to compare the transformer attributes of the obtained transformer ledger list in a one-to-one character matching manner, and obtain transformer ledger information with different matching degree values;

A matching verification module, which is used to classify transformers with the same matching degree value into the same type of transformers;

The result storage module is used for storing the same type of transformer ledger information in the form of ledger correspondence table, and ends the verification of transformer ledger data.

Wherein, the intelligent terminal processing unit adopts a computer, and communicates with the server through the TCP/IP protocol.

The information encoded by the character string encoding module is a character string in digital form.

In this embodiment, the server adopts a dual-channel quad-core rack type, the processor model is XeonE5520, the memory is 32GDDR3, and the hard disk is 1TB; the operating system of the PC is 64-bit, the CPU model is i5-4590, 3.3GH, the memory is 8G and the hard disk 500GB.

The invention enables the production management system to work normally without being affected by the operation of the ledger data checking system. The server and the computer communicate with the TCP/IP protocol, and do not need to access the external network for communication, which has high security.

As shown in Figure 1, the verification method based on the transformer ledger data verification system of the present invention includes:

The substation equipment ledger information and substation equipment ledger non-standard information are collected and stored in the substation workstation through the interface, and are transmitted to the server for storage;

Obtain the standard information of the equipment ledger in the station and the non-standard information of the equipment ledger in the station, and encode the obtained information in the form of a string;

The substation information in the non-standard information of the encoded station equipment ledger is matched with the substation information in the standard information of the station equipment ledger in a one-to-one character way, and then the verification data is divided;

On the basis of substation information matching, according to the preset relationship between substations and transformers, query and obtain the transformer ledger list under the corresponding substation;

Use one-to-one character matching to compare the transformer attributes of the obtained transformer ledger list, and obtain the transformer ledger information with different matching degree values; divide the transformers with the same matching degree value into the same type of transformer; use the ledger Store the same type of transformer ledger information in the form of a corresponding table, and end the transformer ledger data verification.

Further, after obtaining the standard information of the equipment ledger in the station and the non-standard information of the equipment ledger in the station, and encoding the obtained information in the form of a string, the standard information of the equipment ledger in the station and the non-standard information of the equipment ledger in the station are both A string in numeric form; an exact match can be achieved in numeric form.

Further, according to the preset relationship between the substation and the transformer, the process of querying and obtaining the transformer ledger list under the corresponding substation is as follows:

The preset relationship between the substation and the transformer is that all the transformers in a substation are associated with the substation;

Build a tree structure of cotyledons with the substation information as the root node and the transformer information in the substation as the root node;

Obtain substation information, query according to the constructed tree structure and obtain the transformer ledger list under the corresponding substation.

The process of comparing the transformer attributes of the obtained transformer ledger list by means of one-to-one character matching includes:

First, remove the redundant fields in the transformer properties;

Then, split the deredundant transformer attributes by characters;

Finally, compare the divided characters one by one, and calculate the matching degree value of the transformer ledger information.

Among them, the transformer properties include the name, voltage level and type of the transformer.

For example: the transformer name comparison based on string matching needs to normalize the transformer name first, remove the redundant fields in the name that are useless for matching (such as 110Kv, 220Kv), and then split the normalized name by character, and divide the split name The characters are compared one by one to calculate the degree of text matching.

When all characters in the non-standard information of the on-site equipment ledger and the standard information on the on-site equipment ledger are exactly the same, the non-standard information on the on-site equipment ledger and the standard information on the on-site equipment ledger are standard matches;

The standard matching between the non-standard information of the on-site equipment ledger and the standard information on the on-site equipment ledger includes:

The non-standard information of the on-site equipment ledger and the standard information on the on-site equipment ledger contain the same characters and the characters are in the same order;

The non-standard information of the on-site equipment ledger and the standard information of the on-site equipment ledger contain the same characters, but the order of the characters is different.

The specific operation process of the transformer ledger data checking system based on the present invention is:

(1) Write the equipment ledger information in the collection station and the non-standard information of the equipment ledger in the station into the ledger data verification system;

(2) In the query part, select the relevant information table of the transformer ledger that needs to be queried;

(3) Run the transformer ledger data matching verification module, and the system performs verification based on the attributes and then the characters according to the queried equipment list;

(4) After the system finishes running, the corresponding results will be stored in the database after verification by category to form a ledger correspondence table.

The specific process of querying the relevant information table of the transformer ledger:

Find the relevant information table of the transformer ledger;

Select relevant columns in the ledger information table as required;

Perform combined query after selecting relevant columns;

The query results are put into a temporary result set.

Although the specific implementation of the present invention has been described above in conjunction with the accompanying drawings, it does not limit the protection scope of the present invention. Those skilled in the art should understand that on the basis of the technical solution of the present invention, those skilled in the art do not need to pay creative work Various modifications or variations that can be made are still within the protection scope of the present invention.

Claims (10)

1. a transformer account data verification system, is characterized in that, comprises data acquisition unit, and it is connected with work of transformer substation station by interface;

Data acquisition unit obtains the station equipment account information be stored in work of transformer substation station by described interface, and is sent to server; Described station equipment account information comprises station equipment account standard information and station equipment account non-standard information;

Server, it comprises standard information storage unit, and it is for equipment account standard information in storage sites; Non-standard information storage unit, it is for equipment account non-standard information in storage sites;

Intelligent terminal processing unit, it intercoms mutually with server, described intelligent terminal processing unit comprises string encoding module, it is for equipment account standard information in acquisition station and station equipment account non-standard information, and adopt character string forms to encode to the information obtained, the information after coding is sent to transformer station's matching module;

Transformer station's matching module, it for adopting the mode of character one to one to mate the substation information in the station equipment account non-standard information after coding with the substation information in station equipment account standard information, and then is shunted checking data;

Account query module, it is for the basis of mating at substation information, according to the belonging relation of transformer station and the transformer preset, the transformer account list under the corresponding transformer station of inquiry acquisition;

Attribute comparing module, it carries out the comparison of transformer attribute for adopting the mode of character match one to one to the transformer account list obtained, and obtains the transformer account information that matching degree value is different;

Coupling correction verification module, it is for being divided in same class transformer by the transformer of same matching degree value;

Result memory module, it for storing of a sort transformer account information with the form of account correspondence table, and terminates transformer account data check.

2. a kind of transformer account data verification system as claimed in claim 1, it is characterized in that, described intelligent terminal processing unit is computing machine, and itself and server adopt ICP/IP protocol to intercom mutually.

3. a kind of transformer account data verification system as claimed in claim 1, it is characterized in that, the information after described string encoding module coding is the character string of digital form.

4., based on a method of calibration for transformer account data verification system as claimed in claim 1, it is characterized in that, comprising:

Gathered respectively by interface and store and equipment account non-standard information in the station equipment account information in work of transformer substation station and power station, be sent to server and store;

Equipment account standard information and station equipment account non-standard information in acquisition station, and adopt character string forms to encode to the information obtained;

Adopt the mode of character one to one to mate the substation information in the station equipment account non-standard information after coding with the substation information in station equipment account standard information, and then checking data is shunted;

On the basis of substation information coupling, according to the belonging relation of transformer station and the transformer preset, the transformer account list under the corresponding transformer station of inquiry acquisition;

Adopt the mode of character match one to one to carry out the comparison of transformer attribute to the transformer account list obtained, obtain the transformer account information that matching degree value is different; The transformer of same matching degree value is divided in same class transformer; Store of a sort transformer account information with the form of account correspondence table, and terminate transformer account data check.

5. method of calibration as claimed in claim 4, it is characterized in that, equipment account standard information and station equipment account non-standard information in acquisition station, and after the process adopting the information of character string forms to acquisition to encode, station equipment account standard information and station equipment account non-standard information are the character string of digital form.

6. method of calibration as claimed in claim 4, is characterized in that, the belonging relation of the transformer station that described basis is preset and transformer, and the process of the transformer account list that inquiry obtains under corresponding transformer station is:

The transformer station preset and the belonging relation of transformer are that the transformer belonging in a transformer station is all associated with this transformer station;

Building with substation information is root node, the tree of the cotyledon being root node with the transformer information belonging in transformer station;

Obtain substation information, the tree according to building carries out inquiring about and obtains the transformer account list under corresponding transformer station.

7. method of calibration as claimed in claim 4, is characterized in that, adopts the mode of character match one to one to comprise the process that the comparison of transformer attribute is carried out in the transformer account list obtained:

First, the redundant field in transformer attribute is removed;

Then, the transformer attribute of de-redundancy is split by character;

Finally, the character after segmentation is carried out comparison one by one, and calculates the matching degree value of transformer account information.

8. method of calibration as claimed in claim 4, it is characterized in that, described transformer attribute, comprises the title of transformer, electric pressure and type.

9. method of calibration as claimed in claim 4, is characterized in that,

When in station equipment account non-standard information with station equipment account standard information, all characters are identical, then station equipment account non-standard information and station equipment account standard information are matches criteria.

10. method of calibration as claimed in claim 8, it is characterized in that, the situation of station equipment account non-standard information and station equipment account standard information matches criteria, comprising:

Station equipment account non-standard information contains identical character with in station equipment account standard information and character sequence is consistent;

Station equipment account non-standard information contains identical character with in station equipment account standard information and but character sequence is inconsistent.