# US 2024/0256689 A1 · Establishing communication stream with database control agent over which database commands are dispatched for execution against database

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2024/0256689 A1
- Document ID: US20240256689A1
- Status: Published application
- Kind: A1
- Application number: 18/102,751
- Filed: 2023-01-29
- Published: 2024-08-01
- Earliest claimed: 2023-01-29
- Assignees: Micro Focus LLC
- Applicants: Micro Focus LLC
- Inventors: Xiaojing He; Daniel L. Christensen
- Web page: https://patentgrep.com/patent/US20240256689A1

## CPC

- G06F 21/6218: {to a system of files or objects, e.g. local or distributed file system or database}
- G06F 16/21: Design, administration or maintenance of databases
- G06F 16/252: {between a Database Management System and a front-end application}
- G06F 21/6227: {where protection concerns the structure of data, e.g. records, types, queries}
- G06F 2221/2115: Third party
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## 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.

## Claims

### 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 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;
receiving a database command for the database from client program code;
dispatching the database command to the database control agent over the communication stream for execution against the database;
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.

### Claim 2 (depends on 1)

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

### Claim 3 (depends on 2)

The non-transitory computer-readable data storage medium of claim 2, wherein receiving the database command comprises receiving the 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.

### Claim 4 (depends on 1)

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

### Claim 5 (depends on 1)

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 database occurs, and the database network comprises a private network on which the database is hosted.

### Claim 6 (depends on 1)

The non-transitory computer-readable data storage medium of claim 1, wherein the processing further comprises:
upon establishing the communication stream, adding the database control agent to an agent map;
upon receiving the database command, storing the database command within a command queue;
periodically polling the command queue to identify that the database command has been newly stored within the command queue;
upon identifying that the database command has been newly stored within the command queue, retrieving the 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 database control agent for the database to which the database command pertains for dispatch of the database command.

### Claim 7 (depends on 6)

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 program code from which the identified database command was received; and
removing the database command from the command queue.

### Claim 8 (depends on 6)

The non-transitory computer-readable data storage medium of claim 6, wherein the communication stream is a first communication stream, the client program code is first client program code, the database command is a first database command, the database is a first database, the database control agent is a first database control agent, the database network is a first database network, and the execution results are first execution results, the processing further comprises:
receiving a second database command for a second database from second client program code;
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 a 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.

### Claim 9 (depends on 8)

The non-transitory computer-readable data storage medium of claim 8, wherein the processing further comprises, after storing the second database command within the command queue:
establishing a second communication stream with the second database control agent for the 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;
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
upon retrieval of the second database command from the command queue, dispatching the second database command to the second database control agent over the second communication stream for execution against the second database.

### Claim 10 (depends on 9)

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 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.

### Claim 11 (depends on 1)

The non-transitory computer-readable data storage medium of claim 1, wherein the processing further comprises:
upon establishing the communication stream, instantiating a publication/subscription channel associated with the database and subscribing the database control agent to the publication/subscription channel; and
upon receiving the database command, storing the database command within a command queue;
identifying that the database to which the database command pertains is associated with which the publication/subscription channel; and
upon identifying that the database is associated with the publication/subscription channel, publishing the database command to the publication/subscription channel,
wherein publication of the database command to the publication/subscription channel associated with the database to which the database command pertains causes dispatch of the database command to the database control agent that has been subscribed to the publication/subscription channel, over the communication stream.

### Claim 12 (depends on 11)

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

### Claim 13 (depends on 11)

The non-transitory computer-readable data storage medium of claim 11, wherein the communication stream is a first communication stream, the client program code is first client program code, the database command is a first database command, the database is a first database, the database control agent is a first database control agent, the database network is a first database network, the execution results are first execution results, and the publication/subscription channel is a first publication/subscription channel, the processing further comprises:
receiving a second database command for a second database from second client program code;
storing the second database command within the command queue;
identifying whether the second database to which the database command pertains is associated with any second publication/subscription channel; and
in response to identifying that the second database is not associated with any second publication/subscription channel, maintaining the second database command within the command queue.

### Claim 14 (depends on 13)

