System and method for real-time data storage and access for grid control systems

Abstract

The application provides a system and method suitable for real-time data storage and access of a power grid regulation system, a cache is established for real-time data on a local server, a unified data storage format is established, and two query services are published through a dubbo framework, one is a cache query interface published according to application business needs, and the other is a client calling entry, which provides a routing function, judges data attribution according to an agreement mode, and calls a cache query service interface of an attribution place to complete a calling process. The method can improve query efficiency, reduce the scale of data collection of branch centers, simplify client query steps, realize remote data access, complete data collection and rapid access of all levels of data at a service level.

Description

[0001] Field of study

[0002] This invention belongs to the field of real-time data storage and access technology, and relates to a system and method for real-time data storage and access in power grid control systems. Background Technology

[0003] With the rapid development and continuous expansion of the power grid, the power grid dispatch and control system needs to record more comprehensive power equipment status, covering various equipment types such as transformers, circuit breakers, and line terminals, as well as various measurement data such as voltage values, frequency values, active power values, reactive power values, and current values. Among these, real-time characteristic data used to monitor the current operating status of the power grid are accessed most frequently.

[0004] Traditional data acquisition methods involve uploading data from power grids at all levels to branch centers according to communication protocols, whereby each branch center stores the data and provides corresponding access interfaces. However, due to differences in the construction of power grid control systems at various levels, data storage structures vary, and the continuous aggregation of data leads to an expansion in storage scale, putting pressure on storage and access. Therefore, how to alleviate storage pressure and quickly acquire real-time characteristic data from power grids at all levels has become a crucial problem that urgently needs to be solved. Summary of the Invention

[0005] Objective: To address the above-mentioned problems, this invention provides a system and method for real-time data storage and access in power grid control systems. On a local server, real-time characteristic data of cross-sections is cached, a unified data storage format is implemented, and two query services are published through the Dubbo framework. One publishes a cache query interface, while the other serves as the client's call entry point and provides routing functionality. It determines data ownership according to a pre-defined method and calls the cache query service interface of the corresponding location. This method improves query efficiency, reduces the scale of data aggregation at branch centers, simplifies client query steps, enables remote data access, and completes the aggregation of data from various regions and levels at the service level.

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

[0007] A system and method for real-time data storage and access in power grid control systems are proposed. In a local server, a memory database is used to cache real-time data. A query interface is formed according to the application business needs. The cached data query interface is published as a service through the Dubbo framework. At the same time, a Dubbo service is published as the client call entry point. This service provides routing function, calls the local service according to the data source and returns the result to complete the call process.

[0008] Furthermore, real-time data is cached on a local server, with the storage unit describing the data format of the real-time data cache storage.

[0009] Furthermore, the storage unit includes a device sampling point number, real-time data, status value, and time stamp value.

[0010] Furthermore, the device sampling point number refers to the unique identifier of the sampling point; the real-time data refers to the data value of the sampling attribute at the current moment; the status value refers to the data quality; and the timestamp value identifies the sampling time of the data value.

[0011] A system and method for real-time data storage and access in power grid control systems, characterized by comprising the following steps:

[0012] (1) The request is initiated by the client;

[0013] (2) The unified query service receives the request;

[0014] (3) Determine the source of the requested data;

[0015] (4) Compare the current location with the data source location;

[0016] (5) The real-time data service queries the cached data to obtain the results and returns them to the unified query service;

[0017] (6) The unified query service encapsulates the query results and returns them to the client;

[0018] (7) The client receives the response result.

[0019] Furthermore, on the local server, two real-time data services are published through the Dubbo framework. The first is a real-time data service that can query and retrieve stored real-time data based on device ID, device type, and measurement type parameters. The second is a unified query service that is provided for clients to call. Internally, the service can access the real-time data service through local or wide-area access, encapsulate the response results, and forward them back to the client.

[0020] Furthermore, the real-time data service provides a cached data query interface, with the input parameter being the device sampling point number and the output parameters being a floating-point data value, an integer status value, and an integer time stamp value.

[0021] Furthermore, the cached data query interface includes multiple overloaded forms:

[0022] Query real-time data for a single device sampling point;

[0023] Query real-time data from multiple device sampling points;

[0024] Query real-time data for a single sampling type of a specific device type;

