Invention Grant
- Patent Title: Fine grain synchronization for database replay
- Patent Title (中): 数据库重播的细粒度同步
-
Application No.: US12775322Application Date: 2010-05-06
-
Publication No.: US08326816B2Publication Date: 2012-12-04
- Inventor: Romain Colle , Benoit Dageville , Karl Dias , Leonidas Galanis , Supiti Buranawatanachoke , Jonathan Klein , Efstratios Papadomanolakis , Yujun Wang
- Applicant: Romain Colle , Benoit Dageville , Karl Dias , Leonidas Galanis , Supiti Buranawatanachoke , Jonathan Klein , Efstratios Papadomanolakis , Yujun Wang
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Palermo Truong Becker Bingham Wong LLP
- Main IPC: G06F17/30
- IPC: G06F17/30

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.
Public/Granted literature
- US20110276550A1 FINE GRAIN SYNCHRONIZATION FOR DATABASE REPLAY Public/Granted day:2011-11-10
Information query