Mapping of tenant-specific database sessions to workload classes

Patent metadata

Field	Value
Publication number	US-12360819-B2
Application number	US-202218063472-A
Country	US
Kind code	B2
Filing date	Dec 8, 2022
Priority date	Dec 8, 2022
Publication date	Jul 15, 2025
Grant date	Jul 15, 2025

Abstract

Systems and methods include establishment of a first authenticated database session with a first database user of a database instance hosting a plurality of tenants, determination of a first tenant of the plurality of tenants based on a mapping of the first database user to the first tenant, determination of a first workload class based on the first tenant, and management of resource consumption of the first authenticated database session based on the first workload class.

First claim

What is claimed is:

1. A computer-implemented method comprising:
establishing a first authenticated database session with a first database user of a database instance hosting a plurality of tenants;
establishing a second authenticated database session with a second database user of the database instance;
determining a first tenant of the plurality of tenants based on a mapping of the first database user to the first tenant, and determining a second tenant of the plurality of tenants based on a second mapping of the second database user to the second tenant;
determining a first workload class based on the first tenant;
determining a second workload class based on the second tenant;
determining a third workload class based on the first tenant and a session context of the first authenticated database session;
determining first resource consumption limits associated with the first workload class, determining second resource consumption limits associated with the second workload class, and determining third resource consumption limits associated with the third workload class, the second resource consumption limits being different from the first resource consumption limits, the first resource consumption limits being tenant-level resource consumption limits and the third resource consumption limits being statement-level resource consumption limits; and
managing resource consumption of the first authenticated database session to conform to the first resource consumption limits and to the third resource consumption limits, and managing resource consumption of the second authenticated database session to conform to the second resource consumption limits.

2. A method according to claim 1 , further comprising:
establishing a third authenticated database session with a third database user of the database instance;
determining the first tenant of the plurality of tenants based on a mapping of the third database user to the first tenant; and
managing resource consumption of the third authenticated database session to conform to the first resource consumption limits.

3. A method according to claim 2 , further comprising:
creating an object instance of the first tenant;
assigning the first database user to the first tenant;
creating an object instance of the second tenant;
assigning the second database user to the second tenant; and
assigning the third database user to the first tenant.

4. A method according to claim 1 , further comprising:
creating an object instance of the first tenant;
assigning the first database user to the first tenant;
creating an object instance of the second tenant; and
assigning the second database user to the second tenant.

5. A method according to claim 1 , further comprising:
in response to determining the first tenant of the plurality of tenants based on the mapping of the first database user to the first tenant, adding the first tenant to the session context of the first authenticated database session.

6. A system comprising:
a memory storing executable program code;
one or more processing units to execute the program code to cause the system to perform operations comprising:
establishing a first authenticated database session with a first database user of a database instance hosting a plurality of tenants;
establishing a second authenticated database session with a second database user of the database instance;
determining a first tenant of the plurality of tenants based on a mapping of the first database user to the first tenant, and determining a second tenant of the plurality of tenants based on a second mapping of the second database user to the second tenant;
determining a first workload class based on the first tenant;
determining a second workload class based on the second tenant;
determining a third workload class based on the first tenant and a session context of the first authenticated database session;
determining first resource consumption limits associated with the first workload class, determining second resource consumption limits associated with the second workload class, and determining third resource consumption limits associated with the third workload class, the second resource consumption limits being different from the first resource consumption limits, the first resource consumption limits being tenant-level resource consumption limits and the third resource consumption limits being statement-level resource consumption limits; and
managing resource consumption of the first authenticated database session to conform to the first resource consumption limits and to the third resource consumption limits, and managing resource consumption of the second authenticated database session to conform to the second resource consumption limits.

7. A system according to claim 6 , the one or more processing units to execute the program code to cause the system to perform operations comprising:
establishing a third authenticated database session with a third database user of the database instance;
determining the first tenant of the plurality of tenants based on a mapping of the third database user to the first tenant; and
managing resource consumption of the third authenticated database session to conform to the first resource consumption limits.

8. A system according to claim 7 , the one or more processing units to execute the program code to cause the system to perform operations comprising:
creating an object instance of the first tenant;
assigning the first database user to the first tenant;
creating an object instance of the second tenant;
assigning the second database user to the second tenant; and
assigning the third database user to the first tenant.

9. A system according to claim 6 , the one or more processing units to execute the program code to cause the system to perform operations comprising:
creating an object instance of the first tenant;
assigning the first database user to the first tenant;
creating an object instance of the second tenant; and
assigning the second database user to the second tenant.

10. A system according to claim 6 , the one or more processing units to execute the program code to cause the system to perform operations comprising:
in response to determining the first tenant of the plurality of tenants based on the mapping of the first database user to the first tenant, adding the first tenant to a session context of the first authenticated database session.

11. One or more non-transitory computer-readable media storing program code executable by a computing system to cause the computing system to perform operations comprising:
establishing a first authenticated database session with a first database user of a database instance hosting a plurality of tenants;
establishing a second authenticated database session with a second database user of the database instance;
determining a first tenant of the plurality of tenants based on a mapping of the first database user to the first tenant, and determining a second tenant of the plurality of tenants based on a second mapping of the second database user to the second tenant;
determining a first workload class based on the first tenant;
determining a second workload class based on the second tenant;
determining a third workload class based on the first tenant and a session context of the first authenticated database session;
determining first resource consumption limits associated with the first workload class, determining second resource consumption limits associated with the second workload class, and determining third resource consumption limits associated with the third workload class, the second resource consumption limi

Assignees

• Sap Se

Inventors

• Joy Robin
• Karl Ruediger
• May Norman
• Scheuer Tobias
• Voelker Patrick
• Choi Jaeyoung
• Jung Hyogi

Classifications

• G06F21/6218

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

• G06F16/211

  Schema design and management · CPC title

• H04L67/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) · CPC title

• G06F9/5077

  Logical partitioning of resources; Management or configuration of virtualized resources (specific details on emulation or internal functioning of virtual machines G06F9/455) · CPC title

• G06F16/256

  in federated or virtual databases · CPC title