Sap Se

Hyogi Jung

Norman May

Jaeyoung Choi

Tobias Scheuer

Ruediger Karl

Patrick Voelker

Robin Joy

Juchang Lee

Chul Won Lee

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.

Mapping of tenant-specific database sessions to workload classes

Systems and methods include establishment of a first database session with a first database user, determine first session variable values associated with the first database session, the first session variable values including a first tenant value, determine a first workload class based on the first tenant value and on zero or more of the other first session variable values, the first workload class including first parameter values specifying first resource consumption limits, and manage resource consumption of the first database session based on the first parameter values.

Workload classes for tenant-level resource isolation

A computer implemented method is provided for capturing and replaying a database workload by obtaining a workload capture file comprising execution context information generated in a database system and replayable to replicate the workload, generating a modified workload capture file by generating modified execution context information, replaying the modified workload capture file by generating at least one read statement based on the modified workload execution information and issuing at least one read statement to a primary database system having an associated secondary database system, determining that the at least one read statement may be routed to the secondary database system for execution, and routing the read statement to the secondary database system for execution. Related apparatus, systems, techniques and articles are also described.

Workload capture and replay for replicated database systems

Growing community of inventors

Seoul, South Korea

Hyogi Jung