Method, system, device and medium for shielding real-time database measurement point code differences

Abstract

The application discloses a method, system, device and medium for shielding differences of real-time database measuring point codes, and establishes a mapping relationship between standard codes and power station side measuring point codes through an encoding mapping database, so that a power generation group business system can directly access real-time data of the power station through the standard codes, and the power stations can also exchange data horizontally through the standard codes. Through the application, unification of various real-time database data codes of the power stations can be realized in a low-cost and low-risk manner, a standard real-time data access specification is established, and a standard horizontal data exchange channel between the power stations is established.

Description

Technical Field

[0001] This invention belongs to the field of computer server development technology, specifically relating to a method, system, device, and medium for shielding the differences in the coding of real-time database measurement points. Background Technology

[0002] The application of information technology in power plants has evolved through four stages: digital computing for power experiments, specialized business applications, power industry informatization, and management informatization. With the rapid development of information technology in power plants, various business systems and applications simultaneously provide technical support. Due to differences in manufacturers and project environments, real-time data from power plants uses different real-time databases and different real-time data codes. From the perspective of system integration and unification within power generation groups, the lack of unified data coding leads to drawbacks such as fragmented data and application architectures, information silos, difficulties in horizontal data interaction, and poor data sharing. One approach is to collect data from the power generation group and encode it uniformly, or to require all application systems to undergo data coding rectification. However, both methods impose significant enterprise costs and rectification risks on the power generation group. Summary of the Invention

[0003] The purpose of this invention is to propose a method, system, device, and medium for shielding the differences in real-time database measurement point encoding, so as to overcome the defects of the existing technology. This invention establishes a mapping relationship between standard encoding and power plant-side real-time data encoding by establishing an encoding mapping database, thereby unifying the encoding of various real-time database data in a low-cost and low-risk manner. The power generation group's business system can directly access the power plant's real-time data through the standard encoding, and power plants can also exchange data horizontally through the standard encoding.

[0004] To achieve the above objectives, the present invention adopts the following technical solution:

[0005] A method for masking differences in the coding of measurement points in a real-time database includes the following steps:

[0006] Establish standard coding rules for measurement points, wherein the standard coding rules are the correspondence between the standard codes and descriptions of measurement points;

[0007] Collect real-time database information from the power plant side, including the database type, database version, database access SDK or API tool, database username and password, and database IP address and port; develop an access interface for the real-time database from the power plant side based on the access SDK or API tool.

[0008] Create a coding mapping database, and enter the standard code, description, power station side measuring point code, power station side real-time database type and access permissions into the coding mapping database to form a one-to-one mapping relationship between the standard code and the power station side measuring point code;

[0009] Establish a measurement point data service, integrate the access interface of the power station side real-time database into the measurement point data service, and set user access permissions for measurement point data through the built-in measurement point configuration website in the measurement point data service;

[0010] When the power generation group's business system calls the measurement point data service to access the power plant's measurement point data, or when power plants exchange data horizontally by calling the measurement point data service, the system finds the corresponding power plant's measurement point code based on the mapping relationship by calling the measurement point standard code passed to the measurement point data service. Then, it verifies the access permission of the measurement point data through user information. If there is no access permission, an error is returned. If there is access permission, the measurement point data service finds the corresponding real-time database access interface in the real-time database access pool according to the type of real-time database, and finally accesses the power plant's measurement point data through the power plant's measurement point code and the corresponding real-time database access interface.

[0011] Furthermore, the description of the measurement point in the standard coding rules includes: power plant abbreviation, unit abbreviation, measurement point type, equipment abbreviation, and extended suffix.

[0012] Furthermore, the access interface of the power plant-side real-time database includes reading data snapshots, historical slice values, historical raw values, historical linear interpolation, and historical statistical values.

[0013] Furthermore, the measurement point data service can provide the power station with the function of maintaining the measurement point mapping relationship through the built-in measurement point configuration website. When the measurement point code on the power station side changes, the mapping relationship between the measurement point code on the power station side and the standard code is updated through the measurement point configuration website.

[0014] Furthermore, the maintenance functions include add, delete, modify, query, import, and export functions.

[0015] Furthermore, the power station can obtain the mapping relationship between the standard code of the measuring point and the measuring point code of the power station through the measuring point data service. When the data is abnormal, the power station's data maintenance personnel can verify the data through this mapping relationship.

[0016] A system for masking coding differences at measurement points in a real-time database includes a module for establishing standard coding rules for measurement points, a module for establishing an access interface, a module for creating a coding mapping database, a module for establishing measurement point data services, and an access module, wherein:

[0017] Standard coding rule establishment module for measuring points: used to establish standard coding rules for measuring points, wherein the standard coding rules are the correspondence between the standard codes and descriptions of measuring points;

