Query execution on a replicated database with most recent data

A method for executing a query on a target database against the most recent source data is disclosed. The method comprises maintaining linked-i.e., at least partially synchronized-databases comprising a source and a target database. The method comprises receiving a direct query against a table in th...

Full description

Saved in:
Bibliographic Details
Main Authors Hrle, Namik, Michel, Christian, Dimov, Vassil Radkov, Martin, Daniel
Format Patent
LanguageEnglish
Published 01.10.2024
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

More Information
Summary:A method for executing a query on a target database against the most recent source data is disclosed. The method comprises maintaining linked-i.e., at least partially synchronized-databases comprising a source and a target database. The method comprises receiving a direct query against a table in the target database, the query comprising a request for using the most recent source data and requesting by the target database from the source database a status about latest data regarding the table. Upon the status indicating that data in the table do not correspond to the most recent data, the method comprises waiting up to a predefined time period for the most recent data of the table to be synchronized from the source database to the target database, and upon the data of the table not being synchronized within the predefined time period, the method comprises issuing a timeout signal.
Bibliography:Application Number: US202217658158