Unlock instant, AI-driven research and patent intelligence for your innovation.

A real-time database data interaction method and system based on microservices

A data interaction and microservice technology, applied in database management systems, transmission systems, structured data retrieval, etc., can solve problems such as inability to provide RESTful interfaces, complex debugging and deployment processes, and low development efficiency, to ensure data access efficiency, The effect of improving development efficiency and simplifying the process

Active Publication Date: 2022-07-22
NR ELECTRIC CO LTD +1
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] In the power industry, since the transmission rate of electric energy in the power grid is the speed of light, the monitoring of the power grid operation status requires fast data processing methods. Conventional power monitoring programs need to cache data in real-time databases in order to process data efficiently and quickly. , for data acquisition, processing and calculation programs, the SQL interface is used to access the real-time library. However, for the front-end program of human-computer interaction, the current mainstream efficient interaction method is the RESTful interface, but the current real-time library cannot provide the RESTful interface, which causes human-computer interaction. Computer-interactive applications must convert the data into the format required by the front-end interface by calling the SQL interface, and then transfer it to the front-end. There are many links in the middle, the development efficiency is low, the debugging and deployment process is complicated, and it cannot meet the frequent changes in the requirements of the front-end interface.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • A real-time database data interaction method and system based on microservices
  • A real-time database data interaction method and system based on microservices
  • A real-time database data interaction method and system based on microservices

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0069] This embodiment introduces a real-time database data interaction method based on microservices. Refer to figure 1 ,include:

[0070] Receive an external REST interface request, where the external REST interface request includes a real-time database access request embedded with an SQL statement in the message body;

[0071] Parse the http header of the external REST interface request to determine whether the external REST interface request is a real-time database access request with access rights;

[0072] In response to the external REST interface request being a real-time database access request with access rights, forward the real-time database access request to a started access request execution microservice instance according to the preset allocation strategy; the access request executes the microservice instance of the microservice instance. The quantity is at least one;

[0073] Execute the microservice instance through the access request to parse the message bo...

Embodiment 1-1

[0076] This embodiment specifically introduces an implementation manner of Embodiment 1, and on the basis of Embodiment 1, it also involves authentication of the user identity of the requesting party, that is, authentication.

[0077] The method of this embodiment includes the following aspects:

[0078] 1. Receiving and parsing external REST access requests

[0079] This part of the content can be implemented using service gateway technology.

[0080] Only consider that the external access request type is a real-time database access request, and does not consider the case where the access frequency is too high due to user misoperation: After receiving and parsing the http header of the external REST interface request, obtain the identity information of the requester, if the requester If the identity information includes user identity information, the search matches the currently logged-in user identity information. If the match is successful, the external REST interface requ...

Embodiment 2

[0121] Based on the same inventive concept as Embodiment 1 and Embodiment 1-1, this embodiment introduces a real-time database data interaction system based on microservices. Refer to figure 1 , the system includes a service gateway module and an access request execution microservice instance; the number of the access request execution microservice instance is at least one;

[0122] The service gateway module receives the external REST interface request, parses the http header of the external REST interface request, and determines whether the external REST interface request is a real-time database access request with access rights, and if so, according to the preset allocation strategy, the real-time database is allocated. The access request is forwarded to a started access request execution microservice instance; the external REST interface request includes a real-time database access request embedded with an SQL statement in the message body;

[0123] The access request exec...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a real-time database data interaction method and system based on micro-services. By embedding SQL operation requests in a REST request message body, the service gateway technology is used to realize the reception of REST access requests and the parsing of HTTP message headers, and the request The load is balanced to the access request execution microservice instance. The access request execution microservice instance parses the microservice RESTful request message, extracts the content of the SQL request, calls the real-time library SQL interface to execute, and returns the execution result. The invention can simplify the process of accessing the real-time database by the front-end of human-computer interaction, ensure the efficiency of data access, reduce the difficulty of programming, greatly improve the efficiency of front-end development, and adapt to the rapidly changing interface display requirements.

Description

technical field [0001] The invention relates to the technical field of real-time database access of an electric power dispatching automation system, in particular to a real-time database data interaction method and system based on micro-services. Background technique [0002] In the electric power industry, since the transmission rate of electric energy in the power grid is the speed of light, the monitoring of the operating status of the power grid requires fast data processing means. In order to process data efficiently and quickly, the conventional power monitoring program needs to cache the data in the real-time database. , For data acquisition, processing and computing programs, the SQL interface is used to access the real-time library. However, for the front-end program of human-computer interaction, the mainstream efficient interaction method is the RESTful interface, but the current real-time library cannot provide the RESTful interface, which causes people The compu...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/242G06F16/25H04L67/51H04L67/02
CPCG06F16/25G06F16/2433H04L67/02H04L67/51
Inventor 孙超史豪杰翟桂锋陆鑫顾全
Owner NR ELECTRIC CO LTD