Measuring point mapping method for SCADA (supervisory control and data acquisition) system and related device

Abstract

The invention belongs to the technical field of new energy management systems, and discloses a measuring point mapping method for an SCADA system and a related device, and the method comprises the steps: classifying all devices in a new energy station based on the types of the devices in the new energy station, and obtaining a device classification result; determining standard measuring point description keywords of different equipment categories based on an equipment classification result; establishing a measuring point mapping template based on the standard measuring point numbers and the standard measuring point description keywords of different equipment categories; based on the measuring point mapping template, matching the actual measuring point name with the standard measuring point number, establishing a mapping relation between the actual measuring point and the standard measuring point number, and obtaining a measuring point mapping result; according to the method, automatic matching of the actual measuring point name and the standard measuring point number is realized, the tedious process of manual one-by-one matching is avoided, the error rate is effectively reduced, the data accuracy is improved, and reliable guarantee is provided for stable operation and accurate data analysis of a new energy station SCADA system.

Description

TECHNICAL FIELD

[0001] The present application belongs to the technical field of new energy management system, and particularly relates to a measurement point mapping method for a SCADA system and a related device. BACKGROUND

[0002] With the continuous expansion of the scale of the new energy industry, the scale of wind farms and photovoltaic power stations is also continuously expanding, and the number of various types of equipment and components in the station is showing a very growing trend. In a new energy station, each device or component covers a large amount of measurement point information. However, due to the influence of different manufacturers, various equipment models and different installation units, the naming methods of the measurement points are different and lack of unified standards, which brings serious challenges to the Supervisory Control And Data Acquisition (SCADA) system of the new energy station and greatly hinders the unified management and data analysis of the system.

[0003] At present, in the actual operation of the new energy station, the corresponding matching between the actual measurement points and the standard measurement points is mainly completed by manual operation. However, the traditional manual operation method has the problems of large workload, high error rate and uncertainty. Specifically, with the massive increase in the number of measurement points, the workload of manual matching becomes extremely large, which requires a large amount of time and labor cost. On the other hand, manual operation is inevitably affected by subjective factors, and human errors are extremely easy to occur, which leads to a decrease in data accuracy and seriously affects the operation efficiency of the entire system. SUMMARY

[0004] In view of the technical problems in the prior art, the present application provides a measurement point mapping method for a SCADA system and a related device to solve the technical problems of large workload, high error rate and uncertainty of the traditional manual operation method.

[0005] To achieve the above-mentioned purposes, the technical solution adopted by the present application is as follows: The present application provides a measurement point mapping method for a SCADA system, comprising: classifying all the devices in the new energy station based on the device types in the new energy station to obtain a device classification result; determining standard measurement point description keywords for different device categories based on the device classification result; establishing a measurement point mapping template based on the standard measurement point numbers and the standard measurement point description keywords for different device categories; matching the actual measurement point names with the standard measurement point numbers based on the measurement point mapping template to establish a mapping relationship between the actual measurement points and the standard measurement point numbers, and obtaining a measurement point mapping result.

[0006] Further, the measurement point mapping template includes a standard measurement point number, standard measurement point description information and a standard measurement point description keyword.

[0007] Further, based on the measurement point mapping template, the actual measurement point name is matched with the standard measurement point number, a mapping relationship between the actual measurement point and the standard measurement point number is established, and a process of obtaining a measurement point mapping result includes: Based on the edit distance between the actual measurement point name and the standard measurement point number, the string similarity of the actual measurement point name and each standard measurement point number in the measurement point mapping template is calculated to obtain a string similarity calculation result of the actual measurement point name. The string similarity calculation result of the actual measurement point name is compared with a preset similarity matching threshold. If the string similarity of the actual measurement point name and a certain standard measurement point number in the measurement point mapping template is greater than the preset similarity matching threshold, a mapping relationship between the actual measurement point and the corresponding standard measurement point number is established.

[0008] Further, based on the edit distance between the actual measurement point name and the standard measurement point number, the string similarity of the actual measurement point name and each standard measurement point number in the measurement point mapping template is calculated to obtain a string similarity calculation result of the actual measurement point name.

