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:
Oct. 29, 2013
Filed:
Sep. 21, 2007
Benjamin Michael Parees, Durham, NC (US);
David Michael Eads, Raleigh, NC (US);
David Michael Enyeart, Raleigh, NC (US);
Luis Eduardo Guillen-sanchez, Raleigh, NC (US);
Latha Sivakumar, Chapel Hill, NC (US);
Dan Mcbryde Willey, Cary, NC (US);
Benjamin Michael Parees, Durham, NC (US);
David Michael Eads, Raleigh, NC (US);
David Michael Enyeart, Raleigh, NC (US);
Luis Eduardo Guillen-Sanchez, Raleigh, NC (US);
Latha Sivakumar, Chapel Hill, NC (US);
Dan McBryde Willey, Cary, NC (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
A method, system and computer program product for performing synchronization between source and target tables. An external data source inserts a new row in a first table as it modifies or creates a row in the source table where each new row in the first table includes a primary key value associated with the modified/created row in the source table. An application copies the distinct values for the primary keys listed in the first table and inserts them in a second table. The application performs uncommitted read operations on the source table for each row corresponding to the primary key values stored in the second table. The application inserts the data read into the corresponding rows of the target table. In this manner, a platform agnostic application may be able to synchronize the relational source and target tables in an efficient manner while minimizing the contention at the source table.