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:
Jul. 22, 2014
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, IN;
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, IN;
Dan McBryde Willey, Cary, NC (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
A method, system and computer program product for ensuring that archival data deleted in a source table is already stored in a target table. An external data source sets a flag in the first table to identify the row in the source table to be deleted. An application sets a flag in a second table for each row of the source table that is marked to be deleted according to the first table. The application performs uncommitted read operations on the source table for each row corresponding to the distinct primary key values stored in the first table. The application inserts the data read into the corresponding rows of the target table. The application deletes the rows in the source table indicated to be deleted by the second table. In this manner, the archival data deleted from the source table is ensured to already be stored in the target table.