[0009] Wherein, The string similarity calculation result of the actual measurement point name is calculated. The edit distance between the actual measurement point name and the standard measurement point number is calculated. The actual measurement point name is calculated. The standard measurement point number is calculated. The string length of the actual measurement point name is calculated. The string length of the standard measurement point number is calculated.

[0010] Further, before the actual measurement point name is matched with the standard measurement point number based on the measurement point mapping template, a mapping relationship between the actual measurement point and the standard measurement point number is established, and a measurement point mapping result is obtained, further including: Using regular expression technology, the actual measurement point is keyword screened to filter the actual measurement points that are completely irrelevant to the keyword.

[0011] Further, the actual measurement point includes an actual measurement point name and actual measurement point description information.

[0012] The application also provides a measurement point mapping system for a SCADA system, including: A device classification module is configured to classify all devices in a new energy station based on the type of the devices in the new energy station to obtain a device classification result. The keyword extraction module is configured to determine standard measurement point description keywords of different device categories based on the device classification results. The mapping template construction module is configured to establish a measurement point mapping template based on the standard measurement point numbers and the standard measurement point description keywords of different device categories. The mapping relationship matching module is configured to match the actual measurement point names with the standard measurement point numbers based on the measurement point mapping template, establish a mapping relationship between the actual measurement point and the standard measurement point number, and obtain a measurement point mapping result.

[0013] The present application also provides an electronic device, comprising: A processor adapted to execute a computer program; A computer readable storage medium having a computer program stored therein, wherein the computer program is executed by the processor to implement the measurement point mapping method for a SCADA system.

[0014] The present application also provides a computer readable storage medium having a computer program stored therein, wherein the computer program is executed by the processor to implement the measurement point mapping method for a SCADA system.

[0015] The present application also provides a computer program product comprising a computer program, wherein the computer program is executed by the processor to implement the measurement point mapping method for a SCADA system.

[0016] Compared with the prior art, the present application has the following advantages: The measurement point mapping method for a SCADA system provided by the present application determines standard measurement point description keywords based on the device classification results of all devices in a new energy station, and then establishes a measurement point mapping template according to the standard measurement point description keywords. The automatic matching of the actual measurement point names and the standard measurement point numbers is realized through the established measurement point mapping template, which avoids the tedious process of manual matching one by one, greatly reduces the interference of human factors, effectively reduces the error rate, improves the data accuracy, and provides reliable protection for the stable operation and accurate data analysis of the SCADA system of the new energy station.

[0017] The measurement point mapping system for a SCADA system, the electronic device, the computer readable storage medium and the computer program product provided by the present application have all the advantages of the measurement point mapping method for a SCADA system described above. BRIEF DESCRIPTION OF DRAWINGS

[0018] In order to make the technical problems solved in the application, the technical solutions and beneficial effects clearer, the technical solutions in the embodiments of the application will be clearly and completely described below with reference to the drawings in the embodiments of the application. Obviously, the described embodiments are only some of the embodiments of the application, not all the embodiments. Based on the embodiments in the application, all other embodiments obtained by those of ordinary skill in the art without creative work fall within the protection scope of the application.

[0019] Figure 1 A flowchart of a measurement point mapping method for a SCADA system is provided for Embodiment 1. Figure 2 A structural block diagram of a measurement point mapping system for a SCADA system is provided for Embodiment 2. Figure 3 A structural block diagram of an electronic device is provided for Embodiment 3. DETAILED DESCRIPTION

[0020] In order to make the technical problems solved in the application, the technical solutions and beneficial effects clearer, the technical solutions in the embodiments of the application will be clearly and completely described below with reference to the drawings in the embodiments of the application. Obviously, the described embodiments are only some of the embodiments of the application, not all the embodiments. Based on the embodiments in the application, all other embodiments obtained by those of ordinary skill in the art without creative work fall within the protection scope of the application.

[0021] The application provides a measurement point mapping method for a SCADA system, comprising the following steps: Step 100, classifying all devices in a new energy station based on the device types in the new energy station, to obtain a device classification result.

[0022] Step 200, determining standard measurement point description keywords of different device categories based on the device classification result.

[0023] Step 300, establishing a measurement point mapping template based on the standard measurement point numbers and the standard measurement point description keywords of different device categories.

