The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Apr. 10, 2007
Filed:
Feb. 26, 2004
Nicolas G. Adiba, San Jose, CA (US);
Jaime F. Anaya, San Jose, CA (US);
Bruce G. Lindsay, San Jose, CA (US);
Guido Rost, Cupertino, CA (US);
Budi Surjanto, Markham, CA;
Nicolas G. Adiba, San Jose, CA (US);
Jaime F. Anaya, San Jose, CA (US);
Bruce G. Lindsay, San Jose, CA (US);
Guido Rost, Cupertino, CA (US);
Budi Surjanto, Markham, CA;
International Business Machines Corporation, Armonk, NY (US);
Abstract
A method and system for asynchronously replicating data changes in a database system captures update information for a data update in a source table from a database log, where the data value from the data update is not in the database log. A query is built to obtain the data value from the source table using the update information, including a key column value that identifies the row of the source table in which the data resides. When the key column is also updated in the same or different transaction, the data update information is stored, and the updated key column value is replaced with a later captured key column update value. The query is built and executed, and the data update is replicated at a target table. In this manner, data objects whose values are not recorded in a database log can be asynchronously replicated in a database system.