International Business Machines Corporation

Jörn Klauke

Jens Peter Seifert

Thomas Rech

Dirk Nakott

Holger Hellmuth

Alexander Zietlow

Hans-Jürgen Zeltwanger

Martin Jungfer

An approach includes collecting metadata indicative of a computer system comprising (i) a primary database, configured to connect to a secondary database, and (ii) the secondary database that replicates the primary database. The approach further includes receiving, at the primary database from a requestor, a query referencing the primary database. The approach further includes, responsive to receiving the query, performing an offload including: determining a first load on the primary database; responsive to the first load satisfying a first offload condition, determining, using the metadata, whether a second load on the secondary database satisfies a second offload condition; and responsive to the second load satisfying the second offload condition, offloading at least part of the query to the secondary database in order to cause the at least part of the query to be executed by the secondary database. The method further includes providing to the requestor results of the query.

Query offloading in a computer system

Growing community of inventors

Petersberg, Germany

Jörn Klauke