[0018] Access Interface Establishment Module: Used to collect real-time database information from the power plant side, including the database type, database version, database access SDK or API tool, database username and password, database IP address and port; and to develop an access interface for the real-time database from the power plant side based on the access SDK or API tool.

[0019] The coding mapping database creation module is used to create a coding mapping database and enter the standard code, description, power station side measuring point code, power station side real-time database type and access permissions into the coding mapping database to form a one-to-one mapping relationship between the standard code and the power station side measuring point code.

[0020] Measurement point data service establishment module: Establish measurement point data service, integrate the access interface of the power station side real-time database into the measurement point data service, and set user access permissions for measurement point data through the built-in measurement point configuration website in the measurement point data service;

[0021] Access Module: When the power generation group's business system calls the measurement point data service to access the power plant's measurement point data, or when power plants exchange data horizontally by calling the measurement point data service, it finds the corresponding power plant's measurement point code based on the mapping relationship by calling the measurement point standard code passed in by the measurement point data service. Then, it verifies the access permission of the measurement point data through user information. If there is no access permission, an error is returned. If there is access permission, the measurement point data service finds the corresponding real-time database access interface in the real-time database access pool according to the type of real-time database, and finally accesses the power plant's measurement point data through the power plant's measurement point code and the corresponding real-time database access interface.

[0022] A computer device includes a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program to implement the steps of the method for masking real-time database measurement point coding differences.

[0023] A computer-readable storage medium storing a computer program that, when executed by a processor, implements the steps of the method for masking differences in the coding of real-time database measurement points.

[0024] Compared with the prior art, the present invention has the following beneficial technical effects:

[0025] As more and more power plants establish their own real-time systems, the drawbacks and problems caused by inconsistent measurement point coding and access will become increasingly apparent. This invention provides a low-cost, low-risk way to unify the coding of various real-time databases in power plants. It not only establishes a standard real-time data access specification but also creates a standard horizontal data exchange channel between different power plants. Attached Figure Description

[0026] The accompanying drawings are provided to further understand the invention and constitute a part of this invention. The illustrative embodiments of the invention and their descriptions are used to explain the invention and do not constitute an improper limitation of the invention.

[0027] Figure 1 This is a schematic diagram of the method flow of the present invention;

[0028] Figure 2 This is a schematic diagram of the system structure of the present invention. Detailed Implementation

[0029] The present invention will be further described in detail below with reference to the accompanying drawings and specific embodiments.

[0030] To enable those skilled in the art to better understand the present invention, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings of the embodiments of the present invention. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort should fall within the scope of protection of the present invention.

[0031] It should be noted that the terms "first," "second," etc., in the specification, claims, and accompanying drawings of this invention are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It should be understood that such data can be interchanged where appropriate so that the embodiments of the invention described herein can be implemented in orders other than those illustrated or described herein. Furthermore, the terms "comprising" and "having," and any variations thereof, are intended to cover a non-exclusive inclusion; for example, a process, method, system, product, or apparatus that comprises a series of steps or units is not necessarily limited to those steps or units explicitly listed, but may include other steps or units not explicitly listed or inherent to such processes, methods, products, or apparatus.

[0032] A method for masking differences in the coding of measurement points in a real-time database includes the following steps;

[0033] Step 1: Establish standard coding rules for measurement points. These rules define the correspondence between the standard codes and descriptions of measurement points. The standard coding rules consist of the following parts: power plant abbreviation, generator unit abbreviation, measurement point type (primary point, calculation point), equipment abbreviation, and extended suffixes.

[0034] Step 2: Collect real-time database information from the power plant side. This information includes the database type, version, access SDK or API tool, username and password, IP address, and port. Based on the access SDK or API tool, develop an access interface for the real-time database. This interface should include functions for reading data snapshots, historical slice values, historical raw values, historical linear interpolation, and historical statistical values.

[0035] Step 3: Create a coding mapping database in the group, and enter the standard code, description, power station side measuring point code, power station side real-time database type and access permissions into the coding mapping database to form a one-to-one mapping relationship between the standard code and the power station side measuring point code.

[0036] Step 4: Establish a measurement point data service within the group, integrate the access interface of the power plant side real-time database into the measurement point data service, and set user access permissions for measurement point data through the built-in measurement point configuration website in the measurement point data service.

[0037] Step 5: When the power generation group's business system calls the measurement point data service to access the power plant side measurement point data, or when power plants call the measurement point data service for horizontal data exchange, the measurement point standard code passed in by calling the measurement point data service can find the corresponding power plant side measurement point code according to the mapping relationship. Then, the access permission of the measurement point data is verified through user information. If there is no access permission, an error is returned; if there is access permission, the measurement point data service finds the corresponding real-time database access interface in the real-time database access pool according to the type of real-time database, and finally accesses the power plant side measurement point data through the power plant side measurement point code and the corresponding real-time database access interface.

