Invention Grant
- Patent Title: Client-side handling of transient duplicates for row-level replication
-
Application No.: US13622276Application Date: 2012-09-18
-
Publication No.: US09965535B2Publication Date: 2018-05-08
- Inventor: Hung V. Tran , Lik Wong , Edwina Ming-Yue Lu
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: ORACLE INTERNATIONAL CORPORATION
- Current Assignee: ORACLE INTERNATIONAL CORPORATION
- Current Assignee Address: US CA Redwood Shores
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Transient duplicate key violations of unique key constraints are handled during row updates. Row changes are buffered until a point is reached that those changes are safe to execute. Row changes are effectively reordered to avoid constraint violations during execution of updates. In response to receiving a constraint key violation from a server after an attempted update, a client locally stores a record containing information regarding the failed update. Later, in response to the lack of receipt of an error in response to another update to the same column of the same table, the client uses the information in this record to instruct the server to attempt to repeat a failed update that previously attempted to change the value of a row to a value that was present in a uniqueness-constrained column at the time of the failure, but is no longer present due to the successful update.
Public/Granted literature
- US20140081907A1 Client-Side Handling Of Transient Duplicates For Row-Level Replication Public/Granted day:2014-03-20
Information query