[0024] Step 400, matching actual measurement point names with standard measurement point numbers based on the measurement point mapping template, establishing a mapping relationship between actual measurement points and standard measurement point numbers, and obtaining a measurement point mapping result.

[0025] The point mapping method for the SCADA system provided by the application determines standard point description keywords based on device type classification, establishes a point mapping template, and standardizes the matching between actual point names and standard point numbers, thereby realizing unified management of points, greatly reducing the workload of manual operation, improving work efficiency, and reducing labor and time costs. At the same time, the standardized point mapping template is used for matching, avoiding the subjectivity and uncertainty of manual operation, reducing human errors, thereby improving the accuracy of data and ensuring stable and efficient operation of the entire SCADA system.

[0026] The point mapping method for the SCADA system provided by the application is further explained below with some specific embodiments: Embodiment 1 As shown in the accompanying Figure 1 The embodiment 1 provides a point mapping method for the SCADA system, which includes the following steps: Step 1, based on the device type in the new energy station, all devices in the new energy station are classified to obtain the device classification result. The device classification result is used as the basic dimension data for matching and matching between the actual point name and the standardized point number, and the device classification result is, for example, a fan, a photovoltaic panel, an inverter, and a booster station.

[0027] Step 2, according to the device classification result, the standard point description keywords of different device categories are determined.

[0028] Specifically, based on the device classification result, the keywords in the standard point description corresponding to the device category are obtained, i.e. the keywords corresponding to the standard point number are determined, and the standard point description keywords of different device categories are obtained; for example, the standard point number ZS, the standard point description information is the rotating speed, and the keywords are rotating speed, speed or RPM; for example, the standard point number FDGL, the standard point description information is the power generation power, and the keywords are power or output power; for example, the standard point number WD, the standard point description information is the temperature, and the keywords are temperature or heat.

[0029] Step 3, based on the standard point number and the standard point description keywords of different device categories, a point mapping template is established. The point mapping template includes the standard point number, the standard point description information and the standard point description keywords; preferably, the point mapping template is stored in a preset database to form an information dictionary library for matching the standard point number with the actual point in the preset data, which is used for the process of matching the actual point name with the standard point number in step 4.

[0030] Step 4, based on the mapping template of the measuring point, the actual measuring point name is matched with the standard measuring point number, the mapping relationship between the actual measuring point and the standard measuring point number is established, and the mapping result of the measuring point is obtained. Among them, the actual measuring point includes the actual measuring point name and the actual measuring point description information.

[0031] Specifically, the process is as follows: Step 41, using regular expression technology, the actual measuring point is keyword screened to filter the actual measuring point which is completely not interested in the keyword. For example, when the measuring point related to the fan blade is obtained, the regular expression containing the keyword of the blade, the rotating speed or the temperature can be set, and the actual measuring point is keyword screened based on the regular expression containing the keyword of the blade, the rotating speed or the temperature, that is, other completely irrelevant actual measuring points such as tower or gear box can be excluded, so that the data amount of subsequent matching processing is greatly reduced, and the measuring point matching process is more efficient.

[0032] Step 42, based on the edit distance of the actual measuring point name and the standard measuring point number, the string similarity of the actual measuring point name and each standard measuring point number in the mapping template of the measuring point is calculated, and the string similarity calculation result of the actual measuring point name is obtained. The calculation process of the string similarity calculation result of the actual measuring point name is as follows:

[0033] Among them, is the string similarity calculation result of the actual measuring point name; is the edit distance of the actual measuring point name and the standard measuring point number; is the actual measuring point name; is the standard measuring point number; is the string length of the actual measuring point name; is the string length of the standard measuring point number.

[0034] Step 42, the string similarity calculation result of the actual measuring point name is compared with the preset similarity matching threshold. Specifically, the string similarity calculation result of the actual measuring point name is compared with the preset similarity matching threshold.

[0035] Step 43, if the string similarity of the actual measuring point name and the standard measuring point number in the mapping template of the measuring point is greater than the preset similarity matching threshold, the mapping relationship between the actual measuring point and the corresponding standard measuring point number is established; if the string similarity of the actual measuring point name and each standard measuring point number in the mapping template of the measuring point is less than the preset similarity matching threshold, the actual measuring point is not consistent with each standard measuring point number in the mapping template of the measuring point.