The non-transitory computer-readable data storage medium of claim 13, wherein the processing further comprises, after storing the second database command within the command queue:
establishing a second communication stream with a second database control agent for the 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;
identifying that the command queue stores the second database command for the second database with which the second publication/subscription channel is associated;
upon identifying that the command queue stores the second database command for the second database with which the second publication/subscription channel is associated, retrieving the second database command from the command queue without removing the second database command from the command queue; and
upon retrieval of the second database command from the command queue, publishing the second database command to the second publication/subscription channel,
wherein publication of the second database command to the second publication/subscription channel causes dispatch of the second database command to the second database control agent that has been subscribed to the second publication/subscription channel, over the second communication stream, for execution of the second database command against the second database.

### Claim 15 (depends on 14)

The non-transitory computer-readable data storage medium of claim 14, 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 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.

### Claim 16

A management server on a management network, comprising:
a processor; and
a memory storing management program code executable by the processor, the management program code comprising:
a plurality of dispatch program codes, each dispatch program code establishing communication streams with database control agents for databases on database networks separate from the management network, without opening any ports on the database networks for access by management program code; and
a plurality of command program codes, each command program code to receive database commands for the databases from client program codes and to return execution results to the client program codes in satisfaction of the database commands,
wherein the dispatch program codes are to dispatch the received database commands for the databases to the database control agents over the communication streams for execution against the databases,
and wherein the dispatch program codes are to receive the execution results for the database commands from the database control agents.

### Claim 17 (depends on 16)

The management server of claim 16, wherein a given dispatch program code is to, upon establishing a given communication stream with a given database control agent for a given database on a given database network, add the given database control agent to an agent map maintained by the given dispatch program code,
wherein a given command program code is to, upon receiving a given database command for the given database from a given client program code, store the given database command within a command queue maintained by the given command program code,
wherein the given dispatch program code is to periodically poll the command queue to identify that the given database command has been newly stored within the command queue, retrieve the given database command from the command queue, and dispatch the given database command to the given database control agent over the given communication stream for execution against the given database,
wherein the given dispatch program code is to, upon receiving given execution results for the given database command from the given database control agent over the given communication stream, provide the given execution results to the given command program code,
and wherein the given command program code is to, upon receiving the given execution results from the given dispatch program code, return the given execution results to the given client program code, and remove the given database command from the command queue.

### Claim 18 (depends on 16)

The management server of claim 16, wherein a given dispatch program code is to, upon establishing a given communication stream with a given database control agent for a given database on a given database network, instantiate a publication/subscription channel associated with the given database and maintained by the given dispatch program code, and subscribe the given database control agent to the publication/subscription channel,
wherein a given command program code is to, upon receiving a given database command for the given database from a given client program code, store the given database command within a command queue maintained by the given command program code, and publish the given database command to the publication/subscription channel,
wherein the given dispatch program code is to, upon publication of the given database command to the publication/subscription channel, dispatch the given database command to the given database control agent over the given communication stream for execution against the given database,
wherein the given dispatch program code is to, upon receiving given execution results for the given database command from the given database control agent over the given communication stream, provide the given execution results to the given command program code,
and wherein the given command program code is to, upon receiving the given execution results from the given dispatch program code, return the given execution results to the given client program code, and remove the given database command from the command queue.

### Claim 19

A method comprising:
establishing, by dispatch program code running on a management server on a management network, 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 server;
instantiating, by the dispatch program code, a publication/subscription channel associated with the database;
subscribing, by the dispatch program code, the database control agent to the publication/subscription channel;
receiving, by command program code running on the management server, a database command for the database from client program code;
storing, by the command program code, the database command within a database queue;
publishing, by the command program code, the database command to the publication/subscription channel; and
upon publication of the database command to the publication/subscription channel, dispatching, by the dispatch program code, the database command over the communication stream to the database control agent for execution against the database.

### Claim 20 (depends on 19)

The method of claim 19, further comprising:
receiving, by the dispatch program code, execution results of the database command from the database control agent over the communication stream;
providing, by the dispatch program code, the execution results to the command program code;
upon having been provided the execution results, identifying, by the command program code, the client program code from which the database command was received;
returning, by the command program code, the execution results to the identified client program code in satisfaction of the database command; and
removing, by the command program code, the database command from the command queue.
