Granted Patent B2

US 12,481,674 · App. 17/653,315 · Granted Nov 25, 2025

Inventors: Thomas Rech (Rittersheim, DE); Hans-Jürgen Zeltwanger (Weinsberg, DE); Dirk Nakott (Stuttgart, DE); Jens Peter Seifert (Gaertringen, DE); Martin Jungfer (Ostelsheim, DE); Holger Hellmuth (Bensheim, DE); Jörn Klauke (Petersberg, DE); Alexander Zietlow (Sandhausen, DE)

Assignee: International Business Machines Corporation

G06F16/27G06F16/2471

Abstract

Claims (58)

1 . A computer-implemented method comprising:

storing, to a primary database, metadata indicative of a computer system comprising (i) the primary database, configured to connect to a secondary database, and (ii) the secondary database that replicates the primary database;

receiving, at the primary database from a requestor, a query referencing data stored to the primary database;

determining a first load of a first value on the primary database;

responsive to the first load on the primary database failing to satisfy a first offload condition, initiating, by the primary database, execution of the query;

executing, by the primary database, a first subset of the query;

determining, dynamically during execution of the query and subsequent to successfully executing the first subset of the query, a change to the first load on the primary database, wherein the first value of the first load on the primary database has changed to a second value of the first load on the primary database;

responsive to the second value of the first load satisfying the first offload condition, determining, using the metadata, that a second load on the secondary database satisfies a second offload condition;

responsive to the second load satisfying the second offload condition:

offloading, during execution of the received query, a second subset of the query to the secondary database, wherein the second subset is a nonexecuted portion of the query; and

causing the secondary database to execute the second subset of the query; and

returning results of the query to the requestor, wherein the results include a result of the first subset of the query executed by the primary database and the second subset of the query executed by the secondary database.

2 . The computer-implemented method of claim 1 , the first load comprising a selection from the group consisting of: central processing unit (CPU) utilization of the primary database, execution queue length at the primary database, and number of records of the query; and

wherein the first offload condition requires that at least one of the values exceeds a respective threshold.

3 . The computer-implemented method of claim 1 , the second load comprising a selection from the group consisting of: central processing unit (CPU) utilization, execution queue length, and number of records of the query; and

wherein the second offload condition requires that at least one of the values exceeds a respective threshold.

4 . The computer-implemented method of claim 1 , wherein the first offload condition is the second offload condition.

5 . The computer-implemented method of claim 3 , wherein the first offload condition is different from the second offload condition.

6 . The computer-implemented method of claim 1 , the first offload condition further requiring that the received query is a read-only query.

7 . The computer-implemented method of claim 1 , the metadata comprising connection information of the connection to the secondary database, and status information of the secondary database, the status information comprising a selection from the group consisting of: last applied transaction and execution queue length.

8 . The computer-implemented method of claim 1 , wherein the metadata is updated upon an occurrence of a selection of the group consisting of: start-up of the primary database, start-up of the secondary database, and changing data in the secondary database.

9 . The computer-implemented method of claim 7 , wherein the connection information is updated upon start-up of the primary database and the status information is updated upon start-up of the secondary database.

10 . The computer-implemented method of claim 1 , comprising storing the metadata in non-persistent storage.

11 . The computer-implemented method of claim 1 , further comprising: determining, using the metadata, that a copy of data of the primary database that is referenced by the query is present in the secondary database, wherein the offloading is performed in response to the copy of the data being present in the secondary database.

12 . A computer program product comprising:

one or more computer readable storage media; and

program instructions stored on the one or more computer readable storage media to perform operations comprising:

storing, to a primary database, metadata indicative of a computer system comprising (i) the primary database, configured to connect to a secondary database, and (ii) the secondary database that replicates the primary database;

receiving, at the primary database from a requestor, a query referencing data stored to the primary database;

determining a first load of a first value on the primary database;

responsive to the first load on the primary database failing to satisfy a first offload condition, initiating, by the primary database, execution of the query;

executing, by the primary database, a first subset of the query;

determining, dynamically during execution of the query and subsequent to successfully executing the first subset of the query, a change to the first load on the primary database, wherein the first value of the first load on the primary database has changed to a second value of the first load on the primary database;

responsive to the second value of the first load satisfying the first offload condition, determining, using the metadata, that a second load on the secondary database satisfies a second offload condition;

responsive to the second load satisfying the second offload condition:

offloading during execution of the received query, a second subset of the query to the secondary database, wherein the second subset is a nonexecuted portion of the query; and

causing the secondary database to execute the second subset of the query; and

returning results of the query to the requestor, wherein the results include a result of the first subset of the query executed by the primary database and the second subset of the query executed by the secondary database.

13 . The computer program product of claim 12 , the first load comprising a selection from the group consisting of: central processing unit (CPU) utilization of the primary database, execution queue length at the primary database, and number of records of the query; and

wherein the first offload condition requires that at least one of the values exceeds a respective threshold.

14 . The computer program product of claim 12 , the second load comprising a selection from the group consisting of: central processing unit (CPU) utilization, execution queue length, and number of records of the query; and

wherein the second offload condition requires that at least one of the values exceeds a respective threshold.

15 . The computer program product of claim 12 , wherein the first offload condition is the second offload condition.

16 . A computer system comprising:

a processor set;

one or more computer readable storage media; and

program instructions stored on the one or more computer readable storage media to cause the processor set to perform operations comprising:

storing, to a primary database, metadata indicative of a computer system comprising (i) the primary database, configured to connect to a secondary database, and (ii) the secondary database that replicates the primary database;

receiving, at the primary database from a requestor, a query referencing data stored to the primary database;

determining a first load of a first value on the primary database;

responsive to the first load on the primary database failing to satisfy a first offload condition, initiating, by the primary database, execution of the query;

executing, by the primary database, a first subset of the query;

determining, dynamically during execution of the query and subsequent to successfully executing the first subset of the query, a change to the first load on the primary database, wherein the first value of the first load on the primary database has changed to a second value of the first load on the primary database;

responsive to the second value of the first load satisfying the first offload condition, determining, using the metadata, that a second load on the secondary database satisfies a second offload condition;

responsive to the second load satisfying the second offload condition:

offloading during execution of the received query, a second subset of the query to the secondary database, wherein the second subset is a nonexecuted portion of the query; and

causing the secondary database to execute the second subset of the query; and

returning results of the query to the requestor, wherein the results include a result of the first subset of the query executed by the primary database and the second subset of the query executed by the secondary database.

Assignments (1)

Continuity (1)

References Cited (18)