[0036] Step 5, display the remaining actual point names and point mapping results, and based on the preset editing function, batch manual matching of the remaining actual point names or batch manual adjustment of the point mapping results. Among them, the remaining actual point names are actual point names that are not mapped to any standard point number suggestion mapping relationship in the point mapping template; it should be noted that the process of manually matching the remaining actual point names is similar to the existing point matching process, which will not be repeated here.

[0037] Example: The following takes the point mapping process of a SCADA system in a new energy station as an example; among them, the point mapping template and actual point information in the example new energy station are shown in Tables 1-2.

[0038] Table 1 Point mapping template in example new energy station

[0039] Table 2 Actual point information in example new energy station

[0040] Next, based on the point mapping template, the actual point name is matched with the standard point number to establish the mapping relationship between the actual point and the standard point number, and the point mapping result is obtained; among them, the point mapping result in the example new energy station is shown in Table 3.

[0041] Table 3 Point mapping result in example new energy station

[0042] As can be seen from Table 3, Table 3 gives the mapping relationship matching result of the actual point and the standard point number; among them, more than the threshold value represents that the current actual point corresponds to the standard point. Below the threshold value represents that the current point does not match the standard point number.

[0043] After that, the remaining actual point names and point mapping results are displayed, and based on the preset editing function, batch manual matching of the remaining actual point names is performed; among them, the batch manual matching result is shown in Table 4.

[0044] Table 4 Batch manual matching result

[0045] The point mapping method for the SCADA system described in this embodiment 1 is based on the device type of the new energy station, obtains all the device or component categories possessed by the new energy station, obtains the device classification result, and the device classification result will be used as the basic dimension data for matching and comparison later; based on the device classification result, the keywords in the point description corresponding to the category are obtained respectively, and the keyword information that needs to be matched for the standard point number is determined; then, based on the standard point number and the keyword information, a point mapping template is constructed and saved in the database to obtain the information dictionary library of the standard point number matching the actual point, which is convenient for subsequent automatic matching; then, using regular expression technology, the actual point is screened for keywords to filter out actual points with completely irrelevant keywords; then, the string similarity calculation result of the actual point name is compared with the preset similarity matching threshold value, if the string similarity calculation result of the actual point name is greater than the preset similarity matching threshold value, it means that the current actual point is consistent with the standard point number, and the corresponding relationship between the two is established; if the string similarity calculation result of the actual point name is less than the preset similarity matching threshold value, it means that the current actual point is not consistent with the standard point number, and then other actual points are matched.

[0046] Embodiment 2 As shown in the accompanying drawings, Figure 2 The embodiment 2 provides a point mapping system for a SCADA system, which includes a device classification module, a keyword extraction module, a mapping template construction module, a mapping relationship matching module and a manual adjustment module.

[0047] The device classification module is used to classify all the devices in the new energy station based on the device type in the new energy station, and obtain the device classification result; the keyword extraction module is used to determine the standard point description keywords of different device categories based on the device classification result; the mapping template construction module is used to establish a point mapping template based on the standard point number and the standard point description keywords of different device categories; the mapping relationship matching module is used to match the actual point name with the standard point number based on the point mapping template, establish the mapping relationship between the actual point and the standard point number, and obtain the point mapping result; the manual adjustment module is used to display the remaining actual point names and the point mapping result, and based on the preset editing function, batch manual matching of the remaining actual point names or batch manual adjustment of the point mapping result.

[0048] Optionally, the mapping relationship matching module is specifically used to: utilize regular expression technology to perform keyword filtering on actual test points to filter out actual test points that are completely irrelevant to the keywords; calculate the string similarity between the actual test point name and each standard test point number in the test point mapping template based on the edit distance between the actual test point name and the standard test point number, and obtain the string similarity calculation result of the actual test point name; compare the string similarity calculation result of the actual test point name with a preset similarity matching threshold; if the string similarity between the actual test point name and a certain standard test point number in the test point mapping template is greater than the preset similarity matching threshold, then a mapping relationship between the actual test point and the corresponding standard test point number is established; if the string similarity between the actual test point name and each standard test point number in the test point mapping template is less than the preset similarity matching threshold, then the actual test point and each standard test point number in the test point mapping template are inconsistent.