[0025] Query real-time data for multiple sampling types of a specific device type.

[0026] Furthermore, the unified query service confirms the current deployment location during initialization and updates and maintains the routing table periodically. When a request is received, it determines the actual location of the data based on the routing table and request parameters, compares it with the current location, and accesses the real-time data service of the location via local or wide area mode.

[0027] Furthermore, the routing table configures the routing method and source site for device sampling data queries.

[0028] The beneficial effects of this invention are: This invention is applicable to scenarios involving distributed data storage and unified access within multiple local area networks (LANs), requiring at least one server to be able to communicate with other LANs. This invention was first used in the State Grid Corporation's "Control Cloud" real-time data platform, solving the problem of real-time data storage and access, and enabling rapid access to data from all branch centers and provincial levels across the entire network. Attached Figure Description

[0029] Figure 1 This is the overall architecture diagram of the present invention;

[0030] Figure 2 This is a diagram of the storage unit format for the real-time data cache of this invention;

[0031] Figure 3 This is a diagram of the routing table structure of the present invention;

[0032] Figure 4 This is a flowchart illustrating the client-side call process of the present invention. Detailed Implementation

[0033] The technical solution of the present invention will be further described below with reference to the accompanying drawings and embodiments.

[0034] The present invention will be further described below with reference to the accompanying drawings. The following examples are only used to more clearly illustrate the technical solution of the present invention, and should not be used to limit the scope of protection of the present invention.

[0035] like Figure 1The diagram shows the overall architecture of this invention. Taking two sites as an example, these sites can be understood as two local area networks (LANs), where only a portion of the servers can communicate with each other (at least one). Within each site, a real-time data cache is established and updated periodically; a real-time data service is published, which publishes multiple types of query interfaces to retrieve cached data based on request information; a unified query service is published, which reads the current deployment location and routing table configuration during initialization, and simultaneously publishes interfaces directly for client calls. Upon receiving a request, the service determines the location of the data to be queried based on the above information and compares it with the current location to determine whether to call the real-time data service from the data source location via local or wide-area access. Both of these services are published through the Dubbo framework, and multiple services can be published through a registry center to achieve load balancing in a clustered manner.

[0036] like Figure 2 The diagram shows the real-time data cache storage unit format of this invention, which stores the device sampling point number, real-time data value, status code, and time stamp value. The storage unit for one device sampling point is shown below:

[0037] Equipment sampling point number Real-time value status codes Time scale value 11013200000000022400002002 49.58 1073741824 1646786372

[0038] The sampling point number serves as the unique identifier for the real-time data. The real-time value represents the latest data value, the status code indicates the quality and availability of the value at that moment, and the timestamp value indicates the time information when the data entered the cache.

[0039] like Figure 3 This is the storage structure of the routing relationship table involved in the unified query service. The routing relationship table defines from which site the real-time data for a device is obtained, and consists of the following four fields: device sampling point number, routing code, routing node name, and a spare field. The sampling point number is a unique identifier for this record. The routing code is defined according to convention; for example, if the routing code is 0, the administrative division code in the point number determines the data's location; if the routing code is 1, the data source location is specified according to the configuration of the subsequent "routing node name" field. A routing relationship table record is shown below:

[0040]

[0041]

[0042] like Figure 4 The diagram illustrates the workflow of a client calling a server according to the present invention. It describes a data query process from the client initiating a request to receiving a response. The steps are as follows:

[0043] Step 1: Begin;

[0044] Step 2: The client initiates the request;

[0045] Step 3: The unified query service receives the request;

[0046] Step 4: Determine the source of the requested data based on the routing table;

[0047] Step 5: If the data source of the request parameter has been specified in the routing table, then directly obtain the source information;

[0048] Step 6: If not specified, extract the administrative division code based on the id information in the request parameters. For example, if the request parameters contain the device sampling point number "11013200000000022400002002", the administrative division code extracted from the point number is "32". In particular, if the table does not contain the relationship configuration of this request parameter, the default is the unspecified mode.

[0049] Step 7: Determine the data source location based on the administrative division code, such as "32" representing Jiangsu Province;

[0050] Step 8: Compare the current location with the data source location;

[0051] Step 9: If they are the same, then call the locally published real-time data service;

[0052] Step 10: If they are different, call the real-time data service from the source location;

