Invention Grant
US09244996B2 Replicating data across multiple copies of a table in a database system
有权
在数据库系统中的表的多个副本上复制数据
- Patent Title: Replicating data across multiple copies of a table in a database system
- Patent Title (中): 在数据库系统中的表的多个副本上复制数据
-
Application No.: US11771801Application Date: 2007-06-29
-
Publication No.: US09244996B2Publication Date: 2016-01-26
- Inventor: Serge Bourbonnais , Elizabeth B. Hamel , Bruce G. Lindsay , Stephen J. Todd
- Applicant: Serge Bourbonnais , Elizabeth B. Hamel , Bruce G. Lindsay , Stephen J. Todd
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Stephen R. Tkacs; Stephen J. Walder, Jr.; Mohammed Kashef
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A mechanism for handling transaction messages in asynchronous data replication in a database system, in which the database system includes a source node and a target node, and each transaction message has information concerning a row change to a table copy at the source node. The mechanism determines whether a first transaction message has a dependency on a preceding non-completed transaction message. Responsive to the first transaction message having a dependency on the preceding non-completed transaction, the mechanism holds the first transaction message, completes the preceding non-completed transaction message including applying the row change associated with the preceding non-completed transaction message to the table copy at the target node, and responsive to completing the preceding non-completed transaction message, releases the first transaction message and applying the row change associated with the first transaction message to the table copy at the target node.
Public/Granted literature
- US20070288537A1 METHOD AND APPARATUS FOR REPLICATING DATA ACROSS MULTIPLE COPIES OF A TABLE IN A DATABASE SYSTEM Public/Granted day:2007-12-13
Information query