[0049] Example 3 As attached Figure 3 As shown, this embodiment 3 provides an electronic device, including: a memory for storing a computer program; a processor for executing the computer program to implement the steps of the measurement point mapping method for a SCADA system; or, the processor for executing the computer program to implement the functions of each module in the measurement point mapping system for a SCADA system described above.

[0050] For example, the computer program may be divided into one or more modules / units, which are stored in the memory and executed by the processor to complete the present invention. The one or more modules / units may be a series of computer program instruction segments capable of performing a preset function, the instruction segments describing the execution process of the computer program in the electronic device.

[0051] The electronic device may be a desktop computer, laptop, handheld computer, or cloud server, etc. The electronic device may include, but is not limited to, a processor and memory. Those skilled in the art will understand that the above are examples of electronic devices and do not constitute a limitation on the electronic device. It may include more components than described above, or combine certain components, or different components. For example, the electronic device may also include a communication interface, input / output devices, network access devices, and a bus.

[0052] The processor can be a central processing unit, and can also be other general-purpose processors, digital signal processors, application-specific integrated circuits, programmable logic devices, discrete gates or transistor logic components, discrete hardware components, or the like. The general-purpose processor can be a microprocessor or the processor can also be any conventional processor or the like, which is the control center of the electronic device and connects all parts of the electronic device through various communication interfaces and lines.

[0053] The memory can be used to store the computer programs and / or modules, and the processor realizes various functions of the electronic device by running or executing the computer programs and / or modules stored in the memory, and calling the data stored in the memory.

[0054] The memory can mainly include a program storage area and a data storage area, wherein the program storage area can store an operating system, at least one application program required for a function (such as a sound playing function, an image playing function, etc.), and the like; and the data storage area can store data created according to the use of the mobile phone (such as audio data, a phone book, etc.), and the like. In addition, the memory can include a high-speed random access memory, and can also include a non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a smart memory card, a secure digital card, a flash memory card, at least one disk storage device, a flash memory device, or other volatile solid-state memory devices.

[0055] Embodiment 4 The embodiment 4 also provides a computer readable storage medium, which stores a computer program, and the computer program is executed by a processor to realize the steps of the point mapping method for a SCADA system.

[0056] The modules / units of the point mapping system for a SCADA system are stored in a computer readable storage medium if they are realized in the form of software function units and sold or used as independent products.

[0057] Based on such understanding, the present application realizes all or part of the processes of the point mapping method for a SCADA system, and can also be completed by a computer program instructing related hardware, the computer program can be stored in a computer readable storage medium, and the computer program is executed by a processor to realize the steps of the point mapping method for a SCADA system. The computer program includes computer program codes, which can be in the form of source codes, object codes, executable files or preset intermediate forms, etc.

[0058] The computer readable storage medium can include any entity or device capable of carrying the computer program code, recording medium, U disk, mobile hard disk, magnetic disk, optical disk, computer memory, read-only memory, random access memory, electrical carrier signal, telecommunication signal, software distribution medium, etc.

[0059] Embodiment 5 Embodiment 5 provides a computer product, which includes a computer program stored in a computer readable storage medium; a processor of an electronic device reads the computer program from the computer readable storage medium, and the processor executes the computer program so that the electronic device can perform the measurement point mapping method for SCADA system described in embodiment 1, which will not be repeated here.

[0060] It should be noted that those skilled in the art can understand that all or part of the processes in the above-mentioned embodiments can be completed by a computer program instructing related hardware, and the program can be stored in a computer readable storage medium, and when the program is executed, it can include the processes of the above-mentioned embodiments.

[0061] The measurement point mapping method for SCADA system provided by the present application effectively solves the problem of consuming a large amount of time and manpower caused by manually corresponding the actual measurement points and the standard measurement point numbers, and significantly improves the efficiency and accuracy of mapping the actual measurement points and the standard point numbers; specifically, a measurement point mapping template is created to describe the related matching information of the actual measurement points that the standard measurement point numbers may correspond to; then, based on the measurement point mapping template, all actual measurement points and standard point numbers are automatically matched; and the matched results are displayed through the interface, which facilitates batch manual adjustment according to the actual situation, fundamentally reduces the workload and improves the accuracy, and has strong engineering application and promotion value.