[0038] When power plants exchange data horizontally, they can also directly access each other's data through the measurement point data service in the manner described above.

[0039] In addition, the measurement point data service provides the power plant with functions for maintaining the measurement point mapping relationship, including adding, deleting, modifying, querying, importing, and exporting. When measurement points on the power plant side change, such as being renamed or deleted, the mapping relationship with the standard code can be updated through the measurement point data service. The power plant can obtain the mapping relationship between the standard measurement point code and the power plant-side measurement point code through the measurement point data service. When data is abnormal, this mapping relationship can be used to verify the data.

[0040] A system for masking coding differences at measurement points in a real-time database includes a module for establishing standard coding rules for measurement points, a module for establishing an access interface, a module for creating a coding mapping database, a module for establishing measurement point data services, and an access module, wherein:

[0041] Standard coding rule establishment module for measuring points: used to establish standard coding rules for measuring points, wherein the standard coding rules are the correspondence between the standard codes and descriptions of measuring points;

[0042] Access Interface Establishment Module: Used to collect real-time database information from the power plant side, including the database type, database version, database access SDK or API tool, database username and password, database IP address and port; and to develop an access interface for the real-time database from the power plant side based on the access SDK or API tool.

[0043] The coding mapping database creation module is used to create a coding mapping database and enter the standard code, description, power station side measuring point code, power station side real-time database type and access permissions into the coding mapping database to form a one-to-one mapping relationship between the standard code and the power station side measuring point code.

[0044] Measurement point data service establishment module: Establish measurement point data service, integrate the access interface of the power station side real-time database into the measurement point data service, and set user access permissions for measurement point data through the built-in measurement point configuration website in the measurement point data service;

[0045] Access Module: When the power generation group's business system calls the measurement point data service to access the power plant's measurement point data, or when power plants exchange data horizontally by calling the measurement point data service, it finds the corresponding power plant's measurement point code based on the mapping relationship by calling the measurement point standard code passed in by the measurement point data service. Then, it verifies the access permission of the measurement point data through user information. If there is no access permission, an error is returned. If there is access permission, the measurement point data service finds the corresponding real-time database access interface in the real-time database access pool according to the type of real-time database, and finally accesses the power plant's measurement point data through the power plant's measurement point code and the corresponding real-time database access interface.

[0046] The present invention will be further described in detail below with reference to embodiments:

[0047] Establish standard codes for power station monitoring points. The specific codes are as follows:

[0048]

[0049] The two example power plants in the embodiments use the OSI PI database as their real-time database. The developers developed the corresponding data access interface based on the SDK development tools provided by the database.

[0050] Create a code mapping database within the group, and based on the standard code, enter the following information into the code mapping database:

[0051]

[0052] Set up a measurement point data service within the group and integrate the data access interface into the service. Create a new data access user named JT and add access permissions TT and DD to this user.

[0053] When the group application needs to obtain snapshot data of the load of Unit 1 of TT Power Plant, it should call the data snapshot interface in the measurement point data service. In the request header, along with the username and password, the standard code of the measurement point, TT.ET.N1ES_W_G, should be passed. The data snapshot interface will then return the latest load value of Unit 1 of TT Power Plant and the time of that value.

[0054] The two example power plants can also use JT users to access various types of data from each other in the same way, such as historical slice data, raw value data, linear interpolation, etc.

[0055] When the power plant side code changes, such as when the load code of Unit 1 of TT Power Plant is changed to TT.IN0076820, the mapping relationship of the measuring points can be updated by calling the measuring point mapping relationship maintenance function in the measuring point data service.

[0056] Those skilled in the art will understand that embodiments of the present invention can be provided as methods, systems, or computer program products. Therefore, the present invention can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, the present invention can take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0057] This invention is described with reference to flowchart illustrations and / or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, generate instructions for implementing the flowchart illustrations and / or block diagrams. Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.

[0058] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.

[0059] These computer program instructions may also be loaded onto a computer or other programmable data processing equipment to cause a series of operational steps to be performed on the computer or other programmable equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable equipment for implementing the process. Figure 1 One or more processes and / or boxes Figure 1 The steps of the function specified in one or more boxes.

[0060] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention and not to limit its scope of protection. Although the present invention has been described in detail with reference to the above embodiments, those skilled in the art should understand that after reading the present invention, they can still make various changes, modifications or equivalent substitutions to the specific implementation of the invention, but these changes, modifications or equivalent substitutions are all within the scope of protection of the pending claims of the invention.

Claims