[0053] Step 11: The real-time data service queries the data cache to obtain the results and returns them to the unified query service;

[0054] Step 12: The unified query service encapsulates the query results, adds a return code indicating whether the call was successful and a call log, merges the data query results, and returns them to the client.

[0055] Step 13: The client receives the response result;

[0056] Step 14: End.

[0057] Those skilled in the art will understand that embodiments of this application can be provided as methods, systems, or computer program products. Therefore, this application can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, this application 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.

[0058] This application is described with reference to flowchart illustrations and / or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of this application. 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... Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.

[0059] 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.

[0060] 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.

[0061] 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 it. Although the present invention has been described in detail with reference to the above embodiments, those skilled in the art should understand that modifications or equivalent substitutions can still be made to the specific implementation of the present invention. Any modifications or equivalent substitutions that do not depart from the spirit and scope of the present invention should be covered within the scope of protection of the claims of the present invention.

Claims

1. A system for real-time data storage and access in power grid control systems, characterized in that, On the local server, a memory database is used to cache real-time data. A query interface is formed according to the application's business needs. The cached data query interface is published as a service through the Dubbo framework. At the same time, a Dubbo service is published as the client call entry point. This service provides routing functionality, calls the local service and returns the result according to the data source, and completes the call process. On the local server, two services are published through the Dubbo framework: one is a real-time data service, which can query and retrieve stored real-time data based on device ID, device type, and measurement type parameters; the other is a unified query service, which is provided for clients to call. The service can access the real-time data service locally or in a wide area, encapsulate the response results, and forward them back to the client. The real-time data service provides a cached data query interface. The input parameter is the device sampling point number, and the output parameters are floating-point data values, integer status values, and integer timestamp values. The unified query service confirms the current deployment location during initialization and updates and maintains the routing table periodically. When a request is received, it determines the actual location of the data based on the routing table and request parameters, compares it with the current location, and accesses the real-time data service of the location through local or wide-area methods. The unified query service determines the location of the actual data based on the administrative division code in the device sampling point number.

2. The system for real-time data storage and access in a power grid control system according to claim 1, characterized in that, Real-time data is cached on the local server, and the real-time data format stored in the cache is described by the storage unit.

3. The system for real-time data storage and access in a power grid control system according to claim 2, characterized in that, The storage unit includes the device sampling point number, real-time data value, status value, and time stamp value.

4. The system for real-time data storage and access in a power grid control system according to claim 3, characterized in that, The device sampling point number refers to the unique identifier of the sampling point; the real-time data refers to the data value of the sampling attribute at the current moment; the status value refers to the data quality; and the timestamp value indicates the sampling time of the data value.

5. A method for real-time data storage and access in power grid control systems, characterized in that, Includes the following steps: (1) The request is initiated by the client; (2) The unified query service receives the request; (3) Determine the source of the requested data; (4) Compare the current location with the data source location; (5) The real-time data service queries the cached data to obtain the results and returns them to the unified query service; (6) The unified query service encapsulates the query results and returns them to the client; (7) The client receives the response result; On the local server, two services are published through the Dubbo framework: one is a real-time data service, which can query and retrieve stored real-time data based on device ID, device type, and measurement type parameters; the other is a unified query service, which is provided for clients to call. The service can access the real-time data service locally or in a wide area, encapsulate the response results, and forward them back to the client. The real-time data service provides a cached data query interface. The input parameter is the device sampling point number, and the output parameters are floating-point data values, integer status values, and integer timestamp values. The unified query service confirms the current deployment location during initialization and updates and maintains the routing table periodically. When a request is received, it determines the actual location of the data based on the routing table and request parameters, compares it with the current location, and accesses the real-time data service of the location through local or wide-area methods. The unified query service determines the location of the actual data based on the administrative division code in the device sampling point number.

6. The method for real-time data storage and access in a power grid control system according to claim 5, characterized in that, The cached data query interface includes multiple overload modes: Query real-time data for a single device sampling point; Query real-time data from multiple device sampling points; Query real-time data for a single sampling type of a specific device type; Query real-time data for multiple sampling types of a specific device type.

7. The method for real-time data storage and access in a power grid control system according to claim 5, characterized in that, The routing table configures the routing method and source site for device sampling data queries.

Images