Establishing communication stream with database control agent over which database commands are dispatched for execution against database

Patent metadata

Field	Value
Publication number	US-12591699-B2
Application number	US-202318102751-A
Country	US
Kind code	B2
Filing date	Jan 29, 2023
Priority date	Jan 29, 2023
Publication date	Mar 31, 2026
Grant date	Mar 31, 2026

Abstract

Management program code is executable by a management server on a management network to perform processing. The processing includes establishing a communication stream with a database control agent for a database on a database network separate from the management network, without opening any ports on the database network for access by the management program code. The processing includes receiving a database command for the database from client program code, and dispatching the database command to the database control agent over the communication stream for execution against the database. The processing includes receiving execution results of the database command from the database control agent over the communication stream, and returning the execution results to the client program code in satisfaction of the database command.

First claim

We claim:

1 . A non-transitory computer-readable data storage medium storing management program code executable by a management server on a management network to perform processing comprising:
establishing a first communication stream with a first database control agent for a first database on a first database network separate from the management network, without opening any ports on the first database network for access by the management program code; instantiating a first publication/subscription channel associated with the first database and subscribing the first database control agent to the first publication/subscription channel; receiving a first database command for the first database from first client program code; publishing the first database command to the first publication/subscription channel, wherein publication causes dispatch of the first database command to the first database control agent over the first communication stream, for execution against the first database; receiving execution results of the first database command from the first database control agent over the first communication stream; returning the execution results to the first client program code in satisfaction of the first database command; establishing a second communication stream with a second database control agent for a second database on a second database network separate from the management network, without opening any ports on the second database network for access by the management program code; instantiating a second publication/subscription channel associated with the second database and subscribing the second database control agent to the second publication/subscription channel; receiving a second database command for the second database from second client program code; and publishing the second database command to the second publication/subscription channel, wherein publication causes dispatch of the second database command to the second database control agent over the second communication stream, for execution against the second database.

2 . The non-transitory computer-readable data storage medium of claim 1 , wherein establishing the first communication stream with the first database control agent comprises receiving initiation of the first communication stream by the first database control agent over a Google Remote Procedure Call (gRPC) framework.

3 . The non-transitory computer-readable data storage medium of claim 2 , wherein receiving the first database command comprises receiving the first database command over a representational state transfer (REST) application programming interface (API),
and wherein returning the execution results comprises returning the execution results over the REST API.

4 . The non-transitory computer-readable data storage medium of claim 1 , wherein the first database command comprises a database query language (DQL) command to query the first database, or a data control language (DCL) to manage the first database.

5 . The non-transitory computer-readable data storage medium of claim 1 , wherein the management network comprises a public network over which partial management of the first database occurs, and the database network comprises a private network on which the first database is hosted.

6 . The non-transitory computer-readable data storage medium of claim 1 , wherein the processing further comprises:
upon establishing the first communication stream, adding the first database control agent to an agent map; upon receiving the first database command, storing the first database command within a command queue; periodically polling the command queue to identify that the first database command has been newly stored within the command queue; upon identifying that the first database command has been newly stored within the command queue, retrieving the first database command from the command queue without removing the database command from the command queue; and upon retrieval of the database command from the command queue, identifying within the agent map the first database control agent for the first database to which the first database command pertains for dispatch of the first database command.

7 . The non-transitory computer-readable data storage medium of claim 6 , wherein the processing further comprises:
upon receiving the execution results, identifying within the command queue the database command to which the execution results pertain for returning the execution results to the first client program code from which the identified first database command was received; and removing the first database command from the command queue.

8 . The non-transitory computer-readable data storage medium of claim 6 , wherein the processing further comprises:
storing the second database command within the command queue; periodically polling the command queue to identify that the second database command has been newly stored within the command queue; retrieving the second database command from the command queue without removing the second database command from the command queue; identifying within the agent map whether there is the second database control agent for the second database to which the second database command pertains for dispatch of the second database command; and in response to identifying within the agent map that there is no second database control agent for the second database to which the second database command pertains for dispatch of the second database command, maintaining the second database command within the command queue.

9 . The non-transitory computer-readable data storage medium of claim 8 , wherein the processing further comprises:
adding the second database control agent to the agent map; upon adding the second database control agent to the agent map, identifying that the command queue stores the second database command for the second database to which the second database control agent pertains; upon identifying that the command queue stores the second database command for the second database to which the second database control agent pertains, retrieving the second database command from the command queue without removing the second database command from the command queue; and wherein the second database command is published to the second publication/subscription channel upon retrieval of the second database command from the command queue.

10 . The non-transitory computer-readable data storage medium of claim 9 , wherein the processing further comprises:
receiving second execution results of the second database command from the second database control agent over the second communication stream; upon receiving the second execution results, identifying within the command queue the second database command to which the second execution results pertain; returning the second execution results to the client second program code from which the identified second database command was received in satisfaction of the second database command; and removing the second database command from the command queue.

11 . The non-transitory computer-readable data storage medium of claim 1 , wherein the processing further comprises:
storing the first database command within a command queue.

12 . The non-transitory computer-readable data storage medium of claim 11 , wherein the processing further comprises:
upon receiving the execution results, identifying the first database command to which the execution results pertain within the command queue for returning the execution results to the first client program code from which the identified first database command was received; and removing

Assignees

• Micro Focus Llc

Inventors

• He Xiaojing
• Christensen Daniel L

Classifications

• G06F16/21 Primary

  Design, administration or maintenance of databases · CPC title

• G06F2221/2115

  Third party · CPC title

• G06F16/252

  between a Database Management System and a front-end application · CPC title

• G06F21/6227

  where protection concerns the structure of data, e.g. records, types, queries · CPC title

• G06F21/6218 Primary

  to a system of files or objects, e.g. local or distributed file system or database · CPC title