1. A method for masking differences in the coding of measurement points in a real-time database, characterized in that, Includes the following steps: Establish standard coding rules for measurement points, wherein the standard coding rules are the correspondence between the standard codes and descriptions of measurement points; Collect real-time database information from the power plant side, including the database type, database version, database access SDK or API tool, database username and password, and database IP address and port; develop an access interface for the real-time database from the power plant side based on the access SDK or API tool. Create a coding mapping database, and enter the standard code, description, power station side measuring point code, power station side real-time database type and access permissions into the coding mapping database to form a one-to-one mapping relationship between the standard code and the power station side measuring point code; Establish a measurement point data service, integrate the access interface of the power station side real-time database into the measurement point data service, and set user access permissions for measurement point data through the built-in measurement point configuration website in the measurement point data service; When the power generation group's business system calls the measurement point data service to access the power station's measurement point data, or when power stations call the measurement point data service for horizontal data exchange, the corresponding power station's measurement point code is found based on the mapping relationship by calling the measurement point standard code passed in by the measurement point data service. Then, the access permission of the measurement point data is verified through user information. If there is no access permission, an error is returned. When access is granted, the measurement point data service finds the corresponding real-time database access interface in the real-time database access pool based on the type of real-time database, and finally accesses the power station side measurement point data through the power station side measurement point code and the corresponding real-time database access interface. The measurement point data service can provide the power station with the function of maintaining the measurement point mapping relationship through the built-in measurement point configuration website. When the measurement point code on the power station side changes, the mapping relationship between the measurement point code on the power station side and the standard code is updated through the measurement point configuration website. The maintenance functions include adding, deleting, modifying, querying, importing, and exporting functions; The description of the measurement point in the standard coding rules includes: power plant abbreviation, unit abbreviation, measurement point type, equipment abbreviation, and extended suffix; The access interface for the real-time database on the power plant side includes reading data snapshots, historical slice values, historical raw values, historical linear interpolation, and historical statistical values. The power station can obtain the mapping relationship between the standard code of the measuring point and the code of the measuring point on the power station side through the measuring point data service. When the data is abnormal, the power station's data maintenance personnel can verify the data through this mapping relationship.

2. A system for masking differences in the coding of measurement points in a real-time database, characterized in that, It includes a standard coding rule establishment module for measurement points, an access interface establishment module, a coding mapping database creation module, a measurement point data service establishment module, and an access module, among which: Standard coding rule establishment module for measuring points: used to establish standard coding rules for measuring points, wherein the standard coding rules are the correspondence between the standard codes and descriptions of measuring points; Access Interface Establishment Module: Used to collect real-time database information from the power plant side, including the database type, database version, database access SDK or API tool, database username and password, database IP address and port; and to develop an access interface for the real-time database from the power plant side based on the access SDK or API tool. The coding mapping database creation module is used to create a coding mapping database and enter the standard code, description, power station side measuring point code, power station side real-time database type and access permissions into the coding mapping database to form a one-to-one mapping relationship between the standard code and the power station side measuring point code. Measurement point data service establishment module: Establish measurement point data service, integrate the access interface of the power station side real-time database into the measurement point data service, and set user access permissions for measurement point data through the built-in measurement point configuration website in the measurement point data service; Access Module: When the power generation group's business system calls the measurement point data service to access the power plant's measurement point data, or when power plants exchange data horizontally by calling the measurement point data service, it finds the corresponding power plant's measurement point code based on the mapping relationship by calling the measurement point standard code passed in by the measurement point data service. Then, it verifies the access permission of the measurement point data through user information. If there is no access permission, an error is returned. If there is access permission, the measurement point data service finds the corresponding real-time database access interface in the real-time database access pool according to the type of real-time database, and finally accesses the power plant's measurement point data through the power plant's measurement point code and the corresponding real-time database access interface. The measurement point data service can provide the power station with the function of maintaining the measurement point mapping relationship through the built-in measurement point configuration website. When the measurement point code on the power station side changes, the mapping relationship between the measurement point code on the power station side and the standard code is updated through the measurement point configuration website. The maintenance functions include adding, deleting, modifying, querying, importing, and exporting functions; The description of the measurement point in the standard coding rules includes: power plant abbreviation, unit abbreviation, measurement point type, equipment abbreviation, and extended suffix; The access interface for the real-time database on the power plant side includes reading data snapshots, historical slice values, historical raw values, historical linear interpolation, and historical statistical values. The power station can obtain the mapping relationship between the standard code of the measuring point and the code of the measuring point on the power station side through the measuring point data service. When the data is abnormal, the power station's data maintenance personnel can verify the data through this mapping relationship.

3. A computer device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that, When the processor executes the computer program, it implements the steps of the method for masking the differences in real-time database measurement point encoding as described in claim 1.

4. A computer-readable storage medium storing a computer program, characterized in that, When the computer program is executed by the processor, it implements the steps of the method for masking the differences in real-time database measurement point encoding as described in claim 1.

Images