Invention Grant
US07149759B2 Method and system for detecting conflicts in replicated data in a database network
失效
用于检测数据库网络中复制数据中的冲突的方法和系统
- Patent Title: Method and system for detecting conflicts in replicated data in a database network
- Patent Title (中): 用于检测数据库网络中复制数据中的冲突的方法和系统
-
Application No.: US10107095Application Date: 2002-03-25
-
Publication No.: US07149759B2Publication Date: 2006-12-12
- Inventor: Michael Morrison
- Applicant: Michael Morrison
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Sawyer Law Group LLP
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A method and system for detecting conflicts in replicated data in a database network that includes a plurality of computer systems, each having a table which includes replicated data includes providing a column to the table in each system which indicates whether replicated data in the table is current for the system. The method further includes determining whether replicated data in the table in the system is current based on a value in the column when a request to access the replicated data in the table is received.Through aspects of the method and system of the present invention, conflict detection is delayed until a request to access the replicated data in the system is submitted. Thus, no conflict detection is required during the replication cycle, nor is any conflict resolution required during the replication cycle. In an environment with many thousands or millions of rows being replicated, but with few actual conflicts, delaying the detection and resolution until the system actually accesses the replicated data greatly improves the overall performance of the replication environment.
Public/Granted literature
- US20030182319A1 Method and system for detecting conflicts in replicated data in a database network Public/Granted day:2003-09-25
Information query