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. 07, 2014
Filed:
Jun. 09, 2006
Amit Ganesh, San Jose, CA (US);
Niloy Mukherjee, Belmont, CA (US);
Manosiz Bhattacharyya, San Jose, CA (US);
Bipul Sinha, Foster City, CA (US);
Amit Ganesh, San Jose, CA (US);
Niloy Mukherjee, Belmont, CA (US);
Manosiz Bhattacharyya, San Jose, CA (US);
Bipul Sinha, Foster City, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
A bulk delete operation with reduced latency allows for retrieval of deleted data. Each database object holds a Delete SCN indicating when a bulk delete operation was last performed. Each row in the database object holds a Row Modification SCN indicating when the row was last updated. A bulk delete is performed by writing the old value of the Delete SCN to the undo tablespace and updating the Delete SCN. No undo information is stored for the rows. A write is performed by finding a deleted row, storing undo information for the deleted row and writing over the deleted row. To read from the database object, a rollback operation is performed, if necessary. Those rows are then retrieved for which the Row Modification SCN is higher than the Delete SCN and is less than or equal to the timestamp for the requested data.