Invention Grant
- Patent Title: Auto-correction in database replication
- Patent Title (中): 数据库复制中的自动更正
-
Application No.: US13150955Application Date: 2011-06-01
-
Publication No.: US08417669B2Publication Date: 2013-04-09
- Inventor: Chengzi Xu , Stephen C. Shepherd
- Applicant: Chengzi Xu , Stephen C. Shepherd
- Applicant Address: US CA Dublin
- Assignee: Sybase Inc.
- Current Assignee: Sybase Inc.
- Current Assignee Address: US CA Dublin
- Agency: Sterne, Kessler, Goldstein & Fox P.L.L.C.
- Main IPC: G06F17/00
- IPC: G06F17/00

Abstract:
Systems, methods and computer program product embodiments for auto-correction in database replication are disclosed herein. An embodiment includes receiving a log record of one or more database row changes on a table marked for replication. From the received log record, one or more insert operations on the marked table are identified. Each identified insert operation is automatically replaced with a first pair of operations, where each first pair comprises a delete operation associated with a new insert operation. Each first pair, when executed at a replicate database, acts to delete data at a first location identified by each identified insert operation prior to inserting data of the new insert operation at the first location. The embodiment further includes identifying, from the log record, one or more update operations on the marked table, and automatically replacing each identified update operation with a second pair of operations, where each second pair comprises a new delete operation associated with a new insert operation.
Public/Granted literature
- US20120310885A1 Auto-Correction in Database Replication Public/Granted day:2012-12-06
Information query