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:
Dec. 04, 2012
Filed:
May. 06, 2010
Romain Colle, San Francisco, CA (US);
Benoit Dageville, Foster City, CA (US);
Karl Dias, Foster City, CA (US);
Leonidas Galanis, San Jose, CA (US);
Supiti Buranawatanachoke, San Mateo, CA (US);
Jonathan Klein, Redwood City, CA (US);
Efstratios Papadomanolakis, San Francisco, CA (US);
Yujun Wang, Los Gatos, CA (US);
Romain Colle, San Francisco, CA (US);
Benoit Dageville, Foster City, CA (US);
Karl Dias, Foster City, CA (US);
Leonidas Galanis, San Jose, CA (US);
Supiti Buranawatanachoke, San Mateo, CA (US);
Jonathan Klein, Redwood City, CA (US);
Efstratios Papadomanolakis, San Francisco, CA (US);
Yujun Wang, Los Gatos, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
A method, apparatus, and computer readable medium for preserving data dependency during replay of database commands without strictly preserving a global ordering of the database commands is provided. A capture process captures a workload of database commands executed by a production system. The captured workload includes object identifiers that identify database objects that were referenced directly or indirectly during execution of the database commands by the production system. The captured workload also includes an indication of whether the database objects were potentially read or written during execution of the commands. The workload is processed to determine that an object accessed during execution of a command was previously modified during execution of one or more other commands. A replay process on a test database system prevents the command from being replayed until after the one or more other commands have been replayed to modify the object.