# US 2023/0418805 A1 · Tenantification of database management systems

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

- Number: US 2023/0418805 A1
- Document ID: US20230418805A1
- Status: Published application
- Kind: A1
- Application number: 18/201,883
- Filed: 2023-05-25
- Published: 2023-12-28
- Earliest claimed: 2022-06-22
- Assignees: Nutanix, Inc.
- Applicants: Nutanix, Inc.
- Inventors: Ashish Dhar; Nishanth Janugani; Akshay Chandak
- Web page: https://patentgrep.com/patent/US20230418805A1

## CPC

- G06F 16/235: {Update request formulation}
- G06F 9/45533: {Hypervisors; Virtual machine monitors}
- G06F 9/4881: {Scheduling strategies for dispatcher, e.g. round robin, multi-level priority queues}
- G06F 9/4887: {involving deadlines, e.g. rate based, periodic}
- G06F 16/2365: {Ensuring data consistency and integrity}
- G06F 16/252: {between a Database Management System and a front-end application}
- G06F 16/258: {Data format conversion from or to a database}
- G06F 16/27: Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F 21/6218: {to a system of files or objects, e.g. local or distributed file system or database}
- H04L 67/60: Scheduling or organising the servicing of application requests, e.g. requests for application data transmissions using the analysis and optimisation of the required network resources (admission control or resource allocation H04L47/70)
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- H04L: TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION (arrangements common to telegraphic and telephonic communication H04M)

## Abstract

A system may include a memory having computer-readable instructions stored thereon and a processor of a control plane that executes the computer-readable instructions to receive a request from a tenant to update a portion of a database, determine an individual tenant identifier of the tenant, determine whether the portion of the database is associated with the individual tenant identifier or a global tenant identifier, and allow the tenant to update the portion of the database in response to determining that the portion of the database is associated with the global tenant identifier or the individual tenant identifier or restrict the tenant from updating the portion of the database in response to determining that the portion of the database is associated with neither the global tenant identifier nor the individual tenant identifier.

## Claims

### Claim 1

A system comprising:
a memory having computer-readable instructions stored thereon; and
a processor of a control plane that executes the computer-readable instructions to:
receive a request from a tenant to update a portion of a database;
determine an individual tenant identifier of the tenant;
determine whether the portion of the database is associated with the individual tenant identifier or a global tenant identifier; and
allow the tenant to update the portion of the database in response to determining that the portion of the database is associated with the global tenant identifier or the individual tenant identifier or restrict the tenant from updating the portion of the database in response to determining that the portion of the database is associated with neither the global tenant identifier nor the individual tenant identifier.

### Claim 2 (depends on 1)

The system of claim 1, wherein the portion of the database comprises one or more rows of the database, and wherein the processor further executes computer-readable instructions to apply a row-level-security policy to allow or restrict the tenant from updating rows of the portion.

### Claim 3 (depends on 1)

The system of claim 1, wherein to determine the individual tenant identifier, the processor further executes computer-readable instructions to:
fetch the individual tenant identifier from an execution context of the request.

### Claim 4 (depends on 3)

The system of claim 3, wherein the execution context is a thread context.

### Claim 5 (depends on 1)

The system of claim 1, wherein the portion of the database includes metadata of one or more entities on a database server associated with the tenant, and wherein the request to update the portion of the database is triggered by an update to the one or more entities on the database server.

### Claim 6 (depends on 5)

The system of claim 5, wherein the processor further executes computer-readable instructions to:
receive a message from the database server in a topic of a messaging cluster, wherein the topic is associated with the database server, and wherein the message includes the update to the one or more entities on the database server; and
determine the tenant based on one or more of the individual tenant identifier or one or more characteristics of the topic.

### Claim 7 (depends on 1)

The system of claim 1, wherein the portion of the database includes metadata of one or more entities on a database server associated with the tenant, and wherein the request to update the portion of the database triggers an update to the one or more entities on the database server.

### Claim 8 (depends on 7)

The system of claim 7, wherein to update the one or more entities on the database server, the processor further executes computer-readable instructions to:
publish an update command in a topic of a messaging service, wherein an agent of the control plane running on the database server subscribes to the topic.

### Claim 9 (depends on 1)

The system of claim 1, wherein the tenant is a tenant of a database management system, and wherein the database comprises a database on the control plane comprising metadata of entities on a database server in communication with the control plane.

### Claim 10 (depends on 9)

The system of claim 9, wherein to communicate with the database server, the processor further executes computer-readable instructions to generate topics associated with the database server on a messaging service, wherein the messaging service includes a plurality of topics associated with a plurality of database servers.

### Claim 11

A non-transitory, computer-readable media comprising computer-readable instructions stored thereon that when executed by a processor of a control plane cause the processor to:
receive a request from a tenant to update a portion of a database;
determine an individual tenant identifier of the tenant;
determine whether the portion of the database is associated with the individual tenant identifier or a global tenant identifier; and
allow the tenant to update the portion of the database in response to determining that the portion of the database is associated with the global tenant identifier or the individual tenant identifier or restrict the tenant from updating the portion of the database in response to determining that the portion of the database is associated with neither the global tenant identifier nor the individual tenant identifier.

