Method of Synchronizing Data Between Databases, and Computer System and Computer Program for the Same
AssigneeInternational Business Machines Corporation
InventorsMikio Takeuchi, Gaku Yamamoto
Life of this patent
Estimating the term…
Abstract
Systems for synchronizing data between a first-database and a second-database are presented including: a memory; and a client configured for determining whether a retrieval request requires a synchronization of the second-database before processing the received retrieval request, where the system partially synchronizes the second-database from the first-database with only that portion of the first-database associated with the retrieval request in response to determining whether synchronization is required and for processing the retrieval request from the second-database.
Claims20
(canceled)
A system for synchronizing data between a first-database and a second-database comprising:
- a memory;
- and
- a client configured for determining whether a retrieval request requires a synchronization of the second-database before processing the received retrieval request, wherein
- the system partially synchronizes the second-database from the first-database with only that portion of the first-database associated with the retrieval request in response to determining whether synchronization is required and for processing the retrieval request from the second-database.
A system for synchronizing data between a first-database and a second-database in response to a retrieval request comprising:
- a memory;
- an application for receiving the retrieval request from a user;
- a driver for providing the application an application programming interface (API) for operating the databases;
- a client configured for determining whether a retrieval request requires a synchronization of the second-database before processing the received retrieval request, wherein
- the system partially synchronizes the second-database from the first-database with only that portion of the first-database associated with the retrieval request in response to determining synchronization is required and for processing the retrieval request from the second-database, wherein that portion represents only a portion of data out of all possible data sets that differ between the first-database and the second-database;
- an asynchronous replication transmitter for transmitting that portion of the first-database associated with the retrieval request;
- an asynchronous replication receiver for receiving that portion of the first-database associated with the retrieval request;
- and
- an update log table for storing update information for the first-database, wherein the update information includes at least updated data and updated time.
The system of 12, wherein the retrieval request includes at least one data set included in the database to be referenced and wherein the retrieval request further includes at least a SELECT phrase of an SQL statement, a pass-through request, or a command using a reserved word prepared for the databases.
Dependencies are inferred from the claim text.