[0062] The above-mentioned embodiments are only one of the implementation manners of the technical solutions of the present application, and the scope of protection of the present application is not limited to the above-mentioned embodiments, but also includes any changes, substitutions and other implementation manners easily thought by those skilled in the art within the technical scope disclosed by the present application.

Claims

1. A measurement point mapping method for SCADA systems, characterized in that, include: Based on the equipment types in new energy power stations, all equipment in new energy power stations is classified to obtain equipment classification results; Based on the equipment classification results, determine the standard measurement point description keywords for different equipment categories; A measurement point mapping template is established based on standard measurement point numbers and standard measurement point description keywords for different equipment categories; Based on the measurement point mapping template, the actual measurement point name is matched with the standard measurement point number to establish a mapping relationship between the actual measurement point and the standard measurement point number, and the measurement point mapping result is obtained.

2. The measurement point mapping method for a SCADA system according to claim 1, characterized in that, The measurement point mapping template includes the standard measurement point number, standard measurement point description information, and standard measurement point description keywords.

3. The measurement point mapping method for a SCADA system according to claim 1, characterized in that, Based on the measurement point mapping template, the process of matching actual measurement point names with standard measurement point numbers to establish a mapping relationship between actual measurement points and standard measurement point numbers, and obtaining the measurement point mapping results, includes: Based on the edit distance between the actual measurement point name and the standard measurement point number, the string similarity between the actual measurement point name and each standard measurement point number in the measurement point mapping template is calculated to obtain the string similarity calculation result of the actual measurement point name. The string similarity calculation result of the actual measurement point name is compared with the preset similarity matching threshold; If the string similarity between the actual measurement point name and a standard measurement point number in the measurement point mapping template is greater than the preset similarity matching threshold, then a mapping relationship between the actual measurement point and the corresponding standard measurement point number is established.

4. The measurement point mapping method for a SCADA system according to claim 1, characterized in that, The process of calculating the string similarity between the actual measurement point name and each standard measurement point number in the measurement point mapping template, based on the edit distance between the actual measurement point name and the standard measurement point number, and obtaining the string similarity calculation result of the actual measurement point name is as follows: in, The result of string similarity calculation for the actual measurement point names; This is the edit distance between the actual measurement point name and the standard measurement point number; The actual name of the measuring point; Standard measurement point numbering; The length of the string representing the actual measurement point name; The length of the string representing the standard measurement point number.

5. A measurement point mapping method for a SCADA system according to claim 3, characterized in that, Based on the measurement point mapping template, the actual measurement point names are matched with the standard measurement point numbers to establish a mapping relationship between the actual measurement points and the standard measurement point numbers. Before obtaining the measurement point mapping results, the process also includes: Regular expression techniques are used to filter actual test points by keywords, thereby filtering out actual test points with completely irrelevant keywords.

6. The measurement point mapping method for a SCADA system according to claim 1, characterized in that, The actual measurement point includes the actual measurement point name and actual measurement point description information.

7. A measurement point mapping system for SCADA systems, characterized in that, include: The equipment classification module is used to classify all equipment in a new energy power station based on the equipment type in the station, and obtain the equipment classification results. The keyword extraction module is used to determine standard measurement point description keywords for different equipment categories based on the equipment classification results. The mapping template building module is used to create a measurement point mapping template based on the standard measurement point number and standard measurement point description keywords of different equipment categories; The mapping relationship matching module is used to match the actual measurement point name with the standard measurement point number based on the measurement point mapping template, establish the mapping relationship between the actual measurement point and the standard measurement point number, and obtain the measurement point mapping result.

8. An electronic device, characterized in that, include: A processor is used to execute computer programs; A computer-readable storage medium storing a computer program, which, when executed by the processor, performs the measurement point mapping method for a SCADA system as described in any one of claims 1-6.

9. A computer-readable storage medium storing a computer program, characterized in that, When the computer program is executed by the processor, it implements the measurement point mapping method for a SCADA system as described in any one of claims 1-6.

10. A computer program product, characterized in that, The computer program product includes a computer program that, when executed by a processor, implements the measurement point mapping method for a SCADA system as described in any one of claims 1-6.

Images