### Claim 12 (depends on 11)

The non-transitory, computer-readable media of claim 11, wherein the portion of the database comprises one or more rows of the database, and wherein the instructions further cause the processor to apply a row-level-security policy to allow or restrict the tenant from updating rows of the portion.

### Claim 13 (depends on 11)

The non-transitory, computer-readable media of claim 11, wherein the instructions further cause the processor to:
determine the individual tenant identifier by fetching the individual tenant identifier from an execution context of the request.

### Claim 14 (depends on 13)

The non-transitory, computer-readable media of claim 13, wherein the execution context is a thread context.

### Claim 15 (depends on 11)

The non-transitory, computer-readable media of claim 11, wherein the portion of the database includes metadata of one or more entities on a database server associated with the tenant, and wherein the request to update the portion of the database is triggered by an update to the one or more entities on the database server.

### Claim 16 (depends on 15)

The non-transitory, computer-readable media of claim 15, wherein the instructions further case the processor to:
receive a message from the database server in a topic of a messaging cluster, wherein the topic is associated with the database server, and wherein the message includes the update to the one or more entities on the database server; and
determine the tenant based on one or more of an identifier of the tenant and one or more characteristics of the topic.

### Claim 17 (depends on 11)

The non-transitory, computer-readable media of claim 11, wherein the portion of the database includes metadata of one or more entities on a database server associated with the tenant, and wherein the request to update the portion of the database triggers an update to the one or more entities on the database server.

### Claim 18 (depends on 17)

The non-transitory, computer-readable media of claim 17, wherein to update the one or more entities on the database server, the instructions further cause the processor to:
publish an update command in a topic of a messaging cluster, wherein an agent of the control plane running on the database server subscribes to the topic.

### Claim 19 (depends on 11)

The non-transitory, computer-readable media of claim 11, wherein the tenant is a tenant of a database management system, and wherein the database is a database on the control plane comprising metadata of entities on a database server in communication with the control plane.

### Claim 20 (depends on 19)

The non-transitory, computer-readable media of claim 19, wherein to communicate with the database server, the instructions further cause the processor to generate topics associated with the database server on a messaging cluster, wherein the messaging cluster includes a plurality of topics associated with a plurality of database servers.

### Claim 21

A method comprising:
receiving, by a processor of a control plane, a request from a tenant to update a portion of a database;
determining, by the processor, an individual tenant identifier of the tenant;
determining, by the processor, whether the portion of the database is associated with the individual tenant identifier or a global tenant identifier; and
allowing, by the processor, the tenant to update the portion of the database in response to determining that the portion of the database is associated with the global tenant identifier or the individual tenant identifier or restricting the tenant from updating the portion of the database in response to determining that the portion of the database is associated with neither the global tenant identifier nor the individual tenant identifier.

### Claim 22 (depends on 21)

The method of claim 21, wherein the portion of the database comprises one or more rows of the database, and wherein the method further comprises applying, by the processor, a row-level-security policy to allow or restrict the tenant from updating rows of the portion.

### Claim 23 (depends on 21)

The method of claim 21, further comprising:
Determining, by the processor, the individual tenant identifier by fetching the individual tenant identifier from an execution context of the request.

### Claim 24 (depends on 23)

The method of claim 23, wherein the execution context is a thread context.

### Claim 25 (depends on 21)

The method of claim 21, wherein the portion of the database includes metadata of one or more entities on a database server associated with the tenant, and wherein the request to update the portion of the database is triggered by an update to the one or more entities on the database server.

### Claim 26 (depends on 25)

The method of claim 25, further comprising:
receiving, by the processor, a message from the database server in a topic of a messaging cluster, wherein the topic is associated with the database server, and wherein the message includes the update to the one or more entities on the database server; and
determining, by the processor, the tenant based on one or more of an identifier of the tenant and one or more characteristics of the topic.

### Claim 27 (depends on 21)

The method of claim 21, wherein the portion of the database includes metadata of one or more entities on a database server associated with the tenant, and wherein the request to update the portion of the database triggers an update to the one or more entities on the database server.

### Claim 28 (depends on 27)

The method of claim 27, further comprising:
publishing an update command in a topic of a messaging cluster to update the one or more entities on the database server, wherein an agent of the control plane running on the database server subscribes to the topic.

### Claim 29 (depends on 21)

The method of claim 21, wherein the tenant is a tenant of a database management system, and wherein the database is a database on the control plane comprising metadata of entities on a database server in communication with the control plane.

### Claim 30 (depends on 29)

The method of claim 29, further comprising generating topics associated with the database server on a messaging cluster to communicate with the database server, wherein the messaging cluster includes a plurality of topics associated with a plurality of database servers.
