US 12,105,732 B2
Query execution on a replicated database with most recent data
Vassil Radkov Dimov, Stuttgart (DE); Daniel Martin, Leinfelden-Echterdingen (DE); Christian Michel, Sindelfingen (DE); and Namik Hrle, Boeblingen (DE)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by INTERNATIONAL BUSINESS MACHINES CORPORATION, Armonk, NY (US)
Filed on Apr. 6, 2022, as Appl. No. 17/658,158.
Prior Publication US 2023/0325404 A1, Oct. 12, 2023
Int. Cl. G06F 16/27 (2019.01); G06F 16/23 (2019.01)
CPC G06F 16/27 (2019.01) [G06F 16/2379 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method for executing a query on a target database against a copy of a most recent source data, the method comprising:
maintaining linked databases comprising a source database and a related target database, wherein tables of the source database are continuously synchronized with respective tables in the target database;
receiving a direct query against a table in the target database, the query comprising a request for using the most recent source data, wherein the direct query does not originate in the source database of the linked databases or is not forwarded from the source database of the linked databases;
in response to the query including an amount of time to wait for the most recent source data, the target database requesting a status about a latest data regarding the table in the query;
requesting by a replication engine component to verify when the most recent source data are replicated to the target database, based on comparing timestamps of data records in the target database versus a timestamp of a commit statement for respective data in the source database for replicated tables in the query; and
based on the replicated tables in the query being available prior to an expiration of the amount of time to wait, executing the query.