Method and system for detecting conflicts in replicated data in a database network
First Claim
1. A method for detecting conflicts in replicated data in a database network, wherein the database network includes a plurality of systems, each system including a table which includes replicated data, the method comprising the steps of:
- (a) providing a column to the table in each of the plurality of systems which indicates whether the replicated data in the table is current; and
(b) determining whether the replicated data in the table in one of the plurality of systems is current based on the column when a request to access the replicated data in the table is received.
1 Assignment
0 Petitions
Accused Products
Abstract
A method and system for detecting conflicts in replicated data in a database network is disclosed. The database network includes a plurality of computer systems, each having a table which includes replicated data. According to the method and system of the present invention, a column is provided to the table in each system which indicates whether replicated data in the table is current for the system. The method and system 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.
-
Citations
33 Claims
-
1. A method for detecting conflicts in replicated data in a database network, wherein the database network includes a plurality of systems, each system including a table which includes replicated data, the method comprising the steps of:
-
(a) providing a column to the table in each of the plurality of systems which indicates whether the replicated data in the table is current; and
(b) determining whether the replicated data in the table in one of the plurality of systems is current based on the column when a request to access the replicated data in the table is received. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A computer usable medium containing programming instructions for detecting conflicts in replicated in a database network, wherein the database network includes a plurality of systems, each system including a table which includes replicated data, the programming instructions for:
-
(a) providing a column to the table in each of the plurality of systems which indicates whether the replicated data in the table is current;
(b) determining whether the replicated data in the table in one of the plurality of systems is current based on the column when a request to access the replicated data in the table is received. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18, 19, 20)
-
-
21. A system for detecting conflicts in replicated data in a database network, wherein the database network includes a plurality of computer systems, each computer system including a database management system (“
- DBMS”
) and a table which includes replicated data, the system comprising;
a column appended to the table in each of the plurality of computer systems, wherein the column indicates whether replicated data in the table in the computer system is current; and
a conflict detection/resolution module in each of the plurality of computer systems coupled to the DBMS, wherein the conflict detection/resolution module in the computer system includes means for determining whether replicated data in the computer system is current based on the column when a request to access replicated data in the table is received. - View Dependent Claims (22, 23, 24, 25, 26, 27)
- DBMS”
-
28. A method for resolving conflicts in replicated data in a peer-to-peer database network, wherein the database network includes a plurality of members, each member including a table which includes replicated data, the method comprising the steps of:
-
(a) adding a conflict detection indicator column to the table in each member, wherein the conflict detection indicator column indicates whether replicated data in the table is current;
(b) examining a value in the conflict detection indicator column to determine whether replicated data in the table in a first member is current when a request to access replicated data in the table is received;
(c) obtaining current replicated data from a second member identified by the value in the conflict detection indicator column if the replicated data in the table in the first member is not current;
(d) updating the replicated data in the first member with the current replicated data; and
(e) modifying the value in the conflict detection indicator column to indicate that the replicated data in the table in the first member is current. - View Dependent Claims (29, 30)
-
-
31. A computer usable medium containing programming instructions for resolving conflicts in replicated data in a peer-to-peer database network, wherein the database network includes a plurality of members, each member including a table which includes replicated data, the programming instructions for:
-
(a) adding a conflict detection indicator column to the table in each member, wherein the conflict detection indicator column indicates whether replicated data in the table is current;
(b) examining a value in the conflict detection indicator column to determine whether replicated data in the table in a first member is current when a request to access replicated data in the table is received;
(c) obtaining current replicated data from a second member identified by the value in the conflict detection indicator column if the replicated data in the table in the first member is not current;
(d) updating the replicated data in the first member with the current replicated data; and
(e) modifying the value in the conflict detection indicator column to indicate that the replicated data in the table in the first member is current. - View Dependent Claims (32, 33)
-
Specification